The database server supports the following SMI tables.
| Table | Description | Reference |
|---|---|---|
| sysadtinfo | Auditing configuration information | page sysadtinfo |
| sysaudit | Auditing event masks | page *** |
| syschkio | Chunk I/O statistics | page syschkio |
| syschunks | Chunk information | page syschunks |
| sysconfig | Configuration information | page sysconfig |
| sysdatabases | Database information | page sysdatabases |
| sysdbslocale | Locale information | page sysdbslocale |
| sysdbspaces | Dbspace information | page sysextents |
| sysdri | Data-replication information | page sysdri |
| sysextents | Extent-allocation information | page sysextents |
| sysextspaces | External spaces information | page sysextspaces |
| syslocks | Active locks information | page syslocks |
| syslogs | Logical-log file information | page syslogs |
| sysprofile | System-profile information | page sysprofile |
| sysptprof | Table information | page sysptprof |
| syssesprof | Counts of various user actions | page syssesprof |
| syssessions | Description of each user connected | page syssessions |
| sysseswts | User's wait time on each of several objects | page sysseswts |
| systabnames | Database, owner, and table name for the tblspace tblspace | page systabnames |
| sysvpprof | User and system CPU used by each virtual processor | page sysvpprof |
Many other tables in the sysmaster database are part of the system-monitoring interface but are not documented. Their schemas and column content can change from version to version. The flags_text table now contains more rows. To view the new rows you must first drop and then recreate the sysmaster database.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]