SAP ASE Devices and System Databases

Devices are files or portions of a disk that are used to store databases and database objects. You can initialize devices using raw disk partitions or operating system files.

The master, sybsystemdb, and sysprocsdev devices are created when you create a new SAP ASE.

• The master Device
  The master device contains the master, model, tempdb, and sample databases.
• The sybsystemdb Device
  The sybsystemdb device stores the sybsystemdb database, which stores information about transactions in progress, and which is also used during recovery.
• The sysprocsdev Device
  The sybprocsdev devices stores the sybsystemprocs database, which contains most of the SAP-supplied system procedures. System procedures are a collection of SQL statements and flow-of-control statements, for example sp_configure, that perform system tasks.
• Optional Devices and Databases
  Optional devices and database include the PCI database, sample databases, the sybsecurity device and database, and the database consistency checker database.
• Using Operating System Files as Database Devices
  For devices that are initialized on operating system files, ensure that device writes occur directly on the physical media.