sybsystemprocs contains the stored procedures that are installed by the
server (known as system procedures), which are used to query and
change the contents of system tables.
sybsystemdb is used for the data change processes known as distributed
transactions.
n
Special functionality databases:
dbccdb is used to store output from the dbcc checkstorage command.
sybsecurity is the auditing database; it must be installed prior to turning
on the auditing options.
sybdiag is installed by Sybase Technical Support to help debug
problems.
n
Sample databases:
pubs2 and pubs3 are optional databases; they are the source of syntax
examples in the documentation set, and are used in many Sybase classes
for labs. The installation scripts are provided with ASE.
n
User databases:
These are databases created specifically for applications.
z
System Tables Overview
The system tables govern the ASE and/or the databases within the ASE. In
addition to the master system tables that pertain to the ASE as a whole (see
Table 1-1 for a list of these system tables), every database (including master)
contains a set of system tables that refer only to that database (see Table 1-2).
These tables are maintained and modified with the use of Transact-SQL state
-
ments (create, drop, disk init, etc.) and system procedures (sp_addlogin,
sp_adduser, sp_configure, etc.).
Table 1-1: System tables
System Table Contents
syscharsets One row for each character set or sort order
sysconfigures One row for each server configuration parameter
syscurconfigs Information about configuration parameters currently
being used by Adaptive Server
sysdatabases One row for each database on Adaptive Server
sysdevices One row for each data device and dump device
sysengines One row for each Adaptive Server engine currently online
syslanguages One row for each language (except U.S. English) known
to the server
8 Chapter 1: System Administration Overview
System Table Contents
syslisteners One row for each type of network connection used by
current Adaptive Server
syslocks Information about active locks
sysloginroles One row for each server login that possesses a system
role
syslogins One row for each Adaptive Server login
syslogshold Information about the oldest active transaction for each
database
sysmessages One row for each system error or warning
sysmonitors One row for each monitor counter
sysprocesses Information about server processes
sysremotelogins One row for each remote user
sysresourcelimits One row for each resource limit
syssecmechs Information about the security services available for each
security mechanism that is available to Adaptive Server
sysservers One row for each remote Adaptive Server and for the
server itself
syssessions Only used when Adaptive Server is configured for
Sybase’s Companion Server in a high availability system
syssrvroles One row for each server-wide role
systimeranges One row for each named time range
systransactions One row for each transaction
sysusages One row for each disk piece allocated to a database
Table 1-2: All databases
System Table Contents
sysalternates One row for each aliased user
sysattributes One row for each object attribute definition
syscolumns One row for each column in a table or view, and for
each parameter in a procedure
syscomments One or more rows for each view, rule, default, trigger,
and procedure, giving SQL definition statement
sysconstraints One row for each referential and check constraint
associated with a table or column
sysdepends One row for each procedure, view, or table that is
referenced by a procedure, view, or trigger
sysgams Allocation bitmaps for an entire database
sysindexes One or more rows for each table and its indexes
sysjars One row for each Java archive (JAR) file that is retained
in the database.
syskeys One row for each primary, foreign, or common key; set
by user (not maintained by Adaptive Server)
syslogs Transaction log
sysobjects One row for each table, view, procedure, rule, trigger
default, log, and (in tempdb only) temporary object
syspartitions One row for each page chain of a partitioned table
Chapter 1: System Administration Overview
9

Get Administrator's Guide to Sybase ASE 15 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.