DB2 10.5 for Linux, UNIX, and Windows

Miscellaneous routines and views

This grouping of routines and views can be used to accomplish various, category-independent tasks.

ALTOBJ procedure
The ALTOBJ procedure parses an input CREATE TABLE statement that serves as the target data definition language (DDL) for an existing table that is to be altered.
COMPILATION_ENV table function - Retrieve compilation environment elements
The COMPILATION_ENV table function returns the elements of a compilation environment.
CONTACTGROUPS administrative view - Retrieve the list of contact groups
The CONTACTGROUPS administrative view returns the list of contact groups, which can be defined locally on the system or in a global list.
CONTACTS administrative view - Retrieve list of contacts
The CONTACTS administrative view returns the list of contacts defined on the database server.
DB_HISTORY administrative view - Retrieve history file information
The DB_HISTORY administrative view returns information from the history files from all database partitions.
DBPATHS administrative view and ADMIN_LIST_DB_PATHS table function - Retrieve database paths
The DBPATHS administrative view and the ADMIN_LIST_DB_PATHS table function return the values for database paths that are required for tasks such as creating split mirror backups.
GET_DBSIZE_INFO procedure
The GET_DBSIZE_INFO procedure calculates the database size and maximum capacity.
NOTIFICATIONLIST administrative view - Retrieve contact list for health notification
The NOTIFICATIONLIST administrative view returns the list of contacts and contact groups that are notified about the health of an instance.
PD_GET_DIAG_HIST table function - Return records from a given facility
The PD_GET_DIAG_HIST table function returns log records, event records and notification records from a given facility.
PDLOGMSGS_LAST24HOURS administrative view and PD_GET_LOG_MSGS table function - Retrieve problem determination messages
The PDLOGMSGS_LAST24HOURS administrative view and the PD_GET_LOG_MSGS table function return problem determination log messages that were logged in the DB2 notification log.
REORGCHK_IX_STATS procedure - Retrieve index statistics for reorganization evaluation
The REORGCHK_IX_STATS procedure returns a result set containing index statistics that indicate whether or not there is a need for reorganization.
REORGCHK_TB_STATS procedure - Retrieve table statistics for reorganization evaluation
The REORGCHK_TB_STATS procedure returns a result set containing table statistics that indicate whether or not there is a need for reorganization.
SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY procedure - disable recording of temporal history
The SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY procedure sets the internal option to disable recording of temporal history for a system-period temporal table and allows values to be specified for the special temporal columns.
SQLERRM scalar functions - Retrieves error message information
There are two versions of the SQLERRM scalar function. The first allows for full flexibility of message retrieval including using message tokens and language selection. The second takes only an SQLCODE as an input parameter and returns the short message in English.
SYSINSTALLOBJECTS procedure
The SYSINSTALLOBJECTS procedure creates or drops the database objects that are required for a specific tool.