470,832 Members | 2,073 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,832 developers. It's quick & easy.

Problem with Rebuild Index after loading data with DSN1COPY

I have been asked to copy a handfull of table spaces in to new
identical table spaces so that they can be accessed with out running
into the nightly batch update. I first did a FULLCOPY with SHARELEVEL
REFERENCE of the table space. Then I copied the DDL used to create the
original object and changed the table space name, table name, index
names and made sure that the priqty/secqty were adequate to hold the
data. I then created the objects successfully in the same database as
they were originally located. Using DSN1COPY I loaded the full copy
into the newly created objects with parms at CHECK, FULLCOPY, OBIDXLAT,
RESET. The page count loaded matches the page count from the COPY. Here
is where the fun begins. I am attempting to rebuild the index's but
the job fails with:

REBULDIX DSNUPROC PH01S18 - ABEND=S04E U0000 REASON=00E40347

There is another reason code before the 00E40347. It is :

UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00C9007E'

Here are the messages from DB2:

STC04394 DSNI014I - DSNIRFNX DATA IN USE DURING ABEND 643

REASON 00C90101

ERQUAL 5016

TYPE 00000302

NAME PHJ5CSG .PCSHYY .X'00000012'

CONNECTION-ID=UTILITY

CORRELATION-ID=REBULDIX

LUW-ID=*

STC04394 DSN3201I - ABNORMAL EOT IN PROGRESS FOR USER=ISARHJ 680

CONNECTION-ID=UTILITY CORRELATION-ID=REBULDIX
JOBNAME=REBULDIX
TCB=00AAFA80

STC04394 DSN3201I - ABNORMAL EOT IN PROGRESS FOR USER=ISARHJ 681

CONNECTION-ID=UTILITY CORRELATION-ID=REBULDIX
JOBNAME=REBULDIX
TCB=00AE40E8

STC04394 DSN3201I - ABNORMAL EOT IN PROGRESS FOR USER=ISARHJ 682

CONNECTION-ID=UTILITY CORRELATION-ID=REBULDIX
JOBNAME=REBULDIX
TCB=00AAFD90

STC04394 DSN3201I - ABNORMAL EOT IN PROGRESS FOR USER=ISARHJ 683

CONNECTION-ID=UTILITY CORRELATION-ID=REBULDIX
JOBNAME=REBULDIX.

Message code 00C9007E states that The compression dictionary for the
table space or partition was not successfully retrieved. Therefore, the
data request failed.

The 00C90101 says that the data manager detected an internal error
within DB2. The error may indicate inconsistent data or an error in
internal DB2 control structures or code.

I have verified my OBID translation. I have run a checks on the indexes
and data.

Does anybody have any ideas what it is that I am doing wrong? Is there
a better way to copy the data?

Guess is should mention that we are Z/OS 1.3, DB2 v 6.1.

Nov 12 '05 #1
1 8989
Anybody?? Ferris?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Stefan Bauer | last post: by
15 posts views Thread by Ken Allen | last post: by
9 posts views Thread by Eric Wallstedt | last post: by
10 posts views Thread by wackyphill | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.