IBM Support

PI14399: RECEIVE SQLCODE = -531 WHEN COPYING A SELECTED ROW FROM ONE DB2 LOCATION TO ANOTHER USING THE FM/DB2 COPY UTILITY.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When copying a selected row from one DB2 location to another,
    and 'Ignore RI/Constraint errors' is selected on the Copy
    Options, receive message:
    
    DSNT408I SQLCODE = -531. ERROR: PARENT KEY IN A PARENT ROW
    CANNOT BE UPDATED BECAUSE IT HAS ONE OR MORE DEPENDENT ROWS IN
    RELATIONSHIP <name>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of File Manager DB2 component.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: In File Manager DB2 copy, SQLCODE-531   *
    *                      attempting to update a row, with the    *
    *                      option 'ignore RI errors' selected.     *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    The only SQLCODEs tolerated on update are SQLCODE-530 and
    SQLCODE-545.  SQLCODE-531 indicates a referential integrity
    error on update, and should be ignored when the option 'ignore
    RI errors' is selected.
    

Problem conclusion

  • File Manager DB2 component has been updated to correct the
    problem.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI14399

  • Reported component name

    FILE MANAGER Z/

  • Reported component ID

    5655Q1200

  • Reported release

    D12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-03-25

  • Closed date

    2014-04-13

  • Last modified date

    2014-05-02

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

    PI13512

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

Modules/Macros

  • FMN2LVL
    

Fix information

  • Fixed component name

    FILE MANAGER Z/

  • Fixed component ID

    5655Q1200

Applicable component levels

  • RD12 PSY UI17000

       UP14/04/19 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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
02 May 2014