Multiple CA Fast Load jobs fail with -911 on PTG700T2 PFL0413E

Document ID : KB000005204
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Running multiple Fast Load jobs at the same time may cause an occasional SQL -911 timeout failure on the CA Restart Table PTG700T2, receiving error: PFL0413E - Unable to Update Restart Table 

Environment:
CA R18 and R19, DB2 V10 and above
Cause:

Running multiple Fast load utilities at the same time. 

Resolution:

Alter CA Tablespace PTG700T2 from LOCKSIZE PAGE to LOCKSIZE ROW to resolve the problem of contention due to high usage of the Restart table. This has corrected the problem for all our customers who hit this same problem.