I haven't done a dump/load on my DB in a decade so I thought it might be time (scatter factor is over 8 on some tables!). I always used to do it with the ASCII dump, but thought I'd try binary this time, using a small table as a test.
Binary dump is successful. I delete the table from the DB (I read that if you just delete the records then the records are loaded back into the same memory locations). I re-create the table. I do a binary load, and it appears to work:
pro11> proutil mlsd -C load /uc/div/judge.bd
OpenEdge Release 11.7.2 as of Tue Oct 24 19:00:29 EDT 2017
Binary Dump created on Fri Oct 25 10:54:37 2019
from database /db/mlsd/mlsd. (6203)
Loading table judge, Table number 44
starting with record 1, section 1. (6204)
Loaded 269 records. (15167)
YOU SHOULD REBUILD THE FOLLOWING INDEXES IN TABLE PUB.judge:
judge-no
name
Binary Load complete. (6256)
But when I run a simple "for each judge: disp judge" it returns no records. I did the whole process twice just to see if I missed anything. I even delete and re-created the indexes on the off chance that inactive indexes were somehow making the records invisible (very unlikely, but I was out of ideas).
A subsequent ASCII dump/load worked just fine, so it's not that the records are there but not visible to me for some reason.
If I had an error message, I'd have a place to start searching for answers. But this is the first time that I've had a message say everything worked, and the records aren't there.
What am I missing? I'm assuming it's something simple/obvious.
Oh yes - v11.7.2, CHUI, AIX Unix
Binary dump is successful. I delete the table from the DB (I read that if you just delete the records then the records are loaded back into the same memory locations). I re-create the table. I do a binary load, and it appears to work:
pro11> proutil mlsd -C load /uc/div/judge.bd
OpenEdge Release 11.7.2 as of Tue Oct 24 19:00:29 EDT 2017
Binary Dump created on Fri Oct 25 10:54:37 2019
from database /db/mlsd/mlsd. (6203)
Loading table judge, Table number 44
starting with record 1, section 1. (6204)
Loaded 269 records. (15167)
YOU SHOULD REBUILD THE FOLLOWING INDEXES IN TABLE PUB.judge:
judge-no
name
Binary Load complete. (6256)
But when I run a simple "for each judge: disp judge" it returns no records. I did the whole process twice just to see if I missed anything. I even delete and re-created the indexes on the off chance that inactive indexes were somehow making the records invisible (very unlikely, but I was out of ideas).
A subsequent ASCII dump/load worked just fine, so it's not that the records are there but not visible to me for some reason.
If I had an error message, I'd have a place to start searching for answers. But this is the first time that I've had a message say everything worked, and the records aren't there.
What am I missing? I'm assuming it's something simple/obvious.
Oh yes - v11.7.2, CHUI, AIX Unix