Error: 7411,求解决方案.

hiaw

00:00000:00001:2005/08/11 08:00:20.17 server  Error: 7411, Severity: 18, State: 1
00:00000:00001:2005/08/11 08:00:20.17 server  The 'Systhresholds' table in database 'DZGeneralDB' is not in its correct sort order. Its clustered index needs to be rebuilt using 'sp_fixindex'. Only the last chance threshold has been activated.
00:00000:00001:2005/08/11 08:00:20.17 server  Error: 7411, Severity: 18, State: 1
00:00000:00001:2005/08/11 08:00:20.17 server  The 'Systhresholds' table in database 'DZGeneralDB' is not in its correct sort order. Its clustered index needs to be rebuilt using 'sp_fixindex'. Only the last chance threshold has been activated.

sybase 12.5.2 windows2000AV 环境.

已经试过的解决办法:


dbcc indexalloc(Systhresholds,1,full,fix)

sp_fixindex DZGeneralDB,systhresholds,1

都没有修复成功.这个表是系统表.

将尝试的解决办法:

1.sp_configure 'allow update',1
之后, 删除再重建这个系统表的索引.

2.sp_configure 'allow update',1
go
update dbname..systhresholds set free_space=<一个非0值>; where status=1
go


3.BCP OUT，DBCC清空数据，然后再导入这个表.

也请,各位老大,讨论一下,出个解决方案. 再一起感谢大家.

chinage

Action :
Run dbcc checktable (systhresholds) and dbcc tablealloc (systhresholds) to check
consistency of the system table. If you find corruption in systhresholds, call
Sybase Technical Support for further instructions.

hiaw

问题已经解决:

方法如下:

sp_dropthreshold DZGeneralDB,"logsegment",5840

sp_addthreshold DZGeneralDB,"logsegment",5840,sp_thresholdaction

update systhresholds set status=1


systhresholds系统表是数据库定义的free space的阀值
5840 由sp_helpthreshold 得出的.

再次感谢大家,特别要感谢 hobbylu 和 jasonshan !
小弟在他们的帮助下才得解决的.


努力学习中......