Design Guidelines for Applications
There are recommendations for designing applications for best performance when using JDBC/SQLJ. Some of them have been described in the IBM Redpaper “DB2 for z/OS and OS/390 V7 Selected Performance Topics”—REDP0162 and are summarized below.
Data Types
There are a few performance gains that can be realized when developing Java applications in regards to data types. While this is also a database design issue, it is important to recognize these options.
Mapping
Java data types need to be mapped to the SQL column data types to achieve best performance. This can help with ensuring the predicates are Stage 1 and indexable and so that the cost of conversion can be minimized. See Table13-2.
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
