INF: Disk Dump Device Size in SYSDEVICES

ID: 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 "sp_addumpdevice:" specify the size in megabytes. "sp_helpdevice" shows both the internal values stored in SYSDEVICES and a plain-language interpretation of them.

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

Keywords : kbother SSrvServer
Version : 4.2
Platform : OS/2
Issue type :