Solved

reason code "5" while executing DB2 8 external  UDF

Posted on 2006-06-28
2
740 Views
Last Modified: 2008-02-01
Hello experts,

We are getting error with reason code "5" while executing external C UDF in db2 8.1 fixpack 10


Any ideas ?


thanks in advance
0
Comment
Question by:leonstryker
2 Comments
 
LVL 45

Accepted Solution

by:
Kdo earned 500 total points
ID: 17004236

I can find documentation on "reason code 5" being issued in only two circumstances.  The first, is when a partition mismatch occurs.  Since you don't seem to be having issues anywhere else we can probably safely ignore this one.

The other is when DB2 can not communicate with a .net interpreter.  Here's IBM's blurb:

SQLCODE -4301, SQLSTATE 58004, reason code 5 or 6

An error occurred while attempting to start or communicate with a .NET interpreter. DB2 was unable to load a dependent .NET library [reason code 5] or a call to the .NET interpreter failed [reason code 6].

Ensure that the DB2 instance is configured correctly to run a .NET procedure or function (mscoree.dll must be present in the system PATH). Ensure that db2clr.dll is present in the sqllib/bin directory, and that IBM.Data.DB2 is installed in the global assembly cache. If these are not present, please ensure that the .NET Framework version 1.1, or a later version, is installed on the database server, and that the database server is running DB2 version 8.2 or a later release.


Based on your description, it would appear that your 8.1 system doesn't support the function and you'll need to upgrade to 8.2.

Good Luck,
Kent
0
 
LVL 29

Author Comment

by:leonstryker
ID: 17004415
Hello Kent,

We are running DB2 on Solaris box

thanks
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now