• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 768
  • Last Modified:

reason code "5" while executing DB2 8 external UDF

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
1 Solution
Kent OlsenData Warehouse Architect / DBACommented:

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,
leonstrykerAuthor Commented:
Hello Kent,

We are running DB2 on Solaris box

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now