Re: db2 file size limit

select count(*) from qsys2.syslimits
where limit_id = 18409;
returns a value of 212.

values QIBM_SYSTEM_LIMITS_PRUNE_BY_OBJECT;
returns a value of 20

values QIBM_SYSTEM_LIMITS_SAVE_HIGH_POINTS_BY_OBJECT ;
returns a value of 5

That last one probably explains why those 5 huge objects are not going
away.
What I don't know is why I have 212 entries and not just 20.

SELECT journal_code, journal_entry_type, hex( journal_identifier ),
object, object_type, X.*
FROM TABLE (QSYS2.Display_Journal(
JOURNAL_LIBRARY => 'QSYS2',
JOURNAL_NAME => 'QSQJRN',
STARTING_RECEIVER_NAME => '*CURCHAIN',
OBJECT_LIBRARY => 'QSYS2',
OBJECT_NAME => 'SYSLIMTBL',
OBJECT_OBJTYPE => '*FILE',
OBJECT_MEMBER => '*ALL',
STARTING_TIMESTAMP => CURRENT DATE
) ) AS X
;
Shows deletions occurring at 05:20 and 13:47.
So perhaps cleanup happens twice a day or so? And it always keeps the 5
largest ones irregardless of existence or age but purges the rest until
I'm down to 20 records?


Rob Berendt