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

Specify the database instance to be recovered. If the instance to be recovered is the default, specify
DEFAULT.
-target database-name(s)
Specify this option to recover specific databases. When specifying multiple databases to be recovered,
use a comma to separate each database name. If you specify a database name containing a space
character, enclose the database name in double quotation marks (").
When both this option and the -f option are omitted, the entire instance will be recovered.
-f target-definition-file-name
Like the -target option, this option restores specific databases during recovery. Unlike the -target
option, this option lets you specify a target definition file that collectively specifies all the databases
to be restored. The target definition file containing the list of databases must be created before you
attempt to use this option. Use an absolute path name to specify the target definition file. If you specify
a target definition file name containing a space character, enclose the target definition file name in
double quotation marks (").
Make sure that you specify databases that exist in the specified instance. If you specify databases in
separate instances, those databases will not be recovered.
-transact_log_list name-of-target-definition-file-for-transaction-logs
Specify the order of the transaction log files to be applied during recovery. The order of these
transaction log files is listed in the name-of-target-definition-file-for-transaction-logs. Make sure that you
use an absolute path when specifying the file name. If you specify a
name-of-target-definition-file-for-transaction-logs name containing a space character, enclose the
name-of-target-definition-file-for-transaction-logs name in double quotation marks (").
The log to be applied differs, depending on the user operation. Confirm the backup log by using the
drmsqllogbackup command, and then select the log to be applied.
If this option is omitted, recovery processing by roll-forward is not performed, since the transaction
log is not applied. Therefore, the database will return to the latest backup status.
-undo
Specifies that the database should be put in standby mode, accessed as read-only, after recovery.
Temporary files will be created for each database in the undo file storage directory specified by the
drmsqlinit command. If the UNDO file storage directory has not been set using the drmsqlinit
command, an error message appears, indicating that no parameters are set for the drmsqlinit
command. Specify the UNDO file storage directory using the drmsqlinit command.
If both the -undo option and -loading option are omitted, the database can be fully accessed after
recovery, but any subsequent transaction logs are not applied.
-loading
Specify this to place the database in the loading status after recovery. In this status, transaction logs
can continue to be applied.
When the -loading option is specified, since no temporary files are created as with the -undo
option, you do not need to create the temporary file storage directory beforehand.
If both the -undo option and -loading option are omitted, the database can be fully accessed after
recovery, but any subsequent transaction logs are not applied.
Return Values
0: Normal termination
Any value other than 0: Termination with an error
CLI Reference Guide 173