The dbcc_faults table provides a description of each fault detected by dbcc checkstorage.
The columns for dbcc_faults are:
Column name |
Datatype |
Description |
---|---|---|
dbid |
smallint |
Identifies the target database. |
id |
smallint |
Identifies the table. The value is derived from sysindexes and sysobjects. |
indid |
smallint |
Identifies the index. The value is derived from sysindexes. |
partitionid |
int |
Identifies the partition. The value is derived from sysindexes and syspartitions. Counters are maintained for page ranges, so “partition” refers to the defined object-page affinity, rather than the actual object page chain. |
devid |
int |
Identifies the disk device. The value is derived from sysdevices. |
opid |
smallint |
Identifies the dbcc operation that was performed. |
faultid |
int |
Provides a unique sequence number assigned to each fault recorded for the operation. |
type_code |
int |
Identifies the type of fault. Valid values are 100000 – 100032. They are described in Table 2-1. |
status |
int |
Classifies the fault. Valid values are:
For more information, see the System Administration Guide. |
Combination of dbid, id, indid, partitionid, devid, opid, faultid, and type_code
Copyright © 2005. Sybase Inc. All rights reserved. |