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

T DB OBJECT FILE FS FSTYPE DG LVM-DEVICE
DEVICE COPY-GROUP PORT# TID# LUN# MU# LDEV# P/S SERIAL#
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
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 display information about the SQL Server database spe-
cified by the instance SQL1 and management information for the dictionary map files:
PROMPT> drmsqldisplay SQL1 -v
VIRTUAL-SERVERNAME: host1
DB-PATH: D:\Program Files\CVXPAE\DRM\db2
INSTANCE: SQL1
CORE-MAPFILE-UPDATE-TIME: 2002/06/01 10:00:00
APP.-MAPFILE-UPDATE-TIME: 2002/06/01 10:00:00
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 about the SQL Server database spe-
cified by the instance SQL1 and management information for the dictionary map files (when the
dictionary map files do not exist):
PROMPT> drmsqldisplay SQL1 -v
VIRTUAL-SERVERNAME: host1
DB-PATH: D:\Program Files\Hitachi\DRM\db2
KAVX0039-E The core map file(s) cannot be found.
• In this example, this command is used to display the information including the cascade:
PROMPT> drmsqldisplay -remote -target UserDB1
INSTANCE: default
T DB OBJECT FILE L-COPY-GROUP R-COPY-GROUP PORT#
TID# LUN# MU# LDEV# P/S SERIAL#
D UserDB1 DATAFILE Z:\UserDB1_Data.MDF - - CL1-A
1 32 - 32 P 116
- - - - SI11,dev01 - CL1-A
1 60 0 60 S 116
- - - - TC11,dev11 - CL1-A
1 32 0 32 S 600
- - - - TC11,dev11 TC11,dev11#0 -
- - 0 60 C 600
T UserDB1 TRANSACT Z:\UserDB1_Log.LDF - - CL1-A
1 32 - 32 P 116
- - - - SI11,dev01 - CL1-A
1 60 0 60 S 116
CLI Reference Guide 163