PI92839: EXCLUDED XML / LOB COLUMNS STILL REQUIRE TRACKING FOR LOADFILE /SQL GENERATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Currently when generating a LOADFILE or SQL for an object that
  contains XML or a LOB column, Log Analysis Tool requires the
  tracking of the XML / LOB data or an ALAA088W message is issued.
  If these XML and LOB columns are excluded from the LOADFILE and
  SQL generation, the product should not require XML / LOB data to
  be tracked. This APAR will create a code path to not require the
  tracking of XML and LOB data when the columns are excluded.
  However, if XML / LOB data is needed for one object for the
  LOADFILE / SQL generation, then it must be tracked for all
  objects in the filter set.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of ALA350                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Currently when generating a LOADFILE or *
  *                      SQL for an object that                  *
  *                      contains XML or a LOB column, Log Analy *
  *                      Tool requires the                       *
  *                      tracking of the XML / LOB data or an    *
  *                      ALAA088W message is issued.             *
  *                      If these XML and LOB columns are exclud *
  *                      from the LOADFILE and                   *
  *                      SQL generation, the product should not  *
  *                      require XML / LOB data to               *
  *                      be tracked. This APAR will create a cod *
  *                      path to not require the                 *
  *                      tracking of XML and LOB data when the   *
  *                      columns are excluded.                   *
  *                      However, if XML / LOB data is needed fo *
  *                      one object for the                      *
  *                      LOADFILE / SQL generation, then it must *
  *                      be tracked for all                      *
  *                      objects in the filter set.              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * 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

• ALABSQL
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI54241

     UP18/03/08 P F803

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.