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

Aurora Dell'Anno

[DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8 NFM
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

Aurora Dell'Anno

AW: [DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8 NFM
(in response to Aurora Dell'Anno)
The SORTDEVT is actually SYSDA.

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

Aurora Dell'Anno

AW: [DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8 NFM
(in response to Aurora Dell'Anno)
in UTPRINT I don't have a lot of info just

DC 0 TC 0 CS DSVXX KSZ 26 VSZ 26
FSZ=367200 RE IGN=0 C AVG=45 45 WSP=21462 E DYN=0 0
B1-K19866 B2-K40562 EC-K10929 B4-K17569 DA-K28804
AN S04E ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT (PHASE S 3)

Marcel,

I'll look for that PTF now 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 Chris Tee
Gesendet: Mi 11/05/2011 10:12
An: [login to unmask email]
Betreff: Re: [DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8 NFM


I think the messages have been truncated, SORTDEVT is SYSDA, DEA2DPR1.MTCDMKTGRP is the mapping table.

Are there any messages in UTPRINT?



________________________________

Date: Wed, 11 May 2011 11:01:35 +0200
From: [login to unmask email]
Subject: [DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8 NFM
To: [login to unmask email]

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 >


________________________________


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

Max Scarpa

Re: AW: [DB2-L] Betr: [DB2-L] REORG abend S04E reason code 00E40311 DB2 V8 NFM
(in response to Aurora Dell'Anno)
Aurora

if you can look at z/OS syslog, is there any x37 abend or SMS space
emssage during reorg execution ? Db2 sometimes hide x37 space errors with
DB2 error codes.


_________________________________________________________________

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