Results 1 to 7 of 7
  1. #1
    Join Date
    May 2011
    Posts
    4

    Unanswered: Transaction log is full

    Hi there,

    iīve got some problems while loading a table on DB2(9.7 FP2).

    The command looks like similar to this one:

    LOAD CLIENT FROM "data.csv" OF DEL MODIFIED BY COLDEL0x09 METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9) MESSAGES "logs.txt" REPLACE INTO SCHEMA.TABLE (1, 3, 2, 5, 4, 7, 6, 9, 8) NONRECOVERABLE

    This command always failed with the message: "The transaction log for the database is full"

    I donīt understand this, because the Option NONRECOVERABLE is set.
    Why did this happen?

    To prevent this error i could increase the logfilesize (LOGFILSIZ, LOGPRIMARY, LOGSECOND), but i donīt want to do that.

    What can i do there?

    Regards,
    Marco

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Do you see load performing a delete phase?

    See this thread for some information:
    http://www.dbforums.com/db2/1661713-load-command.html

  3. #3
    Join Date
    May 2011
    Posts
    4
    Hi,

    the load is performing a delete:

    2011-05-04-08.50.04.921229+120 I295585E545 LEVEL: Warning
    PID : 2977 TID : 140625332660560PROC : db2sysc 0
    INSTANCE: xxxxx NODE : 000 DB : xxxxx
    APPHDL : 0-4930 APPID: xxxxx
    AUTHID : xxxxx
    EDUID : 129 EDUNAME: db2agent (xxxxx) 0
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
    DATA #1 : String, 101 bytes
    LOADID: 129.2011-05-04-08.49.42.998852.0 (3;3)
    Starting DELETE phase at 2011-05-04 08.50.04.921137.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Correct your input file so that db2 doesn't have to execute this phase.

  5. #5
    Join Date
    May 2011
    Posts
    4
    Hmm.... would it help to bring the columns in the correct position?

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    No, it would not. During the DELETE phase duplicate rows (those that violate unique constraints on the table) are being deleted. Remove duplicate rows from the input file.

  7. #7
    Join Date
    May 2011
    Posts
    4
    Thatīs it. Thank you!

Posting Permissions

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