If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > problem with binding (package was not found)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-30-03, 13:21
nmkumaran nmkumaran is offline
Registered User
 
Join Date: Mar 2003
Posts: 35
Wink problem with binding (package was not found)

Hi,

I have a problem with package while accessing through the application.
It throws the error SQL0805N
WITH KVELU.UTILSORA <VERSION NUMBER> WAS NOT FOUND.
This is running in linux box with versioN UDB 8.1

I tried with drop and recreate the package ,
db2rbind package all -u user -p passwd
REBIND PACKAGE KVELU.UTILSORA VERSION LOCALHOST.LOCALDOMAIN:UTILSORA.SQC:5559711

bind @db2ubind.lst blocking all grant public
bind @db2cli.lst blocking all grant public


Still i am getting the same problem with corresponding package was not found.

Tried with compiling again also and recreated the package.

I can not figure out how to solve it, if any one know about this error, please revert me ASAP.

This is error is happening for the particular one user from linux client to linux server .


Thanks in advance.
Muthu
Reply With Quote
  #2 (permalink)  
Old 10-30-03, 18:52
nmkumaran nmkumaran is offline
Registered User
 
Join Date: Mar 2003
Posts: 35
Thumbs up Re: problem with binding (package was not found)

Hi Guys,
Thanks for looking my problem, problem was solved.
The problem was shadow file (same file )was created in two different places when he compiled.

thanks,
Muthu


Quote:
Originally posted by nmkumaran
Hi,

I have a problem with package while accessing through the application.
It throws the error SQL0805N
WITH KVELU.UTILSORA <VERSION NUMBER> WAS NOT FOUND.
This is running in linux box with versioN UDB 8.1

I tried with drop and recreate the package ,
db2rbind package all -u user -p passwd
REBIND PACKAGE KVELU.UTILSORA VERSION LOCALHOST.LOCALDOMAIN:UTILSORA.SQC:5559711

bind @db2ubind.lst blocking all grant public
bind @db2cli.lst blocking all grant public


Still i am getting the same problem with corresponding package was not found.

Tried with compiling again also and recreated the package.

I can not figure out how to solve it, if any one know about this error, please revert me ASAP.

This is error is happening for the particular one user from linux client to linux server .


Thanks in advance.
Muthu
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On