II.   SYSTEM DATABASES AND TABLES.

When ASE is installed following databases are installed.

* master
* model
* sybsystemprocs
* tempdb

Optional databases that can be installed are

* sybsecurity
* sybsystemdb
* dbcc
* sybdiag
* pubs2  and pubs3

ASE  databases:

master database:–

Controls the operation of ASE and stores the information of user databases and devices on the ASE server

No.… Information…………………………………………….System Table
1        User accounts :……………………………………………….syslogins

2       Remote user accounts :…………………………………… sysremotelogins

3      Remote servers that this servercan interact with:….sysservers
4      Ongoing processes :………………………………………….sysprocesses
5      Configurable environment variables :………………….sysconfigures
6      System error messages:…………………………………….sysmessages
7      Databases on Adaptive Server:…………………………..sysdatabases
8     Storage space allocated to each database:……………..sysusages
9    Tapes and disks mounted on the system:……………… sysdevices
10    Active locks:…………………………………………………..syslocks
11    Character sets:………………………………………………..syscharsets
12    Languages:…………………………………………………….syslanguages
13    Users who hold server-wide roles:……………………. sysloginroles
14    Server roles:………………………………………………….syssrvroles
15    Adaptive Server engines that are online:…………….sysengines

model database:–-

All new user databases use model database as a template database. ASE copies this database whenever a new database is created and extends the space of the new user database as specified in the ‘create database’ command Use sp_tables system SP to get the list of system tables in model database.

sybsystemprocs:-–

All ASE system stored procedures are stored in this database.

tempdb :–-

This is a temporary database used by ASE. “tempdb” database is used to store temporary tables and other working structures.
tempdb is installed by default during ASE installation.
Multiple tempdb(s) can be created based on need.
Optional databases::

sybsecurity :–-

This database contains the audit system to audit database users activity on ASE.
sysbsystemdb:-–

This is used by ASE to store information of distributed transactions and provides transaction coordination for remote servers using RPCs and CIS services.

dbcc :-–

This database is used to store configuration information of target database operation activity and results of the operation from ‘dbcc checkstorage’

sybdiag :–-

This database may be created and used by SYBASE Technical Support to troubleshoot the system. The database holds diagnostic information.

pubs2 and pub3 :-–

These are learning databases provided by SYBASE.