Which predicates are stage 1 and indexable?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Markus Neifer - 03 Jan 2006 21:59 GMT

Hi, i've read that 'Col BETWEEN expr1 and expr2' became stage 1 and
indexable in DB2 UDB for z/OS Version 8.

Is there any way to find out which predicates are stage 1 and indexable
in V7/V8?

Had a look in the SQL references but no luck.

TIA, Markus

Reply to this Message

m0002a@yahoo.com - 03 Jan 2006 22:39 GMT

> Hi, i've read that 'Col BETWEEN expr1 and expr2' became stage 1 and
> indexable in DB2 UDB for z/OS Version 8.
[quoted text clipped - 5 lines]
>
> TIA, Markus

The information you need is located in the Administration Guide, which
you can download for free from the IBM web site.
http://www-306.ibm.com/software/data/db2/zos/v7books.html
http://www-306.ibm.com/software/data/db2/zos/v8books.html

Do a search on "predicate types and processing" in the PDF version of
the manual.

Reply to this Message

Markus Neifer - 04 Jan 2006 10:48 GMT

> The information you need is located in the Administration Guide

Thanks a lot! You saved me.

I come from DB2 UDB for LUW and it seems that things are quite
different with DB2 UDB for z/OS...

Greetings, Markus

Reply to this Message