IBM Support

IT30278: TABLESPACE CONTAINERS COULD BE DELETED WHEN A STORAGE GROUP EXIST ON DBPATH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With a storage group created on its db path, the tablespace
    containers in this storage group could be deleted when another
    DB is dropped, in a scenario like the following:
    
    - DB tstb reuses the db path after the DB tsta
    with the storage group TST_SG has been dropped
    - restore of DB tsta puts the storage group TST_SG to DB tstb's
    db path
    - drop of DB tstb deletes all content in its db path including
    the restored TST_SG of DB tsta
    
    -------------------------------------
    (v111_331@norco1) /home/v111_331
    $ db2 create db tsta
    DB20000I  The CREATE DATABASE command completed successfully.
    (v111_331@norco1) /home/v111_331
    $ db2 connect to tsta
    
       Database Connection Information
    
    Database server        = DB2/LINUXX8664 11.1.3.3
    SQL authorization ID   = V111_331
    Local database alias   = TSTA
    
    (v111_331@norco1) /home/v111_331
    $ db2 "CREATE STOGROUP TST_SG ON
    '/home/v111_331/v111_331/NODE0000/SQL00001'"
    DB20000I  The SQL command completed successfully.
    >>>>> this is the main point of this issue.
    (v111_331@norco1) /home/v111_331
    $ db2 "CREATE TABLESPACE TST_TBSP USING STOGROUP TST_SG"
    DB20000I  The SQL command completed successfully.
    (v111_331@norco1) /home/v111_331
    $ db2 terminate
    DB20000I  The TERMINATE command completed successfully.
    (v111_331@norco1) /home/v111_331
    $ db2 backup db tsta
    
    Backup successful. The timestamp for this backup image is :
    20190821005912
    
    (v111_331@norco1) /home/v111_331
    $ db2 drop db tsta
    DB20000I  The DROP DATABASE command completed successfully.
    (v111_331@norco1) /home/v111_331
    $ db2 create db tstb
    DB20000I  The CREATE DATABASE command completed successfully.
    (v111_331@norco1) /home/v111_331
    $ db2 restore db tsta
    DB20000I  The RESTORE DATABASE command completed successfully.
    (v111_331@norco1) /home/v111_331
    $ db2 drop db tstb
    DB20000I  The DROP DATABASE command completed successfully.
    (v111_331@norco1) /home/v111_331
    $ db2 connect to tsta
    SQL1051N  The path "/home/v111_331/v111_331/NODE0000/SQL00001"
    does not exist
    or is not valid.  SQLSTATE=57019
    (v111_331@norco1) /home/v111_331
    -------------------------------------
    

Local fix

  • Do not create a storage group in the DBPATH.  If one is already
    created, using redirect restore to relocate the storage group to
    a different path other than the DBPATH.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to db2_v111m4fp6                                     *
    ****************************************************************
    

Problem conclusion

  • Do not create a storage group in the DBPATH.  If one is already
    created, using redirect restore to relocate the storage group to
    a different path other than the DBPATH.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30278

  • 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-09-13

  • Closed date

    2021-03-13

  • Last modified date

    2021-03-13

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

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

    IT30898

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSY

       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