SQL0101N for a Select query

#1

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.

#2

On 2/24/2010 10:52 AM, Kiram wrote:

Quote:

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

#3

On Feb 24, 3:08*pm, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL0101N for a Select query

comp.databases.ibm-db2 comp.databases.ibm-db2

SQL0101N for a Select query - 02-24-2010 , 09:52 AM

Re: SQL0101N for a Select query - 02-24-2010 , 02:08 PM

Re: SQL0101N for a Select query - 02-25-2010 , 04:45 PM