INFLIGHT

Use the INFLIGHT parameter in CQMPARMS to control the processing behavior used for inflight SQL calls.

Description

Specifies whether or not long running SQL calls that execute in Db2® are displayed before they complete.

Syntax

INFLIGHT(Y|N)

Default

Y

Valid values

Y

(Default) Long running SQL calls that execute within Db2 are displayed before they complete. If you specify INFLIGHT(Y), you can use the DISABLE_INFLIGHT dynamic configuration change commands to disable inflight processing.

N

Long running SQL calls that execute within Db2 are not displayed before they complete. If you specify INFLIGHT(N), you can use the ENABLE_INFLIGHT dynamic configuration change commands to enable inflight processing.

Example

INFLIGHT(Y)