Symptom
- When upgraded an ASE server from ASE 15.7 SP100 to SP110 via binary overlay, the configuration parameter 'engine local cache percent' was not added to the server.
- Attempted to use sp_configure and sysconfigures table, but did not show the parameter
- 1> sp_configure 'engine local cache percent'
2> go
Msg 18124, Level 16, State 1:
Server 'ASE157', Procedure 'sp_configure', Line 1594:
No matching configuration options. Here is a listing of groups:
----------------------------------------------------------------------------------------------------
Application Functionality
Backup/Recovery
Cache Manager
Component Integration Services
Configuration Options
DTM Administration
Diagnostics
Disk I/O
Error Log
Extended Stored Procedure
General Information
Java Services
Languages
Lock Manager
Memory Use
Meta-Data Caches
Monitoring
Network Communication
O/S Resources
Physical Memory
Physical Resources
Processors
Query Tuning
Rep Agent Thread Administration
SQL Server Administration
Security Related
Shared Disk Cluster
Unicode
User Environment
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- Dataserver
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
engine local cache percent, sp_configure, sysconfigures, missing, CR754644, CR#754644, 754644 , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.