PQ93616: SQLCODE -302 SQLCODE302 WHEN USING MAXIMUM LENGTH TABLE NAMES AND PERFORMING A FILE RETRIEVE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IBM INTERNALLY FOUND PROBLEMS
  1) SQLCODE -302 sqlcode302 when using maximum length table
     names and performing a file retrieve.
  2) Fix the index space calculation for the index created
     on an archive target table after the insert phase of an
     archive.
  3) Allow parallel execution of the same archive-to-file
     specification.
  4) ERROR MESSAGE working data set DD names missing.
     REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=SORTOUT
  5) Retrieve a file archive ds to a retrieve target table
     defined with an index.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Data Archive Expert are         *
  *                 affecte.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The purpose of this APAR is as follow:  *
  *                      -- allow parallel execution of the      *
  *                      same archive to file specification.     *
  *                      -- retrieve a file archive data set     *
  *                      to a retrieve target table defined      *
  *                      with an index (for those users who      *
  *                      receive errors indicating that working  *
  *                      data set DD names are missing, the      *
  *                      problem is fixed).                      *
  *                      -- fix SQLCODE -302 when using maximum  *
  *                      length target table names when          *
  *                      performing a file retrieve.             *
  *                      -- fix index space calculation for the  *
  *                      index that is created on an archive     *
  *                      target table after the insert phase of  *
  *                      an archive.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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:

  UK00844

Modules/Macros

• AHXALMET AHXCRDB  AHXCRMET AHXHDFRE AHXHOF2D
  AHXHSETT AHXHSFLT AHXHSINF AHXHSLIS AHXHSOFF AHXHSRNV AHXHSVER
  AHXJ00   AHXPRIM  AHXTOOL  AHXV110  AHX8CMET
  

Fix information

• Fixed component name

  DB2 DATA ARCHIV

• Fixed component ID

  5655I9500

Applicable component levels

• R110 PSY UK00844

     UP05/03/09 P F503

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.