Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    19

    Unanswered: creating bufferpools on raw device

    Hi,

    New to DB2. I would like to know how I can create a bufferpool in a raw device? This is on DB2 8.2 on HPUX.

    Thanks

    AR

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    You create bufferpool in memory; you create tablespaces on raw device(or filesystem). When DB2 reads/writes data from a tablespace, it has to come to the bufferpool. If the tablespace is on a filesystem, the OS reads data from the file to filecache(which is OS buffer for filesystem I/O) and then DB2 reads it from filecahe to DB2 bufferpool; if tablespace is raw data goes directly to the DB2 bufferspace. If you use filesystem you have to reserve a good portion (20-30%) for filecache; if you use raw devices filecache can be smaller and bufferpools bigger than in filesystem systems.
    mota

Posting Permissions

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