PM78877: SQLCODE531 ERROR IN DB2SQL COMMAND WHEN TRYING TO CHANGE STOGROUP NAMES IN DB2 V10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Possible SQLCODE -531 error in DB2SQL command when trying to
  change STOGROUP names in DB2 V10.
  
  CKZ24621E SQL EXECUTE  FAILED, SQLCODE:     -531 SQLSTATE: 23504
  
  DSNT408I SQLCODE = -531, ERROR:  PARENT KEY IN A PARENT ROW
  CANNOT BE
  UPDATED BECAUSE IT HAS ONE OR
  MORE DEPENDENT ROWS IN RELATIONSHIP DSNSS@SV
  

Local fix

• A possible work around might be to use STORCLAS, MGMTCLAS,
  DATACLAS in the DB2 STOGROUP and not change the STOGROUP name
  as part of the cloning. But instead change STORCLAS, MGMTCLAS,
  DATACLAS as part of the cloning with the DB2SQL command using
  the STORCLAS-MASKS, MGMTCLAS-MASKS, and DATACLAS-MASKS keywords.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Possible SQLCODE -531 error in DB2SQL   *
  *                      command when trying to change STOGROUP  *
  *                      names in DB2 V10.                       *
  *                      CKZ24621E SQL EXECUTE  FAILED,          *
  *                      SQLCODE:     -531 SQLSTATE: 23504       *
  *                      DSNT408I SQLCODE = -531, ERROR:         *
  *                      PARENT KEY IN A PARENT ROW CANNOT BE    *
  *                      UPDATED BECAUSE IT HAS ONE OR           *
  *                      MORE DEPENDENT ROWS IN RELATIONSHIP     *
  *                      DSNSS@SV                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK90597

Modules/Macros

•    CKZ00020 CKZ00047 CKZ00246 CKZ00271 CKZ00900
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R220 PSY UK90597

     UP13/01/09 P F301

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.