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

[Jurgen Haan]

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-

[Jurgen Haan]

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-

[Knut Stolze]

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

[Jurgen Haan]

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-