RE: Converting from SE to Online

Dean, You're on the right track. In fact, it sounds like the dbimport was well on it's way. It is normal for dbimport to pause while loading large tables, but I'm assuming it was more than that. So, here's some things to look for: 1. Did your log files fill? Use "onstat -l" or "onstat -m" to look for this. This is most likely your problem. 2. Did you run out of locks? Use "onstat -k" to check this. What was the precise syntax of your dbimport command? Odds are, you created the new database with logging. This is good, but a bit premature. When you perform a large load, you should have logging turned off. Then, after the load, you can go back and turn the logging on. Finally, once you get the load finished, don't forget to UPDATE STATISTICS! --Craig (craig@chemistry.utah.edu) > > I am new to Informix and I am looking for some advice on transferring from > an Informix SE database to Informix Online. I have managed to figure out > that I need to do a DBEXPORT and then a DBIMPORT. When I ran the DBIMPORT > command (after I had run the DBEXPORT) it seemed to be working as the SQL > statements were being displayed on screen. It then seem to stop for no > apparent reason, no error messages were displayed. The database now > exists when I load DBACCESS but it says the database is locked by another > user ( I assume that the DBIMPORT did not finish and the 'other' user is > me). Can anybody help me. >