Table 3-7 summarizes the new system procedures:
System Procedure |
Function |
---|---|
sp_deviceattr |
Changes the dsync setting of an existing database device file. |
sp_transactions |
Reports detailed information about active transactions. |
sp_companion |
Performs cluster operations such as configuring Adaptive Server as a secondary companion in a high availability system and moving a companion server from one failover mode to another. sp_companion is run from the secondary companion |
sp_ha_admin |
Performs administrative tasks that address second point of failures on Adaptive Servers configured with Sybase’s Failover in a high availability system. |
sp_helpjava |
Displays information about Java classes and JARs installed in the database. |