User Profile

Collapse

Profile Sidebar

Collapse
newentry
newentry
Last Activity: Apr 29 '13, 06:06 AM
Joined: Apr 18 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • newentry
    replied to DB2 multi-thread application and sql error Log full
    in DB2
    Thank you for your reply.

    You're right, increasing primary logs solved this problem.
    But what is "commiting appropriately" ?

    I have the following operations:
    Open cursor for update
    fetch cursor
    insert/update from current position to another table
    delete from current position
    commit/rollback

    So, each operation is followed by commit operation.It seems there's no reason...
    See more | Go to post

      Leave a comment:

    • newentry
      started a topic DB2 multi-thread application and sql error Log full
      in DB2

      DB2 multi-thread application and sql error Log full

      Dear all,

      I have the following situation using DB2 v9.5 in the multi-threaded way.

      1. I created 30 working threads using _beginthread(.. .) C function.
      2. For each working thread I put the following sequence at the beginning:
      sqleBeginCtx(.. .)
      sqleAttachToCtx (...)
      connect to database
      then, I'm using a semaphore to wait for something to do.
      3. After each database...
      See more | Go to post
      No activity results to display
      Show More
      Working...