Re: SQL error - damaged index maybe??

Hi Al,

Thanks for that - I thought the reclaim storage fixed damaged objs, but now I see that you have to do a save first for the system to find them - is that the case?

thanks,

Clare

----- Original Message ----- From: "Al Mac" <macwheel99@xxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, April 12, 2007 4:11 PM
Subject: Re: SQL error - damaged index maybe??

A while back we had a different kind of crash (battery died in UPS & we did
not notice) ... have they done a 100% backup? If there are any damaged
objects, the backup will fail & you will get a log of which objects got
damaged. I'd have to drill down into our documentation, UPI had a quick
fix once the damaged file was identified. We went with an alternative to
IBM support that was more responsive, less expensive, and more flexible in
payment options.

Of course you don't know for a fact that the problem is a damaged object in
the IBM sense. If any BPCS processing was conducted between the time that
the consultant deleted libs & restored them, the programs might have done
malfunctioning things to corrupt the BPCS data base.

If you have a backup from before the original crash, can there be a
comparison of what's on tape vs. what is now on disk? Ignore reoords dated
added since crash should show if any prior records got scrambled.

Hi all,

I have been asked to look at this problem - customer filled up their disk
and system crashed. Afterwards, consultant deleted a whole lot of libs, some
were in the BPCS library list!
He has restored the libs that were in the libl...but doesn't fix the error:
Since then, pick confirm and BIL501 both issue error msgs MCH3402 and
CPF4204, 'tried to refer to all or part of an object no longer there' and
'internal failure in query processor'. Msgs are coming from QQQIMPLE and
QQQQUERY (STARFC), also SQL0901 from QSQROUTE (CK_DEBUG) but no clue as to
which object is affected.
Tried RCLSTG and IPL, could try copyfile - but which file??
Anyone have any other ideas? Get it to recreate access paths maybe?

thanks,

Clare

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.