Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

-911 will rolled back the transaction.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Pons

New User


Joined: 25 May 2007
Posts: 61
Location: Coimbatore

PostPosted: Tue Aug 14, 2007 8:09 am    Post subject: -911 will rolled back the transaction.
Reply with quote

Hi,

I try to solve the -911 (Dead lock) contention issue. For that i explicitly give the commit while we receive the -911.

Ex:

I plan to code like,

IF WS-SQL-CODE = -0911
EXEC SQL
COMMIT
END-EXEC
END-IF.

but my doubt is,

-911 THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO
DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF
RESOURCE resource-type, AND RESOURCE NAME resource-
name.

Is my code will commit the transaction, or while getting the -911 from the DB2 Detecter itself is it rolled back the transaction?

Please let me know some detailed information.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Aug 14, 2007 4:16 pm    Post subject:
Reply with quote

as the -911 says, your current unit of work has been rolled back. If you issue a COMMIT, there is nothing to commit.

What you need to do is restart you last current unit of work.

Are you sure that you did not receive a -913 and ignore it.

you need to read chapter 4 of the sql programming and application guide.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm
No new posts CICS Transaction Timeout Hooman24 CICS 2 Sun Apr 16, 2017 2:16 pm
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 3 Thu Jan 19, 2017 1:31 am
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us