Prev: Limiting file system caching on RH Linux version 5
Next: Message queue sizing on Linux
From: Kiram on 24 Feb 2010 10:52
Hi, I get this error SQL0101N error for the Select Query. I know that
I am selecting all the colums from 10 tables and passing like 200
values to the IN Clause for a column. But it does work in other
environments(different db2 versions though) but doesnt work in one
environment. I am on db2 v9.5 fix pack 0. I tried increasing the
STMTHEAP upto 100000 from 40000 but still doesnt work. Is there
anything else I can do.
From: Serge Rielau on 24 Feb 2010 15:08
On 2/24/2010 10:52 AM, Kiram wrote:
> Hi, I get this error SQL0101N error for the Select Query. I know that
> I am selecting all the colums from 10 tables and passing like 200
> values to the IN Clause for a column. But it does work in other
> environments(different db2 versions though) but doesnt work in one
> environment. I am on db2 v9.5 fix pack 0. I tried increasing the
> STMTHEAP upto 100000 from 40000 but still doesnt work. Is there
> anything else I can do.
Starting with Db2 9.5 -101 should be a very, very rare thing thanks to
the multi-threaded engine.

can you run the query from the command line processor (CLP) using the -a
option.
That will dump the SQLCA.
When you post it here I can home in on the context (e.g. optimizer vs.
parser...)

Cheers
Serge


--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

From: Kiram on 25 Feb 2010 17:45
On Feb 24, 3:08 pm, Serge Rielau <srie...(a)ca.ibm.com> wrote:
> On 2/24/2010 10:52 AM, Kiram wrote:> Hi, I get this error SQL0101N error for the Select Query. I know that
> > I am selecting all the colums from 10 tables and passing like 200
> > values to the IN Clause for a column. But it does work in other
> > environments(different db2 versions though) but doesnt work in one
> > environment. I am on db2 v9.5 fix pack 0. I tried increasing the
> > STMTHEAP upto 100000 from 40000 but still doesnt work. Is there
> > anything else I can do.
>
> Starting with Db2 9.5 -101 should be a very, very rare thing thanks to
> the multi-threaded engine.
>
> can you run the query from the command line processor (CLP) using the -a
> option.
> That will dump the SQLCA.
> When you post it here I can home in on the context (e.g. optimizer vs.
> parser...)
>
> Cheers
> Serge
>
> --
> Serge Rielau
> SQL Architect DB2 for LUW
> IBM Toronto Lab

I solved. There wasn't enough APPL_MEMORY for the STMTHEAP to grow in
order to prepare the Query.

Thanks for responding.
 | 
Pages: 1
Prev: Limiting file system caching on RH Linux version 5
Next: Message queue sizing on Linux