Search found 42 matches
- 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: 2213
- 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: 3338
- 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: 3338
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...
- 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: 2853
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 ------...
- 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: 1424
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?
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?
- 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: 2844
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...
- 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: 6506
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 ...
- Tue Oct 18, 2005 5:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: job log
- Replies: 10
- Views: 5665
- 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: 13084
- 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: 10161
- 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: 10161
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...
- 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: 2944
- 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: 2944
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...
- 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: 10161
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...
- 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: 10161
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...