The database server creates and maintains the sysmaster database. It is analogous to the system catalog for databases, which is described in the IBM Informix: Guide to SQL Reference. Just as a system catalog for every database managed by the database server keeps track of objects and privileges in the database, a sysmaster database for every database server keeps track of information about the database server.
The sysmaster database contains the following tables:
The system-monitoring interface tables in the sysmaster database provide information about the state of the database server. You can query these tables to identify processing bottlenecks, determine resource usage, track session or database server activity, and so on. This chapter describes these tables, which are slightly different than ordinary tables.
The database server creates the sysmaster database when it initializes disk space. The database server creates the database with unbuffered logging. You should not drop the database or any of the tables in it, and you cannot turn logging off.
As user informix on UNIX or a member of the Informix-Admin group on Windows NT, you can create SPL routines in the sysmaster database. (You can also create triggers on tables within sysmaster, but the database server never executes those triggers.)
Joins of multiple tables in sysmaster might return inconsistent results because the database server does not lock the tables during a join. You can join sysmaster tables with tables in other databases, with the same caveat in mind.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]