Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    105

    Unanswered: DB2 Reorg - V9.5

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You log file space is too small about 110MB (4096*2048*13). Make it bigger.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •