PK19447: PANEL KD2VDTDD ISSUE G5 COMMAND AND GET POP-UP THAT THERE ARE NOT SQL CALLS BEING EXECUTED BY THE THREAD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In the CUA coming through the All Connection option to see
  threads and then see the SQL executing works. Coming through
  Distributed thread option results in a message
  Your Request cannot be processed
  because there are not SQL calls
  being executed by this thread
  
  From Panel KD2001 user select Distributed Threads
  On panel KD2ODISD user selects a thread
  
  On Panel KD2VDTDD user issue a G5 command to go to the
  SQL being executed and receives pop up listed above
  
  But if on panel KD2001 they select All Threads
  Then on panel KD2OACOD user selects All Connections
  Then on panel KD2OATCD user selects a specific thread
  Then on panel KD2VTHD6 issues G3 to go to SQL statement the text
  of the excuting SQL can be seen
  

Local fix

• From Panel KD2001 user select Distributed Threads
  On panel KD2ODISD user selects a thread
  
  On Panel KD2VDTDD user issue a G5 command to go to the
  SQL being executed and receives pop up listed above
  
  But if on panel KD2001 they select All Threads
  Then on panel KD2OACOD user selects All Connections
  Then on panel KD2OATCD user selects a specific thread
  Then on panel KD2VTHD6 issues G3 to go to SQL statement the text
  of the excuting SQL can be seen
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of OMEGAMON XE for DB2 PE/DB2PM V310   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Unable to get SQL text when command     *
  *                      G5 is issued from panel KD2OSQLD.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Retrieve SQL text.
  SYSMOD TITLE: Missing SQL text when using G5 command from KD2OSQ
  KEYWORDS:     INCORROUT KD2OSQLD SQL TEXT
  

Temporary fix

Comments

APAR Information

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

  OA13380

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

Modules/Macros

•    KD2OSQLD
  

Fix information

• Fixed component name

  OM XE DB2PE/PM/

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK13697

     UP06/04/21 P F604

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.