PK19476: DYNAMIC SQL FOR DB2 V8 distributed threads is not available in thread history.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Dynamic SQL for DB2 V8 distributed threads is not available in
  Thread History. UA16463 and UA16501 have already been applied.
  
  ________________ ZHTCALL VTM O2 V540./C D2PA 05/25/05 12:40:24 2
  > Help PF1 Back PF3 Up PF7 Down PF8
  >          THREAD HISTORY:  Enter a selection letter on the top
  line.
  > A-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS D-GLOBAL LOCKS
  E-SORT/SCAN
  > *-DYNAMIC SQL G-SQL COUNTS H-DISTRIBUTED I-BUFFER POOL J-GROUP
  BP
  > K-PACKAGE SUMMARY L-RES LIMIT    M-PARALLEL TASKS
  ================================================================
  ========
  =======
  >                      THREAD HISTORY DYNAMIC SQL CALLS
   HPLN
  + Thread: Plan=DISTSERV Connid=SERVER Corrid=JAVA.EXE
  Authid=US0356A5
  + Attach:  APPLDIR        DB2=D2PA        MVS=SYSF
  + Time : Start=05/25/2005 12:27:03.337616 End=05/25/2005
  12:44:16.249982
   call
  +
  : Select Call=NEXT
  (FIRST/LAST/NEXT/PREV/+nnnnn/-nnnnn/Snnnnn)
  +
  +                              SQL Statement      (       1 of
  3)
  +
  +      Dynamic SQL record for this call is not present on the
  dataset
  ================================================================
  

Local fix

• do not use missing data
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Calculation of start and end time for   *
  *                      the rolled up accounting records        *
  *                      is not correct so no statements were    *
  *                      found within the timestamp range of     *
  *                      accumulated group of threads.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• For ACCUMAC rolled up accounting records calculate the correct
  timestamp range for locating matching SQL statements.
  SYSMOD Title: Various forward fits
  Keywords: Near Term History SQL TEXT INCORROUT ZHTCALL
  

Temporary fix

Comments

APAR Information

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

  OA12099

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

Modules/Macros

•    DUMM1KO2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM/

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSN UK13001

     UP06/03/29 P F603

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.