all logs full
Previous topic • Next topic • 5 posts
• Page 1 of 1
all logs full
by 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
by 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
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: 3006
- Joined: Fri Apr 18, 2008 11:25 pm
- Has thanked: 0 time
- Been thanked: 165 times
Re: all logs full
by 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.
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
by 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
by 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
"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
Previous topic • Next topic • 5 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Buffer pool full
by kranthi_2k11 » Sat Nov 12, 2011 1:13 pm - 8 Replies
- 2708 Views
- Last post by dick scherrer
Tue Nov 15, 2011 11:11 pm
- Buffer pool full
-
- Full DB2 RACF authority to user
by ainemorf » Fri Dec 14, 2012 2:16 am - 1 Replies
- 2625 Views
- Last post by dick scherrer
Fri Dec 14, 2012 2:56 am
- Full DB2 RACF authority to user
-
- how to find out Data Differnece b/w 2 full Image Copy?
by sonika2007 » Fri Aug 17, 2007 11:10 pm - 1 Replies
- 2746 Views
- Last post by CICS Guy
Sat Aug 18, 2007 12:51 am
- how to find out Data Differnece b/w 2 full Image Copy?
-
- ADM5510E tablespace full in an autoextend tablespace
by Riddick » Tue Sep 13, 2022 1:44 am - 1 Replies
- 1899 Views
- Last post by engh
Wed Sep 21, 2022 2:29 pm
- ADM5510E tablespace full in an autoextend tablespace
-
- Difference between sub-select and full-select
by nikesh_rai » Tue Oct 29, 2013 3:55 pm - 0 Replies
- 2284 Views
- Last post by nikesh_rai
Tue Oct 29, 2013 3:55 pm
- Difference between sub-select and full-select