MVSFORUMS.com

katrix · Beginner Joined: 11 Jul 2005 Posts: 3 Topics: 1

Hello

,

I have successfully compiled a procedure which performs some looping operations.

But when I try calling that procedure it give me the following error:
Sad

call RA.P_T_C(3,10,5,15)
SQL0805N Package "RA.P5575764 0X47423636504C4856" was not found.
SQLSTATE=51002

SQL0805N Package "RA.P5575764 0X47423636504C4856 " was not found.

Explanation:

The statement cannot complete because the necessary package was
not found in the catalog.

The "<package-name>" is either in the form:

o 'pkgschema.pkgname 0Xcontoken', where the consistency token
is given in hexadecimal.

o 'pkgschema.pkgname.pkgversion', if the package version is the
empty string then '.pkgversion' is omitted from the name.

o '%.pkgname' if the CURRENT PACKAGE PATH is set. The set of
schema names in the CURRENT PACKAGE PATH are implied by the
percent character ('%').

I even tried running db2rbind on my database but the log file for that run read as follows: Confused

Package 'P8504160' of database 'DBNAME' failed to revalidate.
Package 'P8504182' of database 'DBNAME' failed to revalidate.

I would be glad Very Happy

if someone suggested me a way to get out of this.. I am a beginner with DB2 and am not aware of other features that may be exploited.

Hoping to get some suggestion soon.

Thanking you in anticipation

Katrix

kolusu · Posted: Mon Jul 11, 2005 5:49 am Post subject:

katrix,

Make sure there are no other users connected to the database when you are performing the bind. You can perform the following at the DB2 command window to ensure no other users are connected:

katrix · Beginner Joined: 11 Jul 2005 Posts: 3 Topics: 1

HI kolusu,

I tried out as u suggested, but all in vain. I got the same error.

hope ur next suggestion solves my prob Wink

Katrix

kolusu · Posted: Mon Jul 11, 2005 6:27 am Post subject:

check this link

http://tada.percussion.com/web/knowbase.nsf/0/e558923856a5e34585256dcf005a1cc8?OpenDocument

Also run this query to see if the package existed.

katrix · Beginner Joined: 11 Jul 2005 Posts: 3 Topics: 1

hey,

i tried that query and it returned a null. That means that no such package is getting created.

I went through the link that u provided but couldnt decipher how it would help in solving my problem Sad

DB2 itself gave some user-response which advices to issue some db2 utility query but even that didnt work out for me.

Anyway thanks a lot for your prompt response. Will keep trying.....
DO let me know if u find some viable solution

Katrix