A fix is available
APAR status
Closed as program error.
Error description
we are currently installing and testing IBM TIVOLI OMEGAMON XE for DB2 Performance Monitor V310. We found a problem when running the Explain function in batch : FPEY0002W CALL ATTACH FUNCTION OPEN THREAD FAILED. RETURN CODE 12, REASON CODE 00F30040 I added a //dsntrace dd * to the job and found that the explain was trying to connect to plan DGOPMEX instead of the plan KO2EXPL which was bound during the installation of the explain function . To bypass the problem I added a new plan BIND PLAN (DGOPMEX) PKLIST (KO2EX310.*) .... and the problem was solved. So for some reason program FPECMAIN is trying to use plan DGOPMEX instead of KO2EXPL . I think DGOPMEX is and old name used by an earlier version of DB2PM. I will upload the failing explain job and the installation jcl for plan KO2EXPL .
Local fix
As a circumvention please ask user to do the following: specifiying //SYSIN DD * GLOBAL PLANEX(KO2EXPL) in his EXPLAIN batch job.
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - EXPLAIN * **************************************************************** * PROBLEM DESCRIPTION: When running a EXPLAIN batch job * * without the command option PLANEXPLAIN * * the following message occurs: * * FPEY0002W CALL ATTACH FUNCTION OPEN * * THREAD FAILED. * * RETURN CODE 12, REASON CODE 00F30040 * **************************************************************** * RECOMMENDATION: * **************************************************************** When running a EXPLAIN batch job without the command option PLANEXPLAIN the following message occurs: FPEY0002W CALL ATTACH FUNCTION OPEN THREAD FAILED. RETURN CODE 12, REASON CODE 00F30040
Problem conclusion
The default plan name for EXPLAIN now is KO2EXPL. KEYWORDS: EXPLAIN PLANNAME KO2EXPL
Temporary fix
Comments
APAR Information
APAR number
PK41816
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-03-23
Closed date
2007-04-04
Last modified date
2007-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK23712 UK23713
Modules/Macros
DGO@MAIN DGOFPDAT DGOYBEXR DGOYLIST DGOYMAIN DGOYPSUM FPECMDAT FPECVGLC FPECVPEX FPEUCXDL
SC18963900 | SC18964301 | SC18998100 | SC18998500 |
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":"310","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":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 May 2007