PI30594: PANEL ADB2ER ADBGAJOB, LINE 10987: SIGNAL ERROR RETCODE : 16 USING ALT TO CHANGE VARCHAR COLUMN LENGTH

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT function fails showing
  panel ADB2ER 'ISPF Dialog Error':
  Function : ADBGAJOB, LINE 10987: signal error
  Retcode  : 16
  Zerrmsg  :
  Zerrsm   :
  Zerrlm   : TBCREATE error:
  when attempting an online APPLY ALTER when changing the length
  of a column.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use 'Alter Table ALT' (ALT)         *
  *                 command to alter table in the foreground     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the ALT command to alter     *
  *                      the length of column in a temporal      *
  *                      table and choosing Option '1 - Perform  *
  *                      the SQL statements in the foreground'   *
  *                      on panel ADB27CTC 'Alter - SQL or       *
  *                      Batch', DB2 Admin fails with the        *
  *                      following ADB2ER 'ISPF Dialog Error':   *
  *                                                              *
  *                      Function : ADBGAJOB, LINE               *
  *                      10987:  signal error                    *
  *                                                              *
  *                      Retcode  : 16                           *
  *                                                              *
  *                      Zerrmsg  :                              *
  *                      Zerrsm   :                              *
  *                      Zerrlm   : TBCREATE error:              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the ALT command to alter the length of column in a
  temporal table and choosing Option '1 - Perform the SQL
  statements in the foreground' on panel ADB27CTC 'Alter -
  SQL or Batch', DB2 Admin fails with the following ADB2ER
  'ISPF Dialog Error':
  
  Function : ADBGAJOB, LINE 10987: signal error
  COMMAND POWERINP
  Retcode  : 16
  
  Zerrmsg  :
  Zerrsm   :
  Zerrlm   : TBCREATE error:
  

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

•    ADBEALT  ADBH7CTC ADB27CAA ADB27CTC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI27293

     UP15/05/16 P F505

• RB10 PSY UI27294

     UP15/05/16 P F505

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.