The devices and databases described in the following sections are optional.
The sample databases are:
pubs2 and pubs3 – provided as learning tools for Adaptive Server. pubs2 is used for most of the examples in the Adaptive Server documentation; other examples use the pubs3 database. Both are available in U.S. English versions of Adaptive Server.
interpubs – contains French and German data.
jpubs – contains Japanese data.
For information about installing the sample databases, see Chapter 10, “Adding Optional Functionality to Adaptive Server.”
For information about the contents of the sample databases, see the Transact-SQL User’s Guide.
The sybsecurity device is created as part of the auditing installation process. The sybsecurity device stores the sybsecurity database and the auditing system procedures with which you can configure auditing for your system.
The auditing system records system security information in an Adaptive Server audit trail. You can use this audit trail to monitor the use of Adaptive Server or system resources.
For instructions on configuring Adaptive Server for auditing, see Chapter 10, “Adding Optional Functionality to Adaptive Server.” For information about installing and using the auditing system, see Chapter 12, “Auditing,” in the System Administration Guide.
The database consistency checker (dbcc) provides commands for checking the logical and physical consistency of a database. The dbccdb database stores the results of dbcc when dbcc checkstorage or dbcc check verifying is used.
dbcc checkstorage records consistency information for the target database, operation activity, and the results of the operation in the dbccdb database. Stored in the database are dbcc stored procedures for creating and maintaining dbccdb and for generating reports on the results of dbcc checkstorage operations.
For information on installing and using dbccdb, see Chapter 25, “Checking Database Consistency,” in the System Administration Guide.
sybmgmtdb is a Job Scheduler database.
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.
