472,805 Members | 863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

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 9291
Anybody?? Ferris?

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Stefan Bauer | last post by:
Hi NG, we've got a very urgent problem... :( We are importing data with the LOAD utility. The input DATE field data is in the format DDMMYYYY (for days) and MMYYYY (for months). The target...
15
by: Ken Allen | last post by:
I have been developing a suite of assemblies over the past couple of weeks, and this afternoon somethign started misbehaving. If I do not run the IDE and compiler the code from the command line,...
9
by: Eric Wallstedt | last post by:
I have a page that "logs" changes made to input fields using ajax to pass data to a cgi. I use POST and it works fine most of the time (all the time in IE). But it fails when I get the data from...
10
by: wackyphill | last post by:
After rebuilding an index, it still shows as the same amount of fragmentation. ANy ideas what's wrong? I'm determining which indexes to rebuild using the following query: SELECT...
0
by: John Smith | last post by:
ASP.Net 2.0 / C# / IIS 6 I have 2 pages. The master page consists of a tabbed menu created using the Menu and MultiView controls. Something like this: ...
0
by: Alex Brown | last post by:
Is it a problem to attach Non-static site map providers under one that inherits from StaticSiteMapProvider ? We are implementing a custom site map provider for a website that is being converted...
5
by: weidongtom | last post by:
Hi, I tried to implement the Universal Machine as described in http://www.boundvariable.org/task.shtml, and I managed to get one implemented (After looking at what other's have done.) But when I...
1
by: dsdevonsomer | last post by:
Hello all, I am new to managing indexes on large tables and need some help. Hopefully, I am not repeating question here. I searched as much as I can, but not finding relatively best answer.. ...
0
debasisdas
by: debasisdas | last post by:
This code genenates a script to rebuld all the indexes with height greater than 3 for all the users except for SYS user. The script needs to be executed from SYS schema. This can also be executed...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.