DB2 10.5 for Linux, UNIX, and Windows

SET TAPE POSITION command

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 authorities:

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-SET TAPE POSITION--+------------+--TO--position-------------><
                      '-ON--device-'                 

Command parameters

ON device
Specifies a valid tape device name. The default value is \\.\TAPE0.
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.