Page 1 of 1
Open command in ODBC stage
Posted: Fri Dec 02, 2011 5:20 am
by vcsasikala
Hi,
Will the Query in open command of ODBC stage run once in a parallel job with 4 nodes?
or
Will it run once for each node?
Posted: Fri Dec 02, 2011 3:39 pm
by ray.wurlod
Is the stage running in sequential mode or in parallel mode?
Posted: Sat Dec 03, 2011 10:15 pm
by vcsasikala
in parallel mode.
Actually we need to truncate the table before loading. Since we are using lower version of DB2, We are using delete from table tabe_name in open command of ODBC stage which runs in parallel mode. if the delte command tries to delete the same record in each node the table will get locked.
thats where the question raises. Will the open command run once in a job execution or once for each node?
Posted: Sun Dec 04, 2011 12:14 am
by chulett
Once for each node if the stage is running in parallel mode.
Posted: Tue Dec 06, 2011 5:48 pm
by cooperjv
The default execution mode of the ODBC stage is sequential and this cannot be changed.
So the open command will be executed only once