Results 1 to 2 of 2

Thread: Db2_mmap_write

  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Unanswered: Db2_mmap_write

    what are the uses of DB2_MMAP_WRITE and DB2_MMAP_READ

    I know by degault these are on. How do we know when these params need to be turned off. I have seen lot of times , turning these params off is improoving the performance

    What are the monitor elements i should check to turn them off or on

    Thx

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    If you set those variable to on, you tell DB2 to by-pass the operating system's memory cache: http://publib.boulder.ibm.com/infoce..._DB2_MMAP_READ
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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