Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SQL CODE = -904 UNAVAILABLE RESOURCE

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

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Oct 17, 2008 11:18 am    Post subject: SQL CODE = -904 UNAVAILABLE RESOURCE
Reply with quote

HI,
Iam getting following error
Code:
     DB2 SQL DIAGNOSTICS                                         
         TABLE BEING ACCESSED - XAXXES-TABLE              MODULE-CALL CHAIN - IV2ETIB IV2ETVB IV2XKAA IV2EAIB IVEXAI1
DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN         
         UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000302, AND
         RESOURCE NAME VTGDATAC.TXAXXE  .X'503D68'                           
DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE                             
DSNT415I SQLERRP    = DSNXRUID SQL PROCEDURE DETECTING ERROR                 
DSNT416I SQLERRD    = -110  13172746  0  13813475  -1010298874  0 SQL         
         DIAGNOSTIC INFORMATION                                               
71000-INSERT-SUB-ROW                                                         


VTGDATAC..TXAXXE is tablespace.

1. How to resolve UNAVAILABLE RESOURCE situation ? Like making it available.
2. How to see & know what resource is using it/utilizing that particular tablespace ?
Any Utility Command for that ?

Please! Let me know. I am in NEED

Sushanth Bobby
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: Fri Oct 17, 2008 11:33 am    Post subject:
Reply with quote

Hello,

Suggest you talk with your dba. They will know your system best and this will get you the fastest correct answer.
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Fri Oct 17, 2008 11:34 am    Post subject:
Reply with quote

No of Locks exceeded the maximum . Are you using an select query or an update query

how about this link

http://ibmmainframes.com/viewtopic.php?t=34860
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Oct 17, 2008 12:06 pm    Post subject:
Reply with quote

Yes Dick, I will do that definately.
Basically, i am asking. In a situation like this how to resolve or analyze the problem, what are things need to be seen and taken care.

Prasanth, Update Query is being used.

Sushanth
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Oct 17, 2008 6:15 pm    Post subject:
Reply with quote

Thank You Prasanth,
For this link
http://www-01.ibm.com/support/docview.wss?rs=338&context=SSEK24&dc=DB520&uid=swg21220631&loc=en_US&cs=UTF-8&lang=en
in this post http://ibmmainframes.com/viewtopic.php?t=34860

According to the link, I refered the DDL of my TABLESPACE. It was LOCKSIZE PAGE & LOCKMAX 0.
Solution given is : LOCKSIZE = TABLE & LOCKMAX = 0

When LOCKMAX = 0, Esculation LOCK from page to table/tablespace won't be happening. In my case it is getting stopped in PAGE itself.

The tablespace i am using is a partition table space. It has about 10 partitions. If i alter the LOCKSIZE=table & LOCKMAX = 0. The entire table will be locked & concurrency would be reduced, i think. (Guys, i need your advise on this, is my thinking is correct).

Instead of locking the entire table, is there any way to lock a particular partition. I know this sounds stupid, I just read some manuals regarding LOCKSIZE can be in (row,page,table,tablespace,LOB). But, those manuals were refering to most simple & segemented, i did'nt see much of partition there. That's why iam asking a question such as this. Can it be done locking on a particular partition.

Iam using DB2 V8.

Temporary Success : As said in the above mentioned link, reducing the input records. I did'nt receive SQLCODE = -904.


Sushanth Bobby
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: Fri Oct 17, 2008 9:09 pm    Post subject:
Reply with quote

Hello,

I believe i would look at this from a slightly different perspective.

Rather than be concerned about partition versus table versus tablespace, i would focus on why the process needs so many concurrent locks. This nearly always causes long-term problems.

Systems that run well usually lock as little as possible for as short a duration as possible - they lock neither table nor partition.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Sat Oct 18, 2008 1:22 pm    Post subject:
Reply with quote

Hi,
Quote:
Systems that run well usually lock as little as possible for as short a duration as possible - they lock neither table nor partition.


Thank You for ENLIGHING me, d.sch.

Sushanth
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 Speed-up/reduce CPU use of code prino PL/I & Assembler 0 Tue Sep 26, 2017 12:05 am
No new posts Finding IMS resource blocker after se... Hooman24 IMS DB/DC 1 Wed Aug 16, 2017 9:17 pm
This topic is locked: you cannot edit posts or make replies. how to code for GDG in Rexx cvnlynn CLIST & REXX 13 Wed Aug 09, 2017 9:13 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts I want to retire TRX and use only Rex... Abhinav Sharma CLIST & REXX 6 Sat Jul 29, 2017 2:53 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us