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

Return Values
0: Normal termination
Any value other than 0: Termination with an error
Examples
• In this example, the command is used to display information about the database SQL1:
PROMPT> drmsqldisplay SQL1
INSTANCE: SQL1
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
D DB1 DATAFILE D:\SQL\data1.mdf D: - Harddisk1 VG01,dev01
- - - - - - - VG01,dev01
T DB1 TRANSACT D:\SQL\tlog1.ldf D: - Harddisk1 VG01,dev01
- - - - - - - VG01,dev01
D DB2 DATAFILE E:\SQL\data2.mdf E: - Harddisk2 VG02,dev02
- - - - - - - VG02,dev02
T DB2 TRANSACT E:\SQL\tlog2.ldf E: - Harddisk2 VG02,dev02
- - - - - - - VG02,dev02
• In this example, the command is used to display information, in the long format, about the database
SQL1:
PROMPT> drmsqldisplay SQL1 -l
INSTANCE: SQL1
T DB OBJECT FILE FS FSTYPE DG LVM-DEVICE
DEVICE COPY-GROUP PORT# TID# LUN# MU# LDEV# P/S SERIAL#
D DB1 DATAFILE D:\SQL\data1.mdf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk1 VG01,dev01 CLI-A 2 10 0 10000 P 15044
- - - - - - - -
- VG01,dev01 CLI-A 2 20 0 10020 S 15044
D DB1 DATAFILE D:\SQL\data2,mdf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk1 VG01,dev01 CLI-A 2 10 0 10000 P 15044
- - - - - - - -
- VG01,dev01 CLI-A 2 20 0 10020 S 15044
T DB1 TRANSACT D:\SQL\tlog1.ldf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk1 VG01,dev01 CLI-A 2 10 0 10000 P 15044
- - - - - - - -
- VG01,dev01 CLI-A 2 20 0 10020 S 15044
T DB1 TRANSACT D:\SQL\tlog2.ldf D: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk1 VG01,dev01 CLI-A 2 10 0 10000 P 15044
- - - - - - - -
- VG01,dev01 CLI-A 2 20 0 10020 S 15044
D DB2 DATAFILE E:\SQL\data1.mdf E: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk1 VG02,dev01 CLI-A 2 11 0 10001 P 15044
- - - - - - - -
- VG02,dev01 CLI-A 2 21 0 10021 S 15044
D DB2 DATAFILE E:\SQL\data2.mdf E: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk1 VG02,dev01 CLI-A 2 11 0 10001 P 15044
- - - - - - - -
- VG02,dev01 CLI-A 2 21 0 10021 S 15044
T DB2 TRANSACT E:\SQL\tlog1.ldf E: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk1 VG02,dev01 CLI-A 2 11 0 10001 P 15044
- - - - - - - -
- VG02,dev01 CLI-A 2 21 0 10021 S 15044
T DB2 TRANSACT E:\SQL\tlog2.ldf E: NTFS - \\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk1 VG02,dev01 CLI-A 2 11 0 10001 P 15044
- - - - - - - -
- VG02,dev01 CLI-A 2 21 0 10021 S 15044
• In this example, the command is used to only display information, in the long format, about the
data file specified with the instance SQL1:
PROMPT> drmsqldisplay SQL1 -l -transact_log
INSTANCE: SQL1
Basic commands162