DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 42 matches
Author Message
 Topic: Not able to Open a Job
apraman

Replies: 2
Views: 1184

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Dec 29, 2006 2:38 am   Subject: Not able to Open a Job
Is the job is Developed and Opened in the same version of DS?
 Topic: MVS Job - Rollback all the Inserts/Updates
apraman

Replies: 6
Views: 1886

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Dec 28, 2006 10:58 pm   Subject: MVS Job - Rollback all the Inserts/Updates
Can I use the "BUSINESS RULE" stage to implement the same?
If yes how? Idea
 Topic: MVS Job - Rollback all the Inserts/Updates
apraman

Replies: 6
Views: 1886

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Nov 23, 2006 12:21 am   Subject: MVS Job - Rollback all the Inserts/Updates
DataStage® Release: 7x
Job Type: 390
OS: Windows
Additional info: MVS Jobs- Rollback the Insert/updates from Job
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 - ...
 Topic: Job Aborted: Resource temporarily unavailable
apraman

Replies: 2
Views: 1612

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 30, 2006 5:52 am   Subject: Job Aborted: Resource temporarily unavailable
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Additional info: Parallel Job abort
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 u ...
 Topic: Pass all records of Input Link as array parameter in STP
apraman

Replies: 1
Views: 750

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 01, 2005 6:37 am   Subject: Pass all records of Input Link as array parameter in STP
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Additional info: Stored Procedure Stage
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 I ...
 Topic: Job Warning - APT_NO_JOBMON
apraman

Replies: 3
Views: 1480

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 24, 2005 4:29 am   Subject: 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 ...
 Topic: Sequential File stage need to select latest File to Extract
apraman

Replies: 9
Views: 3572

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Oct 18, 2005 11:42 pm   Subject: Sequential File stage need to select latest File to Extract
I think his requirement is to find the latest file based on the timestamp included with in the filename. Smile

If the 'filename' consists the timestamp with the format YYYYMMDDHHMMSS, would have been ...
 Topic: job log
apraman

Replies: 10
Views: 3147

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Oct 18, 2005 5:47 am   Subject: job log
Hi Sasi,

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

http://www.dsxchange.com/viewtopic.php?t=93565
 Topic: joining key columns
apraman

Replies: 28
Views: 8154

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 18, 2005 4:27 am   Subject: joining key columns
This post is been interesting.

Please let forum know how the initial objective is achieved.
 Topic: Effective partition type for sorted input in Transformer
apraman

Replies: 22
Views: 6011

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 18, 2005 3:43 am   Subject: Effective partition type for sorted input in Transformer
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" ...
 Topic: Effective partition type for sorted input in Transformer
apraman

Replies: 22
Views: 6011

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 18, 2005 3:29 am   Subject: Effective partition type for sorted input in Transformer
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 ...
 Topic: Unable to see the Status of Performance after execution
apraman

Replies: 2
Views: 1706

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 18, 2005 12:20 am   Subject: Unable to see the Status of Performance after execution
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 Po ...
 Topic: Unable to see the Status of Performance after execution
apraman

Replies: 2
Views: 1706

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 17, 2005 11:36 pm   Subject: Unable to see the Status of Performance after execution
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Additional info: JobMonApp - Job Monitor
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 ...
 Topic: Effective partition type for sorted input in Transformer
apraman

Replies: 22
Views: 6011

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 17, 2005 10:49 pm   Subject: Effective partition type for sorted input in Transformer
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 ...
 Topic: Effective partition type for sorted input in Transformer
apraman

Replies: 22
Views: 6011

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 17, 2005 10:00 pm   Subject: Effective partition type for sorted input in Transformer
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 m ...
 

 Jump to:   



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