all logs full



IBM's flagship relational database management system

all logs full

Postby kranthi_2k11 » Wed Nov 16, 2011 11:36 pm

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
kranthi_2k11
 
Posts: 8
Joined: Sat Nov 12, 2011 12:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: all logs full

Postby enrico-sorichetti » Thu Nov 17, 2011 12:16 am

why not talk to Your support ?
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: all logs full

Postby db2sysdba » Thu Nov 17, 2011 1:49 pm

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.
db2sysdba
 
Posts: 18
Joined: Wed Sep 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: all logs full

Postby kranthi_2k11 » Fri Nov 18, 2011 6:20 pm

Hi Mate , thanks but isnt it possible to add volumes and increase the size for logs ?
kranthi_2k11
 
Posts: 8
Joined: Sat Nov 12, 2011 12:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: all logs full

Postby db2sysdba » Fri Nov 18, 2011 7:57 pm

Hi Kranthi

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

means

1. add volumes ,
2. delete the old archive logs
db2sysdba
 
Posts: 18
Joined: Wed Sep 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post