SAP Knowledge Base Article - Preview

3659246 - Identity gaps in a column and how to manage them - SAP Adaptive Server Enterprise

Symptom

  • The server is experiencing too many identity gaps/jumps in a column of certain tables.
  • Missing values are observed in the identity column.
  • The issue is related to the design of SAP Adaptive Server Enterprise (ASE), which does not guarantee sequential, gapless numbering in identity columns.


Read more...

Environment

Sybase ASE Database Platform (non Business Suite)

Product

SAP Adaptive Server Enterprise all versions

Keywords

identity gaps, SAP ASE, Adaptive Server Enterprise, identity column, gaps in sequence, identity_gap, custom sequence table, sp_help, sp_chgattribute, database performance, rollback, identity caching , 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.