ERROR REASON=X'00E40347' - ONLINE REORG

Syed (TATA) Fazal

ERROR REASON=X'00E40347' - ONLINE REORG
Hi All,

Does anyone know what is the cause of the error code I am getting while
executing the Online Reorg. We just migrated to V7.

----------------------------------------------------------------------------
----------------------------------------------------------------------------
------------------------------------------
-DSNU017I DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED,
REASON=X'00C4'
DSNU394I +DBT1 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=105
FOR INDEX DBADRG1W.REORG_REORG001_IX
-DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'00E4034
----------------------------------------------------------------------------
----------------------------------------------------------------------------
------------------------------------------

Thanks,
Syed



Alan Gredell

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Syed (TATA) Fazal)
On Mon, 9 Jun 2003 15:11:16 -0400, Fazal, Syed (TATA)
<[login to unmask email]> wrote:

>Hi All,
>
>Does anyone know what is the cause of the error code I am getting while
>executing the Online Reorg. We just migrated to V7.
>
>--------------------------------------------------------------------------
--
>--------------------------------------------------------------------------
--
>------------------------------------------
>-DSNU017I DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION
ABENDED,
>REASON=X'00C4'
> DSNU394I +DBT1 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=105
>FOR INDEX DBADRG1W.REORG_REORG001_IX
>-DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
>REASON=X'00E4034
>--------------------------------------------------------------------------
--
>--------------------------------------------------------------------------
--
>------------------------------------------
>
>Thanks,
>Syed
>
>
>
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can

The explanation for this error:

"Explanation: This utility's main task is abending because one of its
subtasks terminated abnormally. The subtask itself issues an abend before
this one is issued.

System Action: Any error message generated by the subtask in conjunction
with the abend is directed to the device and data set identified by the
SYSPRINT DD statement in the utility job step."

There is more, but you'll need to look further in your output for other
problems.



michael bell

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Alan Gredell)
DB2 error codes are 8 characters so you are missing the last character of
the 00e4034* something code. There should be a systems dump for the DBM1
address space to identify the actual module that abended. The E40347 just
means that a subtask failed so DB2 is abending the utility.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Alan Gredell
Sent: Monday, June 09, 2003 3:59 PM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


On Mon, 9 Jun 2003 15:11:16 -0400, Fazal, Syed (TATA)
<[login to unmask email]> wrote:

>Hi All,
>
>Does anyone know what is the cause of the error code I am getting while
>executing the Online Reorg. We just migrated to V7.
>
>--------------------------------------------------------------------------
--
>--------------------------------------------------------------------------
--
>------------------------------------------
>-DSNU017I DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION
ABENDED,
>REASON=X'00C4'
> DSNU394I +DBT1 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=105
>FOR INDEX DBADRG1W.REORG_REORG001_IX
>-DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
>REASON=X'00E4034
>--------------------------------------------------------------------------
--
>--------------------------------------------------------------------------
--
>------------------------------------------
>
>Thanks,
>Syed
>
>
>
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can

The explanation for this error:

"Explanation: This utility's main task is abending because one of its
subtasks terminated abnormally. The subtask itself issues an abend before
this one is issued.

System Action: Any error message generated by the subtask in conjunction
with the abend is directed to the device and data set identified by the
SYSPRINT DD statement in the utility job step."

There is more, but you'll need to look further in your output for other
problems.








Syed (TATA) Fazal

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to michael bell)
Hi Mike,

Yes we did find the system dump and applied a maintenance patch. But it
seems the patch we applied is not the right one. The fact is that the Online
Reorg was working fine before it hit this bump. Now the Online Reorg is
failing with the same error messages in test and production environment. I
was thinking if anyone in the listserv has faced a situation like this and
know of any appropriate patch.

Thanks,
Syed


-----Original Message-----
From: michael bell [mailto:[login to unmask email]
Sent: Tuesday, June 10, 2003 4:27 PM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


DB2 error codes are 8 characters so you are missing the last character of
the 00e4034* something code. There should be a systems dump for the DBM1
address space to identify the actual module that abended. The E40347 just
means that a subtask failed so DB2 is abending the utility.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Alan Gredell
Sent: Monday, June 09, 2003 3:59 PM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


On Mon, 9 Jun 2003 15:11:16 -0400, Fazal, Syed (TATA)
<[login to unmask email]> wrote:

>Hi All,
>
>Does anyone know what is the cause of the error code I am getting while
>executing the Online Reorg. We just migrated to V7.
>
>--------------------------------------------------------------------------
--
>--------------------------------------------------------------------------
--
>------------------------------------------
>-DSNU017I DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION
ABENDED,
>REASON=X'00C4'
> DSNU394I +DBT1 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=105
>FOR INDEX DBADRG1W.REORG_REORG001_IX
>-DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
>REASON=X'00E4034
>--------------------------------------------------------------------------
--
>--------------------------------------------------------------------------
--
>------------------------------------------
>
>Thanks,
>Syed
>
>
>
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can

The explanation for this error:

"Explanation: This utility's main task is abending because one of its
subtasks terminated abnormally. The subtask itself issues an abend before
this one is issued.

System Action: Any error message generated by the subtask in conjunction
with the abend is directed to the device and data set identified by the
SYSPRINT DD statement in the utility job step."

There is more, but you'll need to look further in your output for other
problems.













Leslie Pendlebury-Bowe

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Syed (TATA) Fazal)
have you searched the archive?

I am sure we had this at Sony a couple yearsback and I think I posted to the
list about it.

.... but a lot of water has gone under the bridge since then.

Leslie

-----Original Message-----
From: Fazal, Syed (TATA)
[mailto:[login to unmask email]
Sent: Wednesday, June 11, 2003 1:05 PM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


Hi Mike,

Yes we did find the system dump and applied a maintenance patch. But it
seems the patch we applied is not the right one. The fact is that the Online
Reorg was working fine before it hit this bump. Now the Online Reorg is
failing with the same error messages in test and production environment. I
was thinking if anyone in the listserv has faced a situation like this and
know of any appropriate patch.

Thanks,
Syed


-----Original Message-----
From: michael bell [mailto:[login to unmask email]
Sent: Tuesday, June 10, 2003 4:27 PM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


DB2 error codes are 8 characters so you are missing the last character of
the 00e4034* something code. There should be a systems dump for the DBM1
address space to identify the actual module that abended. The E40347 just
means that a subtask failed so DB2 is abending the utility.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Alan Gredell
Sent: Monday, June 09, 2003 3:59 PM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


On Mon, 9 Jun 2003 15:11:16 -0400, Fazal, Syed (TATA)
<[login to unmask email]> wrote:

>Hi All,
>
>Does anyone know what is the cause of the error code I am getting while
>executing the Online Reorg. We just migrated to V7.
>
>--------------------------------------------------------------------------
--
>--------------------------------------------------------------------------
--
>------------------------------------------
>-DSNU017I DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION
ABENDED,
>REASON=X'00C4'
> DSNU394I +DBT1 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=105
>FOR INDEX DBADRG1W.REORG_REORG001_IX
>-DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
>REASON=X'00E4034
>--------------------------------------------------------------------------
--
>--------------------------------------------------------------------------
--
>------------------------------------------
>
>Thanks,
>Syed
>
>
>
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can

The explanation for this error:

"Explanation: This utility's main task is abending because one of its
subtasks terminated abnormally. The subtask itself issues an abend before
this one is issued.

System Action: Any error message generated by the subtask in conjunction
with the abend is directed to the device and data set identified by the
SYSPRINT DD statement in the utility job step."

There is more, but you'll need to look further in your output for other
problems.

















***********************************************************************************************
The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only.

This email and any response may be monitored by Sony United Kingdom Limited.
(6)
***********************************************************************************************



Michael Ebert

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Leslie Pendlebury-Bowe)
I got this (rather unspecific) error a while ago in V6. OLR had a lot of
problems with undefined or empty indexes, when it was run on multi-table
tablespaces. The problem started after application of maintenance, so it
is a recently-introduced bug. Make sure you've applied all available PTFs
for OLR.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany



have you searched the archive?

I am sure we had this at Sony a couple yearsback and I think I posted to
the
list about it.

.... but a lot of water has gone under the bridge since then.

Leslie

-----Original Message-----
From: Fazal, Syed (TATA)
[mailto:[login to unmask email]
Sent: Wednesday, June 11, 2003 1:05 PM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


Hi Mike,

Yes we did find the system dump and applied a maintenance patch. But it
seems the patch we applied is not the right one. The fact is that the
Online
Reorg was working fine before it hit this bump. Now the Online Reorg is
failing with the same error messages in test and production environment. I
was thinking if anyone in the listserv has faced a situation like this and
know of any appropriate patch.

Thanks,
Syed

Steve Lamb

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Michael Ebert)
We've had REORG problems in the past where the JCL specifies REGION=0M with
default SYNCSORT parms and a partitioning index is involved. Multiple sort
subtasks get started and these were running out of memory. We put some SORT
parms in to reduce the amount of memory being allocated (and reduce the
number of concurrent tasks) and this cured the problem.

Regards,

Steve



Lynne Flatley

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Steve Lamb)
What were the sort parms? We had a similar problem...

Lynne Flatley

-----Original Message-----
From: Steve Lamb [mailto:[login to unmask email]
Sent: Monday, June 16, 2003 7:20 AM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


We've had REORG problems in the past where the JCL specifies REGION=0M with
default SYNCSORT parms and a partitioning index is involved. Multiple sort
subtasks get started and these were running out of memory. We put some SORT
parms in to reduce the amount of memory being allocated (and reduce the
number of concurrent tasks) and this cured the problem.

Regards,

Steve



Syed (TATA) Fazal

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Lynne Flatley)
Steve,

Can you please share the sort parm. I would try and change the jcl and
rerun the job. The Online reorg was working fine during the testing but in
production it blew up initially with a condition code of 8 and after that
when I reran the job I keep getting X'00E40347' in production. I got the
same error when I ran the job in test. So we were thinking that its a
problem that needs to be fixed by IBM since this happened after we migrated
from V6 to V7.

Thanks,
Syed


-----Original Message-----
From: Steve Lamb [mailto:[login to unmask email]
Sent: Monday, June 16, 2003 7:20 AM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


We've had REORG problems in the past where the JCL specifies REGION=0M with
default SYNCSORT parms and a partitioning index is involved. Multiple sort
subtasks get started and these were running out of memory. We put some SORT
parms in to reduce the amount of memory being allocated (and reduce the
number of concurrent tasks) and this cured the problem.

Regards,

Steve








Jeremiah Eden

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Syed (TATA) Fazal)
What's is your version of DB2 and what RSU level are you at? There are PTFs
that addressed this issue by reducing the amount of subtasks that were used
for processing. Also there was additional information that came out at the
same time relating to Syncsort.

-----Original Message-----
From: Steve Lamb [mailto:[login to unmask email]
Sent: Monday, June 16, 2003 6:20 AM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


We've had REORG problems in the past where the JCL specifies REGION=0M with
default SYNCSORT parms and a partitioning index is involved. Multiple sort
subtasks get started and these were running out of memory. We put some SORT
parms in to reduce the amount of memory being allocated (and reduce the
number of concurrent tasks) and this cured the problem.

Regards,

Steve








Jeremiah Eden

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Jeremiah Eden)
I just found what I did several years ago to resolve this.

1) I applied V6 APAR PQ48300 (V7 version is PQ48507) which limits the
amount of subtasks used.

2) Started using syncsort parms specified in II12069. See Problem summary
section titled

"PROBLEM SUMMARY:Poor Sorting Performance in DB2V6/R610"

Their parm suggestion is below. They also had other suggestions which you
should read.

MINCORE=300K,VSCORE=400K,VSCORET=6M,CORE=MAX,DSM=OFF

3) In addition we put on Syncsort Apars SY53900 and SY53810.


-----Original Message-----
From: Steve Lamb [mailto:[login to unmask email]
Sent: Monday, June 16, 2003 6:20 AM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


We've had REORG problems in the past where the JCL specifies REGION=0M with
default SYNCSORT parms and a partitioning index is involved. Multiple sort
subtasks get started and these were running out of memory. We put some SORT
parms in to reduce the amount of memory being allocated (and reduce the
number of concurrent tasks) and this cured the problem.

Regards,

Steve



Steve Lamb

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Jeremiah Eden)
Our parms are pretty similar to Jeremiah's -

VSCORE=500K,MINCORE=400K,VSCORET=2M

I'm not in the office at the moment, so I can't check what the (biggish)
difference in the VSCORET parm means. HTH.

Steve



Steve Lamb

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Steve Lamb)
Oops - I forgot. We had the problems on both DB2 v6 and v7.



Syed (TATA) Fazal

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Steve Lamb)
We had already applied the apar for syncsort and the PQ48507 for V7 but
still the job is failing with same return code. Is there a way to know where
to specify the parm VSCORE=500K,MINCORE=400K,VSCORET=2M

Thanks,
Syed

-----Original Message-----
From: Steve Lamb [mailto:[login to unmask email]
Sent: Tuesday, June 17, 2003 10:05 AM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


Our parms are pretty similar to Jeremiah's -

VSCORE=500K,MINCORE=400K,VSCORET=2M

I'm not in the office at the moment, so I can't check what the (biggish)
difference in the VSCORET parm means. HTH.

Steve








Steve Lamb

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Syed (TATA) Fazal)
Syed,

Use a £ORTPARM DD statement (£ = pound sign)
e.g. for inline in the JCL
//£ORTPARM DD *
BMSG
VSCORE=500K,MINCORE=400K,VSCORET=6M
/*

Or you can stick it it a dataset if you're calling the JCL in a procedure.

Regards,

Steve



michael bell

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Steve Lamb)
from memory - it should be a ddname like //$ortparm dd something dsn or *
if you put it inline. Check your manual.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Fazal, Syed (TATA)
Sent: Tuesday, June 17, 2003 9:41 AM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG
Importance: High


We had already applied the apar for syncsort and the PQ48507 for V7 but
still the job is failing with same return code. Is there a way to know where
to specify the parm VSCORE=500K,MINCORE=400K,VSCORET=2M

Thanks,
Syed

-----Original Message-----
From: Steve Lamb [mailto:[login to unmask email]
Sent: Tuesday, June 17, 2003 10:05 AM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


Our parms are pretty similar to Jeremiah's -

VSCORE=500K,MINCORE=400K,VSCORET=2M

I'm not in the office at the moment, so I can't check what the (biggish)
difference in the VSCORET parm means. HTH.

Steve













Philip Sevetson

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to michael bell)
::grin:: Interesting. Here on this side of The Pond, we use //$ORTPARM
DD * (a dollar sign). Wonder how the currency symbol fits in there?
Other than as geek humor, I mean.

--Phil Sevetson
[login to unmask email]
Database Administration
Wakefern Food Corporation





Steve Lamb <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
06/17/2003 11:05 AM
Please respond to DB2 Data Base Discussion List


To: [login to unmask email]
cc:
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


Syed,

Use a £ORTPARM DD statement (£ = pound sign)
e.g. for inline in the JCL
//£ORTPARM DD *
BMSG
VSCORE=500K,MINCORE=400K,VSCORET=6M
/*

Or you can stick it it a dataset if you're calling the JCL in a procedure.

Regards,

Steve


http://listserv.ylassoc.com. The owners of the list can be reached at
[login to unmask email]



Steve Lamb

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Philip Sevetson)
On Tue, 17 Jun 2003 11:44:42 -0400, Phil Sevetson
<[login to unmask email]> wrote:

>::grin:: Interesting. Here on this side of The Pond, we use //$ORTPARM
>DD * (a dollar sign). Wonder how the currency symbol fits in there?
>Other than as geek humor, I mean.
>
>--Phil Sevetson
>[login to unmask email]
>Database Administration
>Wakefern Food Corporation
>
>
>
>
>
>Steve Lamb <[login to unmask email]>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>06/17/2003 11:05 AM
>Please respond to DB2 Data Base Discussion List
>
>
> To: [login to unmask email]
> cc:
> Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG
>
>
>Syed,
>
>Use a £ORTPARM DD statement (£ = pound sign)
>e.g. for inline in the JCL
>//£ORTPARM DD *
>BMSG
>VSCORE=500K,MINCORE=400K,VSCORET=6M
>/*
>
>Or you can stick it it a dataset if you're calling the JCL in a procedure.
>
>Regards,
>
>Steve
>
>
>
http://listserv.ylassoc.com. The owners of the list can be reached at
>[login to unmask email]
>
>
>
>

Perhaps it needs changing to the Euro symbol, given that it's going up
against the dollar?



Syed (TATA) Fazal

Re: ERROR REASON=X'00E40347' - ONLINE REORG
(in response to Steve Lamb)
Thanks everyone for the help. The $ORTPARM worked fine with the OLR job.
Also I have opened a ticket with SYNCSORT about the error I am getting.


-----Original Message-----
From: Steve Lamb [mailto:[login to unmask email]
Sent: Wednesday, June 18, 2003 3:40 AM
To: [login to unmask email]
Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG


On Tue, 17 Jun 2003 11:44:42 -0400, Phil Sevetson
<[login to unmask email]> wrote:

>::grin:: Interesting. Here on this side of The Pond, we use //$ORTPARM
>DD * (a dollar sign). Wonder how the currency symbol fits in there?
>Other than as geek humor, I mean.
>
>--Phil Sevetson
>[login to unmask email]
>Database Administration
>Wakefern Food Corporation
>
>
>
>
>
>Steve Lamb <[login to unmask email]>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>06/17/2003 11:05 AM
>Please respond to DB2 Data Base Discussion List
>
>
> To: [login to unmask email]
> cc:
> Subject: Re: ERROR REASON=X'00E40347' - ONLINE REORG
>
>
>Syed,
>
>Use a £ORTPARM DD statement (£ = pound sign)
>e.g. for inline in the JCL
>//£ORTPARM DD *
>BMSG
>VSCORE=500K,MINCORE=400K,VSCORET=6M
>/*
>
>Or you can stick it it a dataset if you're calling the JCL in a procedure.
>
>Regards,
>
>Steve
>
>
>
http://listserv.ylassoc.com. The owners of the list can be reached at
>[login to unmask email]
>
>
>
>

Perhaps it needs changing to the Euro symbol, given that it's going up
against the dollar?



http://listserv.ylassoc.com. The owners of the list can be reached at
[login to unmask email]