PK79186: NO THREAD DETAILS ARE AVILABLE IN ISPF OLM WHEN THREAD IS RUNNING STORED PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ISPF online monitor does not show thread details for threads
  running stored procedures, no error/warning messages are
  issued. Problem exist when OLM runs standalone or with the
  PEServer. PE client shows thread details correctly.
  
  -DIS THD(*) shows this thread with SP status :
  
  NAME     ST A   REQ ID           AUTHID   PLAN     ASID TOKEN
  SERVER   SP * 24229 dllhost.exe  UTICMADM DISTSERV 00B5 134931
   V437-WORKSTATION=SECD1ST101, USERID=UTICMADM,
        APPLICATION NAME=dllhost.exe
   V436-PGM=LILS1001.ICMPLSQU, SEC=2, STMNT=12492
   V429 CALLING PROCEDURE=$ILS1.ICMSEARCH,
        PROC=DE1GCMI1, ASID=00BB, WLM_ENV=DE1GCMI1
   V445-AC1D822D.BCBF.090428143453=134931 ACCESSING DATA FOR
        172.29.130.45
   V447--LOCATION         SESSID           A ST TIME
   V448--172.29.130.45    457:48319        W S2 0835011231861
  

Local fix

• Use PE client or Omegamon Classic (if possible) to see thread
  details for the failed threads
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - ISPF Monitoring dialogs                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: ISPF OLM does not show thread details   *
  *                      for threads running stored procedures   *
  *                      or threads in idle state. No message    *
  *                      is displayed. Problem exist when OLM    *
  *                      runs standalone or with the PEServer.   *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  ISPF OLM does not show thread details for threads running
  stored procedures or threads in idle state. No message is
  displayed. Problem exist when OLM runs standalone or with
  the PEServer.
  
  PROBLEM CONCLUSION:
  Thread details are shown now.
  
  KEYWORDS: THREAD-DETAIL STORED-PROCEDURE-THREAD IDLE-THREAD
  

Problem conclusion

• Thread details are shown now.
  
  KEYWORDS: THREAD-DETAIL STORED-PROCEDURE-THREAD IDLE-THREAD
  

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:

  UK45171

Modules/Macros

• DGOMDHIS DGOMSPOP DGOMTADJ DGOMTLST DGOMTPOP
  DGOMTPUR DGOMTREF DGOVTSOI DGOVUM02 FPEFMAIN FPEMMAIN FPEMMEND
  FPEMMSTH
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK45171

     UP09/03/27 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.