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
Parameter type
  • Configurable online
Propagation class
Default [range]
1 [1 - 30 000]
Unit of measure

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.