The schema is SYSIBMADM.
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
SELECT * from SYSIBMADM.REG_VARIABLES
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.
Column name | Data type | Description |
---|---|---|
DBPARTITIONNUM | SMALLINT | dbpartitionnum - Database partition number monitor element |
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:
|