ON_RECVRY_THREADS

onconfig.std
value

1

units

Number of recovery threads

range of values

Positive integers

takes effect

When shared memory is initialized

refer to

One of the following manuals:

• IBM Informix: Backup and Restore Guide for ON-Bar
• IBM Informix: Archive and Backup Guide for ON-Archive or ontape

ON_RECVRY_THREADS is the maximum number of recovery threads that the database server uses for logical recovery when the database server is online (that is, during a warm restore).

You can tune ON_RECVRY_THREADS to the number of tables that are likely to be recovered because the logical-log records that are processed during recovery are assigned threads by table number. The maximum degree of parallel processing occurs when the number of recovery threads matches the number of tables being recovered.