Hi,

Can i stop writing Transaction log in DB2 while importing large number of data when i don't need transaction log? If it is possible HOw?

Thanks in Advance.
Sengu

You can use the LOAD command ...

The other alternative is to use the NOT LOGGED INITIALLY on the table...

Refer to the db2 manuals for detailed information on these topics

HTH

Sathyaram

HI Sathyaram,

Thank you Very much for your immediate relpy.

Is there any way to configure the same[Not logged initially] in Control center?

Thanks and Regards,
Sengu

Not Logged Initially is not a Configuration parm ...

You will have to mention this when creating the table ...

CREATE TABLE ............. NOT LOGGED INITIALLY


The do the following in the same UOW :

ALTER TABLE <tabname> NOT LOGGED INTIALLY
IMPORT FROM <> ....

Personally, I prefer LOAD to NLI

HTH

sathyaram