Toad World® Forums

Regarding accessing the DAS parameters


#1

Hi,

I want to access some of the DAS parameters via sql.

But I could not find which database table to access for the parameters like EXEC_EXP_TASK, JDK_64_PATH, JDK_64_PATH.

I can get the values of these parameters via DB2 Command : “get admin configuration” and I receive the values for the same.

But I want to retrieve the same via select query.

For example I can get the parameter ‘max_coordagents’ via the query :: select * from sysibmadm.dbmcfg where name = ‘max_coordagents’

Similarly i need to find out which table contains the above mentioned parameters.