Information about the table scan being
performed
ID Name Type
Description
2182
QQDSS
CHAR(1) Table data
selection used.
Y - Yes
N - No
2184
QVSKIPS
CHAR(1) Skip
sequential selection used.
Y - Yes
N - No
2190
QVTBLRC
CHAR(2) Reason code
why a table scan was performed.
Possible values are:
T1 - No indexes exist.
T2 - Indexes exist, but none could be used.
T3 - Optimizer chose table scan
over available indexes.