Close command : parallel

algfr · Post by **algfr** » Wed Sep 09, 2009 3:11 am

Just a quick question.

When I perform a close command and am running on 2 nodes, is this normal that the close command perform for EACH node and not only once after the load is completed ?
I use Oracle

Thanks

singhald · Post by **singhald** » Wed Sep 09, 2009 3:39 am

HI Algfr,

If you are using oracle enterprise stage to load or perform any operation on close command, it doesnt matter how many nodes you are using.

it will be executed once after completion of load operation.

Thanks,[/b]

algfr · Post by **algfr** » Wed Sep 09, 2009 9:13 am

Did you try it ? I did and it creates me two Oracle sessions.

When I use an Open command, it works fine.

DSguru2B · Post by **DSguru2B** » Wed Sep 09, 2009 9:17 am

And the same command is run on both the sessions?

algfr · Post by **algfr** » Thu Sep 10, 2009 5:15 am

Exactly,

When I get to see what takes place in the oracle sessions, it creates two sessions blocking each other.

There is just one when I use an open command.

Can be worked out of course, but still, it's weird !

DSguru2B · Post by **DSguru2B** » Thu Sep 10, 2009 8:06 am

That is wierd. Can someone reproduce this on 7.x ?
Get in touch with IBM and see what they have to say about it.

srinivas.g · Post by **srinivas.g** » Thu Sep 10, 2009 8:28 am

i ran same thing in datastage 7.5.1 A with four nodes.

But it is exceutes only once.

the close command query is

BEGIN
DELETE from <table name>;
COMMIT;
END;

betterthanever · Post by **betterthanever** » Thu Sep 10, 2009 8:30 am

[quote="DSguru2B"]That is wierd. Can someone reproduce this on 7.x ?
Get in touch with IBM and see what they have to say about it.[/quote]
it happened to me as well. i was inserting into some table on 4 nodes, and my job aborts saying " i was trying to insert duplicates" .
i am on 8.0.1 on AIX 5.3.

when i changed it to run on one node...job runs fine.

Regards.

betterthanever · Post by **betterthanever** » Thu Sep 10, 2009 8:37 am

srinivas.g wrote:i ran same thing in datastage 7.5.1 A with four nodes.

But it is exceutes only once.

the close command query is

BEGIN
DELETE from <table name>;
COMMIT;
END;

try to insert into the table and have a primary key.
job will abort.

Regards.

DSguru2B · Post by **DSguru2B** » Thu Sep 10, 2009 8:38 am

Seems like you guys have unconvered a bug on the CLOSE command in 8.x.