Hello All,

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.
Diag.log:
=======
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.


APPHDL : 0-2398 APPID: *LOCAL.db2pmsn1.111219080240
AUTHID : DB2PMSN1
EDUID : 17387 EDUNAME: db2agent (MSN) 0
FUNCTION: DB2 UDB, catalog services, sqlrlRecreateIndexes, probe:99
MESSAGE : Table name:
DATA #1 : Hexdump, 13 bytes
0x07000000007F3950 : 4155 4449 545F 4D45 5353 4147 45 AUDIT_MESSAGE

2011-12-19-08.15.09.384426+000 I369311A890 LEVEL: Error
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, relation data serv, sqlrreorg_table, probe:850
MESSAGE : Remap rc to 1279, Reorg: Recreate index return rc = -2062548983
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09054
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

No other applications were connected to the db.

Log Information:
Log buffer size (4KB) (LOGBUFSZ) = 132
Log file size (4KB) (LOGFILSIZ) = 2048
Number of primary log files (LOGPRIMARY) = 3
Number of secondary log files (LOGSECOND) = 10

I have rebuild the indexes now.
How to eradicate this problem permanently ?

Thanks for your help in advance.

Regards
Meena.s

You log file space is too small about 110MB (4096*2048*13). Make it bigger.

Andy