Hi,



I have a DB2 space issue and I don't know how to manage.
In an AIX partition of 10 GB I have 6 DB2 instances - for test purposes behind some WebSphere Process Server apps.
I am not allowed to extend the AIX partition and I have no more space - 100% used space.
It seems this is caused by archive logs.
Database server = DB2/AIX64 8.2.9
(LOGARCHMETH1) = USEREXIT
(LOGARCHMETH2) = OFF
is set for all instances.
After some tests three of them increased dramatically and I ran out of space - for each about 1.6-1.7 GB are used for the archive logs.
For 'the biggest' instance:
Number of primary log files (LOGPRIMARY) = 15
Number of secondary log files (LOGSECOND) = 113
and in the corresponding path there are exactly 113 S*.LOG files.
For a 2nd big one I have default settings:
Number of primary log files (LOGPRIMARY) = 3
Number of secondary log files (LOGSECOND) = 2
but in the corresponding path there are exactly 105 S*.LOG files. Is something wrong - can I delete them excepting the last two?
This means USEREXIT does not manage properly the archive logs - can I delete / move in other partition / compress ...



Thanks,

Determine the first active log for each database:

You can delete logs prior to that log but that will essentially make prior backups useless.

Alternatively, you can find what was the earliest log for the last backup and delete files prior to that:

Do not delete your logfiles with an O.S.command, always use "db2 prune" .