| IBM MAINFRAME HELP FORUMS for COBOL, JCL, CICS, DB2, IMS etc...
Help & Support Forums for IBM Mainframe computers Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7, CA-11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, VSAM, ISPF, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
kanna n
Joined: 04 Oct 2007
Posts: 5
Location: pune
|
| Posted: Tue Mar 11, 2008 7:19 pm Post subject: Query on INDEX SET |
|
|
HI,
if i define an Index set as below.......
what is that 12 keys?? how to calculate that count.
ADD
SET NAME IS ABCDEF
ORDER IS SORTED
MODE IS INDEX BLOCK CONTAINS 12 KEYS
OWNER IS SYSTEM
WITHIN AREA WXYZ-AREA OFFSET 0 PERCENT FOR 100 PERCENT
can any one please help me in this ??
thanks in advance.. |
|
| Back to top |
|
Shaheen Kalokhe
Joined: 21 Feb 2008
Posts: 5
Location: India
|
| Posted: Wed Mar 12, 2008 12:10 pm Post subject: Re: Query on INDEX SET |
|
|
Hi Kanna,
The Keys that you have in the Index are one/more Fields that are part of your Actual Physical Record. The key(s) tells us the fields on which the Index record is sorted. |
|
| Back to top |
|
kanna n
Joined: 04 Oct 2007
Posts: 5
Location: pune
|
| Posted: Wed Mar 12, 2008 3:15 pm Post subject: Reply to: Query on INDEX SET |
|
|
thanks.
but is there any algorithm or formula to calculate that key count??
if so how. |
|
| Back to top |
|
Shaheen Kalokhe
Joined: 21 Feb 2008
Posts: 5
Location: India
|
| Posted: Tue Mar 18, 2008 5:28 pm Post subject: Re: Reply to: Query on INDEX SET |
|
|
| As per my knowledge there are no algorithms, the DBA'S decide the sort keys when designing the databse as per the requirements. |
|
| Back to top |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|