IBM Maximo: Migrate MAXDB to RH OpenShift (restoresql.sql)
Jump to navigation
Jump to search
-- ***************************************************************************** -- ** automatically created redirect restore script -- ***************************************************************************** UPDATE COMMAND OPTIONS USING S ON Z ON MAXDB76_NODE0000.out V ON; SET CLIENT ATTACH_MEMBER 0; SET CLIENT CONNECT_MEMBER 0; -- ***************************************************************************** -- ** automatically created redirect restore script -- ***************************************************************************** RESTORE DATABASE MAXDB76 -- USER <username> -- USING '<password>' FROM '/mnt/backup' TAKEN AT 20220913055916 -- ON '/home/ctginst1' -- DBPATH ON '<target-directory>' INTO MAXDB76 -- 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/ctginst1' -- ; -- ***************************************************************************** -- ** 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) = 32768 -- ** 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 = 15360 -- ** Number of usable pages = 15356 -- ** High water mark (pages) = 15352 -- ***************************************************************************** -- ***************************************************************************** -- ** Tablespace name = TEMPSPACE1 -- ** Tablespace ID = 1 -- ** Tablespace Type = System managed space -- ** Tablespace Content Type = System Temporary data -- ** Tablespace Page size (bytes) = 32768 -- ** 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) = 32768 -- ** 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 = 1024 -- ** Number of usable pages = 992 -- ** High water mark (pages) = 96 -- ***************************************************************************** -- ***************************************************************************** -- ** Tablespace name = SYSTOOLSPACE -- ** Tablespace ID = 3 -- ** Tablespace Type = Database managed space -- ** Tablespace Content Type = All permanent data. Large table space. -- ** Tablespace Page size (bytes) = 32768 -- ** 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 = 1024 -- ** Number of usable pages = 1020 -- ** High water mark (pages) = 100 -- ***************************************************************************** -- ***************************************************************************** -- ** Tablespace name = SYSTOOLSTMPSPACE -- ** Tablespace ID = 4 -- ** Tablespace Type = System managed space -- ** Tablespace Content Type = User Temporary data -- ** Tablespace Page size (bytes) = 32768 -- ** Tablespace Extent size (pages) = 4 -- ** Using automatic storage = Yes -- ** Total number of pages = 1 -- ***************************************************************************** -- ***************************************************************************** -- ** Tablespace name = MAXDATA -- ** Tablespace ID = 5 -- ** Tablespace Type = Database managed space -- ** Tablespace Content Type = All permanent data. Regular table space. -- ** Tablespace Page size (bytes) = 32768 -- ** 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 = 160000 -- ** Number of usable pages = 159968 -- ** High water mark (pages) = 122048 -- ***************************************************************************** -- ***************************************************************************** -- ** Tablespace name = MAXINDEX -- ** Tablespace ID = 6 -- ** Tablespace Type = Database managed space -- ** Tablespace Content Type = All permanent data. Regular table space. -- ** Tablespace Page size (bytes) = 32768 -- ** 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 = 160000 -- ** Number of usable pages = 159968 -- ** High water mark (pages) = 93408 -- ***************************************************************************** -- ***************************************************************************** -- ** Tablespace name = MAXTEMP -- ** Tablespace ID = 7 -- ** Tablespace Type = System managed space -- ** Tablespace Content Type = System Temporary data -- ** Tablespace Page size (bytes) = 32768 -- ** Tablespace Extent size (pages) = 32 -- ** Using automatic storage = Yes -- ** Total number of pages = 1 -- ***************************************************************************** -- ***************************************************************************** -- ** start redirected restore -- ***************************************************************************** RESTORE DATABASE MAXDB76 CONTINUE; -- ***************************************************************************** -- ** end of file -- *****************************************************************************