Prev: RESOLVED
Next: JDBC type 4 and OpenOffice.org
From: TechWitch on 22 Jan 2007 17:04
Are there any particular DB or DBM parameters that would cause more
occurrences of this SQL error:

[IBM][CLI Driver][DB2/AIX64] SQL0805N Package "NULLID.SYSLH106
0X5359534C564C3031" was not found. SQLSTATE=51002

I know I can make more packages available to the CLI interface, but I'm
just curious is our current configuration is allowing more applications
to execute than should be allowed. We haven't been able to re-produce
the error, as it only appears in our production environment.

Thanks in advance for any tips.
TW

From: Mark A on 22 Jan 2007 18:11
"TechWitch" <tech.witch(a)gmail.com> wrote in message
news:1169503482.924684.76910(a)51g2000cwl.googlegroups.com...
> Are there any particular DB or DBM parameters that would cause more
> occurrences of this SQL error:
>
> [IBM][CLI Driver][DB2/AIX64] SQL0805N Package "NULLID.SYSLH106
> 0X5359534C564C3031" was not found. SQLSTATE=51002
>
> I know I can make more packages available to the CLI interface, but I'm
> just curious is our current configuration is allowing more applications
> to execute than should be allowed. We haven't been able to re-produce
> the error, as it only appears in our production environment.
>
> Thanks in advance for any tips.
> TW

Usually caused by programs not closing cursors when they should.


From: TechWitch on 22 Jan 2007 18:31

Mark A wrote:
> Usually caused by programs not closing cursors when they should.

Now that makes some sense. One of these days I'm gonna get that darn
code vetted before it goes to production. Ah well, guess I'll have to
open up my box of db2 bandaids again....

TW

From: TechWitch on 24 Jan 2007 11:22
Is there any performance implication with making more bind packages
available?

--TW

From: TechWitch on 7 Feb 2007 00:25
On Jan 22, 5:11 pm, "Mark A" <nob...(a)nowhere.com> wrote:

> > [IBM][CLI Driver][DB2/AIX64] SQL0805N Package "NULLID.SYSLH106
> > 0X5359534C564C3031" was not found. SQLSTATE=51002
< snip >

> Usually caused by programs not closing cursors when they should.

I've done a client trace, and reviewing the output. It's like trying
to find a needle in a haystack. I did notice that the client which
makes the call and has the application code is in 32 bit while the db2
instance is 64 bit. I wonder if this could be a factor? We did not
experience the problem before when both the client and instance were
32 bit...

TW

 | 
Pages: 1
Prev: RESOLVED
Next: JDBC type 4 and OpenOffice.org