Kbase P8017: AS/400: How to manually fix the corrupted index from P__file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/28/2003 |
|
Status: Unverified
GOAL:
How to manually fix the corrupted index from P__files
FIX:
There are two ways to remove and re-add the corrupted index from P_files:
1) Using Progress/400 DB2/400 Data Dictionary and remove the index and re-add the index.
or
2) Using Progress/400 utility called RMVSCHE (This will remove the schema entry).
In both cases you have to perform a synchronization with the client schema holder.
When Progress/400 DB2/400 dictionary is used, do not remove the physical object. This is also true when the logical file is used by other non progress applications. Not removing physical file, allows to remove the logical file reference the P__files.
The RMVSCHE utility only removes the information from the P__files. Therefore this process is safer.
In order to add the index back, the index or logical file should be added BEFORE the new synchronization.