Setting a block value for sequence number generation

As part of a comprehensive performance tuning project, experienced MDM implementers can set a block value for sequence number generation. Each database access operation impacts system performance, and sequence number generation is one of the most common operations. To enhance performance by decreasing the number of database access operations, you can configure the operational server to cache block values for entrecno, memrecno, rellinkno, and tskrecno. Rather than accessing the database for each new record number, the next sequence number is retrieved from the cached values. The database is accessed only when all of the cached values are used.

1. Go to your WAS_PROFILE_HOME/conf/ directory and open the com.ibm.mdm.mds.jni.cfg file.
2. Edit the following properties. The default for each property is a block of 10 numbers.

   Property	Description
   MAD_ENTRECNOINCR	The number of values that are cached for an entrecno during sequence generation.
   MAD_MEMRECNOINCR	The number of values that are cached for a memrecno during sequence generation.
   MAD_RELLINKNOINCR	The number of values that are cached for rellinkno during sequence generation.
   MAD_TSKRECNOINCR	The number of values that are cached for tskrecno during sequence generation.

3. Save and close the file.