var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB_CFG_CONFIG or DBM_CFG_CONFIG
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....
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?
Operating System AIX 5200-03
Level DB2 v126.96.36.1995
Client Windows XP proffessional
Last edited by nagasurir; 03-15-05 at 17:40.
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
Visit the new-look IDUG Website
, register to gain access to the excellent content.
Try db2 "select ...... ;"; toget all the fields(columns) try select *
Thank you Sathyaram for the response.
Originally Posted by sathyaram_s
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........