Adaptive Server 15.7, ESD #2 contains new and changed system procedures.
| System Stored Procedures | Description |
|---|---|
| sp_config_dump | Allows you to list, add, or change dump configurations. |
| sp_dump_history | Allows you to purge dump records from the dump history file. The original dump history file is saved with the timestamp suffixed to the file name. |
| sp_optgoal 'show','goal_name' | Reports all individual criteria activated by the user-created optimizer goal. |
| sp_restore_system_role | Restores the system-defined roles or database owner privileges to the system defaults. |
| sp_shmdumpconfig | Configures shared memory dumps. |
| System Stored Procedures | Description |
|---|---|
| sp_dboption | Adds the deferred table allocation parameter to configure the database so Adaptive Server defers page allocation for all subsequently created user tables. |
| sp_checksource | Allows you to include a predicated privilege for objname |
| sp_hidetext | Allows you to include a predicated privilege for objname |
See the Reference Manual: Procedures.