Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Unanswered: Select in performance

    Hi there,

    Recently we moved our codes to new DB2 machine.
    These codes used select in ('A1','A2',.....'A1000') to get result in seconds
    before we moved to new DB2.
    Now these select in SQL took a very very long time to complete.
    Any settings we forget to set in our new DB2?

    Thank you

    Fleming

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    If I was faced such situation, I would do...
    1) Take explain of the query on new machine.
    2) Conpare dbm config and db config.
    3) Execute the query by db2batch to see the detailed elapsed time, logical/physical reads/writes, so on ...
    Last edited by tonkuma; 06-10-09 at 00:31.

  3. #3
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Maybe this setting "DB2_INLIST_TO_NLJN"
    explained here: DB2 Information Center
    and here: http://publib.boulder.ibm.com/infoce.../r0005664.html

Posting Permissions

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