SAP Knowledge Base Article - Preview

2212706 - Resolving a Large Identity Gap in ASE.

Symptom

  • ASE goes down unexpectedly, and subsequently, there is a large gap in the Identity values of a table(s) following the next boot of ASE.
  • What is the procedure to fix this identity gap in an ASE table?
  • Is there a way to avoid this issue in the future?
  • Here is an example of an Identity values gap following an abnormal shutdown of ASE:

   500000000064100
   500000000064101
   500000000064102 
   500000000064103
   1000000000064085
   1000000000064086
   1000000000064087
   1000000000064088
   1000000000064089
   1000000000064090

  • Here is an example of the Identity value burning set configuration:

   sp_configure 'identity burning set factor'
   go

   Parameter Name Default Memory Used Config Value Run Value Unit Type
   ------------------------------ ----------- ----------- ---------------------------------------------------------------------------------------------------------------------------------------------
   identity burning set factor 5000 0 5000 5000 number static


Read more...

Environment

SAP Adaptive Server Enterprise(ASE) 15.7

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Identity, GAP , 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.