REWIND TAPE command using the ADMIN_CMD procedure

The REWIND TAPE command rewinds 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

Database

Command syntax

Read syntax diagramSkip visual syntax diagramREWIND TAPEONdevice

Command parameters

ON device
Specifies a valid tape device name. The default value is \\.\TAPE0.The device specified must be relative to the server.

Example

Rewind the tape on the device named '\\.\TAPE1'. 
CALL SYSPROC.ADMIN_CMD( 'rewind tape on \\.\TAPE1' )

Usage notes

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