New system procedures  Changes to utility programs

Chapter 2: System Changes in Adaptive Server Version 15.0

Changed system procedures

Table 2-9 summarizes the changes made to existing system procedures.

Table 2-9: Changed system procedures

Procedure

Change

sp_checksource

Checks the existence of computed columns source text.

sp_help

Reports information on computed columns, function-based indexes, and partitions.

sp_helpartion

Adds detailed partition information to its output.

sp_helpindex

Reports information on computed column indexes, function-based indexes, and partitions.

sp_helptext

Displays the source text of computed columns, function-based index definitions, and partitions.

sp_hidetext

Hides the text of computed columns, function-based index keys, and partition condition.

sp_modifylogin

Adds option "enable logins during recovery".

sp_webservices

Adds addalias, deploy, dropalias, listudws, listalias, and undeploy options to support user-defined Web Services.

sp_monitorconfig

Supports the number of open partitions configuration parameter.

sp_countmetadata

Supports the number of open partitions configuration parameter.

sp_helpsegment

Prints segment bindings for objects and partitions.

sp_objectsegment

Displays segment information for all partitions for an object.

sp_placeobject

Enables future allocations for a partition from a new segment.

sp_dbcc_faultreport

Creates reports for a specific OPID or fault type.

sp_sysmon

Reports information related to open partitions Metadata Cache Management section of the configuration file.





Copyright © 2005. Sybase Inc. All rights reserved. Changes to utility programs

View this book as PDF