DBCC what to look for

[william-paul_philibert]

Bonjour,

I want to run DBCC to verify database integrity but quite honestly, I have thousands of tables and the ouputs of the dbcc are quite huge. Can you please tell me what I should put my attention to, what shoud I look for? Any documentation on the potential errors or warning in the DBCC output?

dbcc checktable

dbcc checkalloc

dbcc checkcatalog

[former_member188958]

DBCC will report errors that it finds as numbered messages, so search your dbcc output for "Msg" to find them.

Example:

1> dbcc checktable(t1)
2> go
Checking table 't1' (object ID 624002223): Logical page size is 2048 bytes.

Checking partition 't1_624002223' (partition ID 624002223) of table 't1'. The
logical page size of this table is 2048 bytes.
Msg 697, Level 16, State 1:
Server 'rel157_bret_redhead', Line 1:
An attempt was made to fetch logical page '889' for database 'victimdb' (7),
object 't1' (624002223), index 't1' (0), partition 't1_624002223' (624002223)
from cache 'default data cache'. Wrong logical page '624002223' was found in
cache.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

Most of the errors likely to be encountered are documented in the ASE Error Messages and Troubleshooting Guide.

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/tit...

There are also some updated and new write-ups in a collection on the SCN wiki:

https://wiki.scn.sap.com/wiki/display/SYBASE/ASE+Error%2C+Fault%2C+and+Message+Writeups

Cheers,
-bret

[william-paul_philibert]

Awesome, exactly the info I needed, thanks Bret, that makes my life much easier right now and until I can setup the dbcc database.

[william-paul_philibert]

Thanks Mark,

this is something I plan to setup but meanwhile I need to run the DBCC check commands and honestly, don't know what to look for in terms of errors and/or warning.

I can not setup dbccdb quickly enough for the current situation. Any source of information for that?