SEO

#1 (**permalink**) 02-27-2008, 02:13 AM

Is there a way to determine the value of JDK_PATH programmatically
without having to grep and awk the output of "get dbm cfg"? Is there
a way to just access the value of this single parameter?

Thanks!

#2 (**permalink**) 02-27-2008, 02:13 AM

Bruce wrote:
> Is there a way to determine the value of JDK_PATH programmatically
> without having to grep and awk the output of "get dbm cfg"? Is there
> a way to just access the value of this single parameter?
>
> Thanks!

Consult your DB2 documentation for db2CfgGet() and db2CfgSet() API calls. In
particular - you may want to specify as token SQLF_KTN_JDK_PATH when
getting/setting database manager configuration parameter(s).

Jan M. Nelken

#3 (**permalink**) 02-27-2008, 02:14 AM

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

#4 (**permalink**) 02-27-2008, 02:14 AM

Thanks for the help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Determining JDK_PATH