IBM Support

IT26339: 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 fixed if next.

Error description

  • The problem could be reproduced with these steps
    
    1) a NON-AS tablespace TBSP4 had a container named
    /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000004/C0000000.LRG,
    which is the same name/path as if it were created as an AS
    tablespace
    
    2) ALTER TABLESPACE TBSP4 MANAGED BY AUTOMATIC STORAGE
        it failed with sql0299n
    
    3) ALTER TABLESPACE TBSP4 MANAGED BY AUTOMATIC STORAGE
       it succeed
    
    4) Then check storage+tablespace,  the tablespace is offline.
    
    5) in db2diag.log, we can find
    
    
    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>
    
    6) and check the tablespace SQLSPCS.1/SQLSPCS.2, the container
    definition for this tablespace is corrupted.
    

Local fix

  • before alter tablespace to AS, make sure the container name is
    different with the one as if it is a AS tablespace container.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to latest Db2 V11.1 fix pack.                        *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT26339

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-09-18

  • Closed date

    2018-11-07

  • Last modified date

    2018-11-07

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

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

    IT26871

Fix information

Applicable component levels

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

Document Information

Modified date:
07 November 2018