On May 26, 11:30=A0am, wombarrap...@[EMAIL PROTECTED]
wrote:
> On May 26, 4:23 pm, wombarrap...@[EMAIL PROTECTED]
wrote:
>
>
>
>
>
> > Hi all - running on an old version of ASE - Adaptive Server
Enterprise/
> > 11.5.1.1 SWR 9085 ESD 7
> > our overnight DBCC has advised a 2580 error - see below:
>
> > The clustered index page (Page pointer =3D 0x931f7000, pageno =3D
282885=
7,
> > status =3D 0x80, objectid =3D 579689313, indexid =3D 1, level =3D 0)
has=
an
> > unexpected key pointer to an overflow data page (Page pointer =3D
> > 0x62056800, pageno =3D 21516775, status =3D 0x105, objectid =3D
57968931=
3,
> > indexid =3D 0, level =3D 0). =A0Please check page status.
>
> > We have a very tight batch schedule which normally would leave no time
> > for this to be fixed midweek .. wondering if this is ok to leave until
> > the weekend or are we leaving ourselves open to data corruption if we
> > don't fix immediately ?
>
> > Also ... have run a indexalloc with the fix option and am now testing
> > with a checktable to see if the error is repeated ... is this the
> > correct approach to take for the fix ?
>
> > All help appreciated in advance
> > pete
>
> Update: .. the indexalloc has not fixed the problem ... trying
> tablealloc now ...- Hide quoted text -
>
> - Show quoted text -
do you you have non-unique clustered index on the table ?. Nonunique
clustered indexes would normally have overflow pages. If you table is
not big then drop and recreate the index on this table if possible.
And upgrade ASE version as soon as possible :-)
-HTH
Manish Negandhi
[TeamSybase]
|
