IBM Support

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

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

  • 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

[{"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:
14 March 2021