SAP Knowledge Base Article - Preview

2349540 - When running 'select into' with an encryption key, the usage of CPU and Memory increase too high - SAP ASE

Symptom

  • When execute a 'select into' query, if it uses '*' instead of using a specific column name or source table
  • Having encrypted columns or target table has 'with encrypt' clause
  • the usage of CPU and Memory increase too high
  • This can possibly lead to a timeslice error in extreme cases.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP 135
  • Dataserver

Product

SAP Adaptive Server Enterprise 15.7

Keywords

select into, encrypt key, encrypt column , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.