SAP Knowledge Base Article - Preview

2530476 - Default value for parameter max nesting level

Symptom

Manual ASE - System Administration Guide for version 16.0 and version 15.7 states that parameter ""max nesting level"" has a default value "50":

=========

In SAP ASE 15.0.3 and later, the maximum nesting level has been increased to 100, and the default value to 50.

=========

But the output from sp_configure for this parameter ("max nesting level") in both version indicates "16":

=========

1> sp_configure "max nesting level"
2> go
Parameter Name
Default Memory Used
Config Value
Run Value
Unit
Type
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------- ----------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
----------------------------------------
max nesting level
16 0
16
16
number
static

(1 row affected)
(return status = 0)

=========


Read more...

Environment

  • SAP Adaptive Server 15.7
  • SAP Adaptive Server 16.0

Product

SAP Adaptive Server Enterprise 15.7

Keywords

sp_configure default value max nesting level manual system administration guide 494239 810586 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.