Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: list of db or dbm cfg parameters that we are able to change via application?

    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.

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

  3. #3
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72

    get_db_config()

    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

Posting Permissions

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