Host database tuning
System performance will be affected
by the performance of the IBM mainframe database server. Different database
management systems have different performance features. SQL optimizers
of different systems, for example, could behave differently with the
same application.
Check your IBM mainframe database server system performance
documentation for more information.
You might be able to improve performance by using the uncommitted read (UR) or no commit (NC) bind options, where available, to avoid journaling.
Note: When using UR, unjournaled data can only be read, not updated,
and then only if blocking is set to ALL.
Depending on the application server and the lock granularity it provides, the isolation level used for a query or application might have a significant effect on performance. The database should have the appropriate level of normalization, effective use of indexes, and suitable allocation of database space. Performance can also be affected by the data types that you use, as described in the following sections.