+IDCACHE
(SPE2104)
The +IDCACHE parameter specifies the size of the cache that BMC AMI Load uses when generating values for an identity column.
The valid values for this parameter are from 0 through 100000. The recommended value is 1000.
0 | (Default) +IDCACHE does not take effect and BMC AMI Load uses the CACHE value which is specified when defining the identity column |
|---|---|
integer | Size of the cache that BMC AMI Load uses when generating values for an identity column. Valid values are from 0 through 100000. |
The +IDCACHE parameter can be overridden by the IDCACHE option on the LOAD command.
When generating the identity column values, BMC AMI Load updates the MAXASSIGNEDVAL column of the SYSIBM.SYSSEQUENCES with the last value in the cache that it is reserving.
If you specify a small size for this cache, BMC AMI Load accesses and updates SYSIBM.SYSSEQUENCES frequently, which reduces the performance of the load job. However, if you specify a larger size for this cache, there is a greater possibility of gaps in your identity column values and a high risk of running out of numbers.
This cache is a temporary cache that BMC AMI Load uses. This parameter does not affect the cache that you specified when defining your identity column.
Related topics