Search found 42 matches

by apraman
Fri Dec 29, 2006 2:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to Open a Job
Replies: 2
Views: 2212

Is the job is Developed and Opened in the same version of DS?
by apraman
Thu Dec 28, 2006 10:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MVS Job - Rollback all the Inserts/Updates
Replies: 6
Views: 3335

Can I use the "BUSINESS RULE" stage to implement the same?
If yes how? :idea:
by apraman
Thu Nov 23, 2006 12:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MVS Job - Rollback all the Inserts/Updates
Replies: 6
Views: 3335

MVS Job - Rollback all the Inserts/Updates

In MVS jobs, is there any way to ROLLBACK the ALL INSERTS/UPDATES made from job if any ONE OF THE INSERT/UPDATE FAILS? For example: From a main flow, I am trying to 1 - Insert db2 Table1 2 - Update db2 Table 2 3 - Insert db2 Table 3 My Insert 1 and Update was done successfully BUT Insert 3 fails due...
by apraman
Mon Jan 30, 2006 5:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Aborted: Resource temporarily unavailable
Replies: 2
Views: 2848

Job Aborted: Resource temporarily unavailable

Hi, I have parallel job. While run time the job get aborted. Some of the fatal error messages are - main_program: APT_PMConnectionRecord::rsh: fork failed, Resource temporarily unavailable main_program: APT_PM_LocalShell: fork failed, errno = 11 main_program: The section leader on gifbdc died ------...
by apraman
Thu Dec 01, 2005 6:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass all records of Input Link as array parameter in STP
Replies: 1
Views: 1423

Pass all records of Input Link as array parameter in STP

Hi,
I have a Oracle stored procedure which can take tables as in parameter. does a BULK insert, it does some other process too.

My main objective is not to call stored procedure for each row of Input link. I want to pass all values of the input link as array.

Is there any way to achieve it?
by apraman
Mon Oct 24, 2005 4:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Warning - APT_NO_JOBMON
Replies: 3
Views: 2835

Re: Job Warning - APT_NO_JOBMON

Failed to connect to JobMonApp on port 13401 ...... Hi Adarsh, If the above warning message is your concerned then it is sure the Job Monitor in the server is not up. May be you have shut down DS Server , after it is on , the Job Monitor has not started automatically. You need to start your Job Mon...
by apraman
Tue Oct 18, 2005 11:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File stage need to select latest File to Extract
Replies: 9
Views: 6492

I think his requirement is to find the latest file based on the timestamp included with in the filename. :) If the 'filename' consists the timestamp with the format YYYYMMDDHHMMSS, would have been easy, considering the first part ie alphabetic part must remain same. ls -r WalmartProduct*.txt | head ...
by apraman
Tue Oct 18, 2005 5:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job log
Replies: 10
Views: 5648

Hi Sasi,

You can check the following post.
Hope you will get the answer

viewtopic.php?t=93565
by apraman
Tue Oct 18, 2005 4:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: joining key columns
Replies: 28
Views: 13034

This post is been interesting.

Please let forum know how the initial objective is achieved.
by apraman
Tue Oct 18, 2005 3:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Effective partition type for sorted input in Transformer
Replies: 22
Views: 10150

Other than Transformer, in some stages - CHANGE CAPTURE and DIFFERERNCE, you need to take sorted input based on key field. In those stages if I am sorting at the input links - "before" and "after" - instead of using SORT stage after the two passive stage What the issues is going ...
by apraman
Tue Oct 18, 2005 3:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Effective partition type for sorted input in Transformer
Replies: 22
Views: 10150

Impossible to say. Presumably there will be no loss of rows through the Transformer stage.... If the transformer retreiving only a particular sets of records based on a constraint. In that case there will be reduction of records. Will the placement of SORT stage after transformer be the better opti...
by apraman
Tue Oct 18, 2005 12:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to see the Status of Performance after execution
Replies: 2
Views: 2938

Start the job monitor. It's stopped for some reason. Thanks Ray, I have started the Job Monitor and it works fine. I also got some vital information regarding Job Monitor in the following Posts http://www.dsxchange.com/viewtopic.php?t=92922&highlight=Job+Monitor http://www.dsxchange.com/viewtop...
by apraman
Mon Oct 17, 2005 11:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to see the Status of Performance after execution
Replies: 2
Views: 2938

Unable to see the Status of Performance after execution

Till last day, in DS Designer, after successfull completion of a job, the Performance status - number of rows and the transfer rate for each link was being displayed. But today I am unable to view this, during the execution the colour of the link does not even changes . When I check the Log of the J...
by apraman
Mon Oct 17, 2005 10:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Effective partition type for sorted input in Transformer
Replies: 22
Views: 10150

It's not a need, it's a preference Thanks Ray If the situation is sequential, all the stages are working in sequential, say I have alloted a single node from the start. Single OS files as source. Will the inclusion of Sort Stage will matter? And if I place the Sort stage after the transformer, cons...
by apraman
Mon Oct 17, 2005 10:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Effective partition type for sorted input in Transformer
Replies: 22
Views: 10150

Partitioning is completely irrelevant for output links. If you do need to sort, it doesn't matter whether you use a Sort stage or sorting as a property of the input link; it will block rows. It must block rows. Think about it. The Sort stage gives a little more flexibility and control over consumpt...