Re: Logical file index size too small?

["James W. Kilgore" <qappdsn@xxxxxxx>]

Buck Calabro wrote:

> <snip>
> While doing a DSPFD, I noticed that the index size for some
> of these logicals is really small: 16384.  This doesn't
> make any sense because the key length is 36 bytes: I'm
> expecting something closer to 95 megs!
>
>

I think you'll find your answer right here:

> Implicit access path sharing  . . . . . :            Yes
>  <snip>
> Shared access path attributes
>   Maintenance . . . . . . . . . . . . . :            *IMMED
>   Access path recovery  . . . . . . . . :            *NO
>   Force keyed access path . . . . . . . :            *NO
>   Keys must be unique . . . . . . . . . :            No
> ...

Some other, previously recreated, logical has the same index fields (and maybe
additional fields) which this logical is using.



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---