The database server supports the following SMI tables.
| Table | Description | Reference |
|---|---|---|
| syschkio | Chunk I/O statistics | page syschkio |
| syschunks | Chunk information | page syschunks |
| syscogroup | Cogroup information | page syscogroups |
| syscogroupmembers | Cogroup information | page syscogroupmembers |
| sysconfig | Configuration information | page sysconfig |
| sysdatabases | Database information | page sysdatabases |
| sysdbspaces | Dbspace information | page sysextents |
| sysextents | Extent-allocation information | page sysextents |
| syslocks | Active locks information | page syslogs |
| 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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]