PM11788: KO2O1949E MESSAGE RETURN CODE FFFFFF98 REASON CODE 028C WHEN TRYING TO ACCESS SQLPA REPORTS FROM OMPE CLASSIC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Env: OmPE V410, DB2 SQL Performance Analyzer V3.2, DB2 V8CM
  
  Prb: Customer would like to use SQL PA Report from OmPE Classic
  session by selecting "V : SQL PA REPORTS" on Classic Main Menu
  panel. Then following error message is displayed and customer
  cannot get SQL PA reports :
  
  >> KO2O1949E PERFORMANCE WAREHOUSE REQUEST FAILED (O2OSQP  ) <<
  >> REQUEST=getSqlPaCnt   RETURN CODE=FFFFFF98  (  -104)
  REASON CODE=0000028C  (   652)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLPA is not working on a Japanese      *
  *                      environment. Illegal token is found     *
  *                      in the SQL statements.                  *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  The SQL statements were not in upper-case. The code page in use
  on Japanese system does not recognize them.
  
  PROBLEM CONCLUSION:
  The SQL statements are now in upper-case.
  

Problem conclusion

• The SQL statements are now in upper-case.
  
  KEYWORDS :
  SQLPA VTAM PWH ILLEGAL TOKEN -104
  

Temporary fix

Comments

APAR Information

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

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

  UK56309 UK56310

Modules/Macros

• DGO@SAPI DGOZSAPI
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK56309

     UP10/04/28 P F004

• R420 PSY UK56310

     UP10/04/28 P F004

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.