PH44610: DB2 ADMIN: SQLCODE = -122 OCCURS WHEN CMD MIGRI OR LINE CMDS ADDRI, ADDHIS, ADDARC ARE USED ON PANEL ADB28T 'MIGRATE TABLE'

APAR status

• Closed as program error.

Error description

• Db2 Admin Tool: SQLCODE = -122 occurs when command MIGRI or
  line commands ADDRI,  ADDHIS, ADDARC are used on panel ADB28T
  'Migrate Table'.
  
  DESCRIPTION:  When migrating a referentially related table,
  SQLCODE = -122 occurs when command MIGRI or line commands ADDRI,
   ADDHIS, ADDARC are used on panel ADB28T 'Migrate Table'.
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: From panel ADB28T                       *
  *                      'Migrate Table', SQLCODE = -122         *
  *                      might occur when using command          *
  *                      MIGRI or line commands ADDRI,           *
  *                      ADDHIS, or ADDARC.                      *
  ****************************************************************
  When using command MIGRI from panel
  ADB28T 'Migrate Table' or line commands ADDRI,
  ADDHIS, or ADDARC, the following error might occur:
  DSNT408I SQLCODE = -122, ERROR: COLUMN OR
  EXPRESSION IN THE SELECT LIST IS NOT VALID
  

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:

  UI80424

Modules/Macros

• ADB28T
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels