During the installation of ADABAS, a set of system tables is created on each SERVERDB. These system tables can be used to select information about the configuration, structures and sizes of database objects.
On each SERVERD, these tables are owned by the SYSDBA created during the configuration. The specification of the <owner> is not required for the access to the tables.
DBPARAMETERS parameter of a SERVERDB
DESCRIPTION CHAR (18) description of how to interpret the column VALUE
VALUE CHAR (64) value
This table contains the parameters defined for the SERVERDB by using the ADABAS component CONTROL. The column DESCRIPTION contains the following values:
SERVERDB
VALUE contains the logical SERVERDB name
SYSDEVSPACE
VALUE contains the logical name of the first system DEVSPACE of ADABAS
MIRR_SYSDEVSPACE
VALUE contains the logical name of the mirror DEVSPACE of the system DEVSPACE if mirrored DEVSPACEs are defined
TRANSACTION_LOG
VALUE contains the logical name of the transaction log DEVSPACE
ARCHIVE_LOG
VALUE contains the logical name of the first archive log DEVSPACE of ADABAS
MIRR_ARCHIVE_LOG
VALUE contains the logical name of the mirror DEVSPACE of the archive log if mirrored DEVSPACEs are defined
CONTROLUSERID
VALUE contains the name of the CONTROL user
MAXDEVSPACES
VALUE contains the maximum number of DEVSPACEs
MAXDATADEVSPACES
VALUE contains the maximum number of data DEVSPACEs
MAXSERVERDB
VALUE contains the maximum number of SERVERDBs in the distributed database
MAXBACKUPDEVS
VALUE contains the maximum number of backup devices
SERVERTASKS
VALUE contains the maximum number of servers for the handling of remote tasks
MAXUSERTASKS
VALUE contains the maximum number of users who can simultaneously establish sessions with the SERVERDB
MAXDATAPAGES
VALUE contains the maximum number of data pages of the SERVERDB
MAXCPU
VALUE contains the number of CPUs available to ADABAS
DATA_CACHE_PAGES
VALUE contains the size of the data cache in pages
PROC_DATA_PAGES
VALUE contains the size of the storage area in pages available for variables in DB procedures, DB functions and triggers
PROC_CODE_PAGES
VALUE contains the size of the storage area in pages available for the code of DB procedures and triggers
TEMP_CACHE_PAGES
VALUE contains the size of the storage area in pages available for temporary pages in the session-specific caches
CATALOG_CACHE_PAGS
VALUE contains the size of the storage area in pages available for catalog information in the session-specific caches
CONV_CACHE_PAGES
VALUE contains the size of the converter cache in pages
MAXLOCKS
VALUE contains the maximum number of locks and lock requests
RUNDIRECTORY
VALUE contains the path name of the directory where diagnose information will be stored
OPMSG1
VALUE contains the logical name of the device for the output of priority 1 messages
OPMSG2
VALUE contains the logical name of the device for the output of priority 2 messages
CONFIGURATION configuration parameters of the SERVERDB
DESCRIPTION CHAR (40) description of how to interpret the value in the column CHAR_VALUE or NUMERIC_VALUE
CHAR_VALUE CHAR (40) alphanumeric value
NUMERIC_VALUE FIXED (10) numeric value
The column DESCRIPTION contains the following values:
DEFAULT CODE
In this row, the column CHAR_VALUE contains the code (ASCII or EBCDIC) used to store columns of the data type CHAR
DATE TIME FORMAT
In this row, the column CHAR_VALUE contains the date and time formats (EUR, INTERNAL, ISO, JIS, USA) used to represent columns of the data type DATE, TIME or TIMESTAMP
SESSION TIMEOUT
The column NUMERIC_VALUE contains the timeout value for the maximum time of inactivity in seconds
LOCK TIMEOUT
The column NUMERIC_VALUE contains the timeout value for inactive locks in seconds
REQUEST TIMEOUT
The column NUMERIC_VALUE contains the timeout value for lock requests in seconds
LOG MODE
The column CHAR_VALUE describes the log mode (DEMO, SINGLE, NORMAL, DUAL)
LOG SEGMENT SIZE
The column NUMERIC_VALUE contains the size of a log segment in pages
NO OF ARCHIVE LOGS
The column NUMERIC_VALUE contains the number of archive log DEVSPACEs
NO OF DATA DEVSPACES
The column NUMERIC_VALUE contains the number of data DEVSPACEs
MIRRORED DEVSPACES
The column CHAR_VALUE contains information about mirrored DEVSPACEs (YES, NO)
SYS DEVSPACE SIZE
The column NUMERIC_VALUE contains the size of the system DEVSPACE in pages
SYS DEVSPACE NAME
The column CHAR_VALUE contains the logical name of the system DEVSPACE
TRANSACTION LOG SIZE
The column NUMERIC_VALUE contains the size of the transaction log in pages
TRANSACTION LOG NAME
The column CHAR_VALUE contains the name of the transaction log
DATA DEVSPACE * SIZE
The column NUMERIC_VALUE contains the size of the data DEVSPACE in pages
DATA DEVSPACE * NAME
The column CHAR_VALUE contains the name of a data DEVSPACE
DATADEVSPACES usage of data DEVSPACEs
DEVSPACENAME CHAR (40) logical name of the data DEVSPACE
DEVSPACESIZE FIXED (10) size of the DEVSPACE in pages
MAXDATAPAGENO FIXED (10) largest created page number
USEDPERMPAGES FIXED (10) number of DEVSPACE pages used for permanent objects
PCTUSEDPERM FIXED (10) percentage of the pages used for permanent objects
USEDTMPPAGES FIXED (10) number of DEVSPACE pages used for temporary objects
PCTUSEDTMP FIXED (10) percentage of the pages used for temporary objects
UNUSEDPAGES FIXED (10) number of unused pages
PCTUNUSED FIXED (10) percentage of unused pages
INDEXSTATISTICS information about structure and size of indexes
OWNER CHAR (18) owner of a table
TABLENAME CHAR (18) table name
INDEXNAME CHAR (18) index name (NULL for unnamed indexes)
COLUMNNAME CHAR (18) name of an indexed column
DESCRIPTION CHAR (40) description of how to interpret the following columns
CHAR_VALUE CHAR (12) alphanumeric value
NUMERIC_VALUE FIXED (10) numeric value
The column DESCRIPTION contains the following values:
ROOT PNO
NUMERIC_VALUE contains the page number of the B* tree root
FILETYPE
CHAR_VALUE contains the type of the B* tree
USED PAGES
NUMERIC_VALUE contains the number of pages used by the index
INDEX PAGES
NUMERIC_VALUE contains the number of B* tree index pages used by the index
LEAF PAGES
NUMERIC_VALUE contains the number of leaf pages used by the index
INDEX LEVELS
NUMERIC_VALUE contains the number of B* tree index levels
SPACE USED IN ALL PAGES(%)
NUMERIC_VALUE contains the percentage of the index pages used
SPACE USED IN ROOT PAGE(%)
NUMERIC_VALUE contains the percentage of the B* tree root page used
SPACE USED IN INDEX PAGES(%)
NUMERIC_VALUE contains the percentage of the B* tree index pages used
SPACE USED IN INDEX PAGES(%) MIN
NUMERIC_VALUE contains the minimum percentage of the B* tree index pages used
SPACE USED IN INDEX PAGES(%) MAX
NUMERIC_VALUE contains the maximum percentage of the B* tree index pages used
SPACE USED IN LEAF PAGES(%)
NUMERIC_VALUE contains the percentage of the B* tree leaf pages used
SPACE USED IN LEAF PAGES(%) MIN
NUMERIC_VALUE contains the minimum percentage of the B* tree leaf pages used
SPACE USED IN LEAF PAGES(%) MAX
NUMERIC_VALUE contains the maximum percentage of the B* tree leaf pages used
SECONDARY KEYS (INDEX LISTS)
NUMERIC_VALUE contains the number of different values in the indexed columns
AVG SECONDARY KEY LENGTH
NUMERIC_VALUE contains the average length of the index values
MIN SECONDARY KEY LENGTH
NUMERIC_VALUE contains the minimum length of the index values
MAX SECONDARY KEY LENGTH
NUMERIC_VALUE contains the maximum length of the index values
AVG SEPARATOR LENGTH
NUMERIC_VALUE contains the average length of a B* tree separator
MIN SEPARATOR LENGTH
NUMERIC_VALUE contains the minimum length of the separator
MAX SEPARATOR LENGTH
NUMERIC_VALUE contains the maximum length of the separator
PRIMARY KEYS
NUMERIC_VALUE contains the number of tables identified by OWNER and TABLENAME
AVG PRIMARY KEYS PER LIST
NUMERIC_VALUE contains the average number of keys per index list
MIN PRIMARY KEYS PER LIST
NUMERIC_VALUE contains the minimum number of keys per index list
MAX PRIMARY KEYS PER LIST
NUMERIC_VALUE contains the maximum number of keys per index list
VALUES WITH SELECTIVITY <= 1%
NUMERIC_VALUE contains the number of index lists with a selectivity <= 1%
VALUES WITH SELECTIVITY <= 5%
NUMERIC_VALUE contains the number of index lists with a selectivity between 1% and 5%
VALUES WITH SELECTIVITY <= 10%
NUMERIC_VALUE contains the number of index lists with a selectivity between 5% and 10%
VALUES WITH SELECTIVITY <= 25%
NUMERIC_VALUE contains the number of index lists with a selectivity between 10% and 25%.
VALUES WITH SELECTIVITY > 25%
NUMERIC_VALUE contains the number of index lists with a selectivity > 25%
LOCKSTATISTICS information about the lock list contents
SESSION FIXED ( 10) user session identification
TRANSACTION FIXED ( 10) transaction identification
SERVERDBNO FIXED ( 5) SERVERDB identification
PROCESS FIXED ( 10) user process identification
USERNAME CHAR ( 18) user name
TERMID CHAR ( 18) terminal identification
REMOTEUSER CHAR ( 3) 'YES' for lock entries of remote SERVERDBs; otherwise, NO
PENDINGLOCK CHAR ( 3) 'YES' for 'pending' locks;
otherwise; 'NO'
LOCKMODE CHAR ( 14) lock mode
LOCKREQUESTMODE CHAR ( 14) lock request mode
OWNER CHAR ( 18) table owner
TABLENAME CHAR ( 18) table name
ROWIDLENGTH FIXED ( 3) length of the key of the locked row
ROWID CHAR (120) prefix of the key of the locked row
ROWIDHEX CHAR ( 40) prefix of the key of the row in hexadecimal representation
LOCKLISTSTATISTICS information about the lock list usage
DESCRIPTION CHAR (40) description of how to interpret the contents of the column VALUE
VALUE CHAR (12) value
The column DESCRIPTION contains the following values:
ENTRIES
VALUE contains the number of entries available in the lock list
USED ENTRIES
VALUE contains the number of entries for locks and lock requests
USED ENTRIES(%)
VALUE contains the percentage of used entries available in the lock list
AVG USED ENTRIES
VALUE contains the average number of entries for locks and lock requests
AVG USED ENTRIES(%)
VALUE contains the average percentage of used entries for locks and lock requests
MAX USED ENTRIES
VALUE contains the maximum number of entries for locks and lock requests
MAX USED ENTRIES(%)
VALUE contains the maximum percentage of used entries for locks and lock requests
LOCK ESCALATION
VALUE contains the number of lock escalations
TRANSACTIONS HOLDING LOCKS
VALUE contains the number of transactions with assigned locks
TRANSACTIONS REQUESTING LOCKS
VALUE contains the number of transactions requesting locks
CHECKPOINT WANTED
If the column VALUE contains the value 'TRUE', the lock list is closed, i.e., no EXCLUSIVE lock can be assigned to a transaction without EXCLUSIVE lock because a checkpoint was requested
SHUTDOWN WANTED
If the column VALUE contains the value 'TRUE', the lock list is closed because a shutdown was requested
SERVERDBSTATISTICS information about the use of the SERVERDB
SERVERDBSIZE FIXED (10) SERVERDB size in pages
MAXDATAPAGENO FIXED (10) largest page number of the SERVERDB
USEDPERMPAGES FIXED (10) number of SERVERDB pages used for non-temporary objects
PCTUSEDPERM FIXED (10) percentage of pages used for non-temporary objects
USEDTMPPAGES FIXED (10) number of SERVERDB pages used for temporary objects
PCTUSEDTMP FIXED (10) percentage of pages used for temporary objects
UNUSEDPAGES FIXED (10) number of unused pages
PCTUNUSED FIXED (10) percentage of unused pages
UPDATEDPERMPAGES FIXED (10) number of modified pages for permanent objects
LOGSIZE FIXED (10) log size in pages
USEDLOGPAGES FIXED (10) number of log pages used
PCTUSEDLOGPAGES FIXED (10) percentage of log pages used
RESERVEDLOGPAGES FIXED (10) reserved log pages
LOGSEGMENTSIZE FIXED (10) log segment size in pages
COMPLETESEGMENTS FIXED (10) number of completed log segments
SAVEPOINTS FIXED (10) number of savepoints written
CHECKPOINTS FIXED (10) number of checkpoints written
PAGESPERSAVEPOINT FIXED (10) average savepoint distance in log pages
PAGESPERCHECKPOINT FIXED (10) average checkpoint distance in log pages
TABLESTATISTICS information about structure and size of base tables
OWNER CHAR (18) table owner
TABLENAME CHAR (18) table name
DESCRIPTION CHAR (40) description of how to interpret the following columns
CHAR_VALUE CHAR (12) alphanumeric value
NUMERIC_VALUE FIXED (10) numeric value
The column DESCRIPTION contains the following values:
ROOT PNO
NUMERIC_VALUE contains the page number of the B* tree root
FILETYPE
CHAR_VALUE contains the B* tree type
USED PAGES
NUMERIC_VALUE contains the number of pages used by the table
INDEX PAGES
NUMERIC_VALUE contains the number of pages used by the table in the B* tree index
LEAF PAGES
NUMERIC_VALUE contains the number of leaf pages used by the table
INDEX LEVELS
NUMERIC_VALUE contains the number of B* tree index levels
SPACE USED IN ALL PAGES(%)
NUMERIC_VALUE contains the percentage of index pages used
SPACE USED IN ROOT PAGE(%)
NUMERIC_VALUE contains the percentage of the B* tree root page used
SPACE USED IN INDEX PAGES(%)
NUMERIC_VALUE contains the percentage of the B* tree index pages used
SPACE USED IN INDEX PAGES(%) MIN
NUMERIC_VALUE contains the minimum percentage of the B* tree index pages used
SPACE USED IN INDEX PAGES(%) MAX
NUMERIC_VALUE contains the maximum percentage of the B* tree index pages used
SPACE USED IN LEAF PAGES(%)
NUMERIC_VALUE contains the percentage of the B* tree leaf pages used
SPACE USED IN LEAF PAGES(%) MIN
NUMERIC_VALUE contains the minimum percentage of the B* tree leaf pages used
SPACE USED IN LEAF PAGES(%) MAX
NUMERIC_VALUE contains the maximum percentage of the B* tree leaf pages used
ROWS
NUMERIC_VALUE contains the number of table rows
AVG ROWS PER PAGE
NUMERIC_VALUE contains the average number of rows per page
MIN ROWS PER PAGE
NUMERIC_VALUE contains the minimum number of rows per page
MAX ROWS PER PAGE
NUMERIC_VALUE contains the maximum number of rows per page
AVG ROW LENGTH
NUMERIC_VALUE contains the average length of rows
MIN ROW LENGTH
NUMERIC_VALUE contains the minimum length of rows
MAX ROW LENGTH
NUMERIC_VALUE contains the maximum length of rows
AVG KEY LENGTH
NUMERIC_VALUE contains the average length of keys
MIN KEY LENGTH
NUMERIC_VALUE contains the minimum length of keys
MAX KEY LENGTH
NUMERIC_VALUE contains the maximum length of keys
AVG SEPARATOR LENGTH
NUMERIC_VALUE contains the average length of the separator
MIN SEPARATOR LENGTH
NUMERIC_VALUE contains the minimum length of the separator
MAX SEPARATOR LENGTH
NUMERIC_VALUE contains the maximum length of the separator
DEFINED LONG COLUMNS
NUMERIC_VALUE contains the number of defined columns of the data type LONG
AVG LONG COLUMN LENGTH
NUMERIC_VALUE contains the average length of LONG columns
MIN LONG COLUMN LENGTH
NUMERIC_VALUE contains the minimum length of LONG columns
MAX LONG COLUMN LENGTH
NUMERIC_VALUE contains the maximum length of LONG columns
LONG COLUMN PAGES
NUMERIC_VALUE contains the number of pages of all LONG columns of the table
AVG PAGES PER LONG COLUMN
NUMERIC_VALUE contains the average number of pages of the table per LONG column
MIN PAGES PER LONG COLUMN
NUMERIC_VALUE contains the smallest LONG column of the table in pages
MAX PAGES PER LONG COLUMN
NUMERIC_VALUE contains the largest LONG column of the table in pages
TRANSACTIONS information about active transactions of a SERVERDB
SESSION FIXED (10) user session identification
TRANSACTION FIXED (10) transaction identification
SERVERDBNO FIXED ( 5) SERVERDB identification
PROCESS FIXED (10) user process identification
USERNAME CHAR (18) user name
CONNECTDATE DATE
CONNECTTIME TIME session begin
TERMID CHAR (18) terminal identification
REMOTEUSER CHAR ( 3) 'YES' for lock entries of remote SERVERDBs; otherwise, 'NO'
PENDINGLOCK CHAR ( 3) 'YES' for 'pending'locks; otherwise, 'NO'
LOCKMODE CHAR (14) lock mode
LOCKREQUESTMODE CHAR (14) lock request mode
USERSTATISTICS information about the resources used by users
USERNAME CHAR (18) user name
USERMODE CHAR ( 8) user class
PERMLIMIT FIXED (10) maximum number of pages that can be used for permanent objects
PERMLCOUNT FIXED (10) number of pages currently used for permanent objects
TEMPLIMIT FIXED (10) maximum number of pages that can be used for temporary objects
TEMPCOUNT FIXED (10) number of pages currently used for temporary objects