469,364 Members | 2,398 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,364 developers. It's quick & easy.

How to get the Optimization level?

We use DB2-LUW-8.2.

I am doing some research on performance issues and I read about the
"OPTIMIZATION LEVELS' and their impacts on Joins.

How do I get the Optimization level implemented here? Can I query some
system tables? Can someone help me pls ?

Jun 11 '07 #1
4 8732
sp*********@gmail.com wrote:
We use DB2-LUW-8.2.

I am doing some research on performance issues and I read about the
"OPTIMIZATION LEVELS' and their impacts on Joins.

How do I get the Optimization level implemented here? Can I query some
system tables? Can someone help me pls ?
Read the online documentation available at:

http://publib.boulder.ibm.com/infoce...w/v8/index.jsp

You may want to search for CURRENT QUERY OPTIMIZATION term. Note that
default optimization level is part of Database configuration (DFT_QUERYOPT).
Jan M. Nelken
Jun 11 '07 #2
On Jun 11, 11:10 am, speciald...@gmail.com wrote:
We use DB2-LUW-8.2.

I am doing some research on performance issues and I read about the
"OPTIMIZATION LEVELS' and their impacts on Joins.

How do I get the Optimization level implemented here? Can I query some
system tables? Can someone help me pls ?
To see the current level for your session:

VALUES CURRENT QUERY OPTIMIZATION

To set it:

SET CURRENT QUERY OPTIMIZATION n

If you want to look at the bound value for existing packages, query
the QUERYOPT column of SYSCAT.PACKAGES

--Jeff

Jun 11 '07 #3
Ian
sp*********@gmail.com wrote:
We use DB2-LUW-8.2.

I am doing some research on performance issues and I read about the
"OPTIMIZATION LEVELS' and their impacts on Joins.

How do I get the Optimization level implemented here? Can I query some
system tables? Can someone help me pls ?
You can get the CURRENT QUERY OPTIMIZATION special register:

VALUES(CURRENT QUERY OPTIMIZATION)

The default value assigned to a new connection to a database is
determined by the database configuration parameter (DFT_QUERYOPT).

Jun 11 '07 #4
On Jun 11, 12:33 pm, Ian <ianb...@mobileaudio.comwrote:
speciald...@gmail.com wrote:
We use DB2-LUW-8.2.
I am doing some research on performance issues and I read about the
"OPTIMIZATION LEVELS' and their impacts on Joins.
How do I get the Optimization level implemented here? Can I query some
system tables? Can someone help me pls ?

You can get the CURRENT QUERY OPTIMIZATION special register:

VALUES(CURRENT QUERY OPTIMIZATION)

The default value assigned to a new connection to a database is
determined by the database configuration parameter (DFT_QUERYOPT).
Thanks - all of you - for your help. I appreciate it.

Jun 13 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Makis Papapanagiotou | last post: by
5 posts views Thread by AC Slater | last post: by
5 posts views Thread by Praveen_db2 | last post: by
1 post views Thread by Will Ware | last post: by
3 posts views Thread by Abhishek | last post: by
20 posts views Thread by Ravikiran | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.