Consultor Eletrônico

Solution ID: P6424

GOAL:

How to build an index list (for idxbuild, idxfix or idxcompact)

FACT(s) (Environment):

Progress 9.x

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.

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