SAP Knowledge Base Article - Preview

2447907 - EWA report for SAP ASE database is recommending that Database Options are not set correctly

Symptom

You are getting the following alert on the EWA report:


12.1.7 Database Options
The session was unable to read your current system settings, these are the default settings.

Recommendation: One or more database options are not set correctly. We strongly recommend that you set the following database options for the SAP ASE database. The current settings can be checked using the stored procedure
sp_helpdb 'DEV'.

Database options are an important feature of any database. Options control the behavior of the database and must be set for each database individually. The database option settings for a database are determined by the needs of the application.

Database options are set using the stored procedure 'sp_dboption'; you have to be in the master database to set a database option. For details, also see SAP Note 1749935. (Configuration Guide for SAP ASE 15.7), 'Database Options' section.

For example: sp_dboption <SID>,'ddl in tran','true'
The following important database options are required for an SAP ASE database.
<SID> -> ddl in tran
<SID> -> allow nulls by default
<SID> -> allow wide dol rows
<SID> -> enforce dump tran sequence
<SID> -> full logging for all
saptools -> ddl in tran
saptools -> allow nulls by default
saptools -> allow wide dol rows

The following important database options are recommended for an SAP ASE database.
<SID> -> deallocate first text page
<SID> -> abort tran on log full
<SID> -> page compression
sybsystemdb -> trunc log on chkpt


Read more...

Environment

SAP ASE database

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.1 ; SAP Solution Manager 7.2

Keywords

KBA , SV-SMG-SER-EWA , EarlyWatch Alert , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.