RE: In the brown sticky stuff:-))
That wasn't an option. Renamed the table, created a new one, that
got us up and running, now I just have to fix the old table and put the
rows back.
Paul Watson
WF Software Ltd
Tel: +44 1436 674729
Fax: +44 1436 678693
www.wfsoftware.com/informix
> -----Original Message-----
> From: Mark D. Stock [mailto:mdstock@mydas.freeserve.co.uk]
> Sent: Wednesday, October 11, 2000 11:39
> To: Paul Watson
> Cc: informix-list@iiug.org
> Subject: Re: In the brown sticky stuff:-))
>
>
> Paul Watson wrote:
> >
> > I've got table I can't read right through, the oncheck -cDI reports
> >
> >
> > WARNING: index check requires a s-lock on tables whose lock level is
> > page.
> >
> > Validating indexes for
> > drug:viagra.order...
> >
> > WARNING: index check requires a s-lock on tables whose lock level is
> > page.
> >
> > TBLspace data check for
> > drug:viagra.order
> >
> > ERROR:Version 1 on page 72 (0x700947) is out of
> > range
> > <SNIP>
> > ITS is shut, so the question is there anything I can do or
> do I have to
> > wait,
> > I can't unload the table 'cos of the above
>
> Have you tried running oncheck in Quiescent mode?
>
> Cheers,
> --
> Mark.
>
> +----------------------------------------------------------+--
> ---------+
> | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk
> |//////// /|
> | http://www.informix.com http://www.informixhandbook.com
> |///// / //|
> | http://www.iiug.org
> +-----------------------------------+//// / ///|
> | |This email will self-destruct in
> |/// / ////|
> | |10 sec. If you received this email
> |// / /////|
> | |in error, sorry about the mess. |/
> ////////|
> +----------------------+-----------------------------------+--
> ---------+
>
I am glad you got "up and running" on the viagra table.
"Watson, Paul" wrote:
>
> That wasn't an option. Renamed the table, created a new one, that
> got us up and running, now I just have to fix the old table and put the
> rows back.
>
> Paul Watson
> WF Software Ltd
> Tel: +44 1436 674729
> Fax: +44 1436 678693
> www.wfsoftware.com/informix
>
> > -----Original Message-----
> > From: Mark D. Stock [mailto:mdstock@mydas.freeserve.co.uk]
> > Sent: Wednesday, October 11, 2000 11:39
> > To: Paul Watson
> > Cc: informix-list@iiug.org
> > Subject: Re: In the brown sticky stuff:-))
> >
> >
> > Paul Watson wrote:
> > >
> > > I've got table I can't read right through, the oncheck -cDI reports
> > >
> > >
> > > WARNING: index check requires a s-lock on tables whose lock level is
> > > page.
> > >
> > > Validating indexes for
> > > drug:viagra.order...
> > >
> > > WARNING: index check requires a s-lock on tables whose lock level is
> > > page.
> > >
> > > TBLspace data check for
> > > drug:viagra.order
> > >
> > > ERROR:Version 1 on page 72 (0x700947) is out of
> > > range
> > > <SNIP>
> > > ITS is shut, so the question is there anything I can do or
> > do I have to
> > > wait,
> > > I can't unload the table 'cos of the above
> >
> > Have you tried running oncheck in Quiescent mode?
> >
> > Cheers,
> > --
> > Mark.
> >
> > +----------------------------------------------------------+--
> > ---------+
> > | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk
> > |//////// /|
> > | http://www.informix.com http://www.informixhandbook.com
> > |///// / //|
> > | http://www.iiug.org
> > +-----------------------------------+//// / ///|
> > | |This email will self-destruct in
> > |/// / ////|
> > | |10 sec. If you received this email
> > |// / /////|
> > | |in error, sorry about the mess. |/
> > ////////|
> > +----------------------+-----------------------------------+--
> > ---------+
> >