PH57098: EXPLAIN IN SQL PA ENDS WITH CODE -060 AND -60 DUE TO THE WRONG LIMIT IN CAST FUNCTION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Explain in SQL PA ends with code -060 and -60 due to the wrong
  limit in CAST function.
  

Local fix

• BYPASS/CIRCUMVENTION:
  NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 SQL Performance Analyzer        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1) Explain in SQL PA ends with codes -060 and -60 due to wrong
  limit in CAST function
  2) Problem with Bind package in TCz for some jobs
  

Problem conclusion

• 1) Limits for CAST function in Explain statement have been
  updated
  2) Removed reference for outdated program ANLBIND and add bind
  instructions to a JCL
  

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:

  UI94563

Modules/Macros

• ANLMAIN  ANLSQLPA ANLTSO   ANLWLMSP
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI94563

     UP23/11/23 P F311

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.