Sybase Adaptive Server, Configuration Manual

Page: 23 / 150

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.