473,578 Members | 2,739 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with package not found

Running Db2 8.1 w Fixpack 9.

Recently upgraded to this level.

An application attempting a load receives the following error

Error Error 1 2005-12-29 14:55:26 SQLError: sqlstate 51002: [IBM][CLI
Driver][DB2/6000] SQL0805N Package "NULLID.SYSLH10 3
0X5359534C564C3 031" was not found. SQLSTATE=51002

Have done a rbind all, also

db2 "bind @db2ubind.lst blocking all grant public"
and
db2 "bind @db2cli.lst blocking all grant public"

In the /sqllib/bnd directory I've done a grep for SYSLH103 and
anything close but its not there.

Also no package coming back from a query to syscat.packages with that
name.

Any suggestions would be appreciated.

Thanks in advance.

Jan 3 '06 #1
9 6795
In article <11************ **********@z14g 2000cwz.googleg roups.com>,
da*******@yahoo .com (da*******@yaho o.com) says...
Running Db2 8.1 w Fixpack 9.

Recently upgraded to this level.

An application attempting a load receives the following error

Error Error 1 2005-12-29 14:55:26 SQLError: sqlstate 51002: [IBM][CLI
Driver][DB2/6000] SQL0805N Package "NULLID.SYSLH10 3
0X5359534C564C3 031" was not found. SQLSTATE=51002

Have done a rbind all, also

db2 "bind @db2ubind.lst blocking all grant public"
and
db2 "bind @db2cli.lst blocking all grant public"

In the /sqllib/bnd directory I've done a grep for SYSLH103 and
anything close but its not there.


You most likely also need to run the 'db2jdbcbind' command. Search
the online docs at http://tinyurl.com/bslng for it.
Jan 3 '06 #2
Check out this link for a possible solution:
http://www-1.ibm.com/support/docview...1208123&loc=en

Jan 3 '06 #3
I ran the suggested command
db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG
5
Now the job is failing looking for package nullid.SYSLH106

Is there anyway of determining how many packages this app will need?

Jan 4 '06 #4
In article <11************ **********@o13g 2000cwo.googleg roups.com>,
da*******@yahoo .com (da*******@yaho o.com) says...
I ran the suggested command
db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG
5
Now the job is failing looking for package nullid.SYSLH106

Is there anyway of determining how many packages this app will need?


Count the number of needed handles, there's a description about CLI
handles in the DB2 docs at http://tinyurl.com/7m9hc
Jan 4 '06 #5
Thanks..this is very good information. It seems to be saying that I
would need to know the number of packges the app is using in order to
determine the best value to set CLIPKG value. Is that correct?

Jan 4 '06 #6
In article <11************ **********@f14g 2000cwb.googleg roups.com>,
da*******@yahoo .com (da*******@yaho o.com) says...
Thanks..this is very good information. It seems to be saying that I
would need to know the number of packges the app is using in order to
determine the best value to set CLIPKG value. Is that correct?


As far as I understand you have to count the number of handles needed
by your application. I'm not familiar with CLI programming but maybe
the application allocates handles and doesn't release them when they
are not needed anymore.
Jan 4 '06 #7
Ian
da*******@yahoo .com wrote:
I ran the suggested command
db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG
5
Now the job is failing looking for package nullid.SYSLH106

Is there anyway of determining how many packages this app will need?


This doesn't happen to be a perl application, does it? I ran into a
situation using an older build ActivePerl with DBD::DB2 that had the
same issue -- no matter how many CLI packages I bound I would eventually
run out. The only way we could figure out how to release the handles
was to disconnect and reconnect after X transactions.

However, after we upgraded to the most current release of perl (but
using the same DBI and DBD::DB2 modules) the problem was resolved.

Jan 6 '06 #8
Thanks...not Its not perl. We've opened an SR with Siebel as this
happened after a recent Siebel upgrade.

Jan 7 '06 #9
shawnr
1 New Member
How did you resolve this problem?
Mar 21 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

21
4392
by: BlackHawke | last post by:
My name is Nick Soutter, I own a small game development company (www.aepoxgames.net) making our first game (www.andromedaonline.net) in java. I am writing because we are having a very serious problem, and I was hoping someone might have thoughts.
1
3692
by: j vickroy | last post by:
My system: MSW XP professional Python 2.3.3 logging package: 0.4.9.2 My problem: The log_test3.py script, provided with the logging package distribution, generates an unexpected message: No handlers could be found for logger "root"
1
6507
by: kong | last post by:
I created a package using pl/sql. In this package i have a dblink to another Database, call it DB2. Meanwhile, Server2 has a DBlink to another Database, call it DB3. Within my package, i have a sql that link to these DB2's view. In the View of this DB2, it call a function from DB3 and take the data from the DB3. I run this package in few...
1
1194
by: Leo | last post by:
Hello all, I am having a problem which I cannot seem to find a solution for. In SQL Server 2000 I have created a DTS package which imports a Text file into a table. When I run the DTS package from the SQL sever itself it executes without any isses. However it is failing without any error codes when I try to run it from ASP.NET. There seems...
13
3921
by: Lee Newson | last post by:
Hi, I have just written my first application using VB.NET. The app works fine when i am running it within .NET for debugging purposes, however when i try to run the app from the .exe file that .NET creates i get the following error message: "An unhandled exception of type 'System.IO.FileNotFoundException' occurred in VisioTimeline.exe
2
1744
by: Pat | last post by:
Hi, I installed Mysql Administrator with file mysql-administrator-1.0.22a-1.rh9.src.rpm from the mysql-site on my RedHat 9.0 computer I did: rpm -Uvh mysql-administrator-1.0.22a-1.rh9.src.rpm After one second, i could see: ##################### 100% and that's it.
1
3202
by: manish deshpande | last post by:
Hi, When i'm installing MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm by the following command: rpm -i MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm the following error is being shown: warning: MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 file /etc/my.cnf from install of...
3
1785
by: Deepthi | last post by:
Hai.. I have done a project which comprises of Crystal reports with C#.Net and XML files. I have deployed that project and its running fine in my system and when its installed in the clients system, its showing an error saying " This Setup requires the Microsoft Visual J#.Net Redistributable Package version 1.1.4322.". As their is no...
0
938
by: krishnakant Mane | last post by:
hello all, I found a very strange kind of behaviour in python with my own package. I created a package in which there were 4 modules and one __init__.py file I created the entire project in eclipse (pydev). it works fine there with the ide. but now when I try running the code without eclipse, that is when I run the individual .py file from a...
0
6249
debasisdas
by: debasisdas | last post by:
PACKAGE WITH LOCAL FUNCTION ============================= create or replace package my_pkg as procedure my_proc(arg1 in varchar2); function my_fun(arg1 in number) return varchar2; end my_pkg; PACKAGE BODY
0
7850
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7779
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8150
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6524
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5664
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5343
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3801
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1391
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1114
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.