Step information when the query is broken into multiple
steps
ID Name Type
Description
4120
QVTSTP
BIN(32) Total number
of steps.
4122 QVNSTP
BIN(32) Step number
for current subselect.
4124 QVSTPY
CHAR(2) Type of step
processing. Possible values:
HJ - Hash Join
LC - LCP (distributed) query
VM - View Materialization
LJ - Full Left Outer Join
BB - Subquery Temporary
4130 QVUCNT
BIN(32) Unique count
of original query.
4132 QVQDTN
BIN(32) Subselect
number of original query.
4134 QVQDTL
BIN(32) Subselect
level of original query.
4136 QVMATN
BIN(32) Materialized
subselect number of original
query.
4138
QVMATL
BIN(32) Materialized
subselect level of original
query.