Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    2

    Unanswered: How to bypass the DB2 cache on iSeries?

    Hi,

    I am doing some benchmarking on an SQL Query with DB2 for iSeries.
    DB2 for iSeries automatically caches the access plan and ODP, which makes it almost impossible to measure the time the Optimizer takes to build an access plan.

    Is there any way to bypass the cache, to tell DB2 that you don't want to use the cache for this statement? In the QAQQINI file maybe? Or with a statement?

    Thanks,
    Eric

  2. #2
    Join Date
    Mar 2006
    Posts
    2

    System_sql_statement_cache = *no

    I found it in the meantime: SYSTEM_SQL_STATEMENT_CACHE = *NO in QAQQINI...

Posting Permissions

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