PM48079: Message KD200050E in CUA panel KD2OSQLD (SQL Call Being Executed)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer using CUA gets the following error when viewing a
  Distributed Database Access Thread Detail and chooses GoTo(G)
  option 5. SQL Call Being Executed:
  .
   KD2SCYCL    OMEGAMON II for DB2
  .
  KD200050E Bridge Table Get error (8) for
  (KD2.BRIDGE.T0MD1.dM013188).
  .
    KD2@IERR    Omegamon II for DB2
  
        Error on DBtpLOGO, TBopen RC:8
  .
  Related error messages seen in CUA RKLVLOG:
  .
  2011.230 12:48:24.35 KLVDM012 LOOPCTR LIMIT EXCEEDED
  2011.230 12:48:24.35 KLVDM015 DIALOG(KD2OSQLD) MEMBER(KD2$PARS)
                       LINE(170) LU(OMD21385) APPL(OMD2P213)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   CUA Interface                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: KD200050E message on the screen and     *
  *                      log message "KLVDM012 LOOPCTR LIMIT     *
  *                      EXCEEDED" when displaying CUA panel     *
  *                      KD2OSQLD(SQL Call Being Executed).      *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  The loop count limit was set too small in CUA panel
  KD2OSQLD(SQL Call Being Executed) and loop protection
  was triggered unnecessarily.
  
  PROBLEM CONCLUSION:
  Increase loop count limit in CUA panel KD2OSQLD.
  

Problem conclusion

• Increase loop count limit in CUA panel KD2OSQLD.
  

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:

  UK73118 UK73119 UK73120

Modules/Macros

• KD2OSQLD
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK73118

     UP11/10/25 P F110

• R420 PSY UK73119

     UP11/10/25 P F110

• R510 PSY UK73120

     UP11/10/25 P F110

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.