PK03279: THIS APAR TAKEN TO RESOLVE SEVERAL PROBLEMS WITH DAE FOUND IN IBM INTERNAL TESTING.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INTERNAL
  This INTERNAL apar addresses several issues:
  1) Improved performance of the specification definition
  validation which occurs at save time and during
  execution.
  2) Correct a problem where Table name and creator names
  are truncated on the connection keys panel.
  3) Increase size of Row Filter for V7 DB2 to 2000 bytes.
  4) Reset size of scrollable field length for "creator" to 18.
  This corrects an incompatability between creator length and
  temp table definitions.
  5) Fix lowercase SQL in AHXTOOL. SQL errors occur when
  DAE runs under certain DBCS code pages.
  6) Copy archive target table/dataset mappings.
  7) Isolation level of archive run changed to run with
  CURSOR STABILITY.
  8) Remove automatic inclusion of DISTINCT when performing an
  archive.
  9) SQLCODE -532 when walking archive unit tree and performing
  deletes. 532
  10) SQLCODE -206 when validating the row filter. 206
  11) New interface for Get Related function.
  12) Performance improvement in performing the "GET RELATED"
  function.
  13) Connection Key panel abend when deleting circular
  references.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Data Archive Expert are         *
  *                 affected.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following issues are addressed:     *
  *                      .* Validation performance improvement.  *
  *                      .* Table name and creator name          *
  *                         truncation problem on panel          *
  *                         connection keys panel.               *
  *                      .* Increase size of Row Filter for V7   *
  *                         DB2.                                 *
  *                      .* Reset size of scrollable field       *
  *                         length for "creator" to 18.          *
  *                      .* Fix lowercase SQL in AHXTOOL.        *
  *                      .* Copy archive target table/dataset    *
  *                         mappings.                            *
  *                      .* Isolation level of archive run.      *
  *                      .* Remove automatic inclusion of        *
  *                         DISTINCT when performing an archive  *
  *                      .* -532 when walking archive unit tree  *
  *                         and performing deletes.              *
  *                      .* -206 when validating the row filter  *
  *                      .* New interface for Get Related        *
  *                         function.                            *
  *                         prerequisite Grouper APAR is:        *
  *                         PK05014                              *
  *                      .* Performance improvement in           *
  *                         performing the "GET RELATED"         *
  *                         function.                            *
  *                         prerequisite Grouper APAR is:        *
  *                         PK05014                              *
  *                      .* Connection Key panel abend when      *
  *                         deleting circular references.        *
  *                      .* Archive target table index created   *
  *                         differently.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fixes.
  

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:

  UK06708

Modules/Macros

• AHXAQUES AHXCRDB  AHXDCLTB AHXGRP   AHXHAQUE
  AHXJ00   AHXKEYS  AHXNKEYS AHXPRIM  AHXSDEF  AHXTKEYS AHXTOOL
  AHXV110
  

Fix information

• Fixed component name

  DB2 DATA ARCHIV

• Fixed component ID

  5655I9500

Applicable component levels

• R110 PSY UK06708

     UP05/09/15 P F509

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.