PM00183: MISSING DYNAMIC SQLS IN NTH FOR MULTIPLE TASKS-THREADS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer uses the Oracle Database Heterogeneous
  Services. Oracle references to multithreaded
  Agents - please see the following link:
  
  http://download.oracle.com/docs/cd/B19306_01/server.102/b14232/
  multithr.htm#i1005924
  
  Sometimes it happens that a user action is handled from
  multiple tasks-threads. In this case DYNAMIC SQL in Near Term
  History is not being collected for every thread. When zooming
  on a distributed thread that issued Dynamic SQL, panel ZHTCALL
  displays message
  
     No Dynamic SQL statements were issued by this Thread
  
  Customer would like OmPE to show each thread in DB2 with
  it's DYNAMIC SQL
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   OMEGAMON collector                       *
  *                 -   Classic Interface                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Missing dynamic SQL for DISTSERV        *
  *                      threads sometime                        *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Uniqueness value is not enough to correlate all the performance
  IFCIDs associated with a thread in Near Term History.
  
  
  PROBLEM CONCLUSION:
  Use LUWID to retrieve thread's dynamic SQL information.
  

Problem conclusion

• Use LUWID to retrieve thread's dynamic SQL information.
  
  KEYWORDS : LUWID  SQL PERFORMANCE IFCID
             DYNAMIC SQL FOR DISTSERV THREADS
  

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:

Modules/Macros

• DUMM4KO2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSN UK55568

     UP10/03/31 P F003

• R420 PSN UK55569

     UP10/03/31 P F003

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.