Database management for performance

You can tune a number of aspects of database management in order to improve performance.

Setting DBCTL parameters
A number of parameters are required to assist with DBCTL performance. These include MINTHRD and MAXTHRD, which are specified in the DRA startup table (DFSPZP) and DEDB parameters (CNBA, FPBUF, and FPBOF), which are defined during DBCTL system generation or at DBCTL initialization.
Tuning the CICS DB2 attachment facility
The CICS DB2® attachment facility provides a multithread connection to DB2. The DB2CONN, DB2ENTRY, and DB2TRAN definitions of the CICS DB2 attachment facility define the authorization and access attributes on a transaction and transaction group basis. You can optimize performance between CICS and DB2 by adjusting the transaction class limits, MXT system parameters of CICS, and the THREADWAIT, TCBLIMIT, THREADLIMIT, and PRIORITY attributes of DB2CONN and DB2ENTRY.
Selecting authorization IDs for performance and maintenance
A process that connects to or signs on to DB2 must provide one or more DB2 short identifiers, called authorization IDs, that can be used for security checking in the DB2 address space. Every process must provide a primary authorization ID, and it can optionally provide one or more secondary authorization IDs. CICS transactions that acquire a thread into DB2 are considered as processes, and must provide authorization IDs.
Logging
Because logging costs contain some of the variable costs incurred by synchronous accesses to the coupling facility, they are documented here in terms of milliseconds of CPU time.
Sync pointing
The sync point cost needs to be factored into the overall transaction cost. The amount of work at sync point varies according to the number of different types of resource managers involved during the unit of work (UOW). Therefore, the cost can vary.

Parent topic: Improving the performance of a CICS system