The devices and databases described in the following sections are optional.
The sample databases are:
pubs2 and pubs3 are 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 database contains French and German data.
jpubs contains Japanese data.
For information about installing the sample databases, see Chapter 5, “Post-Installation Tasks” in the Adaptive Server Installation Guide for your platform.
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 11, “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 are used.
dbcc checkstorage records configuration 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.