HP StorageWorks P9000 Command View Advanced Edition Suite Software 7.0 Mainframe Agent Installation and Configuration Guide (TB581-96014, November 2010)
Any value other than 0: Termination with an error
Examples
• In this example, the command is used to display information about the SQL Server database spe-
cified in instance SQL1:
PROMPT> drmsqlcat SQL1
INSTANCE: SQL1
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: SQL1 ORIGINAL-ID: 0000000001
START-TIME: 2002/06/01 10:00:00 END-TIME: 2002/06/01 10:03:00 HOSTNAME: DB_SVR1
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
M DB1 METAFILE C:\METADIR\Meta1 C: - - -
D DB1 DATAFILE D:\SQL\data1.mdf 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 D: - Harddisk2 VG02,dev02
- - - - - - - VG02,dev02
T DB1 TRANSACT D:\SQL\tlog2.ldf D: - Harddisk2 VG02,dev02
- - - - - - - VG02,dev02
• In this example, the command is used to display two generations of backup information, in the
long format, about the SQL Server database specified in instance SQL1:
PROMPT> drmsqlcat SQL1 -l
INSTANCE: SQL1
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: SQL1 ORIGINAL-ID: 0000000001
START-TIME: 2002/06/01 10:00:00 END-TIME: 2002/06/01 10:03:00 HOSTNAME: DB_SVR1
T DB OBJECT FILE FS FSTYPE DG LVM-DEVICE
DEVICE COPY-GROUP PORT# TID# LUN# MU# LDEV# P/S SERIAL#
M DB1 METAFILE C:\METADIR\Meta1 C: NTFS - \\?\Volume{df66a5b0-5583-12d5-a410-806d6172696f}\
Harddisk1 VG11,dev01 CLI-A 2 10 0 10010 P 15044
D DB1 DATAFILE D:\SQL\data1.mdf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk2 VG12,dev02 CLI-A 2 20 0 10020 P 15044
- - - - - - - -
- VG12,dev02 CLI-A 2 21 0 10021 S 15044
T DB1 TRANSACT D:\SQL\tlog1.ldf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk2 VG12,dev02 CLI-A 2 20 0 10020 P 15044
- - - - - - - -
- VG12,dev02 CLI-A 2 21 0 10021 S 15044
M DB2 METAFILE C:\METADIR\Meta2 C: NTFS - \\?\Volume{df66a5b0-5583-12d5-a410-806d6172696f}\
Harddisk1 VG11,dev01 CLI-A 2 10 0 10010 P 15044
D DB1 DATAFILE D:\SQL\data2.mdf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk2 VG12,dev02 CLI-A 2 20 0 10020 P 15044
- - - - - - - -
- VG12,dev02 CLI-A 2 21 0 10021 S 15044
T DB1 TRANSACT D:\SQL\tlog2.ldf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk2 VG12,dev02 CLI-A 2 20 0 10020 P 15044
- - - - - - - -
- VG12,dev02 CLI-A 2 21 0 10021 S 15044
INSTANCE: SQL1
BACKUP-ID: 0000000002 BACKUP-MODE: ONLINE INSTANCE: SQL1 ORIGINAL-ID: 0000000002
START-TIME: 2002/06/02 10:00:00 END-TIME: 2002/06/02 10:03:00 HOSTNAME: DB_SVR1
T DB OBJECT FILE FS FSTYPE DG LVM-DEVICE
DEVICE COPY-GROUP PORT# TID# LUN# MU# LDEV# P/S SERIAL#
M DB1 METAFILE C:\METADIR\Meta1 C: NTFS - \\?\Volume{df66a5b0-5583-12d5-a410-806d6172696f}\
Harddisk1 VG11,dev01 CLI-A 2 10 0 10010 P 15044
D DB1 DATAFILE D:\SQL\data1.mdf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk2 VG12,dev02 CLI-A 2 20 0 10020 P 15044
- - - - - - - -
- VG12,dev02 CLI-A 2 21 0 10021 S 15044
T DB1 TRANSACT D:\SQL\tlog1.ldf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk2 VG12,dev02 CLI-A 2 20 0 10020 P 15044
- - - - - - - -
- VG12,dev02 CLI-A 2 21 0 10021 S 15044
M DB2 METAFILE C:\METADIR\Meta2 C: NTFS - \\?\Volume{df66a5b0-5583-12d5-a410-806d6172696f}\
Harddisk1 VG11,dev01 CLI-A 2 10 0 10010 P 15044
D DB1 DATAFILE D:\SQL\data2.mdf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk2 VG12,dev02 CLI-A 2 20 0 10020 P 15044
- - - - - - - -
Basic commands154