Additional information about the SQL statement being
executed
ID Name Type
Description
1306 QVCLSCR
CHAR(10) CLOSQLCSR
setting. Possible values are:
*ENDJOB - SQL cursors are closed when the
job ends.
*ENDMOD - SQL cursors are closed when the
module ends.
*ENDPGM - SQL cursors are closed when the
program ends.
*ENDSQL - SQL cursors are closed when the
first SQL program on the call
stack ends.
*ENDACTGRP - SQL cursors are closed when
the activation group ends.
1308 QVALWCY
CHAR(1) ALWCPYDTA
setting. Possible values are:
N - temporary tables allowed
Y - Temporary copy of the data is allowed
only if necessary to execute the query.
O - Temporary copy of the data may be used
if the query optimizer determines it
is cost effective to do so.
1310 QVPSUDO
CHAR(1) Pseudo
open.
Y - Yes
N - No
1312
QVPSUDC
CHAR(1) Pseudo
close.
Y - Yes
N - No
1314
QVODPI
CHAR(1) ODP
implementation. Possible values are:
R - Reusable ODP
N - Nonreusable ODP
. . - Not used
1320 QVDYNR
CHAR(2) Dynamic
replan reason code. Possible
values are:
NA - No replan.
NR - SQL QDT rebuilt for new release.
A1 - A table or member is not the same
object as the one referenced when
the access plan was last built. Some
reasons they could be different are:
- Object was deleted and recreated.
- Object was saved and restored.
- Schema list was changed.
- Object was renamed.
- Object was moved.
- Object was overridden to a
different object.
- This is the first run of this
query after the object containing
the query has been restored.
A2 - Access plan was built to use a
reusable Open Data Path (ODP) and the
optimizer chose to use a non-reusable
ODP for this call.
A3 - Access plan was built to use a
non-reusable Open Data Path (ODP) and
the optimizer chose to use a reusable
ODP for this call.
A4 - The number of rows in the table
has changed by more than 10% since
the access plan was last built.
A5 - A new index exists over one of the
tables in the query.
A6 - An index that was used for this access
plan no longer exists or is no longer
valid.
A7 - OS/400 Query requires the access plan
to be rebuilt because of system
programming changes.
A8 - The CCSID of the current job is
different than the CCSID of the job
that last created the access plan.
A9 - The value of one or more of the
following is different for the
current job than it was for the
job that last created this access
plan:
- date format.
- date separator.
- time format.
- time separator.
AA - The sort sequence table specified
is different than the sort sequence
table that was used when this
access plan was created.
AB - Storage pool changed or DEGREE
parameter of the Change Query Attributes (CHGQRYA)
command changed.
AC - The system feature DB2 Multisystem
has been installed or removed.
AD - The value of the degree query
attribute has changed.
AE - A view is either being opened by a
high level language or a view is
being materialized.
AF - A User-Defined Type (UDT) or a User-Defined
Function (UDF) is not the same object as
the one referred to in the access
plan.
B0 - The options specified have changed
as a result of the query options
File.
1324
QVDYNSC
CHAR(2) Dynamic
replan subtype reason code.
1326 QVDYNRT
Z
Timestamp of when the access plan was
last rebuilt.
1330 QQPARS
CHAR(1) Parse
required.
Y - Yes
N - No
1332
QQDACV
CHAR(1) Data
Conversion. If greater than 0, some columns
were mapped or converted during execution
of the query. Because the columns were converted
their attributes may no longer match the
attributes of the key column of the index
expected to be used. If the attributes
do not match the index can not be used.
Reasons why the data was converted are:
N - No.
0 - Not applicable.
1 - Lengths do not match.
2 - Numeric types do not match.
3 - C host variable is NULL-terminated
4 - Host variable or column is
variable length and the other
is not variable length.
5 - CCSID conversion.
6 - DRDA and NULL capable, variable
length, contained in a partial
row, derived expression, or
blocked fetch with not enough
host variables.
7 - Data, time, or timestamp column.
8 - Too many host variables.
9 - Target table of an insert is
not an SQL table.
1334 QVCMMT
CHAR(4) Level of
commitment control.
NC - No commit
UR - Uncommitted read
CS - Cursor stability
CSKL - Cursor stability, keep lock
RS - Read stability
RR - Repeatable read
1336 QVBLKE
CHAR(1) Blocking
enabled.
Y - Yes
N - No
1338
QVDLYPR
CHAR(1) Delay
prep.
Y - Yes
N - No
1340
QVNAMC
CHAR(1) Naming
convention used. Possible values are:
S - SQL naming convention
N - System naming convention
1342 QVDYNTY
CHAR(1) Type of
Dynamic. Possible values are:
E - Extended dynamic
S - System wide cache
L - Local prepared statement
1344 QVOLOB
CHAR(1) Optimize LOB
data types.
Y - Yes
N - No
1350
QVUSRP
CHAR(10) User profile used
when compiled program
object is executed.
1352 QVDUSRP
CHAR(10) User profile used
for dynamic SQL
statements.
1354 QVDFTCL
CHAR(128) Name of the default
collection.
1360 QVPROCN
CHAR(128) Procedure name on CALL
to SQL.
1362
QVPROCL
CHAR(128) Procedure schema on
CALL to SQL.
1364 QVSPATH
VARCHAR(1000) Path to be used to find procedures,
functions, and user-defined types for
static SQL statements.