System Tables That Manage Storage

Two system tables in the master database, sysusages and sysdevices, and three more in each user database (syssegments, sysindexes, and syspartitions) track the placement of databases, tables (including the transaction log table, syslogs), and indexes.

The relationship between the tables is illustrated below.

• The sysdevices Table
  The sysdevices table in the master database contains one row for each database device and may contain a row for each dump device (tape, disk, or operating system file) available to SAP ASE.
• The sysusages Table
  The sysusages table in the master database keeps track of the space you assign to all SAP ASE databases.
• The syssegments Table
  The syssegments table, one in each database, lists the segments in a database.
• The sysindexes Table
  The sysindexes table lists each table and index and the segment where each table, clustered index, nonclustered index, and chain of text pages is stored. It also lists other information, such as the max_rows_per_page setting for the table or index.
• The syspartitions Table
  The syspartitions table lists each table and index partition and the segment where the partition is stored.