IBM Support

PM48078: CATALOG COPY FEATURE 'L=LOAD FROM CURSOR' METHOD LOAD DSNU344I UNIQUE INDEX KEY DUPLICATES KEY OF INDEXED RECORD SYSOBJ

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Administration Tool for z/OS' Catalog Copy feature
    created LOAD RESUME YES syntax for the SYSOBJ tablespace when
    the 'L=LOAD from Cursor' method was selected on panel ADB2CCJ
    'Create Catalog Copy and Bind Batch Jobs'.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS who use Catalog Copy to create a        *
    *                 catalog copy and bind the batch job with     *
    *                 type=C.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
    *                      Catalog Copy feature created LOAD       *
    *                      RESUME YES syntax for the SYSOBJ table  *
    *                      space when the 'L=LOAD from Cursor'     *
    *                      method was selected on panel ADB2CCJ    *
    *                      'Create Catalog Copy and Bind Batch     *
    *                      Jobs'.                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The DB2 message DSNU344I:
    
     'DSNU344I  #SSID-  csect-name
     UNIQUE INDEX KEY DUPLICATES KEY OF
     INDEXED RECORD AT RID record-id'
    
    is issued because the LOAD statement uses RESUME YES for the
    table space when the 'L=LOAD from Cursor' method was selected
    on panel ADB2CCJ.
    

Problem conclusion

  • Skeleton ADB2CCL was updated to fix this problem.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM48078

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-16

  • Closed date

    2011-12-22

  • Last modified date

    2012-01-01

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

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

    UK75078

Modules/Macros

  •    ADB2CCL
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK75078

       UP11/12/24 P F112

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":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 January 2012