IBM Mainframe Forum

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

Hello,

DSNIDBET RESOURCE UNAVAILABLE

You need to resolve why the resource was not available.

Suggest you work with your dba.

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'

Hello,

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

Is it possible that some database dataset has been migrated?

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,

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.

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.

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".

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.

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. . .