Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2008

    Red face Unanswered: DB2 QUERY Performance

    Environment : LiNUX, DB2 9.7

    We are running same query in UAT and PROD .. In UAT it got completed in 3 mins and in prod it's taking 2 hours time.
    Indexes,data in tables are same in both the env's
    We ran REORG and RUNSTATS also on both the env's.

    Can anyone please let me know the cause for this issue and let me know What I need to check it

    Thanks IN ADVANSE

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    have you done explain in both env. ? is it the same ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Oct 2008
    Yes.. Both are same .. Thanks

  4. #4
    Join Date
    Dec 2007
    Richmond, VA
    Provided Answers: 5
    Then what is the difference between UAT and Prod environments? If the explain is the same, the data, indexes, etc... Then it has to be an environmental issue, such as buffer pool sizes, sort heap, degree of parallelism, etc...

  5. #5
    Join Date
    Nov 2011
    Have you compared the the snapshot of each query ( eg, data logical read, rows read )?
    There must be some difference。
    if you could ,you can publish the output of db2batch using the following command:
    db2batch -d <dbname> -o e yes p 5 r 5 -i complete -f xxx.sql
    And the execution plan is also needed ( db2exfmt).

Posting Permissions

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