PI91071: VARIOUS ISSUES WITH GENERATING A DELIMITED OR FIXED FORMAT LOADFILE WITH MULTIPLE TABLES IN A SEGMENTED TABLESPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If there are multiple tables in a segmented TABLESPACE and a
  delimited or fixed format LOADFILE is requested. The OBID on
  the first record of the second table, if requested, could not
  be correct. Similarly if under certain circumstances, the
  LOADCARD file may not be generated for the second table.
  Also, if specifying a source and target table for these
  objects, only the last table specified would be included.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of ALA350                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: If there are multiple tables in a       *
  *                      segmented TABLESPACE and a              *
  *                      delimited or fixed format LOADFILE is   *
  *                      requested. The OBID on                  *
  *                      the first record of the second table,   *
  *                      if requested, could not                 *
  *                      be correct. Similarly if under certain  *
  *                      circumstances, the                      *
  *                      LOADCARD file may not be generated for  *
  *                      the second table.                       *
  *                      Also, if specifying a source and target *
  *                      table for these                         *
  *                      objects, only the last table specified  *
  *                      would be included.                      *
  *                                                              *
  ****************************************************************
  * 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:

Modules/Macros

• ALAA72
  

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.