IBM Support

IC98743: SYSTEM GENERATED FUNCTIONS ARE INCORRECTLY OWNED BY THE INSTANCE OWNER.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Some system functions that get created automatically by DB2,
    incorrectly have the instance userid set as the owner of these
    functions.
    It would be more appropriate to have SYSIBM as the owner. Other
    than this owner field, there is no impact of this owner as the
    instance user cannot modify the functions anyway. ( results in
    error )
    
    To see which functions are affected, run  :
    
    db2 "select substr(owner,1,10) owner, substr(routinename,1,20)
    routinename , substr(ROUTINESCHEMA,1,10) ROUTINESCHEMA
    ,ownertype,routinetype  from syscat.routines where ROUTINESCHEMA
    = 'SYSPROC' and owner <> 'SYSIBM' " ;
    
    OWNER      ROUTINENAME          ROUTINESCHEMA OWNERTYPE
    ROUTINETYPE
    ---------- -------------------- ------------- ---------
    -----------
    DB2INST3   DB2SECURITYLABEL     SYSPROC       U         F
    
    DB2INST3   VARCHAR              SYSPROC       U         F
    
    DB2INST3   =                    SYSPROC       U         F
    
    DB2INST3   <                    SYSPROC       U         F
    
    DB2INST3   >                    SYSPROC       U         F
    
    DB2INST3   <=                   SYSPROC       U         F
    
    DB2INST3   >=                   SYSPROC       U         F
    
    DB2INST3   <>                   SYSPROC       U         F
    
    DB2INST3   DB2SQLSTATE          SYSPROC       U         F
    
    DB2INST3   CHAR                 SYSPROC       U         F
    
    DB2INST3   DB2SQLSTATE          SYSPROC       U         F
    
    DB2INST3   =                    SYSPROC       U         F
    
    DB2INST3   <                    SYSPROC       U         F
    
    DB2INST3   >                    SYSPROC       U         F
    
    DB2INST3   <=                   SYSPROC       U         F
    
    DB2INST3   >=                   SYSPROC       U         F
    
    DB2INST3   <>                   SYSPROC       U         F
    
    
      17 record(s) selected.
    
    
    The fix for this apar will correct this for new databases. For
    existing databases the ownership of these functions will remain
    the same.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the DB2 server to V9.7 Fix Pack 10 or higher.        *
    ****************************************************************
    

Problem conclusion

  • This problem was first fixed in V9.1 Fix Pack 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC98743

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-01-15

  • Closed date

    2015-01-05

  • Last modified date

    2015-01-05

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC99675

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC98743

Modified date: 05 January 2015