Stimer Macro



IBM's flagship relational database management system

Stimer Macro

Postby jaggz » Tue Apr 10, 2012 10:18 am

Hi,

Are there any IBM supplied MVS wait module source Codes which would help in eradicating the -911 and -904 situations.

Jaggz
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 4 times

Re: Stimer Macro

 

Re: Stimer Macro

Postby steve-myers » Tue Apr 10, 2012 10:50 am

STIMER is an Assembler macro. What does this have to do with DB2?
steve-myers
Global moderator
 
Posts: 1885
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 197 times

Re: Stimer Macro

Postby jaggz » Tue Apr 10, 2012 11:04 am

Hi Steve,

I am just looking for a DB2 specific WAIT module which uses STIMER macro. Its like whenever a DB2 transactions encounters DEADLOCK or consumes more CPU then this Module will cancel those Transactions. So basically the WAIT module would use the STIMER macro set the time intervals.

Jaggz
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 4 times

Re: Stimer Macro

Postby dick scherrer » Tue Apr 10, 2012 9:32 pm

Hello,

I am just looking for a DB2 specific WAIT module which uses STIMER macro. . . . .
So basically the WAIT module would use the STIMER macro set the time intervals.
Ah, NO thisw is NOT something you would want. Once the DEADLOCK condition has been dected, no amount of waiting will free it. . . That is why it is called a deadlock.

When a deadlock occurs it is a design deficiency. Review the processes and correct the order in which things are locked.
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