DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 188 matches
Author Message
 Topic: Oracle connector - Deadlock issue
mouthou

Replies: 9
Views: 317

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 18, 2019 2:27 am   Subject: Oracle connector - Deadlock issue
yes you are logically correct as per the link ordering but I am thinking in the lines of duplicate rows getting into one particular link itself. We had such issues with duplicate data getting processe ...
 Topic: Oracle connector - Deadlock issue
mouthou

Replies: 9
Views: 317

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 14, 2019 1:41 am   Subject: Oracle connector - Deadlock issue
as the deadlock error comes out of Oracle, it is pretty obvious that there is same record going for more than one operation at the same time.

For debugging purpose, try removing the one link each ...
 Topic: Datastage Director Monitor not displaying row counts
mouthou

Replies: 2
Views: 459

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 04, 2019 10:55 pm   Subject: Datastage Director Monitor not displaying row counts
As chulett pointed out, the bottomline is the "JobMon" app to be running on the server. If not, contact your datastage admin to restart the service completely and verify till you see something in "ps ...
Resolved
 Topic: Lineage Report
mouthou

Replies: 2
Views: 523

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 04, 2019 10:36 pm   Subject: Lineage Report
It talks about IGC console only and administration there. May be your user id don't have necessary privileges to see the Admin section.

Try login with some admin user to see if you get Administrati ...
 Topic: Need to get Object list from Package (.pkg) file
mouthou

Replies: 6
Views: 308

PostForum: General   Posted: Mon Feb 04, 2019 7:40 pm   Subject: Need to get Object list from Package (.pkg) file
What do you mean by DataStage package? Do you have list exported already. DataStage package means isx kind of packages here, so needing more clarity.

Again your other question needs clarity too. Wi ...
 Topic: Check if multiple rows returned from Lookup Stage
mouthou

Replies: 5
Views: 474

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jan 20, 2019 11:15 pm   Subject: Check if multiple rows returned from Lookup Stage
I think your colleagues are not entirely correct and working up entirely in Datastage is a selective scenario. Best practice is to push the operation to DB so the minimal preprocessing like yours happ ...
 Topic: Runtime comparision of tables using TD connector stage?
mouthou

Replies: 8
Views: 482

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 18, 2019 3:47 am   Subject: Runtime comparision of tables using TD connector stage?
I think runtime could be in any scenario, be it one time or incremental batch loads. I meant the runtime as to pass the something like tablename when the validation job runs.

This is a temporary v ...
 Topic: Runtime comparision of tables using TD connector stage?
mouthou

Replies: 8
Views: 482

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 16, 2019 9:43 pm   Subject: Runtime comparision of tables using TD connector stage?
Thanks for everyone's comments. To answer few questions from Ray and Chulett

- Yes I also expected a native solution to do within the DB but there isnt much known yet (It will be 2 different DB pro ...
 Topic: Runtime comparision of tables using TD connector stage?
mouthou

Replies: 8
Views: 482

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 16, 2019 3:09 am   Subject: Runtime comparision of tables using TD connector stage?
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

We have about 700-800 existing Teradata tables which required to be migrated to a different Teradata DB server and compare the new data set with the existing set as and when DataStage jobs ...
 Topic: identifying conductor node in default pool
mouthou

Replies: 10
Views: 998

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jul 22, 2018 6:08 am   Subject: identifying conductor node in default pool
Thanks Ray. I thought to clarify the question with 2 samples of config files.

config1:

node1
{
fastname dsserver
pools ""
..........
...
 Topic: identifying conductor node in default pool
mouthou

Replies: 10
Views: 998

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 19, 2018 10:33 am   Subject: identifying conductor node in default pool
Thanks Ray and Paul.

I am not quite clear on the response with the references of named node and default pool, both of which are mutually exclusive as far as my understanding goes. ie, if there is ...
 Topic: identifying conductor node in default pool
mouthou

Replies: 10
Views: 998

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 18, 2018 6:18 am   Subject: identifying conductor node in default pool
I am not rresearching as such. It was a general query as to know which node was picked as the conductor node by the engine when the job runs. If there was a node pool defined with keyword "conductor" ...
 Topic: identifying conductor node in default pool
mouthou

Replies: 10
Views: 998

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jul 15, 2018 10:35 am   Subject: identifying conductor node in default pool
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi All,

When there are 4 nodes in a config file and when the job is run, is there a way to find out which node played as the conductor node out of those 4 nodes.

It may be possible if the node h ...
 Topic: possible ways to write a Sequential File stage in PARALLEL?
mouthou

Replies: 6
Views: 1123

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 02, 2018 8:39 pm   Subject: possible ways to write a Sequential File stage in PARALLEL?
Thanks all for the responses. But as chulett mentioned, the workaround given by UCDI seems little different from my query. I was hoping to see the features in DataStage like readers than a manual logi ...
 Topic: possible ways to write a Sequential File stage in PARALLEL?
mouthou

Replies: 6
Views: 1123

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 02, 2018 10:29 am   Subject: possible ways to write a Sequential File stage in PARALLEL?
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi all,

There are alternative ways to read a sequential file by using options such as number of readers. Are there similar options while WRITING too? Referring to a single file though and not a fil ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours