DB2 Stored Procedures
Posted on 2005-03-10
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?