Adaptive Server devices and system databases
8 Adaptive Server Enterprise
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 optio n is not set immediately
after upgrade.