Direct links to fixes
APAR status
Closed as program error.
Error description
PE Client does not specify a specific destination when starting a trace
Local fix
the DB2 command panel can be used to manually activate and deactivate IFCID 318. From PE Client System Overview select Execute DB2 Commands (C:>). As command input enter START TRACE(MON) CLASS(1) IFCID(318) DEST(SMF) Send the command string and save the assigned trace number from the DB2 command response window. The DB2 command window can be left open during the lifetime of the PE Client session.
Problem summary
**************************************************************** * USERS AFFECTED: Performance Expert Workstation Client Users. * **************************************************************** * PROBLEM DESCRIPTION: PE Client does not specify a specific * * destination when starting a trace. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The PE Client does not specify a specific destination when Starting a DB2 Trace from the dynamic and static statement cache panels. On DB2 11 and later subsystems the missing destination clause in the START TRACE command causes the DB2 trace collection to stop immediately after the command execution from the PE Client code, since DB2 flags the trace as an -orphaned- trace in case the destination is not specified.
Problem conclusion
The PE Client code has been changed to include DEST(SMF) in the START TRACE command issued thru the DB2 IFI interface. The following START TRACE is executed from the PE Client for starting dynamic and static statement cache trace collection: Dynamic statement cache metric collection: START TRACE(MON) CLASS(1) IFCID(318) DEST(SMF) Static statement cache metric collection: START TRACE(MON) CLASS(1) IFCID(400) DEST(SMF)
Temporary fix
Comments
APAR Information
APAR number
PI75616
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
520
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-01-27
Closed date
2017-06-26
Last modified date
2017-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI48320
Modules/Macros
FPEK$INF
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R520 PSY UI48320
UP17/07/12 P F707
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":"5.2.0","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":"5.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 August 2017