with listonly returns a brief description of each dump file on a volume. It includes the name of the database, the device used to make the dump, the file name, the date and time the dump was made, and the date and time it can be overwritten. with listonly = full provides greater detail. Both reports are sorted by SQL tape label.
Following is sample output of 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.
