MVSFORUMS.com

mainhead · Beginner Joined: 07 Feb 2006 Posts: 26 Topics: 11

Hi All,

I am using Telon Cobol + Db2 + Ims dc programe online system (24 hrs) . My job job abends with -911 00C90088
,which is current unit of work has been rolled back due
to dead lock or time out . After some time restarting the job on the failed step it complets suucesful .
From Dba view "It is because of running run incompatible on-line transactions and batch programs at the same time ".

Can i overcome this job abend by fixing programs .
Also from the job abend step it comes from batch program , found from the tool

Could you please advice on this .
Thanks

kolusu · Posted: Wed Feb 15, 2006 9:16 am Post subject:

mainhead,

Check for sqlcode of -911 or -913 and delay the program execuetion and re try the sql once again.

Most shops have standard routines to encounter the deadlock situtations

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Bithead · Posted: Wed Feb 15, 2006 9:19 am Post subject:

mainhead,

mainhead · Beginner Joined: 07 Feb 2006 Posts: 26 Topics: 11

Checking for sql code already in place ,
For example
This happens
1 >> when insert query
2 >> Checking db2 status (sql )

iam concerend of job abend , All the above logics are already in place ,
To run job at different time is not possible has its affects other Production job .
Your advice or any example would be great !!

kolusu · Posted: Wed Feb 15, 2006 10:39 am Post subject:

mainhead · Beginner Joined: 07 Feb 2006 Posts: 26 Topics: 11

Kolusu Performing delay Means ?? are you saying that to run production job at different time than usual time

kolusu · Posted: Wed Feb 15, 2006 11:17 am Post subject:

mainhead · Beginner Joined: 07 Feb 2006 Posts: 26 Topics: 11

Kolusu Sorry to come again , I have seen your code , but i dont know where to include this , Iam using Telon cobol Db2 Ims dc Programs Could you please guide me

kolusu · Posted: Wed Feb 15, 2006 12:43 pm Post subject:

mainhead · Beginner Joined: 07 Feb 2006 Posts: 26 Topics: 11

Kolusu , Thanks for your information !!, iam not asking you to code also i know its self explanotory , I want to know wheather this code is to be included in same cobol program or to keep seperate code by calling my sub program !!!!!!.

Listen iam beginner !!! in few years i will help others like you .

Many Thanks for your information ...

Bithead · Posted: Wed Feb 15, 2006 2:14 pm Post subject:

Just remember that if you are in a deadlock, introducing a delay into your online program will not fix the problem.

Manas Biswal · Posted: Thu Feb 16, 2006 9:42 am Post subject:

mainhead,

Have a look at the following link -
http://mvsforums.com/helpboards/viewtopic.php?t=5542&highlight=911

Deadlocks are best left for DB2 to handle and you should not/may not be able to always handle them.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)