Kbase P32568: Can an area be specified when using proutil idxbuild?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/2/2009 |
|
Status: Verified
GOAL:
Can proutil idxbuild be used to rebuild the indices for an area?
GOAL:
Can an area be specified when using proutil idxbuild?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
In 10.0A and earlier proutil could only build indices for the complete database or by table, but not by area.
10.0B and higher additional functionality was added and proutil may now build indices by a specified area.
Instructions to run idxbuild for the indexes within a certain area:
1. Within the sample program below, change "7" to whatever arenum you are concerned with.
2. Run the program so its output is redirected within a file, named "list_index" for example. "list_index" will contain the list of
indexes from the given area, preceded with the tablename where each index resides.
3. Within the resulting file "list_index", add as a 1 first line:
some
and as the last 3 lines:
!
y
y
4. Run:
proutil <db> -C idxbuild -B 1024 -TB 31 -TM 32 < list_index
Program to generate the list_index file.
FOR EACH _storageobject WHERE _storageobject._object-type = 2 AND _storageobject._area-number = 7 NO-LOCK:
FIND _Index WHERE _index._idx-num = _storageobject._Object-number NO-LOCK NO-ERROR.
FIND _file WHERE _index._file-recid = RECID(_File) NO-LOCK NO-ERROR.
DISPLAY _File-name SKIP _index-name SKIP WITH NO-LABELS.
END.