PI60818: THERE ARE DUPLICATE "FORMAT SPANNED YES" SPECIFICATIONS IN LOAD STATEMENT GENERATED IN MIG PATH WITH SPANNED=YES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• There are duplicate "FORMAT SPANNED YES" specifications in LOAD
  statement generated in MIG path with SPANNED=YES on panel
  ADB2UTC(LOAD option) and Spanned=YES on panel ADB2UPA.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who migrate LOB objects.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When migrating LOB objects, Error       *
  *                      message 'KEYWORD SPANNED' IS            *
  *                      DUPLICATED' is observed by either       *
  *                      of the following:                       *
  *                                                              *
  *                      1. Specify SPANNED = YES on panel       *
  *                      ADB2UPA 'Batch Job Utility Parameters'  *
  *                      and specify SPANNED = YES on panel      *
  *                      ADB2UTC 'Specify Utility Options        *
  *                      - LOAD'.                                *
  *                                                              *
  *                      2. Specify SPANNED = YES on panel       *
  *                      ADB2UPA 'Batch Job Utility              *
  *                      Parameters' and specify SPANNED =       *
  *                      YES on panel ADB2USU 'Specify Utility   *
  *                      Options - UNLOAD'.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When migrating LOB objects with either of the following
  settings:
  
  1. Specify SPANNED = YES on panel ADB2UPA 'Batch Job Utility
  Parameters' and specify SPANNED = YES on panel ADB2UTC
  'Specify Utility Options - LOAD'.
  
  2. Specify SPANNED = YES on panel ADB2UPA 'Batch Job
  Utility Parameters' and specify SPANNED = YES on panel
  ADB2USU 'Specify Utility Options - UNLOAD'.
  
  the following error will occur after submitting the
  Migrate (MIG) Target job ADBMGT1:
  
  LOAD DATA INDDN dbname
  EBCDIC  CCSID(00037,00000,00000)
  FORMAT SPANNED YES
    SORTNUM 4
    SORTDEVT SYSDA
    SHRLEVEL NONE
    REPLACE
    LOG YES
    ENFORCE NO
    ERRDDN SYSERR
    DISCARDDN SYSDISC
    DISCARDS 0
    FORMAT SPANNED YES
  
  DSNU094I    >timestamp< DSNUGPTC - KEYWORD 'SPANNED' IS
  DUPLICATED
  

Problem conclusion

• Problem 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:

  UI37891

Modules/Macros

•    ADB2UTCO ADB28M
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI37891

     UP16/05/19 P F605

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.