DB2 Version 9.7 for Linux, UNIX, and Windows

REG_VARIABLES administrative view - Retrieve DB2 registry settings in use

The REG_VARIABLES administrative view returns the DB2® registry settings from all database partitions. The DB2 registry variable values returned when the REG_VARIABLES administrative view is queried can differ from those returned by the db2set command if a DB2 registry variable is configured using the db2set command after the instance has been started. The difference occurs because REG_VARIABLES only returns the values that were in effect when the instance was started.

The schema is SYSIBMADM.

Authorization

One of the following authorizations is required:

SELECT privilege on the REG_VARIABLES administrative view
CONTROL privilege on the REG_VARIABLES administrative view
DATAACCESS authority

Example

Request the DB2 registry settings that are currently being used.

SELECT * from SYSIBMADM.REG_VARIABLES

The following example is a sample output from this query.

DBPARTITIONNUM REG_VAR_NAME        REG_VAR_VALUE     IS_AGGREGATE AGGREGATE_NAME    
-------------- ---------------...- -------------...- ------------ --------------...-
             0 DB2ADMINSERVER      DB2DAS00                     0 -                 
             0 DB2INSTPROF         D:\SQLLIB                    0 -                 
             0 DB2PATH             D:\SQLLIB                    0 -                 
             0 DB2SYSTEM           D570                         0 -                 
             0 DB2TEMPDIR          D:\SQLLIB\                   0 -                 
             0 DB2_EXTSECURITY     YES                          0 -                 

  6 record(s) selected.

Information returned

Table 1. Information returned by the REG_VARIABLES administrative view
Column name	Data type	Description
DBPARTITIONNUM	SMALLINT	Logical partition number of each database partition on which the function operates.
REG_VAR_NAME	VARCHAR(256)	Name of the DB2 registry variable.
REG_VAR_VALUE	VARCHAR(2048)	Current setting of the DB2 registry variable.
IS_AGGREGATE	SMALLINT	Indicates whether or not the DB2 registry variable is an aggregate variable. The possible return values are 0 if it is not an aggregate variable, and 1 if it is an aggregate variable.
AGGREGATE_NAME	VARCHAR(256)	Name of the aggregate if the DB2 registry variable is currently obtaining its value from a configured aggregate. If the registry variable is not being set through an aggregate, or is set through an aggregate but has been overridden, the value of AGGREGATE_NAME is NULL.
LEVEL	CHAR(1)	Indicates the level at which the DB2 registry variable acquires its value. The possible return values and the corresponding levels that they represent are: I = instance G = global N = database partition E = environment