PK67764: SQLCODE -104 ON SYSPRINT WHEN CHOOSING SQLPA FROM CLASSIC AND VIEWING THE EXPLAIN.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE -104 on sysprint when choosing SQLPA from Classic and
  viewing the EXPLAIN.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using SQLPA from the classic       *
  *                      interface, it may happen that SQLCODE   *
  *                      -204 is displayed in the SYSPRINT of    *
  *                      the SQLPA reports.                      *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  In some case blanks are missing in the SQL statement used by
  SQLPA. The SQL statement stored in the ANLIN used the
  complete record length (72 chars). Now the SQL statement is
  splitted after 70 chars.
  
  PROBLEM CONCLUSION:
  The SQL statement stored in the ANLIN is now splitted after 70
  chars to be sure that we have at least one blank at the end of
  each line.
  

Problem conclusion

• The SQL statement stored in the ANLIN is now splitted after 70
  chars to be sure that we have at least one blank at the end of
  each line.
  
  KEYWORDS :
  SQLPA VTAM SQLCODE -204 SYSPRINT BLANKS MISSING
  

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:

  UK37519

Modules/Macros

• DGO@SQPA DGOZSQPA
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK37519

     UP08/06/24 P F806

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.