Re: Get Record Creation Date

On 07-Jan-2014 14:01 -0800, Vernon Hamberg wrote:

create index dp2test/custdatix
on dp2test/qcustcdt (rrn(qcustcdt))

The index has 12 entries, which is correct.

We are at 7.1 TR6 (IIRC).

I think this support came out in 6.1

Huh. Interesting. Actual tests using keyed access path I/O or the selection of that AccPth by the optimizer in implementing a query would be more telling than just the creation... but just the creation is good to know. Too bad I only have v5r3 to play with :-(

I recalled not being able to create an equivalent on v6r1, and seem to recall also seeing RRN explicitly referenced in the restricted function list for CREATE INDEX, though maybe instead just by implication of the error message. Looking now, I see that the RRN is\was not included in that list on v6r1:
<http://pic.dhe.ibm.com/infocenter/iseries/v6r1m0/topic/db2/rbafzxcindx.htm>

Given how pervasive the implication that the Query Engine would only use table-scan implementations for almost any use of RRN() [excepting what is available via an EVI], I probably just never followed-up; i.e. due to apparent irrelevance, even if such an index existed, except for RLA. I wonder what the real story is.? Found nothing in the What's new, nor anywhere else in the InfoCenter, nor even DeveloperWorks. I did some other quick\wider web searches and came up empty; looking for any stories talking about creating such an index, and the ability for such an INDEX over the RRN() to be utilized by the SQE for implementing. Would have been a good topic to followup on when I was still employed.