Using sp_helpconfig with sybdiagdb (SAP Product Support Only)

sp_helpconfig includes several configname options that are intended only forSAP Product Support to use with the sybdiagdb database:

  • number of ccbs – the number of configurable action point control blocks available to aid debugging.

  • caps per ccb – the maximum number of configurable action points that can be configured at any one time within one configurable action point.

  • average cap size – the estimated number of bytes of memory required to store the information associated with a typical configurable action point.

Note: SAP Technical Support may create the sybdiagdb database on your system for debugging purposes. This database holds diagnostic configuration data, and is for use by SAP Technical Support only.
For example:
sp_helpconfig "number of ccbs"
Minimum Value Maximum Value Default Value Current Value Memory Used
------------- ------------- ------------- ------------- -----------
0             100             0             0            0
sp_helpconfig "caps per ccb"
Minimum Value Maximum Value Default Value Current Value Memory Used
------------- ------------- ------------- ------------- -----------
5             500            50            50            0
sp_helpconfig "average cap size"
Minimum Value Maximum Value Default Value Current Value Memory Used
------------- ------------- ------------- ------------- -----------
100         10000           200           200            0