A fix is available
APAR status
Closed as program error.
Error description
The AUDIT TYPE(BIND) report does not show the DBCS characters in the SQL statement in QW0145TX field correctly. The IFCID 145 record has correct DBCS string but the shift-out (X'0E') and shift-in (X'0F') bytes are replaced with blanks by DB2PE and the DBCS characters become garbage.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Batch Reporting * **************************************************************** * PROBLEM DESCRIPTION: DB2PE AUDIT report DBCS garbage * **************************************************************** * RECOMMENDATION: * * * * * * * * * * * * * * * * * * * * * **************************************************************** Our user checked the SQL call by using DB2PE Audit trace. But, AUdit trace output produced incorrect DBCS data. We compared the SMF data and AUdit trace output. SMF data have SOSI character, but Audit trace output have not contained SOSI character.SOSI character was translated to x'40'.
Problem conclusion
shows value accordingly of SOSI characters KEYWORDS : DBCS - KATAKANA
Temporary fix
Comments
APAR Information
APAR number
PK37082
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2007-01-09
Closed date
2007-04-20
Last modified date
2017-02-04
APAR is sysrouted FROM one or more of the following:
PK35678
APAR is sysrouted TO one or more of the following:
UK24104
Modules/Macros
DGOXFSQL DGOXT001 DGOXT002 DGOXT003 DGOXT005
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R410 PSY UK24104
UP07/04/25 P F704
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"410"}]
Document Information
Modified date:
31 March 2021