New System Procedures

SAP ASE version 16.0 introduces new system procedures.

• sp_confighistory
  Creates the ch_events view and displays changes made to SAP ASE configuration.
• sp_ dropglockpromote_ptn
  Removes partition lock promotion values.
• sp_droprowlockpromote_ptn
  Removes partition lock promotion threshold values at server, database, or table levels.
• sp_helptrigger
  SAP ASE version 16.0 includes the sp_helptrigger system procedure.
• sp_jsconfigure
  Configures the Job Scheduler Agent.
• sp_logging_rate
  Calculates the transaction log growth rate for the specified time period.
• sp_setpglockpromote_ptn
  The sp_setpglockpromote_ptn system procedure sets partition-lock promotion thresholds at the server, database, and table level.
• sp_setrowlockpromote_ptn
  The sp_setrowlockpromote_ptn system procedure sets partition-lock promotion thresholds at the server, database, and table level.