Kbase P35058: Does the -silent option with idxbuild record each fixed reco
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/4/2003 |
|
Status: Unverified
GOAL:
Does the -silent option with idxbuild record each fixed record key in the DB log file?
FIX:
In silent mode each individual record is not recorded in the log file, just the total index changes.
Below is an example of the DB log file from my tests.
Proutil DBNAME -C idxfix
Mon Aug 04 11:18:39 2003
11:18:39 proutil -C idxfix session begin for user1 on CON:. (451)
11:18:39 Begin Physical Redo Phase at 0 . (5326)
11:18:39 Physical Redo Phase Completed at blk 0 off 2417 upd 0. (7161)
11:18:39 proutil -C idxfix session begin for user1 on CON:. (451)
11:19:40 Index 48 (PUB.Order, CustOrder): Found invalid key 5<>6150 recid 5206. (8829)
11:19:40 Index 48 (PUB.Order, CustOrder): Found invalid key 10<>6135 recid 5204. (8829)
11:19:40 Index 48 (PUB.Order, CustOrder): Found invalid key 10<>6140 recid 5205. (8829)
11:19:40 SYSTEM ERROR: Index 48 (PUB.Order, CustOrder) contains 3953 entries, but 3950 records found. (8779)
11:19:40 Index CustOrder in table Order is inactive. (5071)
11:19:40 1 indexes, 642 blocks, 3950 keys checked.
11:19:40 SYSTEM ERROR: Index fix found 4 errors. (4974)
11:19:41 proutil -C idxfix session end. (334)
Proutil DBNAME -C idxfix -silent
Mon Aug 04 11:20:25 2003
11:20:25 proutil -C idxfix session begin for user1 on CON:. (451)
11:20:25 Begin Physical Redo Phase at 0 . (5326)
11:20:25 Physical Redo Phase Completed at blk 0 off 2453 upd 0. (7161)
11:20:25 proutil -C idxfix session begin for user1 on CON:. (451)
11:20:56 Index 48 ( PUB.Order, CustOrder ): activated (8830)
11:20:56 1 indexes, 642 blocks, 3950 keys checked.
11:20:56 Index fix completed successfully.
11:20:56 Index fix made 3 index changes. (4975) *********
11:20:57 proutil -C idxfix session end. (334)