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.