DB2 10.5 for Linux, UNIX, and Windows

GET_DBM_CONFIG table function

The GET_DBM_CONFIG table function returns database manager configuration information. The function does not take any arguments.

Note: This table function has been deprecated and replaced by the DBMCFG administrative view - Retrieve database manager configuration parameter information.


>>-GET_DBM_CONFIG--(--)----------------------------------------><

The schema is SYSFUN.

Authorization

One of the following authorities is required to execute the function:

EXECUTE privilege on the function
DATAACCESS authority
DBADM authority
SQLADM authority

Default PUBLIC privilege

In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.

The function returns a table with two rows containing a column for each parameter. The first column is named DBMCONFIG_TYPE, as shown in the following table.

Table 1. Information returned by the GET_DBM_CONFIG table function
Column name	Data type	Description
DBMCONFIG_TYPE	INTEGER	The row with a value of 0 in this column contains the values of the database manager configuration parameters stored on disk. The row with a value of 1 in this column contains the current values of the database manager configuration parameters stored in memory.

Example

Using the command line processor (CLP), change the value of the numdb and the diaglevel database manager configuration parameters, and then retrieve the original (on disk) and updated (in memory) values.

   UPDATE DBM CFG USING NUMDB 32 DIAGLEVEL 4

   CONNECT TO SAMPLE

   SELECT DBMCONFIG_TYPE, NUMDB, DIAGLEVEL
     FROM TABLE(SYSFUN.GET_DBM_CONFIG()) AS DBMCFG

   CONNECT RESET

The following is an example of output from this query.

DBMCONFIG_TYPE NUMDB       DIAGLEVEL
-------------- ----------- -----------
             0          32           4
             1           8           3

  2 record(s) selected.