Symptom
- Getting the following errors when trying to re-configure tempdb cache, after tempdb bound to a cache:
Server Message: Number 870, Severity 10
Server 'servername', Procedure 'sp_bindcache', Line 409:
WARNING!!! You may have to change the log I/O size for the database 'tempdb_05'. Current setting is '16K' and the cache 'tempdb_05_cache' does not have a '16K' memory pool. - Executing sp_poolconfig to add the pool, Msg 17379 received:
exec sp_poolconfig tempdb_02_cache, '500.0M', '16K', '8K'
Server Message: Number 17379, Severity 16
Server 'servername', Procedure 'sp_do_poolconfig', Line 813:
You cannot configure data caches and NV caches in the system temporary database.
(1 row affected)
(return status = 1)
Read more...
Environment
SAP Adaptive Server Enterprise ASE 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
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