John,
:RUN OMNIUTIL.PUB.DISCACCT;XL="XLOMNIDX.PUB.SYS"
Remember DISCACCT is whatever account you are using "DISC", "DISC300" are
examples.
Select 2 for re-indexing options
Select 2 for re-indexing specific tables
Enter database name
F2 to mark the dataset you want to re-index
F8 to finish and follow instructions to re-create the job.
BTW, re-indexing generally a single threaded CPU intensive process. If you
have multiple CPU's it is possible to do it in multiple thread. YMMV, but if
you have enough memory and I/O, this can cut the re-index time in half or
better. I have 4 processors, and cut the time to 1/4 of what it used to take.
Here is a sample job.
!JOB MACORDIX,MGR.ACCOUNT,MACSDATA;PRI=DS;OUTCLASS=LP,1,1
!COMMENT
!COMMENT ******************************************
!COMMENT Created: MON, MAR 1, 2004, 10:31 AM
!COMMENT
!COMMENT MACORDIX is an indexing JOB stream generated
!COMMENT for an existing OMNIDEX-enhanced database.
!COMMENT It is typically used after reinstalling
!COMMENT OMNIDEX. It repopulates the index sets.
!COMMENT ******************************************
!COMMENT
!SETJCW CIERROR = 0
!CONTINUE
!RUN OMNIUTIL.PUB.DISC300;INFO='-T';XL='XLOMNIDX.PUB.SYS'
MODIFY MACORD.MACSDATA
INDEX CUSTOMERS
INDEX CUSTOMERS.CUST-NO
ACTIVATE
EXIT
!IF CIERROR <> 0 THEN
! SHOWJCW
! TELL MGR.MICRCONV; MACORDIX: Indexing Failed !!!
!ELSE
! TELL MGR.MICRCONV; MACORDIX: Indexing completed.
!ENDIF
!IF CIERROR > 1609 AND CIERROR < 1628 THEN
! COMMENT - TELL Message failed
! SHOWJCW
! SETJCW CIERROR=0
!ENDIF
!EOJ
Regards,
-Craig
--- John Bawden <[log in to unmask]> wrote:
> Fellow Listers,
>
> Currently we re-index the Omnidex tables in an all or
> nothing approach and our application vendor support
> refuses to suppport any other approach. I would like
> to be able to re-index a single dataset when I have
> NetBase out of sync problem rather than incur the 6
> hour exclusive access run time to do the entire
> database. I've tried Omniutil's re-index function but
> it doesn't seem to work. Does any one know of a way to
> do a single set?
> TIA
>
> John Bawden
> QualChoice
>
> __________________________________
> Do you Yahoo!?
> Get better spam protection with Yahoo! Mail.
> http://antispam.yahoo.com/tools
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|