473,657 Members | 2,348 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 6802
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
4406
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
3693
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
6513
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 locations. This package run fine except for one location.
1
1195
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 to be no solution to this so far that I have found. I would greatly appreaciate it if anyone has...
13
3931
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
1748
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
3212
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 MySQL-server-standard-5.0.24a-0.rhel3 conflicts with file from package mysql-3.23.58-1 file...
3
1787
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 relation with J#.Net in my project. Why is that showing that error while installing... Its some what...
0
939
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 command promt it gives me error. for example I have mainwindow.py, customer.py, stock.py and of...
0
6253
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
8732
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8504
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8606
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7337
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6169
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5632
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4159
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
1959
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1622
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.