INCREM BIND is going up and the bind parameters are the below. The
DEFER(PREPARE) is in and could be causing it.
BIND PACKAGE(CISP1) MEMBER(CUBMR116)
LIBRARY('CISD0.PP30AP.DBRMLIB')
OWNER(CISP11 ) QUALIFIER(CISP10 ) CURRENTDATA(NO )
VALIDATE(BIND) EXPLAIN(YES) ACTION(REPLACE)
SQLERROR(NOPACKAGE) ISOLATION(CS) RELEASE(COMMIT )
DEGREE(ANY)
REOPT(VARS) DEFER(PREPARE)
KEEPDYNAMIC(NO )
DBPROTOCOL(PRIVATE)
FLAG(I);
CURRENT SQL COUNTS
PLAN
Thread: Plan=PCIS01P1 Connid=BATCH Corrid=CUNR02$P
Authid=TRAC
Attach: BATCH JOB Name=CUNR02$P JOB Asid=
209
Package: CUBMR116 Collection=CISP1
sqls
Commit = 1199 Abort = 0 Select =
454130
Open Cursor = 9913 Close Cursor = 9913 Fetch =
13301
Insert = 69530 Delete = 0 Update =
3597
Describe = 0 Lock Table = 0 Prepare =
0
Grant = 0 Revoke = 0 Set Rules =
0
Increm Bind = 462840 Label/Comm On = 0 Set SQLID =
0
Set Host Var = 1 Set Connection = 0 Set Degree =
0
Connect Type 1 = 0 Connect Type 2 = 0 Set Path =
0
