Hi All !

Do I have to do something extra to use
CREATE TABLE with the NOT LOGGED INITIALLY clause ?
I ask this because I see the transaction log full messages in my log file.
I did not expect to see the transaction log full message if I am doing multiple inserts in a single unit of work.
Any thoughts as to what could be going wrong ?

Anil

Not sure what interface you are using, but you need to shut off auto-commit and only commit explicitly when all the inserts are done.

If you are using the CLI, then the +c option shuts off auto-commit. See the Command Reference manual for details on CLI options. Don't forget to explicitly commit after you do all the inserts.

Thatz correct Marcus.
In our project we used to get similar problems while inserting (importing ) thousands of records together. We used very frequent commit statement after every 5000 rows and got the problem fixed.

Increasing the "Logprimary" and "Logsecondary" configuration parameter will fix the problem? You can try this too.

Thanks,
Jayanta Datta
Xansa India