sp_addumpdevice 'file' and 'disk' Syntax

[unknown]

Tape Syntax:
sp_addumpdevice "tape", "Tape1", "/dev/nrmt0", 8000.

I understand the 8000 reference the size of the tabe here.

Disk Syntax
sp_addumpdevice "disk", "CustomerDB_dump",
"/dbdump/CustomerDB/CustomerDB_dump", 2

sp_addumpdevice "disk", "CustomerDB_tran",
"/dbdump/CustomerDB/CustomerDB_tran", 2

The Sybase SQL Server 11 Unleashed book does not specify the
purpose of the 2 in the disk syntax. What does the 2
reference in a disk dump?

[Bret Halford]

Post by unknown
sp_addumpdevice "tape", "Tape1", "/dev/nrmt0", 8000.
I understand the 8000 reference the size of the tabe here.
Disk Syntax
sp_addumpdevice "disk", "CustomerDB_dump",
"/dbdump/CustomerDB/CustomerDB_dump", 2
sp_addumpdevice "disk", "CustomerDB_tran",
"/dbdump/CustomerDB/CustomerDB_tran", 2
The Sybase SQL Server 11 Unleashed book does not specify the
purpose of the 2 in the disk syntax. What does the 2
reference in a disk dump?

It is meaningless for a disk dump. From the 12.5.x Reference Manual
entry on
sp_addumpdevice

http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/sprocs/@Generic__BookView?DwebQuery=sp_addumpdevice&DwebSearchAll=1

tapesize

is the capacity of the tape dump device, specified in megabytes. OpenVMS
systems ignore the tapesize parameter if specified. Other platforms
require this parameter for tape devices but ignore it for disk devices.

[unknown]

Post by unknown
sp_addumpdevice "tape", "Tape1", "/dev/nrmt0", 8000.
I understand the 8000 reference the size of the tabe

here. >

Post by unknown
Disk Syntax
sp_addumpdevice "disk", "CustomerDB_dump",
"/dbdump/CustomerDB/CustomerDB_dump", 2
sp_addumpdevice "disk", "CustomerDB_tran",
"/dbdump/CustomerDB/CustomerDB_tran", 2
The Sybase SQL Server 11 Unleashed book does not specify
the purpose of the 2 in the disk syntax. What does the
2 reference in a disk dump?

It is meaningless for a disk dump. From the 12.5.x
Reference Manual entry on
sp_addumpdevice
tapesize
is the capacity of the tape dump device, specified in
megabytes. OpenVMS systems ignore the tapesize parameter
if specified. Other platforms require this parameter for
tape devices but ignore it for disk devices.

Corey Wrote:

Make since now. The book was just a little confusing by
making reference to a value that is never used. Thanks for
the clarification and the link to the procedures that will
become very informative for a newbie to Sybase DBA
environment like me.