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.