Query size limits

Question posted by: --CELKO-- (Guest) on July 28th, 2008 07:45 PM

What are the current query size limits (bytes) for various DB2
products?

Mark A

Guest

n/a Posts

July 28th, 2008
08:15 PM
#2

Re: Query size limits

"--CELKO--" <jcelko212@earthlink.netwrote in message
news:258b1bc3-9ae1-4213-85b9-8e296f43dd27@l64g2000hse.googlegroups.com...

Quote:

What are the current query size limits (bytes) for various DB2
products?

The limits are in one of the appendixes of the SQL Reference. If there is a
SQL Reference Vol 1 & 2, then try Vol 1 (LUW).

Serge Rielau

Guest

n/a Posts

July 29th, 2008
12:05 AM
#3

Re: Query size limits

--CELKO-- wrote:

Quote:

What are the current query size limits (bytes) for various DB2
products?

DB2 for LUW supports 2MB of statement text. The internal size/complexity
is limited by memory. If things get too complex the optimizer will dial
back to a greedy algorithm.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Not the answer you were looking for? Post your question . . .
190,073 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment

Didn't find the answer you were looking for?
Post Your Question

Top Community Contributors