A fix is available
APAR status
Closed as program error.
Error description
When OMPE is configured with TCMDSECU=USER and a user that does not have DB2 authority to cancel a thread issues the TCMD command to cancel a thread, the OMPE task will lose its authority to issue IFI READS and READA commands. User will see the following at the screen where the TCMD command was issued tcmd + Cancel Thread has been issued for Token=004374 + + -CANCEL THREAD(004374) + + <<< error issuing db2 command >>> ... PLAN + >> KO2O1941E EXCHANGE LAYER CALL - RETURN CODE 00000008 (CIFIEXCH) << + >> KO2O1942E EXCHANGE LAYER CALL - REASON CODE 00000059 (CIFIEXCH) << + + >> KO2O1252W THREAD NOT FOUND (PLANMAJ ) << tcmd The JOBLOG will show something like this KO2O1941E EXCHANGE LAYER CALL - RETURN CODE 00000008 (CIFIEXCH) KO2O1942E EXCHANGE LAYER CALL - REASON CODE 00000059 (CIFIEXCH) FPEV0567W DB1U DB2 MEMBER DB1U REPORTED IFI ERROR (RC 00000008, RS 00E60824). The SYSPRINT will show something like this FPEV0567W DATA FOR THIS MEMBER . DB1U ****************************************************** DB1U DB2 Auth Signon failed (RRSAF): DB1U Return code .......... : 8 ( 00000008x) DB1U Reason code .......... : 15925300 ( 00F30034x) DB1U Detecting module ..... : FPEVDB22 DB1U Error message ........ : DB1U +-------------------------------------------------- DB1U | PLAN DB2PM DOES NOT EXIST OR IS NOT AUTHORIZED. DB1U +-------------------------------------------------- DB1U User action .......... : DB1U +-------------------------------------------------- DB1U | PLAN DB2PM IS CREATED IF IT DOES NOT EXIST. IF T DB1U | PROBLEM PERSISTS, ENSURE THE USER/GROUP ID DB2PM DB1U | IS ALLOWED TO ACCESS PLAN. THEN RESTART PE SERVE DB1U +-------------------------------------------------- DB1U ****************************************************** When TCMDSECU=USER the DB2 authorization is obtained for the logged on USER. When TCMDSECU=STC the DB2 authorization is obtained for the OMPE Started Task (STC). When the TCMD command is issued to cancel a thread, the DB2 CANCEL THREAD command is issued under the DB2 authority identified by the TCMDSECU value. If the appropriate DB2 authority is not held, the DB2 CANCEL THREAD command will fail. At that time the authority of the OMPE STC is also lost for other services and access to DB2. TCMD ZTCANT
Local fix
Recycle the montoring of the OMPE STC To STOP a DB2 instance, please issue: F cccccccc,F PESERVER,P db2ssid To START a DB2 instance, please issue: F cccccccc,F PESERVER,S db2ssid where cccccccc is the OMPE STC name and db2ssid is the DB2 subsystem name
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - OMEGAMON collector * * - Classic Interface * **************************************************************** * PROBLEM DESCRIPTION: CANCEL THREAD TCMD COMMAND FAILS WITH * * KO2O1941E RC=00000008 AND KO2O1942E * * RC=00000059 MESSAGES. * * * **************************************************************** * RECOMMENDATION: Apply this PTF * * * **************************************************************** PROBLEM SUMMARY: An authorization failure may be not recognized correctly when CANCEL THREAD command issued on behalf of the user having not enough auth to use IFI. It causes error messages KO2O1941E and KO2O1941E being issued for every attempt to cancel thread by improperly authorized user. PROBLEM CONCLUSION: Code changed to fix this problem.
Problem conclusion
Code changed to fix this problem.
Temporary fix
Comments
APAR Information
APAR number
PM35783
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
420
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-03-28
Closed date
2011-07-07
Last modified date
2011-09-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK69522
Modules/Macros
KO2CIFBB KO2OTHGB
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R420 PSY UK69522
UP11/07/09 P F107
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":"4.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":"4.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 September 2011