Home

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IC99675	Status: Closed
SYSTEM GENERATED FUNCTIONS ARE INCORRECTLY OWNED BY THE INSTANCE OWNER.
product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem 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.
Problem Summary:
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade the DB2 server to V10.1 Fix Pack 5 or higher. * ****************************************************************
Local Fix:

Solution
This problem was first fixed in V10.1 Fix Pack 5
Workaround
not known / see Local fix
BUG-Tracking
forerunner : APAR is sysrouted TO one or more of the following: IC99705 follow-up :
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	26.02.2014 27.10.2014 27.10.2014
Problem solved at the following versions (IBM BugInfos)

Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5