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.
SAP Knowledge Base Article - Preview