Home | Previous Page | Next Page   Configuring and Monitoring Dynamic Server > The sysmaster Database > The System-Monitoring Interface Tables >

sysdatabases

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

Column Type Description
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 date 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 (hex values)
0 No logging
1 Unbuffered logging
2 Buffered logging
4 ANSI-compliant database
8 Read-only database
10 GLS database
20 Checking of the logging mode of syscdr database bypassed
100 Changed status to buffered logging
200 Changed status to unbuffered logging
400 Changed status to ANSI compliant
800 Database logging turned off
1000 Long ID support enabled
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]