db2 drop db txdb

cd /db2/db8sr003/db/TXDB

Remove all other files and folders except for the backup image TXDB.0.db2inst1.DBPART000.20170929070638.001

mkdir logtarget
mkdir DMS
mkdir AUTO


db2 "restore db txdb from '/db2/db8sr003/db/TXDB' taken at 20170929070638 INTO TXDB logtarget '/db2/db8sr003/db/TXDB/logtarget/' redirect generate script TXDB_node0000.clp"

Edit file TXDB_node0000.clp

mkmpgz2133:/db2/db8sr003/db/TXDB$ db2 -tvf TXDB_node0000.clp
UPDATE COMMAND OPTIONS USING S ON Z ON TXDB_NODE0000.out V ON
DB20000I  The UPDATE COMMAND OPTIONS command completed successfully.

SET CLIENT ATTACH_MEMBER  0
DB20000I  The SET CLIENT command completed successfully.

SET CLIENT CONNECT_MEMBER 0
DB20000I  The SET CLIENT command completed successfully.

RESTORE DATABASE TXDB FROM '/db2/db8sr003/db/TXDB' TAKEN AT 20170929070638 ON '/db2/db8sr003/db/TXDB' DBPATH ON '/db2/db8sr003/db/TXDB' INTO TXDB LOGTARGET '/db2/db8sr003/db/TXDB/logtarget/' REDIRECT
SQL1277W  A redirected restore operation is being performed. During a table
space restore, only table spaces being restored can have their paths
reconfigured. During a database restore, storage group storage paths and DMS
table space containers can be reconfigured.
DB20000I  The RESTORE DATABASE command completed successfully.

SET STOGROUP PATHS FOR IBMSTOGROUP ON '/db2/db8sr003/db/TXDB/AUTO'
DB20000I  The SET STOGROUP PATHS command completed successfully.

SET TABLESPACE CONTAINERS FOR 3 USING ( FILE   '/db2/db8sr003/db/TXDB/DMS/AUDITTS' 13072 )
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.

SET TABLESPACE CONTAINERS FOR 8 USING ( FILE   '/db2/db8sr003/db/TXDB/DMS/datats_8k' 1508896 )
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.

SET TABLESPACE CONTAINERS FOR 9 USING ( FILE   '/db2/db8sr003/db/TXDB/DMS/indxts_8k' 500000 )
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.

SET TABLESPACE CONTAINERS FOR 10 USING ( PATH   '/db2/db8sr003/db/TXDB/DMS/stmpts_8k' )
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.

SET TABLESPACE CONTAINERS FOR 11 USING ( FILE   '/db2/db8sr003/db/TXDB/DMS/lobsts_8k' 500000 )
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.

RESTORE DATABASE TXDB CONTINUE
DB20000I  The RESTORE DATABASE command completed successfully.


mkmpgz2133:/db2/db8sr003/db/TXDB$ db2 "rollforward db txdb to end of backup OVERFLOW LOG PATH ('/db2/db8sr003/db/TXDB/logtarget/')"

                                 Rollforward Status

 Input database alias                   = txdb
 Number of members have returned status = 1

 Member ID                              = 0
 Rollforward status                     = DB  working
 Next log file to be read               = S0002443.LOG
 Log files processed                    =  -
 Last committed transaction             = 2017-09-29-11.07.28.000000 UTC

DB20000I  The ROLLFORWARD command completed successfully.
mkmpgz2133:/db2/db8sr003/db/TXDB$ db2 "rollforward db txdb stop OVERFLOW LOG PATH ('/db2/db8sr003/db/TXDB/logtarget/')"

                                 Rollforward Status

 Input database alias                   = txdb
 Number of members have returned status = 1

 Member ID                              = 0
 Rollforward status                     = not pending
 Next log file to be read               =
 Log files processed                    = S0002443.LOG - S0002443.LOG
 Last committed transaction             = 2017-09-29-11.07.28.000000 UTC

DB20000I  The ROLLFORWARD command completed successfully.
mkmpgz2133:/db2/db8sr003/db/TXDB$