PK80033: WHEN USING SQLPA REPORT AND CHANGING SUBSYSTEM ID IT DOES NOT GIVE NEW INFORMATION FROM THE CHANGED SUBSYSTEM.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Even with PK76763 / UK42823 problem still arrises:
  . LOGON on Omegamon Classic Interface with DB2=DB2A
  . R.C.A  EDMPool Snapshot
  . PF11 zoom SQL Cache
  . PF11 zoom Authid W71A001
  . PF11 zoom SQL Statement
  . A invoke SQL PA
  . V.  View SQL PA Reports
    On the SQL PA report I see that SQL PA takes the members
    OMQCDB2A
    and OMQPDB2A --> it's ok
   Then  change the DB2 Subsystem ID on the Realtime Menu to DB2C
    . same scenario
    . but SQL PA takes always the members OMQCDB2A and OMQPDB2A
      instead of OMQCDB2C and OMQPDB2C
    .....
    Another SQLPA subtask did not get switched to the new the
   subsystem.
  

Local fix

• Please apply the PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: WHEN USING SQLPA REPORT AND CHANGING    *
  *                      SUBSYSTEM ID IT DOES NOT GIVE NEW       *
  *                      INFORMATION FROM THE CHANGED SUBSYSTEM. *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  VTAM DB2 subsystem switch without using ZLOG panel
  causes incorrect SQLPA display
  
  PROBLEM CONCLUSION:
  Reinit SQLPA environment when DB2 subsystem switch
  is done without using ZLOG panel
  

Problem conclusion

• Reinit SQLPA environment when DB2 subsystem switch
  is done without using ZLOG panel
  
  KEYWORDS : SQLPA DB2 ZLOG VTAM
  

Temporary fix

• Switch DB2 subsystem using VTAM ZLOG panel
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK45168

Modules/Macros

• KO2NDRVB KO2ODINB KO2OEVCB KO2OSQPB KO2PWHCB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK45168

     UP09/03/31 P F903

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.