Manualshelf

HP StorageWorks P9000 Command View Advanced Edition Suite Software 7.0 Mainframe Agent Installation and Configuration Guide (TB581-96014, November 2010)

ManualsBrandsHP ManualsSoftwareHP XP P9000 Command View Advanced Edition Software
151152153154155156157158159160
PROMPT> drmsqlcat SQL1 -v
VIRTUAL-SERVERNAME: DB_SVR1
DB-PATH: D:\Program Files\Hitachi\DRM\db2
KAVX0024-E The specified backup data does not exist.
• In this example, the command is used to display the backup catalog beginning with SQL2-DR-
10.0:
PROMPT>drmsqlcat default -comment "SQL2-DR-10.01*"
INSTANCE: default
BACKUP-COMMENT: SQL2-DR-10.01-03:56-001
BACKUP-ID: 0000000010 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000010
START-TIME: 12.12.03 14:25:40 END-TIME: 12.12.03 14:25:41 HOSTNAME: flora4
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
M UserDB1 METAFILE C:\ meta\0000000010_0000000005.dmp - - - -
D UserDB1 DATAFILE O:\UserDB1_Data.MDF
O: - Harddisk3 STD03,sqlstd022
- - - -
- - - STD03,sqlstd022
T UserDB1 TRANSACT O:\UserDB1_Log.LDF
O: - Harddisk3 STD03,sqlstd022
- - - -
- - - STD03,sqlstd022
• In this example, the command is used to display the template catalog:
PROMPT>drmsqlcat default -template
INSTANCE: default
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000002
START-TIME: 04.02.04 13:01:35 END-TIME: 04.02.04 13:02:33 HOSTNAME: flora4
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
M UserDB1 METAFILE O:\MSSQL\0000000002_0000000001.dmp - - - -
D UserDB1 DATAFILE O:\UserDB1_Data.MDF
O: - Harddisk4 SI01,sql01
- - - -
- - - SI01,sql01
T UserDB1 TRANSACT O:\UserDB1_Log.LDF
O: - Harddisk4 SI01,sql01
- - - -
- - - SI01,sql01
• In this example, the command is used to display the log sequence number and full backup time
of each database registered in the backup catalog:
PROMPT> drmsqlcat SQL1 -lsn
INSTANCE: SQL1
BACKUP-ID: 0000000001 BACKUP-MODE: ON-LINE INSTANCE: SQL1 ORIGINAL-ID: 0000000001
START-TIME: 2009/10/01 10:00:00 END-TIME: 2009/10/01 10:03:00 HOSTNAME: DB_SVR1
T DB OBJECT FILE CHECKPOINT-LSN FULL-BACKUP-TIME
FS DG DEVICE COPY-GROUP
M DB1 METAFILE C:\METADIR\Meta1 - -
C: - - -
D DB1 DATAFILE D:\SQL\data1.mdf 49000000018400037 2009/10/01 10:01:00
D: - Harddisk2 VG02,dev02
- - - - - -
- - - VG02.dev02
T DB1 TRANSACT D:\SQL\tlog1.ldf - -
D: - Harddisk2 VG02,dev02
- - - - - -
- - - VG02.dev02
M DB2 METAFILE C:\METADIR\Meta2 - -
C: - - -
D DB1 DATAFILE D:\SQL\data2.mdf 259000000004000089 2009/10/01 10:01:00
D: - Harddisk2 VG02,dev02
- - - - - - -
- - VG02.dev02
T DB1 TRANSACT D:\SQL\tlog2.ldf - -
D: - Harddisk2 VG02,dev02
Basic commands156