IBM Support

IT33687: ROLLFORWARD CAN RESULT IN SQL1042C AFTER SET TABLE SPACE CONTAINERS USING AUTOMATIC STORAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A restore that redirects DMS table spaces to use automatic
    storage can cause a subsequent rollforward to fail with SQL1042C
    if the rollforward replays an ALTER TABLESPACE operation
    involving a raw device container. The ALTER TABLESPACE being
    replayed must be for one of the table spaces redirected to use
    automatic storage.
     
    An example of such an ALTER TABLESPACE is ?alter tablespace
    <tablespace_name> begin new stripe set ( device '<rawdevice>'
    1000 )?
    &#160;
    This will produce entires in the db2diag.log file similar to the
    following:
    &#160;
    2020-07-22-09.19.50.406541-240 I365142E602 &#160; &#160; &#160; &#160; &#160; LEVEL:
    Error
    PID &#160; &#160; : 10359 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;TID : 139668939073280 PROC :
    db2sysc
    INSTANCE: XXXXXXXX &#160; &#160; &#160; &#160; &#160; &#160; NODE : 000 &#160; &#160; &#160; &#160; &#160; &#160;DB &#160; :
    XXXXXX
    APPHDL &#160;: 0-63 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; APPID: XXXXXXXX
    AUTHID &#160;: XXXXXXXX &#160; &#160; &#160; &#160; &#160; &#160; HOSTNAME: XXXXXXXX
    EDUID &#160; : 213 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;EDUNAME: db2redom (XXXXXX)
    FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:65
    MESSAGE : ZRC=0x800201A3=-2147352157=SQLB_AS_CLAUSE_NOT_ALLOWED
    &#160; &#160; &#160; &#160; &#160; "A tablespace clause was not allowed in the command or
    statement."
    &#160;
    2020-07-22-09.19.50.406710-240 I365745E596 &#160; &#160; &#160; &#160; &#160; LEVEL:
    Error
    PID &#160; &#160; : 10359 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;TID : 139668939073280 PROC :
    db2sysc
    INSTANCE: XXXXXXXX &#160; &#160; &#160; &#160; &#160; &#160; NODE : 000 &#160; &#160; &#160; &#160; &#160; &#160;DB &#160; :
    XXXXXX
    APPHDL &#160;: 0-63 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; APPID: XXXXXXXX
    AUTHID &#160;: XXXXXXXX &#160; &#160; &#160; &#160; &#160; &#160; HOSTNAME: XXXXXXXX
    EDUID &#160; : 213 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;EDUNAME: db2redom (XXXXXX)
    FUNCTION: DB2 UDB, buffer pool services, sqlbRedo, probe:0
    MESSAGE : ZRC=0x800201A3=-2147352157=SQLB_AS_CLAUSE_NOT_ALLOWED
    &#160; &#160; &#160; &#160; &#160; "A tablespace clause was not allowed in the command or
    statement."
    &#160;
    2020-07-22-09.19.50.406784-240 I366342E713 &#160; &#160; &#160; &#160; &#160; LEVEL:
    Severe
    PID &#160; &#160; : 10359 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;TID : 139668939073280 PROC :
    db2sysc
    INSTANCE: XXXXXXXX &#160; &#160; &#160; &#160; &#160; &#160; NODE : 000 &#160; &#160; &#160; &#160; &#160; &#160;DB &#160; :
    XXXXXX
    APPHDL &#160;: 0-63 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; APPID: XXXXXXXX
    AUTHID &#160;: XXXXXXXX &#160; &#160; &#160; &#160; &#160; &#160; HOSTNAME: XXXXXXXX
    EDUID &#160; : 213 &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;EDUNAME: db2redom (XXXXXX)
    FUNCTION: DB2 UDB, data management, sqldmrdo, probe:1388
    MESSAGE : ZRC=0x800201A3=-2147352157=SQLB_AS_CLAUSE_NOT_ALLOWED
    &#160; &#160; &#160; &#160; &#160; "A tablespace clause was not allowed in the command or
    statement."
    DATA #1 : String, 25 bytes
    Error during REDO of LSN:
    DATA #2 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes
    0000000000039C6D
    

Local fix

  • Take a backup after alter table space operations involving raw
    devices have completed, then do a redirected restore and
    rollforward using that backup image.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

  • See local Fix
    

Comments

APAR Information

  • APAR number

    IT33687

  • 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

    2020-07-24

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

    IT33680

  • 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

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022