2120412 - Execution of CREATE/ALTER DATABASE ... FOR LOAD does not perform in parallel even though documentation states that it will - Pre-ASE 15.7 SP130 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2120412 - Execution of CREATE/ALTER DATABASE ... FOR LOAD does not perform in parallel even though documentation states that it will - Pre-ASE 15.7 SP130

Symptom

  • Execution of CREATE/ALTER DATABASE ... FOR LOAD performs serially
  • Output of sp_monitorconfig 'large i/o buffers' shows only one large i/o buffer in use
  • Configuration parameters for parallel processing have been configured beyond default settings:
              max parallel degree
              max scan parallel degree
              number of worker processes
              number of large i/o buffers
  • ASE Performance & Tuning Guide states that CREATE/ALTER DATABASE will use parallel processing

Read more...

Environment

  • Sybase Adaptive Server Enterprise (ASE) 12.5.4
  • Sybase Adaptive Server Enterprise (ASE) 15.0
  • Sybase Adaptive Server Enterprise (ASE) 15.5
  • SAP Adaptive Server Enterprise (ASE) 15.7 below SP130

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

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 ONE Support launchpad (Login required).

Search for additional results

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