Results 1 to 2 of 2

Thread: Transaction Log

  1. #1
    Join Date
    Oct 2002
    Posts
    16

    Unanswered: Transaction Log

    When loading data or exporting large tables, db2 will complain the transaction log is full. Then I have to update the logfilsz database configuration parameter to increase the log size. Where is the transaction log (in which directory)? I want to know if I can delete the transaction log manually. Thanks!

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

    Re: Transaction Log

    db2 get db cfg for <dbaname>

    The parameter LOGPATH should give you the directory name

    HTH

    Sathyaram

    Originally posted by alex_db
    When loading data or exporting large tables, db2 will complain the transaction log is full. Then I have to update the logfilsz database configuration parameter to increase the log size. Where is the transaction log (in which directory)? I want to know if I can delete the transaction log manually. Thanks!

Posting Permissions

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