Fw: SQL error - damaged index maybe??

["Clare Holtham" <Clare.Holtham@xxxxxxxxxxxxxx>]

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