db_list

Information about each database.

db_list

column sysmaster 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