It may appear to be stuck, but be building the indexes and constraints.
Give it a few minutes to allow the indexing to complete - messages don't
show. I know when this is happening on my laptop because I can see the
drive light working.
An alternative that works faster than the UNLOAD ALL for large databases
is to
1. UNLOAD STRUCTURE to a file e.g. database.str
2. UNLOAD DATA to another file e.g. database.dat
3. Open database.str in the editor and find the point where the tables
have all been created, and the indexing starts.It is usually ALTER
TABLE somethingorother ADD PRIMARY KEY
4. Cut everything from here to the end of the file and put them in
another file e.g. database.ind
5. OUTPUT database.log
6. RUN database.str
7. RUN database.dat
8. RUN database.ind
9. OUTPUT screen
Working this way, R:Base will load the data without indexing.
If you get error messages running database.ind, you may have duplicate
data in one of the tables. Check the database.log file to see what
broke. Do 5 and 6 again, then do select pk_column,count(*) from
errortable group by pk_column having count(*) > 1 to find the duplicates
and fix the errors. When you have completed this, you will have a nice
clean database.
Albert
user sent me there files that he can not Unload ALl,
I ran Autocheck No errors, I Reloaded the DB fine with no errors and
it only took a few minutes but if I Unload ALL then run the file it
gets stuck after the loading the data for the last table.
I am not sure what to look for? Any suggestions?
Marc
