SAP Knowledge Base Article - Preview

2915147 - Which releases have "optimizer level" - SAP ASE

Symptom

Trying to set an optimizer level to ase157sp137 and receive the error:

sp_configure 'optimizer level', 0, 'ase157sp137'
go

Msg 5846, Level 16, State 2:
Server 'ase16', Procedure 'sp_configure', Line 1335:
Illegal value '0' specified for configuration option 'optimizer level'. The legal values are between '1' and '999999'.
(return status = 1)

What are the valid optimizer levels?


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

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

Search for additional results

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