Kbase P23830: What is the syntax to run idxbuild using an input file ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
What is the syntax to run idxbuild using an input file ?
GOAL:
How to run idxbuild unattended ?
FIX:
This solution is only intended to show a sample of how to run
the IDXBUILD in a non interactive mode.
Let's use the table Customer and the index "name" as a example:
create a file named idx.txt with the the following syntax
some
customer
name
!
y
y
Multiple indices may be defined in the text file by putting the table
name and index name on separate lines as in the following example where
the customer table will have the name and custnum index rebuilt:
some
customer
name
customer
custnum
!
y
y
run the following command:
proutil <dbname> -C idxbuild -G 0 < idx.txt > idx.log
The log should read:
PROGRESS Version 9.1D03 as of Wed Dec 4 04:44:43 EST 2002
Index Rebuild Utility
=====================
Select one of the following:
All - Rebuild all the indexes
Some - Rebuild only some of the indexes
Quit - Quit, do not rebuild
Enter your selection:
Enter the name of table containing the index.
Enter ! to indicate input is complete. (9176)
Table name:
Index name:
Enter the name of table containing the index.
Enter ! to indicate input is complete. (9176)
Table name:
The following indexes will be rebuilt:
Owner: PUB
Table: customer
Index: name
Is this correct? (y
)
Do you have enough disk space for index sorting? (y
)
Index 15 ( PUB.Customer, Name ): de-activated (8831)
Temporary sort file at: C:\PROGRESS\WRK will use the available disk space. (5288)
Sorting indexes in 8 groups.
Phase 1 complete.
Sorting and index building group 7.
Index 15: Name rebuild is complete.
Sorting and index building group 6.
Sorting and index building group 5.
Sorting and index building group 4.
Sorting and index building group 3.
Sorting and index building group 2.
Sorting and index building group 1.
Sorting and index building group 0.
Temporary sort file at C:\PROGRESS\WRK used up 0K of disk space. (5283)
A total of 0K of temporary sort disk space was used. (5284)
Index 15 ( PUB.Customer, Name ): activated (8830)
Index rebuild complete. 0 error(s) encountered. (1644)