Filter
Top Products
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 option is not set immediately
after upgrade.