Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: DB2 Transactions issue

  1. #1

    Default DB2 Transactions issue

    Hi there,

    I'm having a little problem when running a transformation that loads more than 34 millions of registers in a DB2 database.

    It appears that Kettle is not using the parameter "commit size" in a "Output Table Step".

    We checked db2's transaction log when running the transformation and it nevers decrement. Is supposed that DB2 empties the transaction log everytime that a commit signal arrives.

    If any of you guys can help me with this... I'll really appreciate it. DB2 is showing an error message after some thousands insertions (a 964)

    [PD: Please excuse my english, I'm not a complete bilingual... -_-!]

  2. #2
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    First of all, you'd be better off posting in the Kettle forum:

    http://forums.pentaho.org/forumdisplay.php?f=135

    As for your problem, I've seen it before:

    http://forums.pentaho.org/showthread.php?t=63834

    But no solutions. You may want to raise a Jira issue for it:

    http://jira.pentaho.com

    Cheers!

  3. #3
    Join Date
    Dec 2005
    Posts
    531

    Default

    Hi,

    Jira isue exists already: http://jira.pentaho.com/browse/PDI-1891

    Regards,
    Ingo

  4. #4
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    Wonderful.

    You should be getting a fix for your problem in the next releases, then, Thomas.

    Cheers!

  5. #5

    Default

    Auch... I can´t wait too much....
    Do you know any workaround about it???

    I'll really appreciate any advice. [we´re in a critic phase of the project... and we must find a quick solve]

    Thanks in advance.

    And sorry to missplace the post.

  6. #6

    Default Solved issue

    Hello,

    I downloaded the Kettle version 3.2 M1 and it comes with the "commit issue" fixed. Thanks all of you for the help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.