New and changed system procedures

This section describes the new system procedures added and changes made to existing system procedures.

Table 5-9 summarizes the new system procedures.

Table 5-9: New system procedures

System Procedure

Function

sp_ssladmin

Adds, deletes, or displays a list of server certificates for Adaptive Server.

sp_extengine

Allows you to start or stop EJB Server, or view status information about EJB Server, from the command line.

Table 5-10 summarizes the changes made to existing system procedures.

Table 5-10: Changed system procedures

Procedure

Change

sp_addserver

Adds functionality for Adaptive Server’s new limits.

sp_dropserver

Adds functionality for Adaptive Server’s new limits.

sp_havrfy

Adds functionality for Adaptive Server’s new limits.

sp_helpjava

Supports the new depends keyword, which allows you to view a list of database objects that depend on the specified Java class or JAR.

sp_configure

sp_configure allows you to specify the value for configuration paramters in unit specifiers. The unit specifiers are p or P for pages, m or M for megabytes, and g or G for gigabytes.

sp_serveroption

Supports the new external engine auto start clause, which enables or disables automatic startup of EJB Server whenever Adaptive Server starts up. The default is true.