PI61980: LOAD WITH VERY LARGE NUMBER OF ROWS RESULTS IN U4039 AND IBM0301S ONCODE=320

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When loading a DB2 table with a very large load file (for
  example, more than 2.5 billion rows), the ADBTEP2 program
  may end with:
  
  USER COMPLETION CODE=4039
  IBM0301S ONCODE=320 The ZERODIVIDE condition was raised.
  From entry point CHECKUTILFROMCONTENT at statement 37475 at
  compile unit offset +000026D4 at entry offset
  +000026D4 at address
  26BF305C.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Batch Restart program ADBTEP2   *
  *                 to run Work Statement List (WSL).            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Batch Restart program        *
  *                      ADBTEP2 to run a WSL which contains     *
  *                      an UNLOAD statement with NUMRECS        *
  *                      value equal to or greater than          *
  *                      2147483648, the ADBTEP2 job issues      *
  *                      an ONCODE=320 'The ZERODIVIDE           *
  *                      condition was raised' and stops         *
  *                      processing.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using Batch Restart program ADBTEP2 to run a WSL which
  contains an UNLOAD statement with NUMRECS value equal to or
  greater than 2147483648, the ADBTEP2 job issues an ONCODE=320
  'The ZERODIVIDE condition was raised' and stops processing.
  
  IBM0301S ONCODE=320 The ZERODIVIDE condition was raised.
           From entry point CHECKUTILFROMCONTENT at
           statement 37475 at compile unit offset >offset< at
           entry offset >offset< at address >address<.
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI39690 UI39691

Modules/Macros

•    ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI39690

     UP16/08/04 P F608

• RB20 PSY UI39691

     UP16/08/04 P F608

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.