PM60606: ABEND0C1 ABEND0C4 ABEND0C7 OR INCRRECT NUMBER OF ROWS IF MOD EXPRESSION PART OF PREDICATE IN WHERE CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload involving either the SQL expression
  MOD(smallint_data) or MOD(decimal_data) might give an incorrect
  result.
  
  The known symptoms are:
  - ABEND0C1
  - ABEND0C4
  - ABEND0C7
  - incorrect number of rows (if the MOD expression is part
    of a predicate in a WHERE clause)
  - incorrect value of the field containing the MOD() expression
  
  PB11496   ABENDS0C1 S0C1 0C1 ABENDS0C4 S0C4 0C4 ABENDS0C7
            S0C7 0C7   Missing rows
  

Local fix

• replace the MOD function by the equivalent
  formula MOD(x,y) = x - BIGINT(x/y) * y
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload involving either the   *
  *                      SQL expression MOD(smallint_data) or    *
  *                      MOD(decimal_data) might give an         *
  *                      incorrect result. The known symptoms    *
  *                      are:                                    *
  *                      - ABEND0C1                              *
  *                      - ABEND0C4                              *
  *                      - ABEND0C7                              *
  *                      - incorrect number of rows (if the      *
  *                       MOD expression is part of a predicate  *
  *                       in a WHERE clause)                     *
  *                      - incorrect value of the field          *
  *                       containing the MOD() expression        *
  *                      PB 11496                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  udbspgsq was changed to allocate the relevant work area.
  

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

•    INZRSAVE INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK77749

     UP12/04/12 P F204

• R410 PSY UK77750

     UP12/04/12 P F204

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.