PI90323: ADDING A CONTINUEIF PARAMETER TO THE GENERATED DB2 LOADFILE AND LOADCARD

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Within Log Analysis Tool a LOADFILE can be generated in DB2 load
  format, but it is currently restricted to 32,752 bytes. The DB2
  Load Utility can process a record up to 32,767 bytes. This
  enhancement will add the additional 15 bytes by using a
  CONTINUEIF parameter. Also, if the actual length of the record
  using the CONTINUEIF parameter exceeds 32,767 a warning will be
  issued and the longer record will be still be generated. This
  record cannot be processed by DB2 and will have to be manually
  handled. This new functionality will be invoked by setting the
  new  Use CONTINUEIF in DB2 LOADFILE  field on the Load
  Expert Options panel to 'Y'.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of ALA350                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Within Log Analysis Tool a LOADFILE can *
  *                      be generated in DB2 load                *
  *                      format, but it is currently restricted  *
  *                      32,752 bytes. The DB2                   *
  *                      Load Utility can process a record up to *
  *                      32,767 bytes. This                      *
  *                      enhancement will add the additional 15  *
  *                      bytes by using a                        *
  *                      CONTINUEIF parameter. Also, if the actu *
  *                      length of the record                    *
  *                      using the CONTINUEIF parameter exceeds  *
  *                      32,767 a warning will be                *
  *                      issued and the longer record will be st *
  *                      be generated. This                      *
  *                      record cannot be processed by DB2 and w *
  *                      have to be manually                     *
  *                      handled. This new functionality will be *
  *                      invoked by a setting                    *
  *                      a new parameter (Load Expert Option) to *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• Apply the PTF
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI53054

Modules/Macros

• ALAAA5E  ALAA71   ALAA72   ALAFR6   ALAFR6X
  ALAGLOAD ALAGLOAT ALAGLS   ALAGLSUM ALAGL2   ALAGL3   ALAGL4
  ALALAUD  ALALDEL  ALAMSP
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI53054

     UP18/01/13 P F801

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.