SAP Knowledge Base Article - Preview

3247827 - Error 17379 when trying to configure cache for tempdb - SAP ASE

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.