IBM Support

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

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

  • 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 )?
     
    This will produce entires in the db2diag.log file similar to the
    following:
     
    2020-07-22-09.19.50.406541-240 I365142E602           LEVEL:
    Error
    PID     : 10359                TID : 139668939073280 PROC :
    db2sysc
    INSTANCE: XXXXXXXX             NODE : 000            DB   :
    XXXXXX
    APPHDL  : 0-63                 APPID: XXXXXXXX
    AUTHID  : XXXXXXXX             HOSTNAME: XXXXXXXX
    EDUID   : 213                  EDUNAME: db2redom (XXXXXX)
    FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:65
    MESSAGE : ZRC=0x800201A3=-2147352157=SQLB_AS_CLAUSE_NOT_ALLOWED
              "A tablespace clause was not allowed in the command or
    statement."
     
    2020-07-22-09.19.50.406710-240 I365745E596           LEVEL:
    Error
    PID     : 10359                TID : 139668939073280 PROC :
    db2sysc
    INSTANCE: XXXXXXXX             NODE : 000            DB   :
    XXXXXX
    APPHDL  : 0-63                 APPID: XXXXXXXX
    AUTHID  : XXXXXXXX             HOSTNAME: XXXXXXXX
    EDUID   : 213                  EDUNAME: db2redom (XXXXXX)
    FUNCTION: DB2 UDB, buffer pool services, sqlbRedo, probe:0
    MESSAGE : ZRC=0x800201A3=-2147352157=SQLB_AS_CLAUSE_NOT_ALLOWED
              "A tablespace clause was not allowed in the command or
    statement."
     
    2020-07-22-09.19.50.406784-240 I366342E713           LEVEL:
    Severe
    PID     : 10359                TID : 139668939073280 PROC :
    db2sysc
    INSTANCE: XXXXXXXX             NODE : 000            DB   :
    XXXXXX
    APPHDL  : 0-63                 APPID: XXXXXXXX
    AUTHID  : XXXXXXXX             HOSTNAME: XXXXXXXX
    EDUID   : 213                  EDUNAME: db2redom (XXXXXX)
    FUNCTION: DB2 UDB, data management, sqldmrdo, probe:1388
    MESSAGE : ZRC=0x800201A3=-2147352157=SQLB_AS_CLAUSE_NOT_ALLOWED
              "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

[{"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:
01 April 2021