We help IT Professionals succeed at work.

DB2 functions not working under Vista

Peter_Dyk
Peter_Dyk asked
on
1,046 Views
Last Modified: 2012-05-05
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.
Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
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.

Author

Commented:
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.

Author

Commented:
As soon as I got the 9.1.3 patch installed, the functions started working properly.  Thanks a lot.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.