1. I want to get each configuration parameter with its value and want to insert these data in to a table, time to time, which has the cfg parameters as its columns.

2. I am getting the below error when I try to execute the below command(for example)
SELECT SORTHEAP, APP_CTL_HEAP_SZ FROM TABLE(SYSPROC.GET_DB_CONFIG()) AS DBMCFG

Error: SQL0440N No authorized routine named "GET_DB_CONFIG" of type "FUNCTION"
having compatible arguments was found. SQLSTATE=42884

I found this query from the db2 docs found in below link....

http://publib.boulder.ibm.com/infoce...n/r0011861.htm

3. Also, as given in the docs, there is no schema like SYSFUN found and no table function like GET_DBM_CONFIG found.
Only I can find is GET_DB_CONFIG under the schema SYSPROC.

Here, is document giving wrong information or I am doing something wrong?

Environment:
Operating System AIX 5200-03
Level DB2 v8.1.7.445
Client Windows XP proffessional
PTF WR21342

Was this database migrated from pre-V8.2 ??? Then please run db2updv8 which creates these routines for you ....

GET_DB_CONFIG is a bug in documentation .. IBM's support pages have a corrected version of the page, but it is a shame that the main documentation has not been fixed yet ...

Have a look at
http://www.db2click.com/tip_month.htm#Feb05-4

for examples

Cheers
Sathyaram

Try db2 "select ...... ;"; toget all the fields(columns) try select *

Thank you Sathyaram for the response.
By the way, we don't find this command 'db2updv8' in any instance or database commands folders. Can you guide me where can we get this and execute it?

Thank you once again.

It should be under $INSTHOME/sqllib/bin directory.
If not, you are missing some thing........

Thanks,
Raj