Search found 36 matches

by Sakthi_Sst
Tue Jan 02, 2007 3:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Table locks when loading through Teradata Enterprise stage
Replies: 19
Views: 14742

Re: Table locks when loading through Teradata Enterprise sta

Hi All, Dsguru, 1st time the job got aborted by itself due to some reason when i was in UAT,from that point i came to know about this issue. 2nd time i was simulating the issue to find a workaround for that. So everybody suggest that the issue is with teradata end and not with DS end(ie.DS is not ho...
by Sakthi_Sst
Fri Dec 29, 2006 2:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Table locks when loading through Teradata Enterprise stage
Replies: 19
Views: 14742

Table locks when loading through Teradata Enterprise stage

Hi All, I have an issue with Teradata Enterprise stage: Issue: 1.I am trying to load a table using a Teardata Enterprise stage through a DS job. 2.But when the job is aborted manually or automatically(1st time) and when i compile and try to run the job for the second time the job aborts again(2nd ti...
by Sakthi_Sst
Fri Dec 22, 2006 12:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding aggregator stage
Replies: 3
Views: 1066

Hi Saama,

Either you can group or sum,
For eg :if you have 3 colums out of which you need to calculate sum for 1 column the remaning 2 should be grouped and not all the 3 col's.
by Sakthi_Sst
Thu Dec 21, 2006 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap allocation failed
Replies: 3
Views: 1827

Hi,

I got the calculation but im not sure how many sessions per player i can specify for a node.

RequestedSessions =number of nodes * SessionsPerPlayer


RequestedSessions =1 * SessionsPerPlayer(?) //for 1 node

Thanks,
Sakthi...
by Sakthi_Sst
Thu Dec 21, 2006 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap allocation failed
Replies: 3
Views: 1827

Heap allocation failed

Hi All, My issue would be "Heap allocation failed" when running around 505 million data. 1.I have a 8 node system datastage server 2.Source is Teradata in Datastage 7.5.1PX. 3.Reading from a Teradata Enterprise stage. 4.It reads upto 260 million records and then job aborts with an error &q...
by Sakthi_Sst
Thu Sep 07, 2006 10:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding importing from ODBC
Replies: 2
Views: 957

[quote="Luciana"]You can import metadata from the ODBC, but the best option is to use Orchestrate Schema Definitions.[/quote]

But before that you need to create a Data Source using ODBC.