with listonly returns a brief description of each dump file on a volume. with listonly = full provides greater detail. Both reports are sorted by SQL tape label.
Sample output for a load database command with listonly:
Backup Server: 4.36.1.1: Device '/dev/nrst0': File name: 'model9320715138 ' Create date & time: Monday, Jul 26, 2007, 23:58:48 Expiration date & time: Monday, Jul 26, 2007, 00:00:00 Database name: 'model '
The following is sample output from with listonly = full:
Backup Server: 4.37.1.1: Device '/dev/nrst0': Label id: 'HDR1' File name:'model9320715138 ' Stripe count:0001 Device typecount:01 Archive volume number:0001 Stripe position:0000 Generation number:0001 Generation version:00 Create date & time:Monday, Jul 26, 2007, 23:58:48 Expiration date & time:Monday, Jul 26, 2007, 00:00:00 Access code:' ' File block count:000000 Sybase id string: 'Sybase 'Reserved:' ' Backup Server: 4.38.1.1: Device '/dev/nrst0': Label id:'HDR2' Record format:'F' Max. bytes/block:55296 Record length:02048 Backup format version:01 Reserved:' ' Database name:'model ' Buffer offset length:00 Reserved:' '
After listing all files on a volume, the Backup Server sends a volume change request:
Backup Server: 6.30.1.2: Device /dev/nrst0: Volume cataloguing
complete.
Backup Server: 6.51.1.1: OPERATOR: Mount the next volume to search.
Backup Server: 6.78.1.1: EXECUTE sp_volchanged
@session_id = 5,
@devname = '/dev/nrst0',
@action = { 'PROCEED' | 'RETRY' | 'ABORT' },
@fname = '
The operator can use sp_volchanged to mount another volume and signal the volume change, or to terminate the search operation for all stripe devices.
