Seeing DSPDBR info in iSeries Navigator

[cwscholbe@dstsystems.com]

When I do this, I see the entire list in Navigator. I am using iSeries Access V5R2 with service pack SI09809. What are you using? Are you connecting to Navigator with a USRPRF that doesn't have authority to some of these indexes???

[David Abramowitz]

Seeing DSPDBR info in iSeries Navigator

Sounds to me like a security issue. Dave

[trevor.lazarus@ssa.gov]

Seeing DSPDBR info in iSeries Navigator

I'm at V5R2 as well, and there's nothing listed in indexes even with the highest authority sign-on. Trevor

[Guest.Visitor]

Seeing DSPDBR info in iSeries Navigator

In Ops Nav, when it says "index", it is being very specific. A logical file is not necessarily an index. A DDS-created LF shows up as a "view". An index is created thru SQL. Ops Nav Properties only shows the latter; DSPDBR shows both. DSPFD on an index shows an "SQL file type" of "INDEX"; on an LF, that property doesn't even appear. I suppose if you created a view thru SQL, the SQL file type would appear, and it would be "VIEW".

[Guest.Visitor]

Seeing DSPDBR info in iSeries Navigator

If you want to see more information about DB relations beyond what DSPDBR shows, check out jDBR from Shane Software. You can download a trial version at www.shanesoftware.com Randy A.

[Guest.Visitor]

Seeing DSPDBR info in iSeries Navigator

When I right-mouse-click on a file listed in Navigator, I can see its Properties. One of the tabs is for Indexes. Why am I only seeing a short list? When I do a DSPDBR on the system, I see the entire list? Am I missing something? Thanks!

[ukpi1b]

Seeing DSPDBR info in iSeries Navigator

Check QSYS2/SYSINDEXES file.