PH70270: SELECT ON A TABLE RECEIVES 00C90101 IN DSNIMOFR 5006 AFTER DROP DEFAULT

APAR status

• Closed as program error.

Error description

• ABEND04E RC00C90101 in DSNIMOFR ERQUAL5006 is received running
  a SELECT on a table where the default has been removed.
  Steps to recreate the problem are :
  1) Create the object (all columns are fixed length).
  2) Insert rows.
  3) ALTER to ADD a new fixed length column with a DEFAULT value.
  4) Update the new column to 0.
  5) ALTER to DROP the default.
  6) SELECT each column from the table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 13 for z/OS users of a SELECT on a   *
  *                 table where the default has been removed.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00C90101 in DSNIMOFR         *
  *                      ERQUAL5006 is received running          *
  *                      a SELECT on a table where the           *
  *                      default column has been removed.        *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  ABEND04E RC00C90101 in DSNIMOFR ERQUAL5006 is received
  running a SELECT on a table where the default column has
  been removed.
  
  Steps to recreate the problem are :
   Create the object (all columns are fixed length).
   Insert rows.
   ALTER to ADD a new fixed length column with a DEFAULT
   value.
   Update the new column to 0.
   ALTER to DROP the default.
   SELECT each column from the table.
  

Problem conclusion

• DB2 has been modified to fix the default column related
  problem.
  
  Additional Keywords: SQLDEFAULT SQLUPDATE SQLALTER SQLDROP
  

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:

  UO07401

Modules/Macros

• DSNXOUID
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels