SOP when you get a message like that (which I do not) is to look at this:
http://ibm.biz/DB2foriServices
And ensure you're at the right DB2 group ptf for your version of the OS.
That being said however I am getting a different message on one row:
IFS_PATH_NAME
GetPath()-Failure in ASP_NUMBER column
/home/DARREN/core.20170606.124555.825572.0001.dmp
/home/DARREN/core.20170606.124936.825585.0001.dmp
/home/DARREN/core.20170606.125201.825598.0001.dmp
/home/DARREN/core.20170606.124812.825574.0001.dmp
/tmp/poifiles/poi-sxssf-sheet809969389437526088.xml
I omitted the size column due to ease of copy/paste from run sql scripts.
The first five are over 9GB.
However they do not exist. Why not?
Here is my first hypothesis: The SYSLIMTBL has a row added with a
condition is met. For example, at one time the file
/home/DARREN/core.20170606.124555.825572.0001.dmp was created. Since it
exceeded one of these limits it recorded it to the SYSLIMTBL. The file
has since been deleted but the row remains in SYSLIMTBL.
My second hypothesis deals with the GetPath()-Failure. I hypothesize that
the directory, along with the file, has been deleted. And that is why I
am getting the error.
So now I wonder how does one purge these rows from SYSLIMTBL? I've read
some stuff about pruning but I'm thinking that's different.
Is it kosher to run something like
delete from qsys2.syslimtbl
where limit_id = 18409
and date(last_change_timestamp) = date('2018-06-06') ;
which is when these 5 files occurred. The rest are all from today.
Rob Berendt
midrange.com
