Omnidex Utilities

ODXAIM

ODXAIM, Omnidex Automatic Index Maintenance, automatically maintains index synchronization for applications that do not use OmniAccess, using database triggers to signal when an update has occurred. It also enables transaction management on the Omnidex indexes.

• Applications like SQL Plus work directly with the underlying database management system and are unaware of Omnidex or the Omnidex indexes. Normally, when data is updated through SQL Plus, the Omnidex indexes remain unchanged. Through database triggers, ODXAIM automatically updates the indexes with these changes.
• If transaction management is set up on a table installed with Omnidex indexes, ODXAIM causes those indexes to inherit the transaction management. When a change is made to the table, a record is written to a table named ODXTRANS. ODXAIM reads the ODXTRANS table and updates the indexes accordingly. If the original transaction fails, the record is never written to ODXTRANS.

It is important to note that index updates are not immediate and, depending on the frequency of database updates, there could be a slight delay in index synchronization.

ODXAIM has four modes of operation.

• As part of the setup process, ODXAIM generates the triggers and a DDL for the AIM table(s), in a script file that is installed in the database through the database's SQL utility (SQL Plus in Oracle).
• ODXAIM
• ODXAIM runs as a daemon process on Unix or a service on Windows, to monitor the AIM table and synchronize the Omnidex indexes with any database changes.

Syntax

ODXAIM operates through the use of command line options. Many of the option settings can also be defined within a configuration file. With the exception of the configuration filespec, all options are preceded with a - (dash). For a list of available options, run ODXAIM with the -help or -? option.

C:\>odxaim -?
OdxAIM - Omnidex Automatic Indexing Manager

Valid directives are:

odxaim [cfgfile]
[-env=OAEnvFile]
[-sleepint=n]
[-sleepstep=n]
[-sleepmin=n]
[-sleepmax=n]
[-colsep=c]
[-datasep=d]
[-nontservice]
odxaim cfgfile
[-ntservice=unique_service_name]
[-ntsrvaction={INSTALL | INSTALL_AUTO | DELETE |
START | STOPT | PAUSE | CONTINUE}
odxaim -shutdown [cfgfile] [-env=OAEnvFIle]
odxaim -gentrigger
[-file=newtrigfile]
[cfgfile]
[-env=OAEnvFile]
[-newenvsrc=newenvsrcfile]
[-tables=<oatablelist>]
[-colsep=c]
[-datasep=d]
[-overwrite]
odxaim -genodxtrans
[-file=envsource]
[-env=OAEnvFile]
[-tables=<oatablelist>]
[-newfile | -append]
odxaim -help | -?
odxaim -version

top