Lopez,
A -904 basically is a resource unavailable - pretty sure you know that
already...
There are 3 common reasons for a resource unavailable message:
1. the 904 could be caused by a contention issue - which you already
ruled out...
2. It can also be caused by a table or dataset being migrated off...
- solution: try recalling the offending dataset, the DSN is
usually displayed with the error message
3. Or finally, it can be the result of a table being in "copy pending"
mode...
Solution: do an image copy of the table and that will release it
from "copy pending"...
Good Luck!
Rohan Cruickshank
Systems Engineer
RTS
770 433 8211 ext 84942
Purity of Heart, Clarity of Mind
and a Soul Devout
These three things I hope to find
Within and not Without
-----Original Message-----
From: Lopez Garcia Ramiro
[mailto:db2udbdba-ezmlmshield-x71164090.[Email address protected]
Sent: Tuesday, May 30, 2006 1:39 PM
To: LazyDBA Discussion
Subject: RE: Help SQL Code
Thanks Cruickshank!
You are rigth, yesterday afternoon the job had a contention with a QMF
online user; but at night the job were running again, alone, and it
abends also with the same sql code/reason code, nothing was running at
the same time, can you believe it? Another way to try fix it?
Rgds!
-----Mensaje original-----
De: Cruickshank Rohan [mailto:db2udbdba-ezmlmshield-x35075964.[Email
address protected] Enviado el: Martes, 30 de Mayo de 2006 12:17 p.m.
Para: LazyDBA Discussion
Asunto: RE: Help SQL Code
Seems like you have a contention issue with someone(s) else accessing
the table. You may want to lock the table exclusive before doing the
update or wait until there is no one else accessing the table.
Here is a link that might be helpful...
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/
com.ibm.db2.doc.mc/listomsgs.html
Thanks..
Rohan Cruickshank
Systems Engineer
RTS
770 433 8211 ext 84942
Purity of Heart, Clarity of Mind
and a Soul Devout
These three things I hope to find
Within and not Without
-----Original Message-----
From: Lopez Garcia Ramiro [mailto:db2udbdba-ezmlmshield-x42553993.[Email
address protected]
Sent: Tuesday, May 30, 2006 12:32 PM
To: LazyDBA Discussion
Subject: Help SQL Code
Hi guys, there is a program COBOL/DB2, runs an massive UPDATE in a jcl
with statict sql, but suddenly abends with:
SQL Code -904, Reason Code 00C200EA
The table has 27 millions of rows,12 indexes and 64 partitions; the
frecuency of commits for the update is 1000 rows. DB2 v7 for z/OS. The
BIND parameters are:
BIND PLAN (myplan) OWNER(X) QUALIFIER(X)+
NODEFER(PREPARE) VALIDATE(BIND) FLAG(I)+
ISOLATION(CS) CACHESIZE(1024) CURRENTDATA(YES)+
DEGREE(ANY) SQLRULES(DB2) ACQUIRE(ALLOCATE)+
RELEASE(DEALLOCATE) EXPLAIN(NO) DYNAMICRULES(RUN)+
NOREOPT(VARS) KEEPDYNAMIC(NO) IMMEDWRITE(NO)+
DBPROTOCOL(PRIVATE) ENCODING(500)+
DISCONNECT(EXPLICIT)+
MEMBER(mine)+
LIBRARY('mylib.prgrms.DBRM')+
ENABLE(*)+
ACTION(REPLACE) RETAIN
Can any one have a suggestion?
Thanks in advanced for all your help!
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
--
this email delivered by mercury
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
--
this email delivered by hermoth
DB2 & UDB email list listserv db2-l LazyDBA home page