Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT04137 Status: Closed

CALLING STORED PROCEDURE ENV_GET_INSTANCE_CODE_LEVELS ON WINDOWS PLATFORM
RESULTS IN SQL0444N

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
When a stored procedure: ENV_GET_INSTANCE_CODE_LEVELS is called 
on 
Windows platform, it results in SQL0444N error. 
 
Here are the steps to reproduce the error: 
 
db2 SELECT * FROM TABLE (SYSPROC. 
ENV_GET_INSTANCE_CODE_LEVELS()) 
: 
SQL0444N  Routine "*E_LEVELS" (specific name 
"ENV_GET_INSTANCE_CODE_LEVELS") 
is implemented with code in library or path "*", function 
"env_get_rolling_update_status" which cannot be accessed. 
Reason code: 
"". 
SQLSTATE=42724 
 
Diag.log may contain the following error: 
 
2014-08-12-11.47.21.273000-420 I645871F1287 LEVEL: Severe 
PID : 10588 TID : 11236 PROC : db2syscs.exe 
INSTANCE: DB2 NODE : 000 DB : TEST 
APPHDL : 0-1157 APPID: *LOCAL.DB2.xxx 
AUTHID : xxxx HOSTNAME: xxx 
EDUID : 11236 EDUNAME: db2agent (TEST) 
FUNCTION: DB2 UDB, routine_infrastructure, 
sqlerRoutineResolveAddress, 
probe:10 
MESSAGE : ZRC=0xFFFFFE44=-444 
SQL0444N Routine "" (specific name "") is implemented with code 
in 
library or path "", function "" which cannot be accessed. Reason 
 
code: "". 
 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -444 sqlerrml: 70 
sqlerrmc: *E_LEVELS ENV_GET_INSTANCE_CODE_LEVELS * 
env_get_rolling_update_status 
sqlerrp : SQLERLIB 
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000 
sqlwarn : (1) (2) (3) (4) (5) (6) 
(7) (8) (9) (10) (11) 
sqlstate: 42724 
DATA #2 : String, 34 bytes 
env_get_rolling_update_status_v105 
DATA #3 : String, 16 bytes 
db2dbrouttrusted
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Windows                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.5 FP5 or higher                           * 
****************************************************************
Local Fix:
Solution
First fixed in DB2 V10.5 FP5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.09.2014
18.03.2015
18.03.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.5 FixList