Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Unanswered: Db2_keep_as_and_dms_containers_open

    Anyone has experience with this registry variable on DB2 9.7 on Linux ?

    Is it sensible to set this in an environment with catalog and temp tablespaces as SMS?

    Thanks

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Based on the doc, it sounds like only should be used for pure DMS environments, but they don't really explain why:

    "When you set this variable to ON, each DMS table space container has a file handle opened until the database is deactivated. Query performance might improve because the processing required to open the containers is eliminated. You should use this registry only in pure DMS environments, otherwise performance of queries against SMS table spaces might be affected negatively."

    I usually have a dedicated bufferpool for the catalog tablespace that is about 4000 4K pages (or 2000 in 8K pages), so hopefully not too much I/O on containers.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I sent you some info... not much

Posting Permissions

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