A fix is available
APAR status
Closed as program error.
Error description
Thread History Dynamic Sql Calls display ZHTCALL. Inquiry displays valid sql statement but, sql is from different thread.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM user. * **************************************************************** * PROBLEM DESCRIPTION: WRONG SQL STATEMENT ON NTH PANEL * * ZHTCALL * * * **************************************************************** * RECOMMENDATION: APPLY THIS PTF. * **************************************************************** INVALID KEY IS USED TO COLLECT V8 DYNSQL W/O ROLLUP SETTING
Problem conclusion
COLLECT DYNAMIC SQL STATEMENT USING THE CORRECT KEY FOR DB2 V8 DISTRIBUTED THREAD. Internal macro consistency enforced KEYWORDS :ZTHCALL NTH DISTSERV ACCUMACC SQL STATEMENT INCORROUT
Temporary fix
Comments
APAR Information
APAR number
PK33782
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
2006-10-30
Closed date
2006-10-31
Last modified date
2017-02-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK19272
Modules/Macros
DGOFPCAL DGOFPDAT DGOFPDPM DGOFPETD DGOFPE15 DGOFPE35 DGOFPINT DGOFPRF0 DGOFPRMC DGOFPRPT DGOFPTRM DGOFP000 DGOMEFTA DGOMEGTM DGOMENAB DGOMEXA0 DGOMEXSS DGOMEXST DGOVUINI FPEMMEND KO2CMVSC KO2CMVSF
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R410 PSY UK19272
UP06/11/03 P F611
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:
04 February 2017