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?
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 ...