Unit-2 : System and optional Databses

                                                      System and Optional Databases



A default SAP ASE installation includes a number of system databases.
• The master database
• The model database
• The system procedure database, sybsystemprocs
• The two-phase commit transaction database, sybsystemdb
• The temporary database, tempdb

Optionally, you can install:
• The auditing database, sybsecurity
• The sample databases, pubs2 and pubs3
• The dbcc database, dbccdb

• The Job Scheduler database, sybmgmtdb 
Use the installjsdb script (located in $SYBASE/ASE-15_0/scripts) to installthe sybmgmtdb database.


Note:
The master, model, sybsystemdb, and temporary databases reside on the master device which is named during installation. The master database must be contained entirely on the master device and cannot be expanded onto any other device. Create all other databases and user objects on other devices.

Warning! Do not store user databases on the master device; doing so makes it difficult to recover both the system databases and any user databases stored on the master device.