471,872 Members | 1,295 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,872 software developers and data experts.

setting optimizing class on iseries

Hi,

Does anyone know how to set the current query optimization class for db2 UDB
for iSeries.
Because the optimizer is joining my subquery , and I want it not to.

This is how it's done on other os.
SET CURRENT QUERY OPTIMIZATION = 1 doesn't work for iseries (token query is
invalid)
http://iibm01.inf.uni-jena.de/db2v8d...n/c0005277.htm

Corné
Nov 12 '05 #1
0 1198

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Thad Rizzi | last post: by
4 posts views Thread by erkki | last post: by
1 post views Thread by Yanik Reid | last post: by
NeoPa
reply views Thread by NeoPa | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.