R
Rob Fitzpatrick
Guest
> I'm wondering if there is some health checkup option in proutil that will verify the state of the database (that all the upgrades over the years were done "cleanly"). If you do proutil db -C updatevst and -C updateschema, that will ensure any previously missed system updates have been applied. You can also try proutil db -C idxfix, which gives you several options. I'd suggest running it on a test DB to get a feel for what it does and how long it takes on your DB/hardware. OpenEdge Release 11.7.5 as of Fri Jun 7 08:29:03 EDT 2019 Index Fix Utility 1. Scan records for missing index entries with index block validation. 2. Scan indexes for invalid index entries. 3. Both 1 and 2 above. 4. Cross-reference check of multiple indexes for a table. 5. Build indexes from existing indexes. 6. Delete one record and its index entries. 8. Scan records for missing index entries. q. Quit. Enter selection: If you want to improve index utilization, you can run proutil db -C idxcompact, online or offline. A dump and load is likely worthwhile if it has been many years since your last one and if you can afford the downtime.
Continue reading...
Continue reading...