Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

DB2 Stored Procedures

Our DBAs recently upgraded our AIX based DB2 database to version 8.2.  Due to business limitations, we are accessing the system using V6 clients.  All stored procedures built prior to the ugrade function perfectly under this arrangement, but new procedures built using either the V7 client or the V8.2 client fail to run producing the following error message:

Error: SQL0444N  Routine "*nQualSum" (specific name "SQL050217160054980") is implemented with code in library or path "...nQualSum", function "DBAWD001.SP0600AdminQualSum" which cannot be accessed.  Reason code: "4".  SQLSTATE=42724
 (State:42724, Native Code: FFFFFE44)

If we build and run the SP using only V8.2 clients the work, but if we build on V8.2 the will not run for V7 and V6, and if we build using V7 client they will not run on any of the clients.  If cannot upgrade the clients to V8.2, does anybody have a solution for this?
1 Solution
Generally speaking, SQL0444n return code 4 is equivalent to the blue screen of death in Windows, very difficult to diagnose and correct. It relates to the compiler settings, more specifically the export path of the stored procedure, or the fact that prior to the upgrade, the stored procedure relied upon certain MS dll's to be present in the system in order to function and perhaps those clients are expecting those function calls to be resolved.
Since V8.2 no longer requires the external MS compiler, I would ask this question directly to IBM support, as there are just way too many variables involved with stored procedures.

You may get a clue as to what is wrong exactly by looking at the db2diag log, if there is an internal return code there, it can be deciphered for help in solving this problem.
I would also try setting the dbset parameters for the compiler settings that were used prior to the upgrade.
Another way perhaps is to distribute the SP with the put command.

Were the binds run for each of the different client versions against the UDB?


Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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