By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,812 Members | 856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,812 IT Pros & Developers. It's quick & easy.

QUESTION: Does db2 8.2 for z/OS support ALLOW REVERSE SCAN onindexes?

P: n/a
BD
Hey, all.

Subject line says it all.

But for background:

I'm developing on UDB for Windows. The production application is on z/
OS.

I'm using some Quest tools (SQL Optimizer) to review some queries, and
it suggests that creating some indexes with the ALLOW REVERSE SCANS
option will increase performance.

I'm managing the data model with ERwin. In the configuration of ERwin,
I do see an option to ALLOW REVERSE SCANS on my indexes when the data
model is being generated for UDB LUW, but I do not see the option when
I'm working with a z/OS-supported data model.

Not quite sure where to start digging here, but I'm hauled down a few
IBM PDFs, and have found no conclusive evidence that this parameter is
supported under z/OS - but I have not yet stumbled upon the full-on
syntax guide.

I will continue to do so - but thought I might poll the group. I've
seen several differences in terms of what is supported under the
various flavors of db2...

Thanks!!

BD
Feb 18 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
BD
On Feb 18, 3:12*pm, BD <robert.d...@gmail.comwrote:
Hey, all.

Subject line says it all.

But for background:

I'm developing on UDB for Windows. The production application is on z/
OS.

I'm using some Quest tools (SQL Optimizer) to review some queries, and
it suggests that creating some indexes with the ALLOW REVERSE SCANS
option will increase performance.

I'm managing the data model with ERwin. In the configuration of ERwin,
I do see an option to ALLOW REVERSE SCANS on my indexes when the data
model is being generated for UDB LUW, but I do not see the option when
I'm working with a z/OS-supported data model.

Not quite sure where to start digging here, but I'm hauled down a few
IBM PDFs, and have found no conclusive evidence that this parameter is
supported under z/OS - but I have not yet stumbled upon the full-on
syntax guide.

I will continue to do so - but thought I might poll the group. I've
seen several differences in terms of what is supported under the
various flavors of db2...

Thanks!!

BD
Follow-up. Found the syntax guide on publib.boulder.ibm.com - it
mentions no ALLOW REVERSE SCAN in the CREATE INDEX syntax.
Feb 18 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.