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 and -904

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

New User


Joined: 22 May 2008
Posts: 56
Location: hyderabad

PostPosted: Tue Oct 07, 2008 12:09 pm    Post subject: -911 and -904
Reply with quote

What are the steps to be followed to get rid off from -911 and -904
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Oct 07, 2008 12:40 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Oct 07, 2008 9:43 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Cristopher

New User


Joined: 31 Jul 2008
Posts: 53
Location: NY

PostPosted: Wed Oct 08, 2008 3:02 pm    Post subject: Reply to: -911 and -904
Reply with quote

Saurabh,
You can go through the attached document.
Hopefully, it will help you in clearing some of your doubts.

Cris
Back to top
View user's profile Send private message
dineshpost

New User


Joined: 06 Nov 2008
Posts: 2
Location: India - Chennai

PostPosted: Mon Dec 22, 2008 3:14 pm    Post subject: Reply to: -911 and -904
Reply with quote

For -904.....

Check with DBA if the id has the more RLF limits. There are chances for timeouts if the id does have enough RLF limits. It is good to check with DBA to increase the RLF limits to avoid resource unavailable status.
Back to top
View user's profile Send private message
Shriram Jogdand

New User


Joined: 14 Oct 2008
Posts: 65
Location: Pune

PostPosted: Mon Dec 22, 2008 6:31 pm    Post subject: Reply to: -911 and -904
Reply with quote

I also faced the same problem some time back. You can resolve this issue by changing the ISOLATION LEVEL. While binding the plan/package, keep the Isolation level as CS i.e. cursor stability.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Tue Dec 23, 2008 12:23 am    Post subject:
Reply with quote

Sometimes a -904 can be caused by not committing often enough. Of course, it depends on the resource type. Several things cause a -904.
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:



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