DSXchange

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

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]

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

When I use an Open command, it works fine.

And the same command is run on both the sessions?

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 !

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

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;

[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.

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.

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