469,286 Members | 2,442 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,286 developers. It's quick & easy.

Packages (Package "NULLID.SYSLH214 0X5359534C564C3031" was not found.)

Hi hi.

I'd like to gain some knowledge on packages.

We're getting an error "SQL0805N Package "NULLID.SYSLH214
0X5359534C564C3031" was not found. SQLSTATE=51002" On our production
database. And as suspected, SYSLH214 is not in the packages catalog.

Afaik, there are only a few packages available per connection?
If so, how can I increase this number?
I know that the error we're having is probably due to the fact that our
program has a few cases in which the cursor object does not get freed.
(known bug, being fixed).

I was wondering if someone could explain to me what packages are
*exactly* used for and what their place is in the database.

Been googling on it, but it appears that some people have the uncanny
ability to be as vague as possible on it.

So, help is greatly appreciated, share your knowledge on packages with
me please. :)

-R-
Nov 21 '06 #1
3 3040
Jurgen Haan wrote:
We're getting an error "SQL0805N Package "NULLID.SYSLH214
0X5359534C564C3031" was not found. SQLSTATE=51002" On our production
database. And as suspected, SYSLH214 is not in the packages catalog.
Ok.. Publib tells me the following:
Apparantly a large placeholder for held cursors. (no idea what 'large'
means, large as in it can hold a lot of cursors? or...?).
214: Isiolation level CS, iteration 14.
What does that iteration mean, and what iterates through it?
Does the iteration work like a stack or something? Thus releasing held
cursors lowering it again?

And when I do a select on the package catalog, I see the following LH2
packages:

SYSLH20E - SYSLH213. Where are 200 through 20D?
Did a clipk bind with clipkg set to 30, what does that affect?
Afaik setting clipkg to 30 would make it possible to iterate from 0 to
29 (decimal, not hex). Apparantly that isn't so?

Ty for any input.

-R-
Nov 21 '06 #2
Jurgen Haan wrote:
Hi hi.

I'd like to gain some knowledge on packages.

We're getting an error "SQL0805N Package "NULLID.SYSLH214
0X5359534C564C3031" was not found. SQLSTATE=51002" On our production
database. And as suspected, SYSLH214 is not in the packages catalog.

Afaik, there are only a few packages available per connection?
If so, how can I increase this number?
I know that the error we're having is probably due to the fact that our
program has a few cases in which the cursor object does not get freed.
(known bug, being fixed).

I was wondering if someone could explain to me what packages are
*exactly* used for and what their place is in the database.
Did you have a look at this article already? It explains packages - as used
by CLI and other applications - pretty well:
http://www.ibm.com/developerworks/db...hun/index.html

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 21 '06 #3
Knut Stolze wrote:
>
Did you have a look at this article already? It explains packages - as used
by CLI and other applications - pretty well:
http://www.ibm.com/developerworks/db...hun/index.html
Ooo.. nice read. Thank you.

-R-
Nov 21 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Chris Barker | last post: by
15 posts views Thread by Nick Coghlan | last post: by
2 posts views Thread by Peter Saffrey | last post: by
1 post views Thread by Kwikrick | last post: by
9 posts views Thread by datapro01 | last post: by
4 posts views Thread by jason.awlt | last post: by
reply views Thread by giovanni gherdovich | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.