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

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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 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