LOAD Utility fails: UNABLE TO RESTART BUILD PHASE

Georg Peter

LOAD Utility fails: UNABLE TO RESTART BUILD PHASE
Environment is DB2 z/OS V8 CM
--------------------------------------------



Collegues,



a LOAD Utility from one of our programmers fails:


myuser INDDEW DSNUPROC LOAD - ABEND=S04E U0000 REASON=00E40310

myuser 1 DSNUPROC DSNUTILB ------------ S04E.

UNABLE TO RESTART BUILD PHASE



Question 1: Any good idea why the LOAD crashes ?



And as a result of this action two indexes went into REBUILD INDEX
state. When I tried to rebuild them the job fails

ERROR LOADING INDEX - DUPLICATE KEY



Question 2: What causes these DUPLICATE KEY's ?


Any info that anybody can provide on the above would be greatly
appreciated.

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
< http://www.dzbw.de/ >
----------------------------------------------------------------------
P Think before you print.


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Balachandran Chandrasekaran1

Re: LOAD Utility fails: UNABLE TO RESTART BUILD PHASE
(in response to Georg Peter)
Could you please paste the LOAD statements from the SYSIN ?





"Peter, Georg" <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>
22/01/2010 19:55
Please respond to
IDUG DB2-L <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] LOAD Utility fails: UNABLE TO RESTART BUILD PHASE






Environment is DB2 z/OS V8 CM
--------------------------------------------

Collegues,

a LOAD Utility from one of our programmers fails:

myuser INDDEW DSNUPROC LOAD - ABEND=S04E U0000 REASON=00E40310
myuser 1 DSNUPROC DSNUTILB ------------ S04E.
UNABLE TO RESTART BUILD PHASE

Question 1: Any good idea why the LOAD crashes ?

And as a result of this action two indexes went into REBUILD INDEX state.
When I tried to rebuild them the job fails

ERROR LOADING INDEX – DUPLICATE KEY

Question 2: What causes these DUPLICATE KEY’s ?

Any info that anybody can provide on the above would be greatly
appreciated.

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------
P Think before you print.




The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.

Walter Jani&#223;en

AW: LOAD Utility fails: UNABLE TO RESTART BUILD PHASE
(in response to Balachandran Chandrasekaran1)
Hello Georg

A failure in a Load-jobs happens in our test-environment all the time. Reasons are:

- output-limit exceeded
- time-limit exceeded

When this happens in the index-evaluation phase or in the discard phase the tablespace is in RECP and the indexes are in RBDP.

I wonder, what the status of your tablespace is?

The reasoncode, you see, is caused, because DB2 is unable to restart the build phase. And you cannot rebuild the index, because duplicates exist from the the first abended load.

Is my explanation too simple?

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40477 Düsseldorf
mailto:[login to unmask email]

Vorsitzender des Aufsichtsrates: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996


________________________________
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Peter, Georg
Gesendet: Freitag, 22. Januar 2010 15:25
An: [login to unmask email]
Betreff: [DB2-L] LOAD Utility fails: UNABLE TO RESTART BUILD PHASE
Wichtigkeit: Hoch

Environment is DB2 z/OS V8 CM
--------------------------------------------

Collegues,

a LOAD Utility from one of our programmers fails:

myuser INDDEW DSNUPROC LOAD - ABEND=S04E U0000 REASON=00E40310
myuser 1 DSNUPROC DSNUTILB ------------ S04E.
UNABLE TO RESTART BUILD PHASE

Question 1: Any good idea why the LOAD crashes ?

And as a result of this action two indexes went into REBUILD INDEX state. When I tried to rebuild them the job fails

ERROR LOADING INDEX - DUPLICATE KEY

Question 2: What causes these DUPLICATE KEY's ?

Any info that anybody can provide on the above would be greatly appreciated.

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de < http://www.dzbw.de/ >
----------------------------------------------------------------------
P Think before you print.


________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L