Re: Fw: SQL error - damaged index maybe??

Midrange-L list has general 400 SQL etc. expertise to identify damaged objects.
BPCS-L list has expertise to help repair BPCS.

Once you past the crash repair, I have idea(s) to share regarding avoiding risk of such a crash occurring in first place, and again.

For one thing, before the 400 actually ran out of disk space, there would have been critical alert warnings in SYSMSGQ. This can be monitored to send e-mail alerts to various tech support places, and key employees, so when your operation is at the edge of a precipice, you don't have to dive over. Your tech support places would be calling your IT staff and management with what to do to avoid going over the precipice.

That's one simple safety that can protect a company from a vast spectrum of possible difficulties. Later I may mention some others, although perhaps this topic belongs in a different subject thread.

(should have posted this to the BPCS List maybe!)

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

--
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: macwheel99@xxxxxxxxxxx