Kbase 20195: PROUTIL IDXCOMPACT Error: Both table and index numbers are required
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/13/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Error when performing IDXCOMPACT
Error: Both table and index numbers are required
CAUSE:
Incorrectly supplying Index Number when specifying Table Name. Need to use Index name.
FIX:
Use IDXCOMPACT to compact the indexes of a table. The basis for determining whether an index needs to be compacted is the interpretation of an index analysis or database analysis that indicates whether an index has grown to a point that it is using a lot of disk space if it has become fragmented.
After the analysis is done, the utility presents a list of the tables and indexes in the database. Two of the items in the list are the index name and number. There is no equivalent to index number for tables.
Enter the table and index name, or the owner of the table, table name, and index name as well as a percentage of compaction with the IDXCOMPACT utility. Do this as follows:
proutil databasename -C idxcompact PUB.tablename.indexname 60 <return>
PUB specifies the owner of the table, and the number 60 specifies percentage of compaction.
If the value for the Index is supplied as the number returned with the analysis:
proutil databasename -C PUB.Customer.13 60 <return>
The following Progress error is generated:
Both table and index numbers are required.
This error is returned because information types have been mixed. There is no equivalent to index number for tables, then table NAME and index NAME should be used in the IDXCOMPACT utility.