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

Document ID:  TEC1518524
Last Modified Date:  07/10/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Fast Load for DB2 for z/OS

Releases

  • CA Fast Load for DB2 for z/OS:Release:18.0
  • CA Fast Load for DB2 for z/OS:Release:19.0

Components

  • CA Fast Load for DB2 for z/OS:PFL
Problem:

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. 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing