Search found 32 matches
- Mon Oct 06, 2014 8:57 am
- Forum: General
- Topic: List out Columns used in datastage job (XMETA/DSODB/UNIX)
- Replies: 4
- Views: 3963
- Fri Oct 03, 2014 9:25 am
- Forum: General
- Topic: List out Columns used in datastage job (XMETA/DSODB/UNIX)
- Replies: 4
- Views: 3963
List out Columns used in datastage job (XMETA/DSODB/UNIX)
Is there a way to list out all columns used in job level/stage level either using DSODB / XMETA / DSJOB Command from unix ? Kindly advise if there is any other approach to get this information.
- Tue Aug 12, 2014 1:38 pm
- Forum: General
- Topic: Impact Analysis usage using datatage and standards required
- Replies: 0
- Views: 1664
Impact Analysis usage using datatage and standards required
We are in the process of defining standard in datastage. To perform column level impact analysis using datastage what are the standards required to define (like way to maintaining the table definitions,how to sync table defintion changes ) , so that every thing is sync and will be able to leverage t...
- Tue Apr 15, 2014 9:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance issue in Oracle connector with multiple links
- Replies: 1
- Views: 2002
Performance issue in Oracle connector with multiple links
In our job we have a single Oracle connector with 3 links connected to it, loading 3 different table as a part of same transaction. Each link loads 1 million records to a different table. Array size is set to 2000. During the job run, even though performance statistics show all records are loaded to...
- Thu Feb 27, 2014 1:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rollback transaction on failure in datastage
- Replies: 0
- Views: 1765
Rollback transaction on failure in datastage
Please advice me a way to keep transaction size as 0 when there is multile iput links to single oracle connector.In one of our job we have a oracle conenctor with two incoming link .Both will do transaction at the same time.Please advice me a way to roll back entire records when there is failure in ...
- Wed Feb 12, 2014 12:33 pm
- Forum: General
- Topic: Notification activity synchronous issue.
- Replies: 1
- Views: 1578
Notification activity synchronous issue.
In our job design we need to terminate a sequence if a job fails. Also we need to receive mail notification that the job is failed. The sequencer is implemented in the following manner. <jobactivity>-----------link1---( failed- conditional)------<notify> \-------link2( failed- conditional)-----<term...
- Fri Jan 24, 2014 8:57 am
- Forum: General
- Topic: Jobs remaining at status 'Queued'
- Replies: 6
- Views: 5440
- Thu Jan 23, 2014 10:47 am
- Forum: General
- Topic: Passing an output content created in parllJob to its seqJob
- Replies: 13
- Views: 8507
- Wed Jan 22, 2014 8:54 pm
- Forum: General
- Topic: Passing an output content created in parllJob to its seqJob
- Replies: 13
- Views: 8507
Craig, One more query regarding this- I dont if this a stupid one. :roll: Will it creates any issue when we run this particular job as a multiple instance ? Like userstatus created by one instance may override the userstatus of the value created by another,when many instance are running simultaneous...
- Wed Jan 22, 2014 4:00 pm
- Forum: General
- Topic: Passing an output content created in parllJob to its seqJob
- Replies: 13
- Views: 8507
- Wed Jan 22, 2014 3:04 pm
- Forum: General
- Topic: Passing an output content created in parllJob to its seqJob
- Replies: 13
- Views: 8507
- Wed Jan 22, 2014 12:48 pm
- Forum: General
- Topic: Passing an output content created in parllJob to its seqJob
- Replies: 13
- Views: 8507
Thanks for the response.The idea,for each time when this job run its creates a sequence number referred as run id , so that it can tied up with all records inserted that time.This run id value (output content ) should be parsed to next attached jobs ,and this runid value be stored as a variable ,ins...
- Wed Jan 22, 2014 12:23 pm
- Forum: General
- Topic: Passing an output content created in parllJob to its seqJob
- Replies: 13
- Views: 8507
Passing an output content created in parllJob to its seqJob
Hi All ,In datastage is it possible to store a output record content created in parallel job level in the form of variable and parses it to sequence level ? I am able to do this by the storing o/p in a file and then parsing this value after reading it using excute command activity sequence job .Is t...
- Mon Jan 20, 2014 2:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sending bulk records in a single webservice call
- Replies: 10
- Views: 4017
- Mon Jan 20, 2014 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sending bulk records in a single webservice call
- Replies: 10
- Views: 4017
Thanks Ernie for the response.Bottle neck will be SOAP. I would definitely like to learn this new xml stage and its capabilities.I was able to compose and parse xml using new xml stage and also do some basic stuff using it.But I wasnt able to create an xml aggregated output for all input rows , that...