SAP Knowledge Base Article - Preview

2053711 - parallel CREATE INDEX with DEFER_RECOVERY - SAP ASE

Symptom

  • CREATE INDEX operations when run in parallel (that is, including the with consumers clause), break the transaction log sequence
  • A full database dump is required before the transaction log can be dumped, after a parallel CREATE INDEX operation
  • Building indexes in serial does not break the transaction log sequence - however it is a very slow operation and not beneficial when large indexes are involved

In order to maintain the ASE transaction log sequence while creating indexes in parallel, use the DEFER_RECOVERY option during index creation.

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and above
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP ERP 6.0

Keywords

create index, recovery, parallel , transaction log , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.