Ad Hoc Index Batch Interface

You can use the jadclient executable RootSchema application AdHocIndexBatchApp to create indexes suitable for optimizing ad hoc queries without requiring database reorganization. For details about ad hoc indexes, see "Maintaining Ad Hoc Indexes", in Chapter 9 of the JADE Development Environment User's Guide.

The JADE initialization file can contain the [JadeAdHocIndex] section, which enables you to specify options for the worker applications that build, drop, and delete an ad hoc index, and for the controller application that starts worker applications when there is an ad hoc index maintenance operation to be performed. For details about the BuildCommitPeriod and MaxBuildWorkers parameters, see "JADE Ad Hoc Index Section [JadeAdHocIndex]", in the JADE Initialization File Reference.

The AdHocIndexBatchApp application specified in the app argument must be run in multiUser mode, because the commands initiate the controller application and its workers to perform the requests.

To execute the AdHocIndexBatchApp application from the non‑GUI client program (for example, from a command script), specify the following.

jadclient schema=RootSchema
          app=AdHocIndexBatchApp
          server=multiUser
          path=database-path
          ini=JADE-initialization-file-path
          startAppParameters
          [command-line-arguments]

The list of command line arguments that you can define after the startAppParameters argument in command=value; format are as follows.

Separate each command action with a semicolon followed by a space, as shown in the following example.

jadclient.exe schema=RootSchema app=AdHocIndexBatchApp server=multiUser path=g:\jade\database\system ini=g:\jade\database\system\jade.ini startAppParameters load=C:\adHoc Files\defn.xml; build=all;

The jadclient executable exits with exit code 1201 if the processing fails or is rejected or exit code 1202 if the status command is performed and the index or indexes are not active.