473,574 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Hmz.. what's this then.

can anyone give me any information about this message?

SQL State: 51002
Native: -805
Message: [IBM][CLI Driver][DB2/LINUXX8664] SQL0805N Package
"NULLID.SYSLH20 3 0X5359534C564C3 031" was not found. SQLSTATE=51002
- Error state:51002 Error code:-805

obviously a system package can not be found. But I don't know why, where
has it gone? How do I get it back? I'm scared :'(

-R-
Nov 12 '05 #1
5 4966
Jurgen Haan wrote:
can anyone give me any information about this message?

SQL State: 51002
Native: -805
Message: [IBM][CLI Driver][DB2/LINUXX8664] SQL0805N Package
"NULLID.SYSLH20 3 0X5359534C564C3 031" was not found. SQLSTATE=51002
- Error state:51002 Error code:-805

obviously a system package can not be found. But I don't know why, where
has it gone? How do I get it back? I'm scared :'(

-R-


From DBForums:

"Previously , I encountered the same error but for the package SYSLH203.
I tried a solution found on the Internet:
db2jdbcbind -url jdbc:db2://LOCALHOST:50000/recon -user xxxxx -password
xxxxx -size 20
This command solved the problem for SYSLH203"

--
Anton Versteeg
IBM Netherlands
Nov 12 '05 #2
Anton Versteeg wrote:
"Previously , I encountered the same error but for the package SYSLH203.
I tried a solution found on the Internet:
db2jdbcbind -url jdbc:db2://LOCALHOST:50000/recon -user xxxxx -password
xxxxx -size 20
This command solved the problem for SYSLH203"


Hmz... this results in a:

DB2Binder stopped: Failure to create connection for binding
SQL code: -4499
SQL state: null
Message: A communication error has been detected. Communication
protocol being used: Reply.fill(). Communication API being used:
InputStream.rea d(). Location where the error was detected: insufficient
data. Communication function detecting the error: *. Protocol specific
error codes(s) TCP/IP SOCKETS

another issue that might be connected:

db2inst1@Data:/opt/IBM/db2/V8.1/bnd> db2 bind db2schema.bnd

LINE MESSAGES FOR db2schema.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
5048 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
5236 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
5429 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "5" errors and "0" warnings.

any thoughts on this?
(I'm not even sure what to ask)

-R-
Nov 12 '05 #3
Well,

we've had something like that happen - though I don't recall the
0X5359534C564C3 031 part of the package identifier. Anyway, per default
three packages of this particular flavor are created when you bind the
CLI packages - SYSLH200,201, and 202. Try going to the $BND directory
and issue

db2 bind @db2cli.lst blocking all grant public clipkg nn

where nn is some number greater than 3.

/T

Nov 12 '05 #4
Well,

we've had something like that happen - though I don't recall the
0X5359534C564C3 031 part of the package identifier. Anyway, per default
three packages of this particular flavor are created when you bind the
CLI packages - SYSLH200,201, and 202. Try going to the $BND directory
and issue

db2 bind @db2cli.lst blocking all grant public clipkg nn

where nn is some number greater than 3.

/T

Nov 12 '05 #5
Tomas wrote:
db2 bind @db2cli.lst blocking all grant public clipkg nn

/T


well that did the trick.. Great!! :)

Now that the critical part is over; what is this package used for?
SYSLH203. Is it used for exception handling in DB2?
Because the error occured when we were performing a rather large
transaction, and when the lock count reached around 1300, this package
is called. Furthermore, I understand the naming of these packages follow
certain rules, the H for hold en the 3 for cursor stability, but what
where they exactly?

-R-
Nov 12 '05 #6

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

Similar topics

220
18902
by: Brandon J. Van Every | last post by:
What's better about Ruby than Python? I'm sure there's something. What is it? This is not a troll. I'm language shopping and I want people's answers. I don't know beans about Ruby or have any preconceived ideas about it. I have noticed, however, that every programmer I talk to who's aware of Python is also talking about Ruby. So it...
92
6386
by: Reed L. O'Brien | last post by:
I see rotor was removed for 2.4 and the docs say use an AES module provided separately... Is there a standard module that works alike or an AES module that works alike but with better encryption? cheers, reed
125
14608
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from software giant such as Microsoft SQL Server, Oracle, and Sybase? Is PostgreSQL reliable enough to be used for high-end commercial application? Thanks
145
8737
by: Mark Johnson | last post by:
Oddly enough, I found it difficult, using Google, to find a list of best-of sites based on the quality of their css packages. So I'd ask. Does anyone know of particularly good sites which are in good measure because of their creative and useful css designs? I'm aware of Zen Garden and a few others. So don't bother with those. And I hope I...
121
9978
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode support IDEs are DreamWeaver 8 and Zend PHP Studio. DreamWeaver provides full support for Unicode. However, DreamWeaver is a web editor rather...
24
2761
by: Bob Alston | last post by:
Most of my Access database implementations have been fairly small in terms of data volume and number of concurrent users. So far I haven't had performance issues to worry about. <knock on wood> But I am curious about what techniques those of you who have done higher volume access implementations use to ensure high performance of the...
13
5025
by: Jason Huang | last post by:
Hi, Would someone explain the following coding more detail for me? What's the ( ) for? CurrentText = (TextBox)e.Item.Cells.Controls; Thanks. Jason
8
3134
by: Midnight Java Junkie | last post by:
Dear Colleagues: I feel that the dumbest questions are those that are never asked. I have been given the opportunity to get into .NET. Our organization has a subscription with Microsoft that basically entitled to us to just about every .Net development tool you can imagine. I cant even begin to mention them. To begin with, my...
669
25703
by: Xah Lee | last post by:
in March, i posted a essay “What is Expressiveness in a Computer Language”, archived at: http://xahlee.org/perl-python/what_is_expresiveness.html I was informed then that there is a academic paper written on this subject. On the Expressive Power of Programming Languages, by Matthias Felleisen, 1990....
23
3639
by: Jess | last post by:
Hello, I understand the default-initialization happens if we don't initialize an object explicitly. I think for an object of a class type, the value is determined by the constructor, and for the built-in types, the value is usually garbage. Is this right? However, I'm a bit confused about value-initialization, when does it happen, and...
0
7794
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, well explore What is ONU, What Is Router, ONU & Routers main...
0
8040
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7800
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...
0
8092
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
6437
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 projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5610
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
5296
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
3745
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2230
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.