IBM Support

IT26871: TABLE SPACE OFFLINE AFTER "ALTER TABLESPACE ... MANAGED BY AUTOMATIC STORAGE" COMMAND

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The problem can be reproduced with these steps:
    
    1) A non-automatic storage table space TS1 has a container named
    /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000004/C0000000.LRG,
    which is the same name/path as if it were created as an
    automatic storage table space.
    2) ALTER TABLESPACE TS1 MANAGED BY AUTOMATIC STORAGE
        -> It fails with SQL0299N
    3) ALTER TABLESPACE TS1 MANAGED BY AUTOMATIC STORAGE
        -> It succeeds
    4) Check db2diag.log. The table space is offline due to the
    following message:
    
    2018-09-08-13.17.33.889445-300 I415126465A684      LEVEL: Error
    PID    : 20316290            TID : 21576         PROC : db2sysc
    0
    INSTANCE: db2inst1            NODE : 000          DB  : SAMPLE
    APPHDL : 0-353               APPID: *LOCAL.db2inst1.180908171848
    AUTHID : DB2INST1            HOSTNAME: db2host1
    EDUID  : 21576               EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbDMSAddContainerRequest, probe:867
    MESSAGE :
    ZRC=0x8002003D=-2147352515=SQLB_CONTAINER_ALREADY_ADDED
             "Duplicate container"
    DATA #1 : <preformatted>
    

Local fix

  • Before altering the table space to automatic storage make sure
    the container name is different than if it was an automatic
    storage table space container.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26871

  • 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

    2018-11-07

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

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

    IT26339

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 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:
02 September 2021