PI98201: CATMAINT UPDATE VCAT SWITCH TO ROLE CAUSED ABENDS04E RC00E40601 AND THEN CATALOG ACCESS INCURRED 00C900A6

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CATMAINT UPDATE OWNER FROM(XXXXXX,YYYYYY) TO ROLE statement
  incurrend abend 04E RC00E40601 Duplicate Key. DM trace shows
  00C90003 reason code. After this abend any catalog access
  incurs 00C900A6 abend.
  .
  This apar also fixes the issue where CATMAINT does not
  change user defined global variable schema name.
  

Local fix

• 1.run a dummy catmaint switch to get rid of 00C900A6, eg,
    CATMAINT UPDATE OWNER FROM (XXXXX) TO ROLE  where XXXXX
    is not a valid userid.
  2.DROP PROCEDURE/FUNCTION to find entries that has multiple
    versions and drop them
  3.run the original CATMAINT UPDATE that user intended to run
    CATMAINT UPDATE OWNER FROM (AAAAA,BBBBB) TO ROLE
    where AAAAA, BBBBB are valid userid
  4.recreate the dropped PROCEDURE/FUNCTION
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the CATMAINT utility using the      *
  *                 SCHEMA SWITCH or OWNER FROM options.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR fixes two problems:           *
  *                      1. CATMAINT utility with the SCHEMA     *
  *                         SWITCH or OWNER FROM options did     *
  *                         not process global variables to      *
  *                         update schema and authorization      *
  *                         ID.                                  *
  *                      2. CATMAINT utility with the OWNER      *
  *                         FROM option failed with              *
  *                         ABEND04E RC00E40601 from DSNUESCM    *
  *                         when changing the authorization ID   *
  *                         for stored procedures that have      *
  *                         more than one version.               *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  This APAR fixes two problems:
  
  1. CATMAINT utility with the SCHEMA SWITCH or OWNER FROM options
     did not process global variables to update schema and
     authorization ID columns in the SYSIBM.SYSVARIABLES and
     the SYSIBM.SYSVARIABLEAUTH catalog tables.
  
  2. CATMAINT utility with the OWNER FROM option failed with
     ABEND04E RC00E40601 from DSNUESCM when changing ownership
     for stored procedures. When changing an object's ownership
     from an authorization ID to a role, a record is inserted
     to the SYSIBM.SYSOBJROLEDEP catalog table. For stored
     procedures with more than one version, CATMAINT utility
     tried to insert a record to the SYSIBM.SYSOBJROLEDEP
     catalog table for each version. Only the first insert
     would be successful, any subsequent insert for the same
     stored procedure would fail because of duplicates.
     CATMAINT utility did not anticipate any failure from
     the insert and took the abend.
  

Problem conclusion

• Db2 code has been update to correct the problems.
  

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:

  UI57968 UI57970

Modules/Macros

•    DSNUESCM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI57970

     UP18/09/05 P F809

• RC10 PSY UI57968

     UP18/09/05 P F809

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.