Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2008
    Posts
    14

    Unanswered: how to verify tablespace is enabled for file system cache?

    Hi,

    How can I verify if tablespace is enabled for file system cache?

    does have view? table?

    thanks
    Last edited by gabrielatme; 05-06-09 at 14:48.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version and OS?

    Andy

  3. #3
    Join Date
    Nov 2008
    Posts
    14
    DB2 V9
    OS Linux RedHat 5

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Use the Snapshot view:

    DB2 Database for Linux, UNIX, and Windows

    Andy

  5. #5
    Join Date
    Nov 2008
    Posts
    14
    I tested but he comes back values between 0 and 3.

    they put in IBM information Center it doesn't inform what means these values. I am speaking about the column FS_CACHING

    any help?

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    FS_CACHING will be 0 if filesystem caching is enabled. You can also get this info from db2pd -tablespaces. Example:

    db2pd -d sample -tablespaces

    Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:00:11

    Tablespace Configuration:
    Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name
    0x078000002041F640 0 DMS Regular 4096 4 Yes 4 1 1 On 1 0 3 SYSCATSPACE
    0x078000002040ABA0 1 SMS SysTmp 4096 32 Yes 32 1 1 On 1 0 31 TEMPSPACE1
    0x078000002040F400 2 DMS Large 4096 32 Yes 32 1 1 On 1 0 31 USERSPACE1



    FSC column

  7. #7
    Join Date
    Nov 2008
    Posts
    14
    thank you very 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
  •