Search found 4 matches

by amr_halawa
Wed Nov 21, 2007 8:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deadlock on TeraSync table (2631)
Replies: 10
Views: 11251

throbinson, thanks for your reply, i think decreasing the Requested session did the trick, i have change the Session from (# of Amp)/2-1 to about 28 and i run the job 4 times and its working fine, so i guess this was the problem that we need to decrease the sessions. I give SessionPerPlayer=1, Reque...
by amr_halawa
Wed Nov 21, 2007 7:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deadlock on TeraSync table (2631)
Replies: 10
Views: 11251

In my job i am using one Teradata Enterprise Stage, which is loading data from a Seqeuncial File, Containing about 250000 records, As the sequencial File is serial so the no of input streams and output streams will not be equal so in this case we need to change partition of the Enterprise stage to R...
by amr_halawa
Wed Nov 21, 2007 3:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deadlock on TeraSync table (2631)
Replies: 10
Views: 11251

I am using Teradata Enterprise Stage which do Fastload, and there is no report generated for it. From the log it seems that two Processes are updating the terasuyn table at the same time, from my point of view each process is writting to terasync table the number of bytes written by it to the final ...
by amr_halawa
Tue Nov 20, 2007 5:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deadlock on TeraSync table (2631)
Replies: 10
Views: 11251

I am also facing this problem, i search the forum but am not able to find any solution for it, the error message is given below, When i run a job it sometimes run successully while the next time it fails, I do have appropreiate rights for creating the terasync table. This problem occurs when data is...