DB2 FOR LUW / DB2FORLUW / B50 - DB2

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

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 v11.5 Mod 2 Fix Pack 0 or higher              *
****************************************************************

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.

not known / see Local fix

forerunner  : IT30278 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.11.2019
18.02.2020
18.02.2020