Skip to Content

SAP Adaptive Server Enterprise (SAP ASE) version 16.0 SP03 PL03 contains several enhancements and new features.

In this blog we will talk about the following four major enhancements:

  • A new parameter for the password_random function
  • The new set statistics ioplan {on | off} command
  • Three new system procedures for SAP ASE monitoring: sp_w, sp_p, sp_sp
  • Customizing up to five file directories for database, transfer log, log, configuration, and backup files in both the HADR pair and the DR node

New parameter for the password_random function

The password_random function gets a new substring parameter.

You can use the substring parameter to specify a sub-string that is not to be used as part of a random password when the disallow simple passwords password complexity check is set to true.

For details, see password_random.

New set statistics ioplan {on | off} command

When set to On, this command displays the IO statistics per plan for each view.

For more details, see set.

New system procedures for SAP ASE monitoring

SAP ASE 16.0 SP03 PL03 introduces three new system procedures for ASE monitoring: sp_w, sp_p, and sp_sp.

These system procedures are the simplified versions of the existing sp_who and sp_showplan system procedures. sp_w returns information about all current SAP ASE users and processes; sp_p displays the concise output of the query plan while sp_sp displays the extended output of the query plan.

For details, see sp_w, sp_p, and sp_sp.

Customizing file directories in HADR pair and DR node

Both the HADR pair and DR node now support up to five customized directories for database, transfer log, log, configuration, and backup files.

Note: This functionality is available for Linux platforms only.

To customize the file directories, configure the following parameters in the response file:

Parameter Description Sample Value
dm_database_file_directory The database file directory $SYBASE/<SID>/database
dm_translog_file_directory The translog file directory $SYBASE/<SID>/translog
dm_log_file_directory The log file directory $SYBASE/<SID>/log
dm_config_file_directory The configuration file directory $SYBASE/<SID>/cfg
dm_backup_file_directory_for_database The backup file directory for database $SYBASE/<SID>/backup

 

For details, see Customizing File Directories.

Thank you for reading!

For more information, see documentation for SAP Adaptive Enterprise version 16.0 SP03 PL03 on the SAP Help Portal.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply