-- *****************************************************************************

-- ** automatically created redirect restore script

-- *****************************************************************************

UPDATE COMMAND OPTIONS USING S ON Z ON OPNACT_NODE0000.out V ON;

SET CLIENT ATTACH_MEMBER  0;

SET CLIENT CONNECT_MEMBER 0;

-- *****************************************************************************

-- ** automatically created redirect restore script

-- *****************************************************************************

RESTORE DATABASE OPNACT

-- USER  <username>

-- USING '<password>'

FROM 'Z:\Db2backups'

TAKEN AT 20160208194316

ON 'z:'

DBPATH ON 'z:'

INTO OPNACT

-- NEWLOGPATH 'D:\DB2\NODE0000\SQL00001\LOGSTREAM0000\'

-- 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 'D:'

-- ;

-- *****************************************************************************

-- ** 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)                  = 27544

-- *****************************************************************************

-- *****************************************************************************

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

-- *****************************************************************************

-- *****************************************************************************

-- ** Tablespace name                            = OATMPTABSPACE

-- **   Tablespace ID                            = 3

-- **   Tablespace Type                          = System managed space                        

-- **   Tablespace Content Type                  = System Temporary data                       

-- **   Tablespace Page size (bytes)             = 32768

-- **   Tablespace Extent size (pages)           = 32

-- **   Using automatic storage                  = No      

-- **   Total number of pages                    = 1

-- *****************************************************************************

SET TABLESPACE CONTAINERS FOR 3

-- IGNORE ROLLFORWARD CONTAINER OPERATIONS

USING (

  PATH   'OATMPTABSPACE'

);

-- *****************************************************************************

-- ** Tablespace name                            = OAREGTABSPACE

-- **   Tablespace ID                            = 4

-- **   Tablespace Type                          = Database managed space                      

-- **   Tablespace Content Type                  = All permanent data. Large table space.      

-- **   Tablespace Page size (bytes)             = 32768

-- **   Tablespace Extent size (pages)           = 32

-- **   Using automatic storage                  = No      

-- **   Storage group ID                         = -1

-- **   Source storage group ID                  = -1

-- **   Data tag                                 = None

-- **   Auto-resize enabled                      = Yes     

-- **   Total number of pages                    = 4480

-- **   Number of usable pages                   = 4448

-- **   High water mark (pages)                  = 4160

-- *****************************************************************************

SET TABLESPACE CONTAINERS FOR 4

-- IGNORE ROLLFORWARD CONTAINER OPERATIONS

USING (

  FILE   'OAREGTABSPACE'                                                    4480

);

-- *****************************************************************************

-- ** Tablespace name                            = SYSTOOLSPACE

-- **   Tablespace ID                            = 5

-- **   Tablespace Type                          = Database managed space                      

-- **   Tablespace Content Type                  = All permanent data. Large 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                                 = -1

-- **   Auto-resize enabled                      = Yes     

-- **   Total number of pages                    = 8192

-- **   Number of usable pages                   = 8188

-- **   High water mark (pages)                  = 152

-- *****************************************************************************

-- *****************************************************************************

-- ** start redirected restore

-- *****************************************************************************

RESTORE DATABASE OPNACT CONTINUE;

-- *****************************************************************************

-- ** end of file

-- *****************************************************************************