PM21332: ABEND80A-10 WHEN THE EXPRESSION INVOLVES THE CONCAT FUNCTION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU320 only: ABEND80A with reason code 10 or ABEND878 can occur
  when a logical unload processed natively (supported SELECT
  statement with DB2 NO or DB2 YES) includes an expression
  involving the CONCAT function or CONCAT operator. The problem is
  more likely to occur when the CONCAT result is used as the right
  operand of a logical operator.
  
  80A 878 S80A S878 ABEND80A ABEND878 ABENDS80A ABENDS878
  
  PB10852
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND80A with reason code 10 or ABEND   *
  *                      878 can occur when a logical unload     *
  *                      processed natively (supported SELECT    *
  *                      statement with DB2 NO or DB2 YES)       *
  *                      includes an expression involving the    *
  *                      CONCAT function or concat operator.     *
  *                      The problem is more likely when the     *
  *                      concat result is used as the right      *
  *                      operand of a logical operator.          *
  *                      PB 10852                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inznode module optimization algorithm was fixed.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

•    INZI01   INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK61475

     UP10/10/25 P F010

• R410 PSY UK61476

     UP10/10/25 P F010

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.