Command Reference

INITIALIZE TAPE

DB2 for Windows NT supports backup and restore to streaming tape devices. Use this command for tape initialization.

This command is available on Windows NT only.

Authorization

None

Required Connection

None

Command Syntax

>>-INITIALIZE TAPE----+-------------+---+-----------------+----><
                      '-ON--device--'   '-USING--blksize--'
 

Command Parameters

ON device

Specifies a valid tape device name. The default value is \\.\TAPE0.

USING blksize

Specifies the block size for the device, in bytes. The device is initialized to use the block size specified, if the value is within the supported range of block sizes for the device.

Note:

The buffer size specified in BACKUP DATABASE, and in RESTORE DATABASE must be divisible by the block size specified here.

If a value for this parameter is not specified, the device is initialized to use its default block size. If a value of zero is specified, the device is initialized to use a variable length block size; if the device does not support variable length block mode, an error is returned.

See Also

REWIND TAPE

SET TAPE POSITION.

[ DB2 List of Books | Search the DB2 Books ]