Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72

    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....

    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
    Last edited by nagasurir; 03-15-05 at 18:40.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Posts
    237
    Try db2 "select ...... ;"; toget all the fields(columns) try select *
    mota

  4. #4
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72
    Quote Originally Posted by sathyaram_s
    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
    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.

  5. #5
    Join Date
    Sep 2004
    Posts
    111
    It should be under $INSTHOME/sqllib/bin directory.
    If not, you are missing some thing........

    Thanks,
    Raj

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •