PK57213: MSGINZU505E SORT SIZE CANNOT BE ESTIMATED WHEN TABLE TO BE UNLOADED HAS NO INDEX AND IS IN A MULTI-TABLE TS. PB 9092

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INZU505E ERROR:
  ERROR: SORT SIZE CANNOT BE ESTIMATED FOR SELECT STARTING AT
  POS(m,n).
   YOU MUST SPECIFY THE ESTIMATED NUMBER OF ROWS TO BE SORTED
  INSTEAD OF 'VSAMSIZE' KEYWORD.
  Error occurs when the table to be downloaded has no index and
  is in a multi-table tablespace. PB 9092
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When SORT EXTERNAL VSAMSIZE is          *
  *                      requested on a table thas has no index  *
  *                      and that is located in a table space    *
  *                      that contains other tables on which     *
  *                      indexes exist, HPU may issue message    *
  *                      INZU505E ERROR: SORT SIZE CANNOT BE     *
  *                      ESTIMATED FOR SELECT STARTING AT        *
  *                      POS(10, 6) YOU MUST SPECIFY THE         *
  *                      ESTIMATED NUMBER OF ROWS TO BE SORTED   *
  *                      INSTEAD OF 'VSAMSIZE' KEYWORD.          *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Modules oestime and inzpab were changed to take the CARDF value
  into account for size estimation when a multitable table
  space is involved.
  

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:

  UK32170

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK32170

     UP07/12/18 P F712

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.