Betr: [DB2-L] AW: [DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8 NFM

Marcel Harleman

Betr: [DB2-L] AW: [DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8 NFM



Hmm,

I jumped a little quick to a conclusion: I'm afraid the output of the your
REORG print was truncated. The statement you are using is SORTDEVT SYSDA
(sounds valid). DEA2DPR1.MTCDMKTGRP is your mapping table. Sorry for the
disturbance.

Marcel.

-----------------------------------------------------------------------
Marcel,

I'll check the parm immediately, thanks!

Thanks.

Aurora Aurora Emanuela Dell'Anno
CA
Sr. Engineering Services Architect

Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
[login to unmask email]

http://www.ca.com/

please don't print this e-mail unless you really need to!

________________________________

Von: IDUG DB2-L im Auftrag von Marcel Harleman
Gesendet: Mi 11/05/2011 10:01
An: [login to unmask email]
Betreff: [DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8
NFM



SORTDEVT=DEA2DPR1.MTCDMKTGRP? I doubt if that is a valid sort device type,
so I think the allocation of your sort wirkfiles is failing.

Marcel

----------------------------------------------------------------------------------------------------------------


I get this recurring annoying abend when I run a reorg as follows (at a
customer's site):

REORG TABLESPACE SCHEMANAME.TSNAME LOG NO DRAIN_WAIT 10 RETRY 3
RETRY_DELAY 300 SHRLEVEL CHANGE FASTSWITCH YES KEEPDICTIONARY COPYDDN
(C0001) RECOVERYDDN(R0001) SORTDEVT SYSDA MAPPINGTABLE SCHEMANAME.TBNAME

DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = CDMKTGRP.REO

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC

DSNU050I DSNUGUTC - REORG TABLESPACE DEA2DPR1.CDMKTGRP LOG NO
DRAIN_WAIT 10
CHANGE FASTSWITCH YES KEEPDICTIONARY COPYDDN(C0001) RECOVERYDDN(R0001)
SORTDEVT
DEA2DPR1.MTCDMKTGRP

DSNU232I -D2P1 DSNURFIT - KEEPDICTIONARY REQUESTED BUT COMPRESS ATTRIBUTE
NOT
DEA2DPR1.CDMKTGRP

DSNU252I DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 F
DSNU250I DSNUGSRT - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00

DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'00E4031

This is the first online reorg I am trying in this PROD environment with
parallel processing - what oh what am I missing or getting wrong please?

Any suggestions gratefully appreciated.

TIA.

Aurora


------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.


________________________________


Introducing IBM® DB2® 10 for z/OS <
http://events.unisfair.com/index.jsp?eid=556&SEID=4595&CODE=idug>

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>


_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv


------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.


_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv


Marcel Harleman

Betr: [DB2-L] AW: [DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8 NFM
(in response to Marcel Harleman)



Aurora,

is PTF UK45619 applied to your system? And look at the local fix. That
might be a workaround for you in case the PTF has not been applied yet.

Marcel.

PK81384: 00E40311 DSNUGCMA+0124 REORGABEND04E FOLLOWING X37 B37 ON SYSCOPY
DATASET RC00E40311

APAR statusClosed as program error.
Error descriptionThe B37 abend is on a SYSCOPY data set in a Reorg. This
causes copy subtask to abend, which in turn causes the parent task to issue
the 00e40346 abend. The subtask issues a commit but a flag is on and the
commit fails which causes the 00E40311

Local fix: increase space for the SYSCOPY output dataset to avoid a B37

Problem
summary****************************************************************
* USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS REORG *
* utility users with zIIP processors. *
****************************************************************
* PROBLEM DESCRIPTION: ABEND04E RC00E40311 following *
* ABENDSB37 on SYSCOPY data set during *
* REORG TABLESPACE with zIIP processors *
* configured. *
****************************************************************
* RECOMMENDATION: Apply corrective PTF when available. *
****************************************************************
A REORG TABLESPACE with inline copy of a partitioned table space
run on a system with zIIP processors configured encountered an
ABENDB37 on the SYSCOPY data set. The ABENDB37 in the subtask
caused an ABEND04E RC00E40346 in the parent task, which is
normal. This was followed by an SVC dump for an ABEND04E
RC00E40311.

REORG TABLESPACE builds the partitioning index concurrently with
loading the data partitions. With zIIP, the index build is
offloaded to an SRB running on the zIIP processor.

Depending on the timing of the x37 abend, the parent task can
terminate while the SRB is attempting to commit. The
termination of the parent task causes the commit to fail, which
causes the SRB to issue the RC00E40311 abend.

Problem conclusionREORG TABLESPACE has been modified to suppress the dump
for the
ABEND04E RC00E40311 if a failure is encountered in the zIIP SRB
and the task has terminated.

Temporary fix
Comments
APAR InformationAPAR numberPK81384
Reported component nameDB2 OS/390 & Z/
Reported component ID5740XYR00
Reported release810
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Special AttentionYesSpecatt / CST
Submitted date2009-02-25
Closed date2009-04-08
Last modified date2009-05-11
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:UK45619 UK45620
Modules/MacrosDSNURBXA

Fix informationFixed component nameDB2 OS/390 & Z/
Fixed component ID5740XYR00
Applicable component levelsR810 PSY UK45619 UP09/04/24 P F904
R910 PSY UK45620 UP09/04/24 P F904


------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.


_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv