identity grab size allows each SAP ASE process to reserve a block of IDENTITY column values for inserts into tables that have an IDENTITY column.
|
Summary Information |
|
|---|---|
|
Default value |
1 |
|
Range of values |
1–2147483647 |
|
Status |
Dynamic |
|
Display level |
Intermediate |
|
Required role |
System administrator |
|
Configuration group |
SQL Server Administration |
This is useful if you are performing inserts, and you want all the inserted data to have contiguous IDENTITY numbers. For instance, if you are entering payroll data, and you want all records associated with a particular department to be located within the same block of rows, set identity grab size to the number of records for that department.
identity grab size applies to all users on SAP ASE. Large identity grab size values result in large gaps in the IDENTITY column when many users insert data into tables with IDENTITY columns.
SAP recommends that you set identity grab size to a value large enough to accommodate the largest group of records you want to insert into contiguous rows.