Tim Joseph <[log in to unmask]> said:

> With regard to SUPERDEX, under TPI the SI set is hidden from DBINFO by default
> (may be toggled).  Some programs loop on set number and may come upon the SI
> where DBINFO act strangely base on normal set assumptions.  By default SI is
> added at the end of the set list, although SUPERDEX TPI indexing will work
> fine
> if SI is at any position in the set list.  Quick work around, if you have
> exclusive access, is to turn indexing off, run howmessy, then turn indexing on
> again.
>
> Steps:
> a) DBUTIL 'DISABLE basename FOR INDEXING'
> b) HOWMESSY
> c) run simaint.superdex.sys and respond to basename prompt then CR out of
> program.

...snipped...

> >In a message dated 98-06-26 14:08:04 EDT, Jim Phillips writes:
> >> HOWMESSY
> >> Enter Database: MMSDB1
> >>  Error:  No match found for master dataset path
...snipped...

Unfortunately, HOWMESSY isn't the only program that shows up this
problem.

If you try creating an Image Btree index on a database where the
Superdex SI set is not the last, the same problem occurs, the
workaround is the same, and Tim Joseph is the one that found it for
us.

HPRC knows of this. SR 5003412783.

Bob.

--=--=--
Bob Walker, Computer Centre  --  [log in to unmask]
Capilano College, North Vancouver, BC, CANADA.
------