Symptom
- Request for sybdiag to report 'optimizer level' as a name rather than a number
- What is the meaning of values 999998 and 999999 reported in sybdiag for configuration parameter 'optimizer level'
- The 'optmizer level' and 'optimization goal' value appear close together in sybdiag Configuration Data section, for example:
Parameter Name Default Memory Used Config Value Run Value Unit
optimization goal allrows_mix 0 allrows_oltp allrows_oltp name
optimizer level 999999 0 999998 999998 number - It would be clearer if 'optimizer level' prints the name rather than the numeric value
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) - All versions
Product
SAP Adaptive Server Enterprise 16.1
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
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.
SAP Knowledge Base Article - Preview