Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    14

    Unanswered: Transaction log is full

    Hello All:

    While importing data i am encountering the fowwloing error. Pls. do suggest me what to be done to do import sucessfully.


    SQL3153N The T record in the PC/IXF file has name "tab61.ixf", qualifier "",
    and source " ".

    SQL3109N The utility is beginning to load data from file "tab61.ixf".

    SQL3306N An SQL error "-964" occurred while inserting a row into the table.

    SQL0964C The transaction log for the database is full. SQLSTATE=57011

    SQL3110N The utility has completed processing. "342845" rows were read from
    the input file.




    Regards

    srinivas

  2. #2
    Join Date
    May 2003
    Location
    Toronto
    Posts
    29
    Try the following:
    decrease the savecount parameter, such as from 10000 to 2000
    or
    increase your log size, such as increase log file size or log file number

  3. #3
    Join Date
    Jan 2004
    Posts
    14
    thank you for the suggestion, it worked fine for me.

Posting Permissions

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