Professional Web Applications Themes

transaction log is full - IBM DB2

I have another problem regarding the transaction log is full error. i am using db2 v8.1 on windows When I use the command center to execute update/delete on the table (around 100 rows), I get this error, meanwhile the LOGFILSIZ is 1024 and 3 primary log file (which is default). I check the option on command center is automatically commit SQL statements. So I assume every row's update will be committed immediately. But It fails . so I change size to 2048 still not work. I thought the error only happened when I have long uncommitted transaction. even though i ...

Sponsored Links
  1. #1

    Default transaction log is full

    I have another problem regarding the transaction log is full error. i
    am using db2 v8.1 on windows

    When I use the command center to execute update/delete on the table
    (around 100 rows), I get this error, meanwhile the LOGFILSIZ is 1024
    and 3 primary log file (which is default). I check the option on
    command center is automatically commit SQL statements. So I assume
    every row's update will be committed immediately. But It fails . so I
    change size to 2048 still not work. I thought the error only happened
    when I have long uncommitted transaction. even though i could keep
    increase the log file size, i still don't understand why i need to do
    this when the commit is executed promptly. Can you tell me how to
    solve this problem ? thank you
    Sponsored Links
    xixi Guest

  2. #2

    Default Re: transaction log is full

    "xixi" <com> wrote in message
    news:google.com... 

    Exactly what error message are you getting and where do you see the message?


    Mark Guest

  3. #3

    Default Re: transaction log is full

    i am using command center to submit a update query or delete, the error pop up .
    xixi Guest

Similar Threads

  1. WS-Transaction
    By moko in forum ASP.NET Web Services
    Replies: 1
    Last Post: August 13th, 12:25 AM
  2. transaction protocol full
    By miro flasza in forum IBM DB2
    Replies: 1
    Last Post: August 15th, 07:58 AM
  3. Transaction id and transaction isolation
    By Alex in forum Informix
    Replies: 3
    Last Post: July 23rd, 09:33 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139