IBM Support

PM35783: CANCEL THREAD TCMD COMMAND FAILS WITH KO2O1941E RC=00000008 KO2O1942E RC=00000059 FOLLOWED BY FPEV0567W IFI ERROR

A fix is available

Subscribe

You can track all active APARs for this component.

 

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