Miagrating Data from SE to ONline Engine
Posted in 1995
I am miagrating Data From SE to Online Engine. I am going to use DBEXPORT and DBIMPORT to do this eventually. Right now, I am using Unload and Load statement to load tables into Online. Some of these tables are very large and I got a message "Long Transactions". The databases uses unbuffered logging and there are 50 logs defined with size of 300 Kbytes. I was able to solve by changing the database to NO LOGGING and it worked fine. Right now, I have no problem having NO Logging to load large tables. But, Once my database in production with UNBUFFERED Transactions then how would I handle this so I can insert large tables without running into "Long Transacations"? Is there any command that allows me to turn from UNBUFFERED logging to No Logging for that one process? How should I setup my database Logging when I use DBIMPORT to miagrate the data to ONLINE? When this database in production with UNBUFFERED LOGGING then How can I prevent user from not doing long transactions? Thanks for your help in advance. Please email me to Patel_Ruchi@avid.avid.com Ruchi