Results 1 to 4 of 4

Thread: parallelism

  1. #1
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Unanswered: parallelism

    Hi people,

    Somebody could tell me if i can run the same stored procedure at the
    same time on the data warehouse center to write on the same table?
    I just want to to know if it supports processes in parallel.

    Please help me..i've a very large database and i can´t do it
    with another method...i know that we can do it if we develop the
    ETL process "bespoke" but i use a etl tool..the Data warehouse Center
    on db2 UDB 7.2 on windows.

    Thanks for your help!

    Rui

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: parallelism

    You can run two instances of the same stored procedure at the same time ..

    Whether you can write into the two tables simaltaneously depends on what you are trying to do ...

    But, if you keep your stored procedure short and simple(you should , as you want concurrency) and commit as soon as it is possible, then the second instance may have a short wait ...

    Cheers
    Sathyaram


    Originally posted by rmleite
    Hi people,

    Somebody could tell me if i can run the same stored procedure at the
    same time on the data warehouse center to write on the same table?
    I just want to to know if it supports processes in parallel.

    Please help me..i've a very large database and i can´t do it
    with another method...i know that we can do it if we develop the
    ETL process "bespoke" but i use a etl tool..the Data warehouse Center
    on db2 UDB 7.2 on windows.

    Thanks for your help!

    Rui
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Re: parallelism

    Thanks a lot...i can write into two tables simaltaneously with the same procedure...but it is possible that two instance of the same procedure write simaltaneously into one table?

    For example:

    I've one table source that store the information about stores and
    I've one control table that store all the str_id(identifier of a store) and the week associated.
    My procedure have to acess the control table to take the str_id's
    for one week and after select the information on the table source to load on a table target.
    I want that my procedure run two stores at the same time, so i want that
    two instance of my procedure acess at the tables(control and target) in parallel.
    For example one instance load str_id=1 and the other instance run the str_id=2...but at the same time...when one instance finish she have to start to load another store(str_id=3) and continue to run at the same time with the other instance of the procedure.
    Could you tell me howm i can do that?
    If you want i can send you my procedures..
    Thanks

    ps:sorry for my english!

    Originally posted by sathyaram_s
    You can run two instances of the same stored procedure at the same time ..

    Whether you can write into the two tables simaltaneously depends on what you are trying to do ...

    But, if you keep your stored procedure short and simple(you should , as you want concurrency) and commit as soon as it is possible, then the second instance may have a short wait ...

    Cheers
    Sathyaram

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: parallelism

    Two instances of the same procedure can write into the same table

    "Whether you can write into the two tables simaltaneously depends on what you are trying to do ... "
    should have read

    "Whether you can write into the same table simaltaneously depends on what you are trying to do ..."

    You can do the reading from the source table simaltaneously, but the load portion depends ... The second procedure may(or may not) have to wait till your first one completes , which I'm not 100% sure ...

    I'll try to understand what sort of locks the loading process takes on the target table to know if two applications can load into the table at the same time ... (The term load is NOT equivalent to LOAD command)

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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