The output of sp_help object has been changed. Specifically, “Data_Located_on_segment” has been removed. “Computed_Column_Object” and information related to partitions have been added.
The order of index_keys and index_description in the output of sp_helpindex has been changed.
Major changes are implemented for sp_helpartition, sp_helpsegment outputs.
When sp_who is invoked, it returns “NULL” instead of blank in the hostname column for all system tasks.
When sp_who is invoked, it will result in SQL command (insert or select) in the output. In the prior releases of Adaptive Server version 15.0, sp_who always return select for the tasks that execute sp_who.
sp_objectsegment now displays the segment information for all the partitions of the table.
sp_lock output has a new column called partitionid. This column has a value of 0 now and is reserved for future.
sp_monitorconfig now accepts number of open partitions. When this procedure is executed with the parameter all, additional output for configuration parameter number of open partitions is displayed.
The Metadata Cache Management section of sp_sysmon displays additional information pertaining to open partitions.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
