DBINSTAL

Program Operation

DBINSTAL uses an interactive prompting sequence for initial prototyping of the Omnidex indexes. For production operations, the input is generally saved in separate script files for the indexing Install and the indexing B (or Index) operations. DBINSTAL continues to prompt for additional Tables and Columns until a '/' is specified as the table or column name. Installation batch files must follow the prompting sequence exactly to avoid errors during execution.

First run DBINSTAL:

osf> [/users/test]$ dbinstal orders.env

The DBINSTAL header is displayed followed by the Cmd: prompt.

Cmd:

Enter and database-level indexing options prior to beginning the installation.

To install indexes use the Install command followed by table options and index options (on columns). The following illustrates the DBINSTAL prompts:

- Enter a compiled Environment filespec. If the environment file suffix is omitted, .env is assumed.

Database or Environment: /usr/disctest/orders.env

Cmd: Install

At the Cmd: prompt, enter any desired database-level options, Install or I to begin the installation or ? or H for a list of valid commands.

Multi-Dimensional Keyword (MDK) Indexes are specified first.

- Enter a table name followed by the desired table options.

Table name? Mytable

If the table entered is a child table, the following prompt will appear:

Link Column 1? /

- Enter the column name to be indexed followed by the desired indexing options.

Column name: mycolumn;NP

To specify a composite index of multiple columns, specify a name with the exclamation point:

Column name: CITY_STATE!
Component 1 (Column [, start, length]): City
Component 2 (Column [, start, length]): State
Component 3 (Column [, start, length]): /

- Enter an additional column or a slash to exit the current table when all columns are specified.

Column name: /

- Enter an additional table name or a slash to exit the MDK installation.

Table name? /

Enter Aggregation/Sorted Keyword (ASK) Indexes next.

Table name? mytable

Column name: agg1!
Component 1 (Column [,start,length]): Account
Component 2 (Column [,start,length]): Trans_amount
Component 3 (Column [,start,length]): /

Column name: /

Table name: /

Proceed with installation [Y]?

Press return or enter 'Y' to install the indexes.

DBINSTAL will now create the empty index files.

top