IBM Support

LI73872: PERFORMING A REDISTRIBUTE, BACKUP AND THEN ANOTHER REDISTRIBUTE WITHOUT DB2STOP,CAUSES REDISTRIBUTE FAIL WITH -1224

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When we perform a REDISTRIBUTE, backup and then issue another
    REDISTRIBUTE without db2stops,the REDISTRIBUTE fails with -1224
    and the following messages in the db2diag.log:
    
    The problem goes away if DB2 is cycled and the CLP is shutdown.
    The error is in the CLP backend process so cycling the instance
    should not be necessary.
    
    2008-10-28-09.58.38.861444-240 E50486335E429       LEVEL: Info
    PID     : 28309                TID  : 183295273312 PROC :
    db2sysc 8
    INSTANCE: nytxt220             NODE : 008          DB   :
    HPDLWISE
    APPHDL  : 8-5278               APPID: *N8.nytxt220.081028135820
    AUTHID  : SONGQING
    EDUID   : 153272               EDUNAME: db2agent (HPDLWISE) 8
    FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:838
    MESSAGE : Backup complete.
    
    2008-10-28-10.01.24.591336-240 I50486765E490       LEVEL: Error
    PID     : 1612                 TID  : 182966382336 PROC : db2bp
    INSTANCE: nytxt220             NODE : 001
    FUNCTION: DB2 UDB, database utilities - Redistribute,
    sqlurRedistRouteOut, probe:1625
    MESSAGE : ZRC=0xFFFFF82C=-2004
    DATA #1 : String, 0 bytes
    Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
    Address is NULL
    DATA #2 : File name, 10 bytes
    sqludrdt.C
    DATA #3 : String, 29 bytes
    Error in getting package info
    
    2008-10-28-10.01.24.591840-240 I50487256E482       LEVEL: Error
    PID     : 1612                 TID  : 182966382336 PROC : db2bp
    INSTANCE: nytxt220             NODE : 001
    FUNCTION: DB2 UDB, database utilities - Redistribute,
    sqlurRedistributeClient, probe:332
    MESSAGE : ZRC=0xFFFFF82C=-2004
    DATA #1 : String, 0 bytes
    Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
    Address is NULL
    DATA #2 : File name, 10 bytes
    sqludrdt.C
    DATA #3 : String, 18 bytes
    Redstribute failed
    
    To be fixed in V9.5 Fp4.
    

Local fix

  • Local fix is to recycle DB2 and shutdown CLP.
    

Problem summary

  • Problem Description:
    
    Performing a REDISTRIBUTE, backup and then another
    REDISTRIBUTE without db2stop,causes the REDISTRIBUTE to fail
    with -1224.
    
    Problem Summary:
    
    Error in diag.log:
    
    2008-10-28-09.58.38.861444-240 E50486335E429       LEVEL: Info
    PID     : 28309                TID  : 183295273312 PROC :
    db2sysc 8
    INSTANCE: nytxt220             NODE : 008          DB   :
    HPDLWISE
    APPHDL  : 8-5278               APPID: *N8.nytxt220.081028135820
    AUTHID  : SONGQING
    EDUID   : 153272               EDUNAME: db2agent (HPDLWISE) 8
    FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:838
    MESSAGE : Backup complete.
    
    2008-10-28-10.01.24.591336-240 I50486765E490       LEVEL: Error
    PID     : 1612                 TID  : 182966382336 PROC : db2bp
    INSTANCE: nytxt220             NODE : 001
    FUNCTION: DB2 UDB, database utilities - Redistribute,
    sqlurRedistRouteOut, probe:1625
    MESSAGE : ZRC=0xFFFFF82C=-2004
    DATA #1 : String, 0 bytes
    Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
    Address is NULL
    DATA #2 : File name, 10 bytes
    sqludrdt.C
    DATA #3 : String, 29 bytes
    Error in getting package info
    
    2008-10-28-10.01.24.591840-240 I50487256E482       LEVEL: Error
    PID     : 1612                 TID  : 182966382336 PROC : db2bp
    INSTANCE: nytxt220             NODE : 001
    FUNCTION: DB2 UDB, database utilities - Redistribute,
    sqlurRedistributeClient, probe:332
    MESSAGE : ZRC=0xFFFFF82C=-2004
    DATA #1 : String, 0 bytes
    Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
    Address is NULL
    DATA #2 : File name, 10 bytes
    sqludrdt.C
    DATA #3 : String, 18 bytes
    Redistribute failed
    

Problem conclusion

  • First fixed in V9.5 FP4
    

Temporary fix

  • Recycle DB2 and shutdown CLP.
    

Comments

APAR Information

  • APAR number

    LI73872

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-05

  • Closed date

    2009-05-29

  • Last modified date

    2009-05-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 May 2009