PK37220: WRITE OUT TO PDS FILE FROM CUA MISSING THE FIRST CHARACTER FROM SQL STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CUA panel KD2OSQLD showed the correct SQL statement, but the
  write out to the PDS file chopped off the first charater from
  SQL statement, for example. 'Select .... from ....' would become
  'elect .... from ....'.
  .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   CUA Interface                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: WRITE OUT TO PDS FILE FROM CUA MISSING  *
  *                      THE FIRST CHARACTER FROM SQL STATEMENT  *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  THE FIRST CHARACTER OF EACH ROW OF SQL SAVED TO A PDS
  MEMBER IS TRUNCATED. ALTERNATELY, SQL DISPLAYED OR SAVED IS
  TRUNCATED.
  
  PROBLEM CONCLUSION:
  CODE WAS ADDED TO CHANGE THE DEFAULT ROWS COLLECTED TO
  THE MAXIMUM. ADDITIONALLY, THE LOGIC USED TO
  PARSE THE SQL STRING WAS CHANGED.
  

Problem conclusion

• CODE WAS ADDED TO CHANGE THE DEFAULT ROWS COLLECTED TO
  THE MAXIMUM. ADDITIONALLY, THE LOGIC USED TO
  PARSE THE SQL STRING WAS CHANGED.
  
  KEYWORDS: INCORROUT SQL PDS TRUNCATION
  

Temporary fix

Comments

APAR Information

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

  OA18071

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

  UK39755 UK39756

Modules/Macros

•    KD2$F11  KD2$NF11 KD2$SLOP KD2CCNVD KD2DINIT
  KD2ENTRY KD2SCYCL KD2SENAV KD2SLOG  KD2SOMEG KD2SQLUT KD2SVO
  KD2SYCL  KD2TSOLG KD2UTDCL KD2UTDTD
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK39755

     UP08/09/17 P F809

• R410 PSY UK39756

     UP08/09/17 P F809

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.