PI86542: ALAA470E DURING LOAD ON 32K PAGESIZES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When an object has a record length that approaches the maximum
  allowed by DB2, the process to generate a LOADFILE could fail
  with an ALAA470E due to headers whether requested or forced for
  object identification.
  .
  This APAR will allow the LOADFILE / LOADCARD to still be
  generated as long as the last column is a VARCHAR and the actual
  length of the VARCHAR data along with the length of the rest of
  the data in the record being created does not exceed 32752.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of ALA350                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: *****PI86542*****                       *
  *                      When an object has a record length      *
  *                      that approaches the maximum             *
  *                      allowed by DB2, the process to          *
  *                      generate a LOADFILE could fail          *
  *                      with an ALAA470E due to headers         *
  *                      whether requested or forced for         *
  *                      object identification.                  *
  *                      .                                       *
  *                      This APAR will allow the                *
  *                      LOADFILE / LOADCARD to still be         *
  *                      generated as long as the last column    *
  *                      is a VARCHAR and the actual             *
  *                      length of the VARCHAR data along with   *
  *                       the length of the rest of              *
  *                      the data in the record being created    *
  *                      does not exceed 32752.                  *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  

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:

  UI51274

Modules/Macros

• ALAA72   ALACTAU  ALAETV   ALAGLOAD ALALFP
  ALALF1   ALAMSP   ALASBDB  ALASQ1CB ALATCZD  ALAZH030
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI51274

     UP17/10/25 P F710

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.