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!


DB2 & UDB email list listserv db2-l LazyDBA home page