PI47438: SORT PERFORMED WITH FIXED LENGTH FIELDS (THE SORT PARAMETER TYPE=F IS SPECIFIED WHILE TYPE=V IS EXPECTED)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When processing in native mode a logical unload against a view
  and specifying an ORDER clause, although the internal processing
  and especially the sort operation should be done using records
  with variable length fields since
  - the table belongs to table space in RRF format,
  - all the table of the table are to be unloaded,
  - the table has variable length columns,
  the sort is performed using records with fixed length fields
  (the SORT parameter TYPE=F is specified while TYPE=V is
  expected).
  
  PB12846
  

Local fix

• Consider unloading from the table instead of from the view.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When processing in native mode a        *
  *                      logical unload against a view and       *
  *                      specifying an ORDER clause, although    *
  *                      the internal processing and especially  *
  *                      the sort operation should be done       *
  *                      using records with variable length      *
  *                      fields since                            *
  *                      - the table belongs to table space in   *
  *                       RRF format,                            *
  *                      - all the table of the table are to be  *
  *                       unloaded,                              *
  *                      - the table has variable length         *
  *                       columns,                               *
  *                      the sort is performed using records     *
  *                      with fixed length fields (the SORT      *
  *                      parameter TYPE=F is specified while     *
  *                      TYPE=V is expected).                    *
  *                      PI12846                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzctrl and oddlx2y modules were changed.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI32342

     UP15/11/26 P F511

• R430 PSY UI32343

     UP15/11/28 P F511

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.