Hi,
Jan M. Nelken wrote:
Consult your DB2 documentation for db2CfgGet() and db2CfgSet() API
or, if you are allready running 8.2 UDB, you can make use of the
get_dbm_config() table function. Example:
<example>
create view my_get_dbm_cfg as select * from table(get_dbm_config()) as
mysnap
</example>
which returns a table containing all DBM-Parameters.
<example>
select jdk11_path from my_get_dbm_cfg where dbmconfig_type=1
/opt/IBMJava2-141
select jdk11_path from my_get_dbm_cfg where dbmconfig_type=0
/opt/java
</example>
where dbmconfig_type=1 refers to the currently used parameter and
dbmconfig_type=0 refers to the "delayed" value.
regards,
Norbert