Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009
    Location
    Calgary, AB Canada
    Posts
    38

    Unanswered: is there an equivalency to the sysibmadm schema within v8?

    I'm trying to pull the DB/DBM values out of the database without having to submit a "get db/dbm cfg" at the prompt. In v9, I went straight to the sysibmadm tables, where would I find this information in v8?

    TIA!

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You can use db2pd with -dbcfg / -dbmcfg if you're on v8.2

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Or you can use the respective APIs and do this programmatically.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    DBM_GET_CFG
    and
    DB_GET_CFG

    One of them was a table function and the other was a procedure

    Don't remember which db2 level they were introdcued.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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