Filter
Top Products
CHAPTER 1 Introduction
Configuration Guide 7
•
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 the Installation
Guide for your platform, Chapter 3, “Post-Installation Tasks.”
For information about the contents of the sample databases, see the
Transact-SQL User’s Guide.
The sybsecurity
device and database
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.
dbccdb database
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 database
sybmgmtdb is a Job Scheduler database.