PH49371: UNEXPECTED SQL TEXT REPORTED FOR TABLES WITH MASKED COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unexpected SQL text can be reported when monitoring queries
  running against tables that have implemented a column mask
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor               *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Unexpected SQL text reported for     *
  *                      tables with masked columns              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1. Unexpected text sometimes seen with a query that has column
  masks
  

Problem conclusion

• 1. During text collection, collector needed to do ignore
  filtering. To enhance the support for statements with column
  masking, an entry was added to the internal filter table
  

Temporary fix

Comments

APAR Information

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

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

  UI83390

Modules/Macros

• CQCMB3C5 CQCMB3D5 CQCMBNB1 CQCMBNC5 CQCMBND5 CQCMESC5 CQCMESD5
  CQCMSTRM CQCTEDB1 CQCTEDC5 CQCTEDD5 CQCTXLB1 CQCTXLC5 CQCTXLD5
  

Fix information

• Fixed component name

  COMMON COLLECTO

• Fixed component ID

  5639OLC00

Applicable component levels

• R110 PSY UI83390

     UP22/11/24 P F211

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.