Configuration routines and views

This grouping of routines and views can be used to retrieve database configuration parameter information and database manager configuration parameter information.

ADMIN_REFRESH_CONFIG stored procedure
Use the ADMIN_REFRESH_CONFIG stored procedure to explicitly initiate a refresh a given instance configuration. It takes one VARCHAR(255) parameter to specify the type of configuration to refresh. Currently, the value TOKEN is supported.
DBCFG administrative view and DB_GET_CFG table function - Retrieve database configuration parameter information
The DBCFG administrative view and the DB_GET_CFG table function retrieve database configuration parameter information for the currently connected database for all active database members.
DBMCFG administrative view and DBM_GET_CFG table function - Retrieve database manager configuration parameter information
The DBMCFG administrative view and the DBM_GET_CFG table function returns database manager configuration parameter information including the values in memory and the values stored on disk.

Parent topic: Supported built-in SQL routines and views