PM78743: DB2 ADMINISTRATION TOOL FOR Z/OS ISSUES MESSAGE "PROCESSING ERROR" ON PANEL ADB26CTF WHEN USING 'D'( DELETE CURRENT COLUMN)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS issues message "Processing
  Error"
  on Panel ADB26CTF when using 'D'( Delete current column)
  while Creating new table on Panel ADB26CT and specifying
  YES on 'As model only'
  .
  ADB26CTF  ------------------ ssid Create Table Columns
  Command ===>
  Processing error
  Schema  . . schema  >            Database  . . . dbname
  Name  . . . new_tb_name   >      Table space . . tsname
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who delete one or more columns on       *
  *                 panel ADB26CTF 'Create Table Columns' to     *
  *                 create a new table.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when using the 'CRE - Create a similar  *
  *                      object' line command on a table on      *
  *                      panel ADB21T 'Tables, Views, and        *
  *                      Aliases', adding a new table name       *
  *                      on panel ADB26CT 'Create Table',        *
  *                      setting option 'As model only'=YES,     *
  *                      then deleting one or more columns on    *
  *                      panel ADB26CTF 'Create Table Columns',  *
  *                      the following error is received:        *
  *                                                              *
  *                      'Processing error'                      *
  *                                                              *
  *                      on the panel, and upon pressing ENTER,  *
  *                      panel ADB2ER 'ISPF Dialog Error' issues *
  *                      the following error:                    *
  *                                                              *
  *                      ISPT061 Table "aaaaaaaa"                *
  *                      error - Attempt to process a table      *
  *                      row that no longer exists.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS, when using the 'CRE -
  Create a similar object' line command on a table on panel
  ADB21T 'Tables, Views, and Aliases', adding a new table name
  on panel ADB26CT 'Create Table', setting option 'As model
  only'=YES, then deleting one or more columns on panel ADB26CTF
  'Create Table Columns', the following error is received:
  
  'Processing error'
  
  on the panel, and upon pressing ENTER, panel ADB2ER 'ISPF
  Dialog Error' issues the following error:
  
  ISPT061 Table "aaaaaaaa" error - Attempt to process a table
  row that no longer exists.
  

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:

  UK91418 UK91419

Modules/Macros

•    ADB26CTF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK91418

     UP13/02/08 P F302

• RA20 PSY UK91419

     UP13/02/08 P F302

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.