By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,513 Members | 1,640 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,513 IT Pros & Developers. It's quick & easy.

Problem with Rebuild Index after loading data with DSN1COPY

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
Anybody?? Ferris?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.