MVSFORUMS.com

jayan.r · Beginner Joined: 16 Jan 2006 Posts: 4 Topics: 2

Hi,
I have a peculiar situation here.
I have a database on which an INSERT is taking place.
The Logic goes something like this.
The program has to insert a record in the database whose primary key is a random number. The program generates a random number and tries to INSERT a record. If the record is duplicates then the program generates a new random number and inserts the record again. This process continues for 999 times after which if unsuccessful the job abends.
Now inorder to enable parallel processing 9 replicas of this job is executed at a single go.
At times this job abends with a -911. Can anyone give any idea of what could be wrong.

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

jayan.r,
What is the Commit frequency? It maybe holding locks for too long causing the parallel threads to timeout.