PH59569: TWO SORTDEVT OPTIONS FOR LOAD DATA ARE GENERATED WHEN MIG PANEL ADB28M INPUT FIELDS UNLOAD METHOD = HPU AND PARALLEL UTILITIES =

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When MIG panel ADB28M has the following input fields set:
  Unload Method . . . H (U - Unload, H - HPU, C - Cross)
  Parallel utilities = YES
  
  ... two SORTDEVT options for LOAD DATA are generated like the
  following when the generated MIG Source job ADBMGS1 is
  submitted:
  
  ISREDDE2   TS5776.TESTE.CNC.T1
  Columns 00001 00072
  Command ===>
  Scroll ===> CSR
  ****** ***************************** Top of Data
  ******************************
  000001 LOAD DATA
  000002   SORTDEVT SYSALLDA  SORTKEYS 1
  000003 EBCDIC CCSID(0037)
  000004
  000005   SORTDEVT SYSDA
  000006   LOG YES
  000007   ENFORCE NO
  000008   ERRDDN SYSERR
  000009   DISCARDDN SYSDISC
  000010   DISCARDS 0
  000011 INTO TABLE
  000012 TS5776.TBFGRA
  000013 (
  000014 A
  000015      POSITION (     1  )        INTEGER
  000016  ,
  000017 B
  000018      POSITION (     6  )        CHAR (     3 )
  000019      NULLIF(     5 ) = X'FF'
  000020
  000021 )
  000022
  ****** **************************** Bottom of Data
  ****************************
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Generated MIG Target job ADBMGT1        *
  *                      fails with RC=8.                        *
  ****************************************************************
  MIG panel ADB28M has the following input fields set:
  Unload Method . . . H (U - Unload, H - HPU, C - Cross)
  Parallel utilities = YES
  
  Given those settings, two SORTDEVT options for the LOAD DATA
  record are generated, which cause the MIG target job ADBMGT1
  to fail with the following error:
  ADB7953I ADBTEP2  DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
  DSNU000I    032 20:55:25.10 DSNUGUTC - OUTPUT START FOR UTILITY,
  DSNU1044I   032 20:55:25.11 DSNUGTIS - PROCESSING SYSIN AS
  EBCDIC
  DSNU005I    032 20:55:25.11 DSNUGPTC - LOAD DATA
  DSNU005I    032 20:55:25.11 DSNUGPTC -   SORTDEVT SYSDA
  SORTKEYS 1
  DSNU005I    032 20:55:25.11 DSNUGPTC - EBCDIC CCSID(0037)
  DSNU005I    032 20:55:25.11 DSNUGPTC -
  DSNU005I    032 20:55:25.11 DSNUGPTC -   SORTDEVT SYSDA
  DSNU094I    032 20:55:25.11 DSNUGPTC - KEYWORD 'SORTDEVT'
  IS DUPLICATED
  DSNU005I    032 20:55:25.11 DSNUGPTC -   LOG YES
  DSNU005I    032 20:55:25.11 DSNUGPTC -   ENFORCE NO
  DSNU005I    032 20:55:25.11 DSNUGPTC -   ERRDDN SYSERR
  DSNU005I    032 20:55:25.11 DSNUGPTC -   DISCARDDN SYSDISC
  DSNU005I    032 20:55:25.11 DSNUGPTC -   DISCARDS 0
  DSNU005I    032 20:55:25.11 DSNUGPTC - INTO TABLE
  .
  .
  .
  DSNU012I    032 20:55:25.11 DSNUGBAC - UTILITY EXECUTION
  TERMINATED, HIGHEST RETURN CODE=8
  

Problem conclusion

• The issue has been resolved.
  

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:

  UI96472 UI96473

Modules/Macros

• ADB28MC  ADB2REPB ADB2US   ADB2USC  ADBEDIAG ADBEUSZC ADBSCMDL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI96472

     UP24/04/12 P F404

• RD10 PSY UI96473

     UP24/04/12 P F404

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.