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

Marcel Harleman

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.


_________________________________________________________________

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


Chris Tee

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

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.





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

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