Adaptive Server devices and system databases

All the job, schedule, and scheduled job information, and data needed by the Job Scheduler task for internal processing is stored in the sybmgmtdb database. Most access to data in the sybmgmtdb database is via stored procedures. The stored procedures make the data available to the GUI, the JS Agent and the command-line interface. Only the Job Scheduler task accesses data directly from the sybmgmtdb database.

For more information about sybmgmtdb and Job Scheduler, see Job Scheduler

User’s Guide.

dsync option on by default for database device files

The dsync option ensures Adaptive Server can recover data from devices on the file systems. By default, Adaptive Server enables dsync for file system devices. However, dsync may cause performance degredation for file system devices that experience high write activity. The dsync option can be set or reset using the disk init, disk reinit, and sp_deviceattr commands.

Note The dsync option is ignored for raw devices.

When installing a new Adaptive Server, by default dsync is set on for all file system devices.

When upgrading from ASE 12.0 or earlier releases on a UNIX server that stored databases on UNIX file system devices, by default dsync is set:

on for the master device

off for all other devices

Immediately after upgrade, set the dsync option for the file system devices. See also sp_deviceattr and sp_helpdevice in the Reference Manual

Warning! Data corruption may occur if dsync option is not set immediately after upgrade.

8

Adaptive Server Enterprise

Page 24
Image 24
Sybase DC35823-01-1500-04 manual Dsync option on by default for database device files