A fix is available
APAR status
Closed as program error.
Error description
SQL texts from QW0140SQ, QW0141TX, QW0142TX, QW0145TX are not printed in full length in RECORD TRACE for IFCID 140, 141, 142 and 145.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Batch Reporting * **************************************************************** * PROBLEM DESCRIPTION: The SQL statement in QW0140SQ, * * QW0141TX, QW0142TX and QW0145TX is not * * always printed in full available * * length. * **************************************************************** * RECOMMENDATION: Apply this PTF to get the full available * * SQL statement text in Record Trace. * **************************************************************** PROBLEM SUMMARY: The SQL statement in QW0140SQ, QW0141TX, QW0142TX and QW0145TX is not always printed in full available length. PROBLEM CONCLUSION: By using a larger internal buffer even large SQL statements are now printed in full available length.
Problem conclusion
By using a larger internal buffer even large SQL statements are now printed in full available length. KEYWORDS : QW0140SQ QW0141TX QW0142TX QW0145TX
Temporary fix
Comments
APAR Information
APAR number
PK52064
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-08-31
Closed date
2007-12-07
Last modified date
2008-01-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK31938 UK31971
Modules/Macros
DGONF140 DGONF150
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 January 2008