SEQPRES in macro DSN6SPRM

Some DB2® utilities scan nonpartitioning indexes and then update a subset of the pages in the indexes. The SEQPRES subsystem parameter specifies whether, when reading data, these utilities are to allow data to remain in cache longer. Valid values are YES and NO.

The default value, YES, means that these DB2 utility prefetch reads remain in cache longer, possibly improving performance of subsequent writes in the following cases for a table with very large nonpartitioned indexes:

LOAD PART integer RESUME
REORG TABLESPACE PART

The utility cache option is useful only with 3390 geometry disk attached to the 3990 Model 6 or later controllers.

A value of NO means that DB2 utilities use the 3990 cache the same way as any other application, which is specified by the SEQCACH subsystem parameter.

This subsystem parameter is deprecated in DB2 10.