DB2 is popularly use database in mainframe. Developing DB2 applications that show highest perforce is a challenging task.
During development, many performance related things you may encounter while working on DB2 applications. Else, it is expensive for the projects, since it takes more CPU time.
I am just quoting Craig Mullen’s DB2 expert tips:
- Assuming an ORDER BY is not necessary for ordered results – if you want your results always to be returned in a specific order, you must include the ORDER BY clause. If you fail to do so, a future rebind can change the access path and also possibly change the order of your results set.
- Forgetting the NULL indicator – when your query can return a null, but sure to include a null indicator or you will get a -305 SQLCODE (22002 SQLSTATE). And be sure to check the null indicator to see if the data is null or not!
Here is full article here.