Sybase DC35823-01-1500-04 manual Introduction

CHAPTER 1 Introduction

The sybsecurity device and database

dbccdb database

sybmgmtdb database

•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 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.

Configuration Guide 7