Hi All,
I am using db2 v8.2.3 aix 5.2,

for some purpose I need list of database and database manager configuration parameters that we can change via applications/bind command,...

than you in advance for your help.

Table function get_db_config, procedure get_dbm_config will help you in retrieving the information ..

ADMIN_CMD Stored proc will help you in updating db config ... AFIAK, dbm config updation is not available yet in a SQL Interface ...

You can try using the API db2CfgSet for updating dbm config ... Wrap it in a C Procedure ...

HTH

Sathyaram

Hi Satyaram,

I used these routenes long time ago and it was needed to create some USERTEMP tablespaces (4K) for these. When I tried to use these routenes again, now it is looking for the USERTEMP tablespaces with 8K size. Is there any change in these routenes in recent releases?
Also, can you please inform Which documents will give more details on this?

as always thank you appreciate for your efforts in this forum.
-Ram