Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    37

    Unanswered: Where am I spending my time? URGENT

    Hi all.

    Please have a look at this preformance extract on one of my JDBC transactions. The query was served by DB2 eventually. It took DB2 a couple of millis. Still, the query did not come back with results for 4.5 minutes !!!

    Where am I spending my time?

    Here is a summary of the TMON for DB2 collection analysis:

    Elapsed Times:
    TOTAL 4:30.38
    TOT CPU 0:00.02
    I/O WT 0:00.02
    SORT 0:00.00

    DB2 0:00.05
    DB2 CPU 0:00.01
    LOCK WT 0:00.00

    Buffer Pool/Locking
    GETPAGES 61
    SYNC RD 17
    PREFETCH 1
    PGS/IO 3.2

  2. #2
    Join Date
    Sep 2003
    Posts
    218
    Could you tell us what other layers form your application? How are the results getting rendered? By initial look of the trace, it rather suggests that you are fine on db front...

    Thanks in advance...

  3. #3
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    37
    Yes. DB2 appears find once it get the request in.

    The architecture layers include a web client creating requests to a Java servlet which dispatches the request to the appropriate delegates for processing. The DAO layer issues a JDBC connection request, then submits the call to DB2 via DB2 Connect.

    The delays are clearly happening on the host before DB2 gets to process the request or sometime after. Not during, otherwise that would show up as DB2 time.

    This is a DB2 for OS/390 v7.2 FP8 environment.

    Thanks for any advise.

  4. #4
    Join Date
    Sep 2003
    Posts
    218
    The best way to go forward is to extract time from log files (assuming you are printing the same) spent in each of these layers. By doing this, you can exactly know which component is causing the issue.

    For eg: User Action <-> UI/Browser <-> App Server <-> Network <-> Database <-> O/s disk

    Make sure you execute the query in db2 exclusively and check to see if all indexes etc are present & update statistics. We have come across similar issue earlier and we resolved it by identifying a component in which the max time was spent. Presumably, it was not in db...

    In my experience, if there is a db issue then it will show up. Involve the right people and prepare a reproducable procedure to test this one out.

    Hope this helps.

Posting Permissions

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