DB2 Version 9.7 for Linux, UNIX, and Windows

SET TAPE POSITION command using the ADMIN_CMD procedure

Sets the positions of tapes for backup and restore operations to streaming tape devices. This command is only supported on Windows operating systems.

Authorization

One of the following:

SYSADM
SYSCTRL
SYSMAINT

Required connection

Database

Command syntax


>>-SET TAPE POSITION--+------------+--TO--position-------------><
                      '-ON--device-'

Command parameters

ON device: Specifies a valid tape device name. The default value is \\.\TAPE0. The device specified must be relative to the server.
TO position: Specifies the mark at which the tape is to be positioned. DB2® for Windows writes a tape mark after every backup image. A value of 1 specifies the first position, 2 specifies the second position, and so on. If the tape is positioned at tape mark 1, for example, archive 2 is positioned to be restored.

Example

Because DB2 databases write a tape mark after every backup image, specifying a position of 1 will move the tape to the start of the second archive on the tape.

CALL SYSPROC.ADMIN_CMD( 'set tape position to 1' )

Usage notes

Command execution status is returned in the SQLCA resulting from the CALL statement.