Information about the temporary hash table
created
ID Name Type
Description
2550 QVHTENT
BIN(32) Number of
rows of hash table created.
2552 QVHTSIZ
BIN(32) Size, in
bytes, of hash table created.
2554 QVHTRSIZ
BIN(32) Row size, in
bytes, of hash table created.
2556 QVHTKSIZ
CHAR(1) Key size, in
bytes, of hash table created.
2558 QVHTESIZ
CHAR(10) Element size, in
bytes, of hash table created.
2560 QVHTPSIZ
CHAR(10) Pool size where
hash table was created.
2562 QVHTPID
CHAR(1) Pool ID
where hash table was created.
2563 QVHTRC
CHAR(1) Hash Table
reason code. Possible values:
J - Created for hash join
G - Created for hash grouping
2564 QVHTCOL
CHAR(1) Columns of
hash table created.