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

Question posted by: Jurgen Haan (Guest) on November 21st, 2006 08:15 AM

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-

Quote | Subscribe

3 Answers Posted

Jurgen Haan November 21st, 2006 08:45 AM

Guest - n/a Posts

#2: Re: Packages (Package "NULLID.SYSLH214 0X5359534C564C3031" was not found.)

Jurgen Haan wrote:

Quote:

Originally Posted by

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 November 21st, 2006 01:55 PM

Guest - n/a Posts

#3: Re: Packages (Package "NULLID.SYSLH214 0X5359534C564C3031" was not found.)

Jurgen Haan wrote:

Quote:

Originally Posted by

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/d...chun/index.html

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Jurgen Haan November 21st, 2006 02:05 PM

Guest - n/a Posts

#4: Re: Packages (Package "NULLID.SYSLH214 0X5359534C564C3031" was not found.)

Knut Stolze wrote:

Quote:

Originally Posted by

>
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/d...chun/index.html
>

Ooo.. nice read. Thank you.

-R-

Not the answer you were looking for? Post your question . . .
197,008 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 197,008 network members.

Post your question now . . .
It's fast and it's free

Top Community Contributors

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

What is Bytes?

Popular Articles

Top Community Contributors