IBM Support

PH09431: DB2 ADMINISTRATION TOOL - ADBTEP2 DUPLICATES SPANNED YES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Create a UNLOAD job for a table with LOB/XML.
    Manually add NOPAD option in the generated JCL.
    
    Depending on the placement of NOPAD option, ADBTEP2 will
    erroneously add an extra SPANNED YES to the utility input
    causing RC08 with error message:
      DSNU094I - KEYWORD 'SPANNED' IS DUPLICATED
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS and DB2 Object Comparison Tool for      *
    *                 z/OS.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: Batch Restart Program (ADBTEP2) fails   *
    *                      unloading due to duplicate SPANNED      *
    *                      keyword.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Depending on the placement of NOPAD option, ADBTEP2 will
    erroneously add an extra SPANNED YES to the utility input
    causing RC08 with error:
    
    DSNU094I DSNUGPTC - KEYWORD 'SPANNED' IS DUPLICATED
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH09431

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-03-07

  • Closed date

    2019-05-30

  • Last modified date

    2019-07-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI63341

Modules/Macros

  •    ADB2PA6
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI63341

       UP19/06/04 P F906

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 July 2019