| column |
sysmaster
table |
description |
| name |
sysdatabases |
name of the database |
| partnum |
sysdatabases |
internal number for database |
| owner |
sysdatabases |
owner of the database |
| created |
sysdatabases |
date the database was created |
| is_logging |
sysdatabases |
1 = is logged, 0 = not logged |
| is_buff_log |
sysdatabases |
1 = buffered logging, 0 = not buffered |
| is_ansi |
sysdatabases |
1 = ansi mode logging, 0 = not ansi |
| is_nls |
sysdatabases |
1 = uses nls, 0 = does not |
| flags |
sysdatabases |
internal flags describing the database |
| dbspace |
infx |
name of the storage space where the database was created |
| alloc_kb |
infx |
space allocated to this database |
| used_kb |
infx |
space used in this database |
| data_kb |
infx |
amount of space in tables |
| idx_kb |
infx |
amount of space in indices |
| lockreqs | sysptprof | total of all tables and indices in the database |
| lockwts | sysptprof | total of all tables and indices in the database |
| deadlks | sysptprof | total of all tables and indices in the database |
| lktouts | sysptprof | total of all tables and indices in the database |
| isreads | sysptprof | total of all tables and indices in the database |
| iswrites | sysptprof | total of all tables and indices in the database |
| isrewrites | sysptprof | total of all tables and indices in the database |
| isdeletes | sysptprof | total of all tables and indices in the database |
| bufreads | sysptprof | total of all tables and indices in the database |
| bufwrites | sysptprof | total of all tables and indices in the database |
| seqscans | sysptprof | total of all tables and indices in the database |
| pagreads | sysptprof | total of all tables and indices in the database |
| pagwrites | sysptprof | total of all tables and indices in the database |