System and Optional Databases

SAP ASE includes a number of system databases, optional SAP-supplied databases that you can install, and the sybdiag database, which SAP Product Support may install for diagnostic purposes.

• Overview of System Databases
  A default SAP ASE installation includes a number of system databases.
• The master Database
  The master database controls the operation of SAP ASE and stores information about all user databases and their associated database devices.
• model Database
  SAP ASE includes the model database, which provides a template, or prototype, for new user databases.
• sybsystemprocs Database
  SAP system procedures are stored in the database sybsystemprocs.
• tempdb database
  SAP ASE has a temporary database, tempdb, that provides a storage area for temporary tables and other temporary working storage needs. The space in tempdb is shared among all users of all databases on the server.
• sybsecurity Database
  The sybsecurity database, which contains the auditing system for SAP ASE, includes these system tables, is installed when you configure SAP ASE for auditing.
• sybsystemdb Database
  The sybsystemdb database stores information about distributed transactions.
• sybmgmtdb Database
  The sybmgmtdb database stores jobs, schedules, scheduled jobs information, and data needed by the internal Job Scheduler task for processing.
• pubs2 and pubs3 Sample Databases
  The pubs2 and pubs3 sample databases are provided as a learning tool for SAP ASE.
• dbccdb Database
  dbcc checkstorage records configuration information for the target database, operation activity, and the results of the operation in the dbccdb database.
• sybdiag Database
  SAP Product Support may create the sybdiag database on your system for debugging purposes. This database holds diagnostic configuration data, and should not be used by customers.
• Determining the Version of the Installation Scripts
  sp_version lets you determine the current version of the scripts (installmaster, installdbccdb, and so on) installed on SAP ASE, whether they ran successfully or not, and the length of time they took to complete.