Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: CPU usage - DB2 Open Cursor

    We have made some enhancements to an IMS-DB/DC system by adding new DB2 databases.

    Currently one of the important query in a transaction took 9 ms of CPU time for a open cursor execution(Join Query).
    Frequency of execution - approx 1 per transaction.

    Can you please provide me with the benchmark values for such a DB operation

    Thanks in Advance
    Biju ValiyaVeedu

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Depends on many different factors. There is no standard benchmark.

    To receive an explanation of why it takes so long, and possible things you can do to improve the performance, please post the following:

    1. SQL open cursor statement,
    2. DDL for the tables and all indexes on the tables referenced in the cursor, and
    3. The number of rows in each table.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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