Kbase P4846: Deleting logical files references in server schena resolves issues with different record counts usin
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
A "FOR EACH" on a table yields a different record count with different indexes
DB2/400 database has *Select/Omit* logical files as indexes
"ALLOW-SELECT-OMIT-INDEXES" attribute cannot be changed in the Progress setting file (PROSET)
Server Schema (dictionary library) contains "Select/Omit" logical files (indexes)
CAUSE:
*Select/Omit* logical files cause the record count to be different because these indices do not reference all records in the physical file.
FIX:
Since the PROSET file can not be changed, you will need to delete each of the *Select/Omit* logical file references from the p__files using the Progress/400 utility RMVSCHE.
WARNING: DO NOT DELETE THE "Select/Omit" LOGICAL FILES FROM THE LIBRARY.
Steps to accomplish this:
1. Use the Progress/400 RMVSCHE (Remove Server Schema Entry) utility to delete each of the *select/omit* logical file references from the server schema.
2. Synchronize the client.