2212706 - Resolving a Large Identity Gap in ASE.

• 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

SAP Adaptive Server Enterprise(ASE) 15.7

SAP Adaptive Server Enterprise(ASE) 16.0

Identity, GAP , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem