Peter_Dyk
asked on
DB2 functions not working under Vista
We are in the process of moving our application from W2K and DB2 V8.2 to Windows Vista and DB2 Express C free V9.1.2. Most of our DB2 processes and queries are working correctly except for when we attempt to use any functions contained in the db2clifn.dll file (e.g., ascii, chr, sqrt, etc.). For example, the query
DB2 select sqrt(4) from user
where the table user has two rows in it. It should return the value 2 twice, but instead generates the error:
SQL0444N Routine "SYSFUN.SQRT" (specific name "SQRT") is implemented with
code in library or path "\db2clifn", function "CLI_udfSQRT" which cannot be
accessed. Reason code: "4". SQLSTATE=42724
I have checked that the db2clifn.dll file is located in a directory that is on our path variable and, in fact, we have several user-created functions in the same directory that work properly. This is our first foray into Vista, so it is also possible that there is some security issue we are not aware of causing this.
DB2 select sqrt(4) from user
where the table user has two rows in it. It should return the value 2 twice, but instead generates the error:
SQL0444N Routine "SYSFUN.SQRT" (specific name "SQRT") is implemented with
code in library or path "\db2clifn", function "CLI_udfSQRT" which cannot be
accessed. Reason code: "4". SQLSTATE=42724
I have checked that the db2clifn.dll file is located in a directory that is on our path variable and, in fact, we have several user-created functions in the same directory that work properly. This is our first foray into Vista, so it is also possible that there is some security issue we are not aware of causing this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
all I can tell you is that is a dll problem, is express certified to work with Vista? If not, you may have a hard time debugging that problem, as its impossible to tell which dll is at fault.
ASKER
momi sabag: I agree, that problem looks to be the same thing and some further testing indicates that there is a problem when the funcion dll, db2clifn.dll, tries to access db2sys.dll in a seperate directory, even though that directory is also on the path variable. There is a fixpack that came out about a week ago that I am in the process of downloading so I will keep you posted.
ghp700: As I mentioned just above, it does seem to be a dll problem, and yes, this version of DB2 is listed as Vista compatible. I believe this version is the first one for Vista, though, so problems are not unexpected.
ghp700: As I mentioned just above, it does seem to be a dll problem, and yes, this version of DB2 is listed as Vista compatible. I believe this version is the first one for Vista, though, so problems are not unexpected.
ASKER
As soon as I got the 9.1.3 patch installed, the functions started working properly. Thanks a lot.