IBM Support

IT30844: IN DPF ENVIRONMENT THE RESTART DATABASE COMMAND MAY FAIL WITH SQL10003C IF TABLESPACE(S) ARE IN AN ABNORMAL STATE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The error can be encountered if a database crashes while
    transactions are indoubt and during the subsequent crash
    recovery a storage error is encountered on a tablespace
    which makes the tablespace inaccessible.  After completing
    crash recovery, Db2 will detect the presence of indoubt
    transactions and will attempt to resolve it.  If the indoubt
    transaction made changes to the tablespace that is no
    longer accessible, SQL10003C error is returned and the
    database is shut down.
    
    $ db2 restart db sample
    SQL10003C  There are not enough system resources to process the
    request.  The request cannot be processed.  SQLSTATE=57011
    
    
    The following messages can be found in db2diag.log.
    
    2019-10-09-02.16.00.686210-420 I28689E515            LEVEL: Info
    PID     : 3015                 TID : 140427164378880 PROC :
    db2sysc 2
    INSTANCE: db2v1058             NODE : 002            DB   :
    SAMPLE
    APPHDL  : 2-57                 APPID: *N2.db2v1058.191009091600
    AUTHID  : DB2V1058             HOSTNAME: TURING11
    EDUID   : 67                   EDUNAME: db2agent (SAMPLE) 2
    FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
    DATA #1 : <preformatted>
    Crash recovery completed. Next LSN is 0000000000001969.
    
    2019-10-09-02.16.00.686538-420 I29205E539            LEVEL:
    Warning
    PID     : 3015                 TID : 140427164378880 PROC :
    db2sysc 2
    INSTANCE: db2v1058             NODE : 002            DB   :
    SAMPLE
    APPHDL  : 2-57                 APPID: *N2.db2v1058.191009091600
    AUTHID  : DB2V1058             HOSTNAME: TURING11
    EDUID   : 67                   EDUNAME: db2agent (SAMPLE) 2
    FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3280
    DATA #1 : <preformatted>
    In-doubt transaction(s) exists at the end of crash recovery on
    log stream 2.
    
    2019-10-09-02.16.00.686951-420 E29745E495            LEVEL:
    Warning
    PID     : 3015                 TID : 140427164378880 PROC :
    db2sysc 2
    INSTANCE: db2v1058             NODE : 002            DB   :
    SAMPLE
    APPHDL  : 2-57                 APPID: *N2.db2v1058.191009091600
    AUTHID  : DB2V1058             HOSTNAME: TURING11
    EDUID   : 67                   EDUNAME: db2agent (SAMPLE) 2
    FUNCTION: DB2 UDB, recovery manager, sqlpssdw, probe:100
    MESSAGE : Resolving indoubt transactions with other nodes.
    
    2019-10-09-02.16.00.918253-420 I30241E622            LEVEL:
    Severe
    PID     : 3015                 TID : 140427097270016 PROC :
    db2sysc 2
    INSTANCE: db2v1058             NODE : 002            DB   :
    SAMPLE
    APPHDL  : 2-57                 APPID: *N2.db2v1058.191009091600
    AUTHID  : DB2V1058             HOSTNAME: TURING11
    EDUID   : 108                  EDUNAME: db2agnsc (SAMPLE) 2
    FUNCTION: DB2 UDB, data management, sqldmund, probe:1184
    MESSAGE :
    ZRC=0x80020033=-2147352525=SQLB_NOT_ALLOWED_ROLLFORWARD_P
              "Access not allowed. Tblspc RF Pending."
    DATA #1 : <preformatted>
    Error during UNDO of LSN: 0000000000001965
    
    2019-10-09-02.16.00.918622-420 I30864E554            LEVEL:
    Severe
    PID     : 3015                 TID : 140427097270016 PROC :
    db2sysc 2
    INSTANCE: db2v1058             NODE : 002            DB   :
    SAMPLE
    APPHDL  : 2-57                 APPID: *N2.db2v1058.191009091600
    AUTHID  : DB2V1058             HOSTNAME: TURING11
    EDUID   : 108                  EDUNAME: db2agnsc (SAMPLE) 2
    FUNCTION: DB2 UDB, data management, sqldmund, probe:1184
    RETCODE :
    ZRC=0x80020033=-2147352525=SQLB_NOT_ALLOWED_ROLLFORWARD_P
              "Access not allowed. Tblspc RF Pending."
    
    2019-10-09-02.16.00.918823-420 I31419E739            LEVEL:
    Severe
    PID     : 3015                 TID : 140427097270016 PROC :
    db2sysc 2
    INSTANCE: db2v1058             NODE : 002            DB   :
    SAMPLE
    APPHDL  : 2-57                 APPID: *N2.db2v1058.191009091600
    AUTHID  : DB2V1058             HOSTNAME: TURING11
    EDUID   : 108                  EDUNAME: db2agnsc (SAMPLE) 2
    FUNCTION: DB2 UDB, data management, sqldmund, probe:1184
    MESSAGE : Error during UNDO of log record:
    DATA #1 : Hexdump, 38 bytes
    0x00007FB7BB3FC2E0 : 01A2 0200 1400 0000 1200 F41A 0700 0000
    ................
    0x00007FB7BB3FC2F0 : 0000 041B 0000 1200 0100 0A00 0800 0000
    ................
    0x00007FB7BB3FC300 : 0008 0000 0000
    ......
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IT30844 or higher                                 *
    ****************************************************************
    

Problem conclusion

  • Upgrade to IT30844 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30844

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-11-04

  • Closed date

    2021-03-19

  • Last modified date

    2021-03-19

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

    IT30578

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
20 March 2021