The problem was solved.

I have a very strange db2 performance problem. I have a sql which join 5 tables and also have a predicate <>. By using cli, it runs about 7 hours to get 8736409 rows result.
By using db2batch , it only takes about 55 minutes to get the same results. (I did restarted db2 instance to avoid cache, also, file system cache is not enabled. ) Now the difference between db2batch and cli is db2batch uses RR, but my cli is CS, so I used...