Alternate Index and ESDS.

[Anup Apte]

Hi

Mostly I've worked with KSDS and AIX, however, I came to kwno that we can create AIX on ESDS also. I'm confused ESDS does not have any INDEX then how it supports AIX?

Thanks

[Robert Sample]

Physically, an alternate index is a complete different pair of files than the base cluster. There is no requirement to have an index before you can have an alternate index. I've never used an ESDS with an alternate index, so I'm not sure of the advantages.

[dick scherrer]

Possibly to provide the ability to directly access info rather than having to find it serially.

For example - read all info for a particular account or department or whatever.

[dick scherrer]

Follow on:

Cannot recall the last time i was a trainee

d

[Anuj Dhawan]

I've an odd habit to take people to their past since the time I happened to be in U.S. during Halloween...

[Anuj Dhawan]

And I'm sure, you'll not be "this" for so long...

And yes, Welcome to the Forums, it's nice to see you here!

Regards,

[Anuj Dhawan]

Hi ApexNC,

Welcome to the Forum and Thanks for posting in the detailed explanation, appreciate it.

Request you to please use BBcode Tags by enclosing the "your code" inside the

Code: Select all

 Tags, like this: (// Please remove the space after code ]):

[quote][code ]
// your code
[/code ] [/quote]

I've edited your post to add the Code Tags... :). Hope it looks fine, the way you wanted to convey it.

Regards,

[Anuj Dhawan]

this is a copy of something I posted to LinkedIn, which is the reason for the leading "_" characters. LinkedIn removes leading spaces so you lose all indentation without them. If this site preserves leading spaces, those could be removed.

Have done the editing, took a bit but I think it looks neat now.

Thanks,

[Anup Apte]

Thanks ApexNC and Enrico - this is a great help and gives me a direction.

Much appreciate your inputs...