473,395 Members | 1,343 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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

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
1 2485
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Hans | last post by:
Hello group, I have a table with the next contents. It lists data about : Who sent what kind of message at what time. For the Level column: The highest level is Critical, the middle is Warning,...
9
by: Robert Brown | last post by:
If I use _reverse_ wildcard search will it always result in a table scan? Is it possible to get the DB (Oracle or SQL server) to use indexes when doing reverse wildcard match? let's say I have:...
11
by: Mark Yudkin | last post by:
The documentation is unclear (at least to me) on the permissibility of accessing DB2 (8.1.5) concurrently on and from Windows 2000 / XP / 2003, with separate transactions scope, from separate...
14
by: ford_desperado | last post by:
Why isn't ALLOW REVERSE SCANS the default? Why do we have to - drop PK - create an index - recreate PK What are the advantages of indexes that do not allow reverse scans?
2
by: Manny Chohan | last post by:
Guys, I am giving users to upload files on my server. i have Symantec virus scan on my server running in the background. Now would a user be able to upload document with virus inside it or not...
9
by: Andy B | last post by:
If I bought one of these boxes/OS combos as a postgresql database server, would postgresql be able to make the best use of it with a huge (e.g. 40GB) database? Box: HP ProLiant DL585, with ...
21
by: yeti349 | last post by:
Hi, I'm using the following code to retrieve data from an xml file and populate a javascript array. The data is then displayed in html table form. I would like to then be able to sort by each...
2
by: natG | last post by:
On a 3 column table, the PK consists of all 3 columns. I have queries on the first two columns, as well as on the last two columns. (Select * where column3=x and column2=y.) I was hoping that...
40
by: Phlip | last post by:
Scott Lurndal wrote: Would it also cause a problem if your file descriptors go "around the horn", and exceed some platform-specific limit, such as 0x80000000? They would "go negative" when...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.