View previous topic :: View next topic
|
Author |
Message |
Daniel Prosser
New User
Joined: 05 Nov 2010 Posts: 57 Location: Amsterdam
|
|
|
|
Dear IBMMAINFRAMERs,
I have a problem with a reorg. This is failing in one of our test regions (yet works fine in PRD and has been working without error for a year or more)
It's failing with:
Code: |
SYSTEM COMPLETION CODE=04E REASON CODE=00E4D5D2
TIME=11.09.41 SEQ=02193 CPU=0080 ASID=02F0
PSW AT TIME OF ERROR 077C1001 BFCD2B7A ILC 2 INTC 0D
NO ACTIVE MODULE FOUND - PRIMARY NOT EQUAL TO HOME
NAME=UNKNOWN
DATA AT PSW 3FCD2B74 - 00181610 0A0DE320 D7E00004
AR/GR 0: BE09D57A/00000000_80000000 1: 00000000/00000000_8004E000
2: 00000000/00000000_00000000 3: 00000000/00000220_00000000
4: 00000000/00000220_00000001 5: 00000000/00000000_4007B434
6: 00000000/00000000_3EC751D0 7: 00010003/00000000_69F41F48
8: 00000000/00000000_6B73DF40 9: 00000000/00000220_A3958014
A: 00000000/00000000_3FCE210F B: 00000000/00000000_3FCE1110
C: 00000000/00000000_73CE5D1F D: 00000000/00000000_73CE4D20
E: 00000000/00000000_3FCD2B62 F: 00000000/00000000_00E4D5D2 |
The REORG stmt is:
Code: |
REORG TABLESPACE DATABASE.TABLESPACE COPYDDN(TEMPL) SHRLEVEL CHANGE KEEPDICTIONARY LOG NO SORTDEVT SYSDA STATISTICS INDEX(ALL KEYCARD) MAPPINGTABLE OWNER.TABLE MAXRO 300 DRAIN ALL LONGLOG DRAIN DELAY 1200 TIMEOUT ABEND |
Does anyone have any idea? I'm thinking maybe the test region's indexes were corrupt.
Dan. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Googling seems to get some useful results. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
Back to top |
|
|
Daniel Prosser
New User
Joined: 05 Nov 2010 Posts: 57 Location: Amsterdam
|
|
|
|
I did google, didn't find a solution. Maybe I am blind. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
:-) Maybe. Can you see this line clearly?
CODE=00E4D5D2
I just put that in the google box and off it hopped... |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
There is no solution on the internets for this reason code.
Like Akatsukami suggested : contact your DBA. |
|
Back to top |
|
|
Daniel Prosser
New User
Joined: 05 Nov 2010 Posts: 57 Location: Amsterdam
|
|
|
|
@Bill - well yes I can see THAT
as PeterHolland suggested there is no solution in the WWW.
In fact if I google CODE=00E4D5D2 the first link is my own question
I've contacted the DBAs as people have suggested.
Thanks. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Well, being an employee of ABNAMRO and IT being outsourced to IBM your DBA is in fact IBM. |
|
Back to top |
|
|
|