SAP Knowledge Base Article - Preview

3591152 - Getting error while adding compression pool with Msg 18146, Level 16, State 1 -SAP ASE

Symptom

  • When checking parameter compression info pool size noticed Error 18124 

sp_helpconfig 'compression info pool size', 'estimate' 
go

The compression information pool size parameter indicates the amount of memory
currently available to store table compression information.Minimum Value
         Maximum Value
         Default Value
         Current Value
         Memory Used
         Unit
         Type
------------------------------------------------------------
         ------------------------------------------------------------
         ------------------------------------------------------------
         ------------------------------------------------------------
         ----------------------------------------------------
         ----------------------------------------------------------------
         ----------------------------
               0
              2147483647
                    4096
                   32768
               71164
         memory pages(2k)
         dynamic

Msg 18146, Level 16, State 1:
Server 'SID', Procedure 'sp_aux_getsize', Line 65:
Syntax error encountered. Sizes must be of the form int[KMGP]. For example, a
size of 5 megabytes may be specified as '5M'.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite.

Product

SAP Adaptive Server Enterprise all versions

Keywords

Msg 18124, compression info pool, sp_helpconfig, sp_configure, sp_aux_getsize , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

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.