A fix is available
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 number
PH49371
Reported component name
COMMON COLLECTO
Reported component ID
5639OLC00
Reported release
110
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-09-08
Closed date
2022-11-22
Last modified date
2022-12-01
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.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 December 2022