PM74960: ALT REMOVING FIELDPROC RESULTS IN ADB1908E NO SYSTABLES ROW FOUND FOR 'CREATE AUXILIARY TABLE' & ADB0380E ADB2CMP RC12

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT functions ALTER
  step fails with messages:
  ADB1908E No systables row found for 'Create auxiliary table': .
  and:
  ADB0380E Module ADB2CMP - Severe error Alter terminates
  and ends with a return code 12 / RC12 when the customer used
  ALT to remove a FIELDPROC from a column definition for a table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'Alter Table ALT' (ALT)     *
  *                 line command.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      ALT function's ALTER step fails with    *
  *                      messages:                               *
  *                                                              *
  *                      ADB1908E No systables row found         *
  *                      for '>statement<': and                  *
  *                      ADB0380E Module ADB2CMP                 *
  *                      - Severe error Alter terminates         *
  *                                                              *
  *                      and ends with a return code 12 /        *
  *                      RC12 when the customer used             *
  *                      ALT to remove a FIELDPROC from a        *
  *                      column definition for a table           *
  *                      on panel ADB26CTU 'Alter Table'.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a base table contains the fieldproc attribute for columns
  defined on a table:
  
  CREATE TABLE
  >table_schema<.>table_name<
    (COLUMN-NAME CHAR(6)
     FIELDPROC PROCEDURE-NAME);
  
  and the ALT function is used to remove the definition of the
  fieldproc from the columns on panel ADB26CTU 'Alter Table',
  the ALTER step fails with the following messages:
  
  ADB1908E No systables row found for '>statement<': and
  ADB0380E Module ADB2CMP - Severe error Alter terminates
  
  and ends with a return code 12 / RC12.
  

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:

  UK90401 UK90402

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK90401

     UP12/12/19 P F212

• RA20 PSY UK90402

     UP12/12/19 P F212

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.