Retry(n)' parameter with the 'run program' command



IBM's flagship relational database management system

Retry(n)' parameter with the 'run program' command

Postby Jorgen Amnestal » Tue Jun 09, 2009 2:38 pm

Hi

I'm curious about the 'retry(n)' parameter with the 'run program' command.
The manual implies it checks for DB2 up and/or batch connections, but will it help me solve a -911 abend for instance?

That would really be neat. ;)

Does anybody know, or should I do some testing?

best rgds
/Jorgen
Jorgen Amnestal
 
Posts: 6
Joined: Tue Aug 26, 2008 6:59 pm
Location: Stockholm, Sweden
Has thanked: 0 time
Been thanked: 0 time

Re: Retry(n)' parameter with the 'run program' command

 

Re: Retry(n)' parameter with the 'run program' command

Postby swd » Wed Jun 10, 2009 9:04 pm

Jorgen

I don't think the RETRY(n) parameter will help in solving a -911, as this deals with the Thread Management, so refers to the number of users of in the DSN command. There may only be 2 users of the DSN command, so no retry will be attempted, and a deadlock could still occur between the 2 DSN batch users. If deadlocks are a problem for you then it's best that you deal with why they are occuring and sort that out.

Cheers
Steve
User avatar
swd
 
Posts: 109
Joined: Wed Feb 18, 2009 9:18 pm
Location: UK
Has thanked: 0 time
Been thanked: 0 time

Re: Retry(n)' parameter with the 'run program' command

Postby dick scherrer » Thu Jun 11, 2009 7:01 am

Hello,

The -911 might be a deadlock or a timeout.

Have you confirmed which it is?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post