How to get the Optimization level?

[specialdosa]

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 ?

[Jan M. Nelken]

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

[jefftyzzer]

On Jun 11, 11:10 am, [e-mail] 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

[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).

[specialdosa]

On Jun 11, 12:33 pm, Ian <[e-mail]:

[e-mail] 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.