IDCACHE integer

The IDCACHE command specifies the size of the cache that BMC AMI Load uses when generating values for an identity column.

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 higher risk of running out of numbers.

This cache is a temporary cache that BMC AMI Load uses. This command option does not affect the cache that you specified when defining your identity column.

Related topics

Basic-options

IDCACHE

Specify the size as the number of values to reserve. Valid values for this option are from 0 through 100000. Specifying 0 is the same as not specifying a value causing BMC AMI Load to use what is defined to Db2 in the column definition. 

IDCACHE.png

You can specify the default for the IDCACHE command option in your installation options by using the IDCACHE installation option. BMC AMI Load is shipped with a recommended value of 1000 for this option. The IDCACHE command option overrides the IDCACHE default.

Important

If no IDCACHE option or +IDCACHE parameter value or IDCACHE 0 is specified, BMC AMI Load uses the CACHE value which is specified when defining the identity column.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*