PH29606: DB2 ADMIN : ERROR DURING MULTI-TARGET CHANGE, DSNT408I SQLCODE = -443, ERROR: ROUTINE ADBCRSP

APAR status

• Closed as program error.

Error description

• When attempting to register a multi-target change, if one of
  the targets contains a CM mask with OWNER, TBOWNER, or IXOWNER,
  the registration process may fail with an SQLCODE -443
  
  example error
  
  Sql error in: CALL ADBCRSP
  
  DSNT408I SQLCODE = -443, ERROR:  ROUTINE ADBCRSP (SPECIFIC NAME
   ADBCRSP) HAS RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC TEXT
  
  DSNT418I SQLSTATE   = 70030 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXRRTN SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -818  0  0  -1  0  0 SQL DIAGNOSTIC
                              INFORMATION
  DSNT416I SQLERRD    = X'FFFFFCCE'  X'00000000' X'00000000'
              X'FFFFFFFF'
              X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS multi-target changes.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -443 on routine ADBCRSP during  *
  *                      registration of a multi-target change.  *
  ****************************************************************
  During registration of a multi-target change, any target change
  with a Change Management (C)M mask that results in a warning
  will cause the registration to fail with the following error:
  
  SQLCODE = -443, ERROR:  ROUTINE ADBCRSP (SPECIFIC NAME ADBCRSP)
  HAS RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC TEXT
  SQLSTATE   = 70030 SQLSTATE RETURN CODE
  
  For example:
  When OWNER related masks are specified, this warning may occur.
  ADB3356W  To migrate DB2V8 masking input, OWNER, TBOWNER and
            IXOWNER will mask both owner and schema fields.
            etc.
  

Problem conclusion

• The 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:

  UI72543

Modules/Macros

• ADBCRSP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels