DF_FILE_IDENTITY_CACHE_SIZE
See Also
Description
DB2 identity columns can have an identity cache, which pre-allocates a number of identity values. This identifies how many values for identity columns the system should keep in cache.
Level
Table
Supported by
The DB2 Driver, revision 6 and higher
Type
Integer, permanent
Access
Read / Write
Values
0..
Remarks
The default value is 0 (NO CACHE).
Setting the identity cache to a value larger than 1 may give better performance when large amounts of new records are created, for example, in a batch process. Refer to the DB2 documentation on Identity Cache for further information.