REASON=X'00C4'



IBM's flagship relational database management system

REASON=X'00C4'

Postby arshadhrashid » Tue Apr 06, 2010 9:26 pm

Hello All,
I have a situation in my db2 9.1 z/os database.
Re Org of tablepace which is in Advisory Reorg state abends with the following error

UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00C4'

After this , the whole sub system crashed and requires a restart.
The started task for MSTR space shows the following errors

08.35.09 STC00137 DSNT501I ¢ DSNIDBET RESOURCE UNAVAILABLE 973
973 CORRELATION-ID=AR62199
973 CONNECTION-ID=TSO
973 LUW-ID=SCLARA.A01KDBLU.C5C88A71E3DE=107
973 REASON 00C90086
973 TYPE 00000100
973 NAME PTIDB001
08.38.25 STC00137 DSNI014I ¢ DSNIMOFR DATA IN USE DURING ABEND 988
988 REASON 00C90101
988 ERQUAL 5384
988 TYPE 00000302
988 NAME PTIDB001.PTITSRCE.X'00000002'
988 CONNECTION-ID=UTILITY
988 CORRELATION-ID=ARSREORG
988 LUW-ID=SCLARA.A01KDBLU.C5C88B2BD17F=0
08.38.25 STC00137 DSN3201I ¢ ABNORMAL EOT IN PROGRESS FOR USER=AR62199 989
989 CONNECTION-ID=UTILITY CORRELATION-ID=ARSREORG JOBNAME=ARSREOR

08.38.28 STC00137 *DSNV086E ¢ DB2 ABNORMAL TERMINATION REASON=00F30420

Any idea?

Thanks a lot
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: REASON=X'00C4'

Postby dick scherrer » Wed Apr 07, 2010 12:28 am

Hello,

DSNIDBET RESOURCE UNAVAILABLE
You need to resolve why the resource was not available.

Suggest you work with your dba.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: REASON=X'00C4'

Postby arshadhrashid » Wed Apr 07, 2010 1:25 am

unfortunately I am the dba.
The data is availble. The status of database in question and all the tablespaces is r/w.
but still any attempt to accees the tablespace REORG/CHECK/UNLOAD, abends with

UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00C4'
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: REASON=X'00C4'

Postby dick scherrer » Wed Apr 07, 2010 1:52 am

Hello,

Try running something in the "other" environment (if tso abends, try batch, etc).

Is it possible that some database dataset has been migrated?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: REASON=X'00C4'

Postby arshadhrashid » Wed Apr 07, 2010 8:42 pm

The only thing different here was I ran some add/update/delete DML statements to upgrade Platinum tools from Sp1 to Sp2.
They all worked fine as per the logs.
Thanks,
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: REASON=X'00C4'

Postby dick scherrer » Wed Apr 07, 2010 11:52 pm

Hello,

If the Platinum tool upgrade caused the problem, back out the upgrade and see if the problem persists or if it then works correctly.

Then open a trouble call with Platinum support and have all of the output from the upgrade available.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: REASON=X'00C4'

Postby arshadhrashid » Thu Apr 08, 2010 1:33 am

Thanks
This is an SMPE install and the problem occured after the full installation so it cannot be backed out.
I have contacted Platinum support but so far they are unable to help.
They suspect its IBM DB2's issue and IBM also so far (more than a week) cannot resolve this.
I was checking if someone out there may have some valuable suggestion.
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: REASON=X'00C4'

Postby Robert Sample » Thu Apr 08, 2010 1:56 am

This is an SMPE install and the problem occured after the full installation so it cannot be backed out.
Do you mean you've already done the ACCEPT? If not, then of course you can REJECT and APPLY again later! If you did the ACCEPT before completing testing, WHY???

I've been dealing with SMP/E for a number of years and have never seen the term "full installation" in any of its documentation -- not from IBM, not from CA, not from anywhere. I've seen RECEIVE, APPLY, APPLY CHECK, ACCEPT, REJECT, LIST, ... but never "full installation".
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: REASON=X'00C4'

Postby arshadhrashid » Thu Apr 08, 2010 3:13 am

The term full installation describes all the 3 steps of installation. Receive, Apply & Accept.
yes it has to be accepted before testing as after the Accept. Post install configuration kicks in
before you can even use the system. The post install runs DMLs which is where the corruption occured.
Thanks.
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: REASON=X'00C4'

Postby dick scherrer » Thu Apr 08, 2010 5:26 am

Hello,

Is there not a backup from just before the upgrade was installed? And hopefully, no other maintenance was applied after. . .

I'd suggest making sure there is follow up dialog with Platinum to get the process corrected. . . Seems completely wrong to force an accept before testing can be completed. . . :?

Possibly there is something i'm not aware of that makes this practice ok. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Next

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post