Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Chennai,India
    Posts
    4

    Post Unanswered: Transaction Log in DB@

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Transaction Log in DB@

    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

    Originally posted by sengu
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Oct 2003
    Location
    Chennai,India
    Posts
    4

    Post Re: Transaction Log in DB@

    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

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Transaction Log in DB@

    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

    Originally posted by sengu
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •