Consultor Eletrônico

Status: Verified

GOAL:

How to build an index list for idxbuild or idxfix?

GOAL:

How to use 4GL to generate a list of index for idxbuild or idxfix?

GOAL:

How to automate idxbuild process?

FACT(s) (Environment):

All Supported Operating Systems
Progress/OpenEdge Versions

FIX:

This small piece of code will generate a file with the list of indexes within your database, in the format that's needed to redirect to an idxbuild, idxfix or idxcompact command.

OUTPUT TO index.file.
FOR EACH _file WHERE _file-number > 0:
FOR EACH _index OF _file:
DISPLAY _file-name SKIP _index-name SKIP WITH NO-LABELS.
END.
END. The generated txt file contains table name, then index name, then table name, then index name and so on
Find below the usage of the "index.file" within a sample for idxbuild and a sample for idxfix, as tested with version 9.1D on UNIX.

For idxbuild, you will need to modify "index.file" by
- adding in the first (empty) line:
some
- adding at the end of your list of indexes, the following 3 lines:

!
y
y

and you run, for example:
proutil <dbname> -C idxbuild -TB 24 -TM 32 -B 512 < index.file

For idxfix on-line, you will need to modify "index.file" by
- removing the first empty line.
- adding the following 2 lines at the top:

3
some

- adding at the end of your list of indexes, the following lines:

!
y
y
y
all
y

and you run, for example:
proutil <dbname> -C idxfix -TB 24 -TM 32 < index.file