Chapter 4: dbcc Stored Procedures  Specifying the object name and date

Chapter 4: dbcc Stored Procedures

Overview

These procedures access the tables only in the dbccdb database or in the alternate database, dbccalt. See the System Administration Guide for details on setting up dbccdb or dbccalt. See Chapter 2, “dbccdb Tables” in Reference Manual: Tables for information on the tables used in these databases.

Table 4-1 lists the dbcc stored procedures described in this chapter. For details on the dbcc system procedure sp_plan_dbccdb, see sp_plan_dbccdb. See the System Administration Guide for more information on this system procedure and the dbcc stored procedures.

Table 4-1: dbcc stored procedures

Procedure name

Description

sp_dbcc_alterws

Changes the size of the specified workspace to a specified value, and initializes the workspace.

sp_dbcc_configreport

Generates a report that describes the configuration information used by the dbcc checkstorage operation for the specified database.

sp_dbcc_createws

Creates a workspace of the specified type and size on the specified segment and database.

sp_dbcc_deletedb

Deletes from dbccdb all the information related to the specified target database.

sp_dbcc_deletehistory

Deletes the results of dbcc checkstorage operations performed on the target database before the specified date and time.

sp_dbcc_differentialreport

Generates a report that highlights the changes in I/O statistics and faults that took place between two dbcc operations

sp_dbcc_evaluatedb

Recomputes configuration information for the target database and compares it to the current configuration information.

sp_dbcc_exclusions

Allows the user to create and manage persistent exclusion lists for use by checkverify and sp_dbcc_faultreport.

sp_dbcc_faultreport

Generates a report covering fault statistics for the dbcc checkstorage operations performed for the specified object in the target database on the specified date, listed in order by table and index.

sp_dbcc_fullreport

Runs sp_dbcc_summaryreport, sp_dbcc_configreport, sp_dbcc_statisticsreport, and sp_dbcc_faultreport.

sp_dbcc_help_fault

Provides a description of the specified fault type and the recommended fix.

sp_dbcc_patch_finishtime

Facilitates reporting on aborted checkverify and checkstorage operations.

sp_dbcc_recommendations

Prints recommendations for a database based on a checkstorage run and groups the recommendations by table and index.

sp_dbcc_runcheck

Runs dbcc checkstorage on the specified database, then runs sp_dbcc_summaryreport or a report you specify.

sp_dbcc_statisticsreport

Generates an allocation statistics report on the specified object in the target database.

sp_dbcc_summaryreport

Generates a summary report on the specified database.

sp_dbcc_updateconfig

Updates the dbcc_config table in dbccdb with the configuration information of the target database.





Copyright © 2005. Sybase Inc. All rights reserved. Specifying the object name and date

View this book as PDF