PI62515: ABEND04E AT DSNXOLV:M100 FOR A ALTER TABLE RENAME COLUMN WHEN THERE IS A COMPILED FUNCTION DEFINED ON THE TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E at DSNXOLV:M100 for a ALTER TABLE RENAME COLUMN when
  there is a compiled function defined on the table
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of                 *
  *                 ALTER TABLE RENAME COLUMN                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABND=04E-00E70005,                      *
  *                      LOC=DSNXGRDS.DSNXOLV:M100 can occur     *
  *                      when renaming a table column with       *
  *                      compiled user-defined functions         *
  *                      depending on the table.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND04E RC00E70005 at DSNXOLV:M100 can occur when executing an
  ALTER TABLE RENAME COLUMN statement and the altered table has
  compiled user-defined functions depending on it. This problem
  occurs because DB2 incorrectly updates these dependent compiled
  user-defined functions.
  
  Other unexpected symptoms may also occur in this scenario.
  
  As an example, the following sequence of statements will result
  in the problem described:
  1. Create a table.
  CREATE TABLE T1
   (C1 SMALLINT,
    C2 DEC,
    C3 DEC)!
  COMMIT!
  
  2. Create a compiled user-defined function depending on the
  table.
  CREATE FUNCTION UDF1
   (IN_SEQ SMALLINT)
    RETURNS DEC
    BEGIN
      DECLARE OUT DEC ;
      SELECT C2 INTO OUT
      FROM T1 WHERE C1 = IN_SEQ
      FETCH FIRST 1 ROWS ONLY;
      RETURN OUT;
    END!
  COMMIT!
  
  3. Rename a column in the dependent table.
  ALTER TABLE T1 RENAME COLUMN C1 TO RC1!
  

Problem conclusion

• DB2 has been modified to correctly process dependent compiled
  user-defined functions when executing an ALTER TABLE
  RENAME COLUMN statement.
  
  Additional Keywords:
  ABEND04E
  RC00E70005
  SQLALTER
  SQLUDF
  

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:

  UI40226

Modules/Macros

• DSNXIRCO DSNXISB2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI40226

     UP16/09/05 P F609

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.