95 lines
4.9 KiB
Plaintext
95 lines
4.9 KiB
Plaintext
-- *****************************************************************************
|
|
-- ** automatically created redirect restore script
|
|
-- *****************************************************************************
|
|
UPDATE COMMAND OPTIONS USING S ON Z ON NBUDB_NODE0000.out V ON;
|
|
SET CLIENT ATTACH_MEMBER 0;
|
|
SET CLIENT CONNECT_MEMBER 0;
|
|
-- *****************************************************************************
|
|
-- ** automatically created redirect restore script
|
|
-- *****************************************************************************
|
|
RESTORE DATABASE NBUDB
|
|
-- USER <username>
|
|
-- USING '<password>'
|
|
LOAD '/usr/openv/netbackup/bin/nbdb2.so64'
|
|
OPEN 4 SESSIONS
|
|
OPTIONS 'DB2_CLIENT=cvdb2:DB2_POLICY=bk-db2:DB2_FULL=1'
|
|
TAKEN AT 20240815135857
|
|
-- ON '/home/db2inst1'
|
|
DBPATH ON '/fcdm/8627c95c-32ac-e16b-c31f-59632309da1b/NBUDB'
|
|
INTO NBUDB
|
|
LOGTARGET 'DEFAULT'
|
|
-- NEWLOGPATH DEFAULT
|
|
-- WITH <num-buff> BUFFERS
|
|
-- BUFFER <buffer-size>
|
|
REPLACE HISTORY FILE
|
|
-- REPLACE EXISTING
|
|
REDIRECT
|
|
-- PARALLELISM <n>
|
|
-- WITHOUT ROLLING FORWARD
|
|
-- WITHOUT PROMPTING
|
|
;
|
|
-- *****************************************************************************
|
|
-- ** storage group definition
|
|
-- ** Default storage group ID = 0
|
|
-- ** Number of storage groups = 1
|
|
-- *****************************************************************************
|
|
-- *****************************************************************************
|
|
-- ** Storage group name = IBMSTOGROUP
|
|
-- ** Storage group ID = 0
|
|
-- ** Data tag = None
|
|
-- *****************************************************************************
|
|
-- SET STOGROUP PATHS FOR IBMSTOGROUP
|
|
-- ON '/home/db2inst1'
|
|
-- ;
|
|
-- *****************************************************************************
|
|
-- ** table space definition
|
|
-- *****************************************************************************
|
|
-- *****************************************************************************
|
|
-- ** Tablespace name = SYSCATSPACE
|
|
-- ** Tablespace ID = 0
|
|
-- ** Tablespace Type = Database managed space
|
|
-- ** Tablespace Content Type = All permanent data. Regular table space.
|
|
-- ** Tablespace Page size (bytes) = 4096
|
|
-- ** Tablespace Extent size (pages) = 4
|
|
-- ** Using automatic storage = Yes
|
|
-- ** Storage group ID = 0
|
|
-- ** Source storage group ID = -1
|
|
-- ** Data tag = None
|
|
-- ** Auto-resize enabled = Yes
|
|
-- ** Total number of pages = 32768
|
|
-- ** Number of usable pages = 32764
|
|
-- ** High water mark (pages) = 28816
|
|
-- *****************************************************************************
|
|
-- *****************************************************************************
|
|
-- ** Tablespace name = TEMPSPACE1
|
|
-- ** Tablespace ID = 1
|
|
-- ** Tablespace Type = System managed space
|
|
-- ** Tablespace Content Type = System Temporary data
|
|
-- ** Tablespace Page size (bytes) = 4096
|
|
-- ** Tablespace Extent size (pages) = 32
|
|
-- ** Using automatic storage = Yes
|
|
-- ** Total number of pages = 1
|
|
-- *****************************************************************************
|
|
-- *****************************************************************************
|
|
-- ** Tablespace name = USERSPACE1
|
|
-- ** Tablespace ID = 2
|
|
-- ** Tablespace Type = Database managed space
|
|
-- ** Tablespace Content Type = All permanent data. Large table space.
|
|
-- ** Tablespace Page size (bytes) = 4096
|
|
-- ** Tablespace Extent size (pages) = 32
|
|
-- ** Using automatic storage = Yes
|
|
-- ** Storage group ID = 0
|
|
-- ** Source storage group ID = -1
|
|
-- ** Data tag = -1
|
|
-- ** Auto-resize enabled = Yes
|
|
-- ** Total number of pages = 8192
|
|
-- ** Number of usable pages = 8160
|
|
-- ** High water mark (pages) = 96
|
|
-- *****************************************************************************
|
|
-- *****************************************************************************
|
|
-- ** start redirected restore
|
|
-- *****************************************************************************
|
|
RESTORE DATABASE NBUDB CONTINUE;
|
|
-- *****************************************************************************
|
|
-- ** end of file
|
|
-- ***************************************************************************** |