Re: Question on catalog view syspartitionindexes

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Also note that only keyed logicals would show as an index...

Charles

On Wed, May 26, 2021 at 9:15 AM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

> You're asking for two different lists...
>
> Try
> SELECT *
>   FROM qsys2.syspartitionindexes
>  WHERE system_table_schema = 'QS36F'
>    AND system_table_name = 'CUSMASP'
>  ORDER BY 4;
>
> Charles
>
>
> On Wed, May 26, 2021 at 9:05 AM Robert Rogerson <rogersonra@xxxxxxxxx>
> wrote:
>
> > Hi all,
> >
> > When I run this query,
> >
> > SELECT *
> >   FROM qsys2.syspartitionindexes
> >  WHERE index_schema = 'QS36F'
> >    AND index_name LIKE 'CUSMAS%'
> >  ORDER BY 4;
> >
> > I see fewer indexes/logicals than when I run
> >
> > DSPDBR FILE(QS36F/CUSMASP)
> >
> > which is the based on table for the indexes/logicals.
> >
> > I've done DSPFD on many of the files comparing what is identified in
> > DSPDBR
> > and what is missing in syspartitionindexes but I can't see anything
> > different.
> >
> > Can anyone explain why these don't return the same list?
> >
> > Thanks,
> >
> > Rob
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com