Checking Database Consistency

The database consistency checker (dbcc) provides commands for checking the logical and physical consistency of a database.

dbcc checkstorage stores the results of checks in the dbccdb database. You can print reports from dbccdb using the dbcc stored procedures.

If you are using Component Integration Services, there are additional dbcc commands you can use for remote databases. See the Component Integration Services Users Guide.

• Page and Object Allocation
  When you initialize a database device, the disk init command divides the new space into allocation units.
• dbcc Checks
  The dbcc commands hat you can run depend on your role.
• Checking Database and Table Consistency
  The dbcc commands for checking the consistency of databases and tables are dbcc checkstorage, dbcc checktable, dbcc checkindex, and dbcc checkdb.
• Checking Page Allocation
  The dbcc commands that you use to check page allocation are dbcc checkalloc, dbcc indexalloc, dbcc tablealloc, and dbcc textalloc.
• Correcting Allocation Errors Using the fix | nofix Options
  The fix | nofix option with dbcc checkalloc, dbcc tablealloc, textalloc, and dbcc indexalloc specifies whether or not the command fixes the allocation errors in tables. The default for user tables is fix. The default for system tables is nofix.
• Generate Reports with dbcc tablealloc and dbcc indexalloc
  Generate full, optimized, or fast reports with dbcc tablealloc or dbcc indexalloc.
• Checking Consistency of System Tables
  dbcc checkcatalog checks for consistency within and between the system tables in a database.
• Strategies for Using Consistency Checking Commands
  dbcc checkdb, dbcc checktable, and dbcc checkcatalog perform different types of integrity checks than dbcc checkalloc, dbcc tablealloc, and dbcc indexalloc.
• Verifying Faults with dbcc checkverify
  dbcc checkverify examines the results of the most recent checkstorage operation (by reading dbcc_faults) and reclassifies each soft fault as either a hard fault or an insignificant fault. checkverify acts as a second filter to remove spurious faults from the checkstorage results.
• Preparing to Use dbcc checkstorage
  Before you can use dbcc checkstorage, configure SAP ASE and set up the dbccdb database.
• Updating the dbcc_config Table
  The dbcc_config table describes the currently executing or last completed dbcc checkstorage operation.
• dbccdb Maintenance Tasks
  You may occasionally need to perform maintenance tasks on dbccdb.
• Generating Reports from dbccdb
  dbccdb includes several stored procedures so that you can generate reports from the data in dbccdb.
• Upgrading Compiled Objects with dbcc upgrade_object
  SAP ASE upgrades compiled objects based on their source text.