SAP Knowledge Base Article - Preview

3798928 - Request for sybdiag to report 'optimizer level' as the name rather than a number - SAP ASE

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.