Home | Previous Page | Next Page   Database Reference > The sysmaster Database > The System-Monitoring Interface Tables >

sysdatabases

The sysdatabases table describes each database that the database server manages.

Column Type Description
coserver_id integer Coserver number
name char(128) Database name
partnum integer The partition number (tblspace identifier) for the systables table for the database
owner char(32) User ID of the creator of the database
created decimal(32,0) Date created
is_logging integer 1 if logging is active, 0 if not
is_buff_log integer 1 if buffered logging, 0 if not
is_ansi integer 1 if ANSI-compliant, 0 if not
is_nls integer 1 if GLS-enabled, 0 if not
flags smallint Logging flags
0 No logging
1 Unbuffered logging
2 Buffered logging
4 ANSI-compliant database
8 Read-only database
16 Database that supports GLS
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]