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

- - - - - -
- - - VG02.dev02
drmsqldisplay (Displays or updates information for an SQL Server database)
Formats
To display the information for the SQL Server database:
drmsqldisplay [ instance-name ]
[ -target database-name | -f target-definition-file-name ]
[ -transact_log ][ -datafile ]
[ -device device-file-name ][ -l ][ -v ][ -cf ]
To display information with linking for copy groups for both the local site and remote sites:
drmsqldisplay [ instance-name ]
[ -target database-name | -f target-definition-file-name ]
[ -transact_log ][ -datafile ]
[ -v ][ -remote ]
To update the information in the dictionary map files:
drmsqldisplay [instance-name ] -refresh [ -coremap ]
Description
The drmsqldisplay command does the following:
1. Displays the resource information of the SQL Server database on the server on which the command
was executed.
2. Displays resource information pertaining to optional instances for the system on which the
command was executed.
3. Updates the SQL Server database information of the dictionary map files. Execute this command
before performing a backup.
The items displayed in 1 and 2 are shown in the table below.
Table 40 Items displayed by the drmsqldisplay command
MeaningDisplayed item
The name of the SQL server instanceINSTANCE
The object type:
D: Data file
T: Transaction log
T
The name of the SQL server databaseDB
CLI Reference Guide 157