Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2015
    Posts
    4

    Unanswered: db2 Query Is Taking Different Time In Diff Environments

    Hi,

    Query is taking different time in DEV and TEST environments. Same query in TEST environment is taking more time then in DEV environment.

    OS= SUSE Linux Enterprise Server 11 (on both).

    DB= db2 10.5 (on both).

    Ram= 32gb (on both).

    CPU on DEV=

    vendor_id : IBM/S390 processors : 8 bogomips per cpu: 14367.00

    CPU on test:

    vendor_id : IBM/S390 processors : 8 bogomips per cpu: 18115.00

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    This topic has been covered a couple of times in the past here. In fact, I just had a similar item, but had already done on the suggested checks against one system to the other.

    http://www.dbforums.com/showthread.p...e-to-CODE-PAGE We have a PMR open with IBM on this right now. Will update that thread once we hear back.

    Easy items first. Check to ensure you have the same indexes and that statistics are current on both systems. Then take a look at your explains are they different?
    Dave

Tags for this Thread

Posting Permissions

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