SQL Query Engine (SQE) - QRO Hash size increase

The SQL query engine uniquely identifies queries with an integer value known as the QRO hash. In order to better support larger SQL plan caches, in IBM i 7.6 the size of the QRO hash value is increased from 32 bits (INTEGER) to 64 bits (BIGINT).

The increased QRO hash size affects IBM-supplied interfaces that use the QRO hash as an input parameter or that return the QRO hash. These interfaces have been updated to represent the QRO hash as a 16-character hexadecimal value.

• In prior releases, the QQC83 column of the 3014 database monitor record contained the QRO hash. In
  IBM i 7.6, the QRO hash has been moved to the QQC301 column and the QQC83 column contains the
  NULL value.
• The QRYS0100 format used by the QIBM_QQQ_QRY_SUPER (Query Supervisor) exit program has
  changed. The CHAR(8) Query identifier field previously at decimal offset 58 is replaced with a CHAR(16)
  Query identifier field at decimal offset 230. Any existing exit programs that use the Query identifier field
  need to be modified and rebuilt to use the updated format. This includes the IBM-provided sample exit
  program that logs information using a data queue.
• Several SQL services rely on the QRO hash for input or output. These services have had their QRO hash
  related fields updated to the larger QRO hash size:
   
  ACTIVE_JOB_INFO table function
  ACTIVE_QUERY_INFO table function
  CLEAR_PLAN_CACHE procedure
  DUMP_PLAN_CACHE procedure
  MTI_INFO table function
  Query Supervisor Exit Program