SAP Knowledge Base Article - Preview

2780687 - EWA report recommendation: table option not set correctly - SAP ASE

Symptom

  • Your EWA report is reporting those recommendations:

Parameter                                    Table                         Current Value        Recommended Value      Rating 

concurrency_opt_threshold      <SID>.SAPSR3.VBHDR              15                              -1
concurrency_opt_threshold      <SID>.SAPSR3.VBMOD              15                              -1
concurrency_opt_threshold      <SID>.SAPSR3.VBDATA             15                              -1

Recommendation: One or more table options are not set correctly. The current settings can be checked using the stored procedure sp_helpdb.
The above database options should be set for an SAP ASE database. For more information, see SAP Note 2049506.

  • You would like to know if there is any impact on the system once this is implemented and if any further risks.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • Solution Manager (Solman) - All versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager all versions

Keywords

EWA, concurrency_opt_threshold, sp_chgattribute, VBHR, VBMOD, VBDATA , KBA , 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.