Adaptive Server 12.5.0.3 provides the following changes to dbcc checkstorage. You can:
Execute dbcc stored procedures from any database.
Generate reports that provide recommended actions to address faults reported by checkstorage.
Generate reports on aborted checkstorage and checkverify operations.
Limit checkverify processing to a specific object.
Exclude tables, faults, and combinations of faults and tables from processing by checkverify and sp_dbcc_faultreport.
Create default configuration values for the dbcc configuration parameters and view them with sp_dbcc_configreport.
Delete values of the dbcc configuration parameters.
Avoid configuring an explicit cache for checkstorage operations.
Avoid creating scan or text workspaces for every database on which checkstorage reports. You can create both or either one, the scan or the workspaces. Default scan and text workspaces are created when you run the installdbccdb script.
Avoid running sp_dbcc_updateconfig to reregister a workspace that you have dropped and re-created.
Avoid manually expanding the dbccdb workspaces.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
