DB2 Version 9.7 for Linux, UNIX, and Windows

GET_DBM_CONFIG table function

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.

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

Authorization

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

EXECUTE privilege on the function
DATAACCESS authority
DBADM authority
SQLADM authority

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 section.

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 example is a sample output from this query.

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

  2 record(s) selected.