Home Forums Data Warehousing Integration Services Extract Speed from DB2 RE: Extract Speed from DB2

  • May 1, 2013 at 5:24 pm

    #1611752

    Ross McMicken (5/1/2013)

    Jeff, you should also check to see if the AS400 you need to extract from has any third party query tools on it, or Query/400. Those generally have th eability to save data to the area that's accessible from other computers.

    Thanks, Ross. I already checked with the AS400 guys and they said they used to have one but didn't see the utility in it so they got rid of it and never renewed the license. :crying: Guess I'll have to hit Google a little harder and see if I can come up with a free tool because they don't want to spend any money on it even if it were to turn a memory sucking, CPU burning, network churning 4+ job into a 10 or 15 minute breath of fresh air. 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)