PI76552: DB2 ADMIN TOOL SQLCODE -530 TRANSFERRING STATISTICS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• While moving table-space statistics from one system to another,
  a problem occurs for PBG table-spaces when the number of
  partitions is less on the target system compared with source.
  In this case the Admin Tool job receives an error on the insert
  to the catalog table SYSIBM.SYSTABSTATS. The problem only
  occurs after migration to DB2 for z/OS V11. DB2 for z/OS V10
  and earlier worked ok.
    sqlerror on INSERT     command, EXECUTE    function
    DSNT408I SQLCODE = -530, ERROR: THE INSERT OR UPDATE VALUE OF
             FOREIGN KEY DSNDP§TT IS INVALID
    DSNT418I SQLSTATE   = 23503 SQLSTATE RETURN CODE
    DSNT415I SQLERRP    = DSNXRINS SQL PROCEDURE DETECTING ERROR
    DSNT416I SQLERRD    = -110  13172774 0 -1 0 0 SQL DIAGNOSTIC
                        INFORMATION
    DSNT416I SQLERRD    = X'FFFFFF92'  X'00C90026'  X'00000000'
                          X'FFFFFFFF' X'00000000'  X'00000000'
                        SQL DIAGNOSTIC INFORMATION
  
  In this case partition 3 for table-space does not exist after
  moving the source table to target.
  

Local fix

• Remove all the insert statements related to partitions that
  do not exist in the target system.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the Migrate function            *
  *                 (MIG command/line command) .                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: While using the MIG function,           *
  *                      a problem occurs for Partition-By-      *
  *                      Group (PBG) table spaces when           *
  *                      the number of partitions from           *
  *                      the target is less than the source.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  While using the MIG function to move table space statistics
  from one system to another, a problem occurs for
  PBG table spaces when the number of partitions from
  target is less than the source. In this case the job fails with
  error SQLCODE = -530 / SQLCODEN530 on the insert
  statement to the DB2 catalog table SYSIBM.SYSTABSTATS:
  
  DSNT408I SQLCODE = -530, ERROR: THE INSERT OR
                     UPDATE VALUE OF FOREIGN KEY
                     >OBJECT< IS INVALID
   DSNT418I SQLSTATE = 23503
   SQLSTATE RETURN CODE
  
  The problem only occurs after migration to DB2 11. DB2
  10 and earlier works.
  

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:

Modules/Macros

•    ADB2RES
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI48282

     UP17/06/28 P F706

• RB20 PSY UI48283

     UP17/06/28 P F706

• RC10 PSY UI48284

     UP17/06/28 P F706

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.