SET TAPE POSITION command

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

  • SYSADM
  • SYSCTRL
  • SYSMAINT

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramSET TAPE POSITIONONdeviceTOposition

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.