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

the -e option alone sets the range from the first log backup ID to the log backup ID specified with
the -e option.
Possible log backup ID values are 0001 through 9999.
-lsn
Specify this option to display the detailed information of the transaction log files in the log backup
catalog. Log backup information about both log backup IDs that are associated with a backup ID
and log backup IDs that are not associated with a backup ID is displayed.
The displayed items are as follows:
Table 42 Items displayed by drmsqllogbackup -lsn
MeaningDisplayed item
Backup ID (10 digits)
#1
BACKUP-ID
Original ID (10 digits)ORIGINAL-ID
Log backup ID (4 digits)LOG-BACKUP-ID
SQL Server database name (set by MSSQL)DB
Transaction log backup file nameFILE
First log sequence number in the log backup
#2
FIRST-LSN
Last log sequence number in the log backup
#2
LAST-LSN
Database full backup end time that was recorded in
msdb of SQL Server when a backup was executed,
displayed as follows:
(yyyy/mm/dd hh:mm:ss)
#2
LAST-FULL-BACKUP-TIME
#1
A hyphen is displayed if a backup catalog has been deleted.
#2
A hyphen is displayed for a backup catalog created by a version earlier than Application Agent
6.3.0-00.
If a hyphen is displayed for BACKUP-ID, perform the following procedure to check the backup ID:
1. For the record to which a hyphen is displayed for BACKUP-ID, check the value of
LAST-FULL-BACKUP-TIME.
2. Execute drmsqlcat -lsn.
3. From the execution result of drmsqlcat -lsn, find a record whose value for
FULL-BACKUP-TIME is the same as the value for LAST-FULL-BACKUP-TIME found in step
1.
4. Check the backup ID for the record found in step 3.
Notes
• This command cannot be applied to the system databases (master, msdb, model, tempdb, and
distribution).
CLI Reference Guide 169