|
View previous topic :: View next topic
|
| Author |
Message |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
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 |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005
Posts: 306
|
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Thank You Prasanth,
For this link
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 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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
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 |
|
|
|
|
