PK91555: UDF FOR CORRECTLY FORMATTING THE HOSTV_TEXT FIELD FOR THE APPROPRIATE DATA TYPE.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Queries run on DB2 offload table EXCP_HOSTV do not display data
  in column HOSTV_TEXT correctly for numeric host variables. Since
  the HOSTV_TEXT column is defined as VARCHAR(64) , host variables
  with numeric values are stored as an incompatible data type.
  This enhancement provides a UDF (User Defined Function), to
  correctly format the HOSTV_TEXT field for the appropriate data
  type.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Queries run on DB2 offload table        *
  *                      EXCP_HOSTV do not display data in       *
  *                      column HOSTV_TEXT correctly for         *
  *                      numeric host variables. Since the       *
  *                      HOSTV_TEXT column is defined as         *
  *                      VARCHAR(64) , host variables with       *
  *                      numeric values are stored as an         *
  *                      incompatible data type. This            *
  *                      enhancement provides a UDF (User        *
  *                      Defined Function), to correctly format  *
  *                      the HOSTV_TEXT field for the            *
  *                      appropriate data type.                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK56085

Modules/Macros

•    CQMHVBLD CQMUDDDL CQMUDFHV
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R230 PSY UK56085

     UP10/04/22 P F004

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.