Microsoft KB Archive/40808

{|
 * width="100%"|

INF: Disk Dump Device Size in SYSDEVICES

 * }

Q40808

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2

-

SUMMARY
This article explains why the high column in SYSDEVICES is equal to 19 for a disk dump device that is supposed to be 1.2 MB.

MORE INFORMATION
The size of disk dump devices is maintained in SYSDEVICES in units of 62K for internal reasons (19 * 62K = 1.2 megabytes). When creating a disk dump device with &quot;sp_addumpdevice:&quot; specify the size in megabytes. &quot;sp_helpdevice&quot; shows both the internal values stored in SYSDEVICES and a plain-language interpretation of them.

The &quot;high&quot; and &quot;low&quot; columns in SYSDEVICES are maintained in units of 2K for database devices.

Keywords : kbother

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2