Sybase DC35823-01-1500-04 User Manual

Page 23

Advertising
background image

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.

Advertising