Page 1 of 1

all logs full

PostPosted: Wed Nov 16, 2011 11:36 pm
by kranthi_2k11
we are maintaining 12 active and archive logs . Suddenly almost all logs are filled all logs shows 100% full .. its due to mass loads .. active logs unable to offload .. will you please help me ,What i have to do ? thanks first

Re: all logs full

PostPosted: Thu Nov 17, 2011 12:16 am
by enrico-sorichetti
why not talk to Your support ?

Re: all logs full

PostPosted: Thu Nov 17, 2011 1:49 pm
by db2sysdba
Cancel that load job and take the backup of old archive log into tape (or delete that if you don't need).

Make sure you have sufficient space for new archive log dataset.

Fire the following command to restart the OFFLOAD process.

ARCHIVE LOG CANCEL OFFLOAD.

Re: all logs full

PostPosted: Fri Nov 18, 2011 6:20 pm
by kranthi_2k11
Hi Mate , thanks but isnt it possible to add volumes and increase the size for logs ?

Re: all logs full

PostPosted: Fri Nov 18, 2011 7:57 pm
by db2sysdba
Hi Kranthi

"Make sure you have sufficient space for new archive log dataset."

means

1. add volumes ,
2. delete the old archive logs