DB2 10.5 for Linux, UNIX, and Windows

dft_loadrec_ses - Default number of load recovery sessions configuration parameter

This parameter specifies the default number of sessions that will be used during the recovery of a table load.

Configuration type

Database

Parameter type

Configurable online

Propagation class

Immediate

Default [range]

1 [1 - 30 000]

Unit of measure

Counter

The value of this parameter should be set to the number of I/O sessions that was specified with the COPY YES option in the original LOAD command. The retrieval of a load copy is an operation similar to restore. You can override this parameter through entries in the copy location file specified by the environment variable DB2LOADREC.

The default number of buffers used for load retrieval is two more than the value of this parameter. You can also override the number of buffers in the copy location file.

This parameter is applicable only if roll forward recovery is enabled.