SAP Knowledge Base Article - Preview

1911872 - Missing errorlog message about "Number of proc buffers allocated" in ASE 12.5 and later versions

Symptom

The "Number of proc buffers allocated" message mentioned in the "System Administration Guide" no longer appears in the errorlogs of newer versions of Adaptive Server Enterprise.

ASE 15.7 ESD #2 System Administration Guide Volume 2 says:

"------------------------------------
Adaptive Server Enterprise 15.7 ESD #2
- System Administration Guide: Volume 2
   - Configuring Memory
     - Configuration parameters that control Adaptive Server memory
       - Data and procedure caches
------------------------------------
Chapter 3: Configuring Memory

Monitoring cache space

........

Procedure cache messages

  These error log messages provide information about the procedure cache:

    server: Number of proc buffers allocated: 556
    server: Number of blocks left for proc headers: 629
------------------------------------"


But in ASE 12.5.x and later, the message "Number of proc buffers allocated: xxxx" no longer appears.
Only the "Number of blocks left for proc headers: xxxxx" message remains.

For examples of the messages that appear in the errorlog of various ASE versions, see below.

-- ASE 12.0.0.8 --
00:00000:00000:2013/05/17 11:30:31.56 kernel  Network and device connection limit is 9990.
00:00000:00000:2013/05/17 11:30:31.57 server  Number of proc buffers allocated: 6188.
00:00000:00000:2013/05/17 11:30:31.61 server  Number of blocks left for proc headers: 6120.
00:00000:00000:2013/05/17 11:30:31.63 server  Proc header memory allocated 3060 pages for each per engine cache
00:00000:00000:2013/05/17 11:30:31.63 server  Memory allocated for the default data cache cachelet 1: 44948 Kb
00:00000:00000:2013/05/17 11:30:31.64 server  Size of the 2K memory pool: 44948 Kb

-- ASE 12.5.4 --
00:00000:00000:2008/04/02 13:54:41.81 kernel  Network and device connection limit is 9985.
00:00000:00000:2008/04/02 13:54:44.48 server  Number of blocks left for proc headers: 139912.
00:00000:00000:2008/04/02 13:54:44.99 server  Proc header memory allocated 69956 pages for each per engine cache
00:00000:00000:2008/04/02 13:54:45.23 server  Size of the 16K memory pool: 512000 Kb
00:00000:00000:2008/04/02 13:54:45.48 server  Size of the 2K memory pool: 512000 Kb
00:00000:00000:2008/04/02 13:54:45.48 server  Memory allocated for the default data cache cachelet 1: 1024000 Kb
00:00000:00000:2008/04/02 13:54:45.57 server  Size of the 16K memory pool: 199680 Kb
00:00000:00000:2008/04/02 13:54:45.57 server  Size of the 2K memory pool: 5120 Kb
00:00000:00000:2008/04/02 13:54:45.57 server  Memory allocated for the dbccdb_cache cachelet 1: 204800 Kb
00:00000:00000:2008/04/02 13:54:45.57 kernel  Enabling Sun Kernel asynchronous disk I/O strategy.
----------------

-- ASE 15.5 ----
00:00:00000:00000:2013/04/08 16:03:05.63 kernel  Network and device connection limit is 9985.
00:00:00000:00000:2013/04/08 16:03:05.63 kernel  ASE - Dynamic Pluggable Component Interface is disabled
00:00:00000:00000:2013/04/08 16:03:05.86 server  Number of blocks left for proc headers: 100016.
00:00:00000:00000:2013/04/08 16:03:06.01 server  Proc header memory allocated 20003 pages for each per engine cache
00:00:00000:00000:2013/04/08 16:03:06.01 kernel  Enabling Sun Kernel asynchronous disk I/O strategy.
----------------

-- ASE 15.7 ----
00:0000:00000:00000:2013/05/08 16:06:01.84 kernel  Network and device connection limit is 39985.
00:0000:00000:00000:2013/05/08 16:06:01.84 kernel  ASE - Dynamic Pluggable Component Interface is disabled
00:0000:00000:00000:2013/05/08 16:06:01.84 kernel  Adaptive Server is running as process id 9331.
00:0000:00000:00000:2013/05/08 16:06:02.42 server  Number of blocks left for proc headers: 143912.
00:0000:00000:00000:2013/05/08 16:06:02.42 server  Proc header memory allocated 899 pages for each per engine cache
00:0000:00000:00000:2013/05/08 16:06:02.43 server  Proc header memory allocated 899 pages for engine 0 local cache
00:0000:00000:00000:2013/05/08 16:06:02.43 kernel  Create Thread Pool 4, "syb_aio_pool", type="Run To Completion", with 0 threads
----------------

What happened to this message? How can I get information about memory usage in the procedure cache?


Read more...

Environment

SAP Sybase Adaptive Server Enterprise (ASE) 12.5.4 and higher

Product

SAP Adaptive Server Enterprise all versions

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 for Me (Login required).

Search for additional results

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