Prev: slow connection to DB2/LINUX 8.2.3
Next: restore backup from v7.2 to v9.1
From: Jurgen Haan on 21 Nov 2006 04:10
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-
From: Jurgen Haan on 21 Nov 2006 09:28
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/db2/library/techarticle/dm-0606chun/index.html
>

Ooo.. nice read. Thank you.

-R-
 | 
Pages: 1
Prev: slow connection to DB2/LINUX 8.2.3
Next: restore backup from v7.2 to v9.1