Derby provides a set of system table expressions which you can use to obtain diagnostic information about the state of the database and about the database sessions.
The following table shows the types and names of the diagnostic table expressions in Derby.
Diagnostic Table Expression | Type of Expression |
---|---|
SYSCS_DIAG.CONTAINED_ROLES | Table function |
SYSCS_DIAG.ERROR_LOG_READER | Table function |
SYSCS_DIAG.ERROR_MESSAGES | Table |
SYSCS_DIAG.LOCK_TABLE | Table |
SYSCS_DIAG.SPACE_TABLE | Table function |
SYSCS_DIAG.STATEMENT_CACHE | Table |
SYSCS_DIAG.STATEMENT_DURATION | Table function |
SYSCS_DIAG.TRANSACTION_TABLE | Table |