| IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
mailsaurabh.tripathi
Joined: 22 May 2008
Posts: 22
Location: hyderabad
|
| Posted: Tue Oct 07, 2008 12:09 pm Post subject: -911 and -904 |
|
|
| What are the steps to be followed to get rid off from -911 and -904 |
|
| Back to top |
|
guptae
Joined: 14 Oct 2005
Posts: 1025
Location: Bangalore,India
|
| Posted: Tue Oct 07, 2008 12:40 pm Post subject: |
|
|
Hello Saurabh,
-904 :UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE.
The sql stmt can not be executed since resource not available .Message will show you resource name just check the resource avaiablity.
1)It can be because tablespace/ IX dataset are migrated ..in that case recall them & then try again
2) May be tablespace are not in RW mode check with ur DBA's
-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
o 00C90088 - deadlock
o 00C9008E - timeout
Check whether you have any indoubt thread running just abort them & try again |
|
| Back to top |
|
dick scherrer
Joined: 23 Nov 2006
Posts: 8597
Location: 221 B Baker St
|
| Posted: Tue Oct 07, 2008 9:43 pm Post subject: |
|
|
Hello,
Quote: What are the steps to be followed to get rid off from -911 and -904
Change the design of the code or change when the processes are scheduled. |
|
| Back to top |
|
Cristopher
Joined: 31 Jul 2008
Posts: 36
Location: NY
|
| Posted: Wed Oct 08, 2008 3:02 pm Post subject: Reply to: -911 and -904 |
|
|
Saurabh,
You can go through the attached document.
Hopefully, it will help you in clearing some of your doubts.
Cris |
|
| Back to top |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|
