Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Toronto, Canada

    Unanswered: ‘get dbm cfg’ does not show BACKBUFSZ, RESTBUFSZ or QUERY_HEAP_SZ

    (db2 v9.5 ESE on AIX 6.1)

    ‘get dbm cfg’ does not show the following 3 config parameters for some reason:

    Backup buffer default size (4KB) (BACKBUFSZ) = 1024
    Restore buffer default size (4KB) (RESTBUFSZ) = 1024
    Query heap size (4KB) (QUERY_HEAP_SZ) = 1000

    DB21085I Instance "db2v9q1" uses "64" bits and DB2 code release "SQL09053" with level identifier "06040107".
    Informational tokens are "DB2 v9.5.0.3", "s081210", "U823474", and Fix Pack "3a".
    Product is installed at "/opt/IBM/db2/V9.5".

    on some v9.5 instances it does show and on some not. Does anybody have same problem? Is it a bug?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jul 2009
    According to product documentation, Command Reference SC23-5846-01, page 151, these three lines should be displayed. If they are not - report a defect.

Posting Permissions

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