Search found 15603 matches

by ArndW
Thu Jul 01, 2010 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to find VOC file
Replies: 4
Views: 1062

If the VOC file were actually missing, nothing would work in your project. Please post the command you issued and the exact error message, perhaps someone here can assist you further.
by ArndW
Thu Jul 01, 2010 5:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stop the sequence at specific time
Replies: 7
Views: 2327

On option is to have another process issue a STOP request at a given time, the job sequence will the sto the next time it polls, or you can use the DSGetJobInfo(JobHandle,DSJ_JOBCONTROL) call to check to see if a stop request is pending.
by ArndW
Tue Jun 29, 2010 9:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem regarding job compilation and running
Replies: 20
Views: 6836

Fix the sort error first. What stage is immediately after the sort? It will be a join or funnel sort or some other stage which requires sorted input. What are the key columns in that stage - it must be identical to that specified in your sort stage.
by ArndW
Tue Jun 29, 2010 8:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to calculate total number of input columns and rejects
Replies: 9
Views: 3609

In this case you don't need to do any processing or aggregation in your actual jobs, but can write a job (preferably a server one) to do all this work for you after the job that you wish to collect usage numbers for has completed. What you write partially depends upon what information you want to co...
by ArndW
Tue Jun 29, 2010 7:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to reset the job if any job fails in project ?
Replies: 10
Views: 3803

Give it a go - either through BASIC code or through scripting with dsjob and if you get stuck post your question to this thread. The general concensus here is that everyone is willing to supply assistance when people get stuck, but providing complete solutions is what many here get paid to do in our...
by ArndW
Tue Jun 29, 2010 7:25 am
Forum: General
Topic: Datastage 8.1 installation
Replies: 4
Views: 1355

Great. It would seem that if the poster ignored the comments on the previous thread on this topic that it will happen again on this one :(
by ArndW
Tue Jun 29, 2010 7:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SSL in Datastage Server Edition
Replies: 5
Views: 1760

You can google "secure IP" and also look into tunneling.
by ArndW
Tue Jun 29, 2010 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to calculate total number of input columns and rejects
Replies: 9
Views: 3609

I would use the builtin functions to do this after the job completes. Using calls to DSAttachJob() to get a job handle, then DSGetLinkInfo() to get the number of rows processed through a named link, then DSDetachJob() to close the handle you can retrieve the row count and then decide what you want t...
by ArndW
Tue Jun 29, 2010 7:09 am
Forum: General
Topic: Datastage 8.1 installation
Replies: 4
Views: 1355

Anil - since the procedures are clearly documented in the README and other files included in your media and it would seem that you haven't attempted to read any of the documents, you won't be getting much qualified help in this forum. If you have read the documents and have specific questions on iss...
by ArndW
Tue Jun 29, 2010 6:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Should I use DataSets?
Replies: 20
Views: 4998

One other aspect is that the type of file system and journalling can play a significant performance impact. Are you using JFS for the data file partition?
by ArndW
Tue Jun 29, 2010 6:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to reset the job if any job fails in project ?
Replies: 10
Views: 3803

While not trivial, it is not difficult to implement. I would write a job sequence or shell script that retrieves the list of all jobs in project (using DSGetProjectInfo() or a dsjob call) and then, for each job, check the status and issue a reset call if that job state is aborted.
by ArndW
Tue Jun 29, 2010 6:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SSL in Datastage Server Edition
Replies: 5
Views: 1760

The DataStage client and server use sockets and their own protocol to communicate with each other. If a secure layer is to be implemented, it would need to be transparent to the processes and thus an SSL layer woudn't fit in since the processes would need to handle authentication and encryption. But...
by ArndW
Tue Jun 29, 2010 4:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Tmestamp to date conversion
Replies: 6
Views: 1625

No, this is not possible. A database DATE column has no format.
by ArndW
Tue Jun 29, 2010 4:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MKS Toolkit "Named Pipes" and RCP
Replies: 8
Views: 2278

It turns out that each table has a specific columns that are to be used. I'v now gone the route of passing in a comma-separated list of columns to the shared container and using a generic stage with coding for the column export operator to create my column, which I'll then use some CRC32 or similar ...
by ArndW
Tue Jun 29, 2010 4:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Routines to run 24/5
Replies: 2
Views: 862

Re: Routines to run 24/5

SachinCho wrote:...runs 24/7 once triggered from autosys...
Since autosys triggers your routines, that is where you would need to change settings.