Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    84

    Unanswered: DB2 look at Package Cache

    I'm using DB2 9.1 with AIX 6.1. How do you look at the Package Cache on db2? For example if someone kicks off an SQL, I would like to look to make sure how many times it's in Package Cache.

    Thank you,

    CC

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    That's available in the dynamic SQL snapshot: statement compilations vs. executions. Aggregate statistics are shown in the database snapshot (package cache inserts vs. lookups). Don't remember if db2pd -dynamic was available in DB2 9.1, but you can always look that up in the manual.

  3. #3
    Join Date
    Feb 2007
    Posts
    84
    I tried all 3 of these methods. I don't know which one is better or if I'm looking at the right thing. Looks like it...

    db2pd -d ow_prod -dynamic

    db2 get snapshot for dynamic sql on ow_prod


    SELECT PREP_TIME_WORST, NUM_COMPILATIONS, SUBSTR(STMT_TEXT, 1, 60)
    AS STMT_TEXT, DBPARTITIONNUM
    FROM SYSIBMADM.SNAPDYN_SQL
    ORDER BY ROWS_READ

Posting Permissions

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