Improving thread reuse in CICS applications

Having transactions reuse threads is generally recommended because each thread creation is associated with a high processor cost.

Procedure

To improve thread reuse in CICS® applications:

Close all cursors that are declared with the WITH HOLD option before each sync point.

Db2 does not automatically close them. A thread for an application that contains an open cursor cannot be reused. You should close all cursors immediately after you finish using them.