Basic Question

I have a dbexport of a huge database which I want to load on another machine. My question is: Is it possible to create a database without logging, Insert data in it and then change it to buffered logging. If yes, then how it can be done. Any pointers will be of great help. Thanks in advance Regards, Sanjeev Tripathi

Yes, check out the -l (?) option on dbimport and then use ontape to put the logging back on tsanjeev wrote: > > I have a dbexport of a huge database which I want to load on another > machine. > My question is: Is it possible to create a database without logging, Insert > data in it and then change it to buffered logging. If yes, then how it can > be done. Any pointers will be of great help. > > Thanks in advance > Regards, > Sanjeev Tripathi -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #

In order to add logging to a database, you can use ontape -s -B <nameofdatabase>. Or alternatively you can use non-buffered logging and specify the command ontape -s -B <nameofdatabase>. Review the ontape command and syntax. This will turn logging on for your database. HTH, Lloyd Wilson. tsanjeev <tsanjeev@inf.com> wrote in message news:8hg95c$5m7$1@news.xmission.com... > > I have a dbexport of a huge database which I want to load on another > machine. > My question is: Is it possible to create a database without logging, Insert > data in it and then change it to buffered logging. If yes, then how it can > be done. Any pointers will be of great help. > > Thanks in advance > Regards, > Sanjeev Tripathi