PK41275: IN DB2 V8 STATUS OF DISTRIBUTED THREADS IN ZTDTL IS CHANGED FROM IN-DB2 TO NOT-IN-DB2 AFTER SCREEN IS REFRESHED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Select T from the primary Classic menu
  
   ________________ ZALLT    VTM     O2       V540./C
  > Help PF1      Back PF3       Up PF7      Down PF8
  > T.A
  >         THREAD ACTIVITY:  Enter a selection letter
  
  > *-ALL         B-TSO      C-CICS      D-IMS     E-B
  > G-DIST DBAC   H-UTIL     I-INACT     J-FILTER  K-F
  > M-TRIGGERS    N-SYSPLEX  O-ENCLAVES  P-WORKSTA
  ====================================================
  >                       ALL THREADS CONNECTED TO DB2
   THDA
  + *
  + Elapsed      Planname  CPU    Status       GetPg
  + ----------   --------  -----  ------------ ------
  + 01:32:41.8   KO2540HP  00.0%  NOT-IN-DB2        0
  + 00:07:54.6   DSNESPRR  00.0%  IN-DB2           52  - correct
  + 00:06:26.2   KO2540HP  00.0%  NOT-IN-DB2        0
  
  then ZOOM on distriduted thread (DSNESPRR)
  
   ________________ ZTDTL    VTM     O2       V5
  > Help PF1
  
  >       THREAD INFORMATION:  Enter a selection
  
  > *-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS
  > F-CURRENT SQL   G-SQL COUNTS  H-DISTRIBUTED
  > K-PACKAGES      L-RES LIMIT   M-PARALLEL TAS
  > P-CANCEL THREAD Q-DB2 CONSOLE R-DSN ACTIVITY
  > U-LONG NAMES
  ==============================================
  >                                THREAD DETAIL
   PLAN
  + Thread:  Plan=DSNESPRR  Connid=TSO      Corr
  + Dist  :  Type=DATABASE ACCESS, Luwid=USCACO0
   act
  + Thread Activity                         User
  + -------------------------------------   ----
  + DB2 Status            =        IN-DB2   TCB  - still correct
  + MVS Status            =                 Wait
  + Total Elapsed Time    =  00:09:35.062   Elap
  + CPU Utilization       =         00.0%   Elap
  + Total CPU Time        =  00:00:00.012   SQL
  + Total Parallel Tasks  =             0
  + Current Parallel Tasks=             0
  +
  + Stored Procedures                       Trig
  
  then press ENTER to update the data
  
   ________________ ZTDTL    VTM     O2       V5
  > Help PF1
  
  >       THREAD INFORMATION:  Enter a selection
  
  > *-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS
  > F-CURRENT SQL   G-SQL COUNTS  H-DISTRIBUTED
  > K-PACKAGES      L-RES LIMIT   M-PARALLEL TAS
  > P-CANCEL THREAD Q-DB2 CONSOLE R-DSN ACTIVITY
  > U-LONG NAMES
  ==============================================
  >                                THREAD DETAIL
   PLAN
  + Thread:  Plan=DSNESPRR  Connid=TSO      Corr
  + Dist  :  Type=DATABASE ACCESS, Luwid=USCACO0
   act
  + Thread Activity                         User
  + -------------------------------------   ----
  + DB2 Status            =    NOT-IN-DB2   TCB  - incorrect!
  + MVS Status            =                 Wait
  + Total Elapsed Time    =  00:10:18.907   Elap
  + CPU Utilization       =         00.0%   Elap
  + Total CPU Time        =  00:00:00.012   SQL
  + Total Parallel Tasks  =             0
  + Current Parallel Tasks=             0
  +
  + Stored Procedures                       Trig
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   OMEGAMON Server                          *
  *                 -   Classic Interface                        *
  *                 -   CUA Interface                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Status of Distributed Threads in    *
  *                      ZTDTL panel is changed from IN-DB2 to   *
  *                      NOT-IN-DB2 after screen is refreshed.   *
  ****************************************************************
  * RECOMMENDATION: APPLY THIS PTF.                              *
  ****************************************************************
  An internal pointer was not set correctly. The status was for
  the wrong thread.
  

Problem conclusion

• Change code to obtain the status for the correct thread.
  
  KEYWORDS : INCORRECT DBAC DB2 STATUS NOT-IN-DB ZTDTL REFRESH
  

Temporary fix

Comments

APAR Information

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

  OA19333

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

  UK24520 UK24521

Modules/Macros

•    KO2CTHSA KO2CTHSS KO2CTHS2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK24520

     UP07/05/03 P F705

• R410 PSY UK24521

     UP07/05/03 P F705

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.