IBM Support

IC78292: SYSCATSPACE MAY BE PUT IN RESTORE PENDING IF LOAD COPY FILE IS MISSING ON HADR STANDBY OR DURING ROLLFORWARD

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • On HADR standby or during rollforward, replaying load copy log
    will fail if load copy image file is missing and corresponding
    tablespaces will be put in restore pending. However it's a
    defect that SYSCATSPACE may be put in restore pending in this
    situation.
    
    The following steps can be used to reproduce:
    
    1. Create two range partitioned tables with some overlap in
    their tablespaces
    db2 create tablespace ix1
    db2 create tablespace ts1
    db2 create tablespace ts2
    db2 create tablespace ts3
    db2 create table t1(c1 int not null, c2 varchar(100), primary
    key (c1)) index in ix1
    partition by range ("C1")
    (PART "PART0" STARTING(1) ENDING(300000) IN "TS1",
    PART "PART1" STARTING(300001) IN "TS2",
    PART "PART2" STARTING(600001) ENDING(1000000) IN "TS3");
    
    db2 create tablespace ts4
    db2 create tablespace ix2
    create table t2(c1 int  not null, c2 varchar(100) , primary key
    (c1)) index in i
    x2 partition by range ("C1") (PART "PART0" STARTING(1)
    ENDING(300000) IN "TS4",
    PART "PART1" STARTING(300001) IN "TS2", PART "PART2"
    STARTING(600001) ENDING(100
    0000) IN "TS3")
    
    2. Load tables on Primary
    [i] DB2_LOAD_COPY_NO_OVERRIDE=COPY YES to /tmp/load
    db2 load from 1m.out of del replace into t1 copy no
    db2 load from 1m.out of del replace into t2 copy no
    
    Please note the copy image file is not accessible from the
    standby.
    
    3. Replaying on Standby fails and SYSCATSPACE is put in restore
    pending.
    MESSAGE : Load copy image restore terminated with rc -3785
    
    2011-08-17-12.15.21.821289-600 I152258A453        LEVEL: Warning
    PID     : 1097968              TID  : 6989        PROC : db2sysc
    0
    INSTANCE: db2ins21             NODE : 000         DB   : HADR
    APPHDL  : 0-3804               APPID: *LOCAL.DB2.110817221500
    EDUID   : 6989                 EDUNAME: db2redom (HADR) 0
    FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
    DATA #1 : String, 53 bytes
    
    Following tablespace does not exist. TS ID: 65535, 0
    
    2011-08-17-12.15.21.828206-600 I152712A438        LEVEL: Warning
    PID     : 1097968              TID  : 6989        PROC : db2sysc
    0
    INSTANCE: db2ins21             NODE : 000         DB   : HADR
    APPHDL  : 0-3804               APPID: *LOCAL.DB2.110817221500
    EDUID   : 6989                 EDUNAME: db2redom (HADR) 0
    FUNCTION: DB2 UDB, recovery manager, sqlpRFWppl, probe:870
    MESSAGE : Tablespaces taken offline due to failed load recovery.
    
    2011-08-17-12.15.21.828377-600 I153151A437        LEVEL: Warning
    PID     : 1097968              TID  : 6989        PROC : db2sysc
    0
    INSTANCE: db2ins21             NODE : 000         DB   : HADR
    APPHDL  : 0-3804               APPID: *LOCAL.DB2.110817221500
    EDUID   : 6989                 EDUNAME: db2redom (HADR) 0
    FUNCTION: DB2 UDB, recovery manager, sqlpRFWppl, probe:870
    DATA #1 : <preformatted>
    Tablespace 0 in restore pending state.
    
    The HADR standby will fail to start once SYSCATSPACE is put
    in restore pending state.
    

Local fix

  • Make sure that load copy file is available before activating the
    standby
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 Fix Pack 6                               *
    ****************************************************************
    

Problem conclusion

  • First fixed to V9.7 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC78292

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-24

  • Closed date

    2012-06-25

  • Last modified date

    2012-06-25

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

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

    IC84405

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78292

Modified date: 25 June 2012