PQ78705: NEW FUNCTION APAR

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function APAR
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Data Archive Expert release 110 *
  *                 are affected.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: This is a New Function APAR for DB2     *
  *                      Data Archive Expert Release 110.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This is a New Function APAR for DB2 Data Archive Expert
  Release 110.
  

Problem conclusion

Temporary fix

Comments

• The following migration and customization steps need to
  be done. After applying this PTF, and before executing the
  Data Archive Expert program, you must do the following:
  A. If this APAR is being applied to a Data Archive Expert
     for which metadata tables have already been created,
     you must customize and execute AHXALTDB in SAMPLIB in
     order to add new columns to AHXUSERPROPS.  This must be
     done for all of the defined schemas. If metadata tables
     have not been created, this step is not necessary; the
     modified version of the AHXCRMET member of SAMPLIB will
     create AHXUSERPROPS with the necessary columns.
  B. In all cases, you must customize and execute the AHXCRWDB
     member of SAMPLIB to create a working database and storage
     group. To customize this member, follow the instructions
     in the prolog of the AHXCRWDB file.
  C. If you choose names other that AHXFLWSG and AHXFLWDB, you
     must customize the AHXGRMET member of SAMPLIB in order
     to grant the needed authorities on these objects.).
  .*
  A prerequisite PTF on DB2 Version 7, UQ80540, is needed for
  the PTF of APAR PQ78705. PTF UQ80540 is for DB2 Release 710
  APAR PQ78704.
   ++ IF FMID(HDB7710) THEN REQ (UQ80540)
  .*
  You need to reference DB2 APAR PQ51163 - Secondary Auth Id
  doesn't take effect for Stored Procedure DSNUTILS invoking
  DB2 Utility.  To enable Secondary Auth id support, the
  identify exit may be changed so that the task level ACEE
  is used.
  .*
  If you have modified any part that happens to be a part in
  the PTF package, the modification you made will be gone
  after the APPLY of the PTF is done. For example, if you have
  made any changes to any of the members in the SAHXSAMP
  dataset that happens to be a part included in this PTF, you
  may want to save them before installing the PTF.
  

APAR Information

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

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

  UQ84696

Modules/Macros

• AHXALIST AHXALTDB AHXATLCM AHXCRMET AHXCRSTP
  AHXCRWB  AHXDEFPR AHXDFRET AHXDPSTP AHXERRRS AHXFLWPU AHXGETTS
  AHXGRCAT AHXGREXP AHXGRMET AHXGRP   AHXGRSTP AHXGTABS AHXGTMPL
  AHXHFLWP AHXHSETT AHXIDXCL AHXIVPAR AHXIVPRN AHXJ01   AHXJ13
  AHXOF2DS AHXONLN  AHXRETDF AHXRETRV AHXRLLCM AHXSCTAB AHXSDEF
  AHXSDEFB AHXSDEFC AHXSDEFF AHXSETTS AHXSLIST AHXSPECI AHXSPECT
  AHXSRUN  AHXSVERS AHXTOOL  AHXTSFLT AHXUNIT  AHXVALO3 AHXVALO5
  AHXVALO6 AHXVTARG AHXV110  AHX23    AHX43    AHX44
  

Fix information

• Fixed component name

  DB2 DATA ARCHIV

• Fixed component ID

  5655I9500

Applicable component levels

• R110 PSY UQ84696

     UP04/03/03 P F403

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.