Server running with DB2V9.5 Fixpack 4 (AIX5L).
No applications were connected to the db , and I ran offline reorg of the table using the command - db2 reorg table schema.tablename.
Got warning message as SQL1279W Some indexes may not have been recreated. So for rebuiliding the indexes , I have executed db2 "select count(*) of schema.tablename" Got transaction log full error.
2011-12-19-08.15.09.227807+000 I365531A550 LEVEL: Severe
PID : 7602398 TID : 17387 PROC : db2sysc 0
INSTANCE: db2pmsn1 NODE : 000 DB : MSN
APPHDL : 0-2398 APPID: *LOCAL.db2pmsn1.111219080240
AUTHID : DB2PMSN1
EDUID : 17387 EDUNAME: db2agent (MSN) 0
FUNCTION: DB2 UDB, catalog services, sqlrlRecreateSingleIndex, probe:200
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.