PI42736: ABENDU101 WITH DB2 FORCE UNLOADING PARTITIONED TABLE WITH TEMPLATE NAME ENDING WITH A NUMBER AND EXTERNAL SORT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ABENDU1010 occurs when the following conditions are
  fullfilled:
  - a logical unload is processed in SQL mode (the unload command
  specified either DB2 FORCE or DB2 YES and an unsupported SQL
  statement)
  - the SQLPART option is specified
  - an ORDER clause is specifed
  - Note: the above three conditions requires the sort be process
  in external mode. Either the SRT(EXTERNAL...) was specified in
  in the unload command or this mode is forced as reported by
  msgINZU512I (INFORMATION: IN SELECT STARTING AT POS(x,y)
  SORT(EXTERNAL) OPTION IS SET BY UTILITY TO PERFORM ORDER BY)
  
  - the output data sets per partition are allocated via a
  TEMPLATE statement (that specifies &PART) which name end with
  numbers
  For example: the issue occurs with an unload statement as
  follows:
  TEMPLATE SYSREC01
  DSN 'MZLCT.&DB..&TS..P&PART..&UQ.'
  UNIT WORK
  SPACE (030,010) TRK  DISP (NEW,CATLG,DELETE)
  UNLOAD TABLESPACE
  DB2   FORCE
  SELECT *
  FROM MZLFLB.TBDZAAFLBM1H01
  SQLPART(ALL)
  ORDER BY 1
  OUTDDN(SYSREC01) FORMAT DSNTIAUL
  
  PB12809
  

Local fix

• Use a template name that does not have a number at the end (e.g.
  SYSREC instead of SYSREC01).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABENDU1010 occurs when the           *
  *                      following conditions are fullfilled:    *
  *                      - a logical unload is processed in      *
  *                       SQL mode (the unload command           *
  *                       specified either DB2 FORCE or DB2 YES  *
  *                       and an unsupported SQL statement)      *
  *                      - the SQLPART option is specified       *
  *                      - an ORDER clause is specifed           *
  *                      - Note: the above three conditions      *
  *                       requires the sort be process in        *
  *                       external mode. Either the              *
  *                       SRT(EXTERNAL...) was specified in the  *
  *                       unload command or this mode is forced  *
  *                       as reported by msgINZU512I             *
  *                       (INFORMATION: IN SELECT STARTING AT    *
  *                       POS(x,y)                               *
  *                              SORT(EXTERNAL) OPTION IS SET    *
  *                       BY UTILITY TO PERFORM ORDER BY)        *
  *                      - the output data sets per partition    *
  *                       are allocated via a TEMPLATE           *
  *                       statement (that specifies &PART)       *
  *                       which name end with figures            *
  *                      For example: the issue occurs with an   *
  *                       unload statement as follows:           *
  *                      TEMPLATE SYSREC01                       *
  *                      DSN 'MZLCT.&DB..&TS..P&PART..&UQ.'      *
  *                      UNIT WORK                               *
  *                      SPACE (030,010) TRK                     *
  *                       DISP (NEW,CATLG,DELETE)                *
  *                      UNLOAD TABLESPACE                       *
  *                      DB2 FORCE                               *
  *                      SELECT *                                *
  *                      FROM MZLFLB.TBDZAAFLBM1H01              *
  *                      SQLPART(ALL)                            *
  *                      ORDER BY 1                              *
  *                      OUTDDN(SYSREC01) FORMAT DSNTIAUL        *
  *                      pb 12809                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• The module inzctrlh was changed.
  

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 UI29639

     UP15/07/25 P F507

• R430 PSY UI29640

     UP15/07/25 P F507

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.