| View previous topic :: View next topic |
| Author |
Message |
issac1029
Intermediate
Joined: 10 Dec 2005
Posts: 159
Topics: 75
|
 Posted: Wed Mar 15, 2006 11:53 pm Post subject: how to resolve -904 |
 |
|
| Quote: | DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000304, AND
RESOURCE NAME OZRBD051.TSRBT001.X'00085E' '.X'0D'
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 101 13172746 0 13813475 -640086009 0 SQL DIAGNOSTIC
INFORMATION
DSNT416I SQLERRD = X'00000065' X'00C9000A' X'00000000' X'00D2C6E3'
X'D9D91007' X'00000000' SQL DIAGNOSTIC INFORMATION |
I modify the sql statement reduce the rows that my sql(select) resolve,then it run well.
From ,It seems that something define in tablespace are not enough.Which filed should be alter? |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
Jaya
Beginner
Joined: 02 Sep 2005
Posts: 77
Topics: 10
Location: Cincinnati
|
|
| Back to top |
|
|
issac1029
Intermediate
Joined: 10 Dec 2005
Posts: 159
Topics: 75
|
| Posted: Thu Mar 16, 2006 9:31 am Post subject: |
|
|
Thanks,
I have know those infomation before I post ,I've try to alter maxrows of ablespace,it can't be used before stop tablespace.It returns -626,how can I deal with this?I would try to alter locksize |
|
| Back to top |
|
|
Manas Biswal
Intermediate
Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India
|
| Posted: Thu Mar 16, 2006 10:24 am Post subject: |
|
|
Jaya and issac1029,
MAXROWS tablespace parameter has got nothing to with locking. It is the maximum number of rows that DB2 can place on a single page.
The tablespace parameter that you are looking for is LOCKSIZE. Check the LOCKSIZE value for the tablespace. If it is "ANY" or "ROW" for your tablespace, consider making it "PAGE" or "TABLESPACE". Or otherwise, explicitly lock the table using the LOCK TABLE statement before running your application.
Remember that these directions are not as black and white as they seem. Before doing any of these, look for other impacts.
Also look for the NUMLKTS(Max locks per tablespace) and NUMLKUS (Max locks per user) parameters. They are DSNZPARM parameters and determine the maximum locks before a lock escalation occurs.
HTH...Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948) |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
