LOgs full

rameshj6 · #1 (**permalink**) 09-04-11, 12:51

Can any one plz help me ... how to check why the logs are getting full so frequently

VERsion : 9.7
fp 3
os : AIX
Partitioned environment

przytula_guy · #2 (**permalink**) 09-05-11, 02:46

do you get logfull sqlcode
maybe long running transactions.. mass delete/update...

skchandra · #3 (**permalink**) 09-05-11, 03:32

In case of "log full" situation, you can find the application handle who is holding the active log from db2diag.log

Code:

db2diag -g message:="The active log is full"

Also, you can use sysibmadm.snapappl and sysibmadm.snapappl_info admin views for getting info on who is hogging the log space.

Naval29 · #4 (**permalink**) 09-07-11, 09:02

This is case of applcaition performanve tunning with db. Please check what application are are running against the db at that time and Need to eleminate highly log space used application. Then issue frequent "COMMIT" in that activity. For immidiate relief you may want to add some more logs.

Thanks
Naval K

Internet Services

Web Development

Digital Marketing

Consumer Tech