Search found 15603 matches

by ArndW
Wed Jun 24, 2009 2:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: orchadmin not displaying dataset information
Replies: 0
Views: 737

orchadmin not displaying dataset information

On all of our AIX DataStage LPARs we have functioning environments with no visible problems. Nevertheless, I've just seen that there are problems with the orchadmin command that I cannot narrow down and was hoping that someone here might have seen similar issues and might be able to assist. After ru...
by ArndW
Wed Jun 24, 2009 1:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem while using seq file and funnel stages.
Replies: 6
Views: 1741

changming - if you specify link ordering you will get the order that you specify.
by ArndW
Wed Jun 24, 2009 1:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQS.DLL FAILED TO LOAD
Replies: 7
Views: 4741

In which directory is this dll on Windows?
by ArndW
Wed Jun 24, 2009 1:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP plug in not working
Replies: 5
Views: 2810

If you are using the default port, try entering just the minimum values - userid/pwd and server name.
by ArndW
Wed Jun 24, 2009 12:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare two columns
Replies: 2
Views: 1807

In a transform stage, put a constraint of "In.ColA <> In.ColB" to the output link going to a sequential file. If this file contains one or more lines then you need to send a mail; this logic can be done as part of the after-job routine, or part of the job sequence which calls the job, or e...
by ArndW
Wed Jun 24, 2009 12:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to get into Designer & Director
Replies: 6
Views: 2233

Even if TELNET is disabled by policy, you can still try to connect to this DS server machine as DS installs it's own telnet listener.

try "TELNET {YourServer}" - does that work?
by ArndW
Wed Jun 24, 2009 12:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to union rows from multiple input into a single output ?
Replies: 1
Views: 801

Yes, that stage will serve the purpose for you.
by ArndW
Wed Jun 24, 2009 12:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation Error in Routine
Replies: 2
Views: 1115

You need to include the definitions for the constants and routine names when writing your own BASIC functions or routines; this is done automatically in before-job routines and is not necessary there.

Add "$INCLUDE DSINCLUDE JOBCONTROL.H" to your routine.
by ArndW
Tue Jun 23, 2009 9:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Update a READONLY routine
Replies: 8
Views: 4172

The .dsx file is a text file and can be modified with the editor of your choice.
by ArndW
Tue Jun 23, 2009 8:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upgrading to DS8.0
Replies: 9
Views: 2309

Some stages don't fully support waves, perhaps that is what was being referred to.
by ArndW
Tue Jun 23, 2009 7:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: the record is too big to fit into block
Replies: 22
Views: 18414

Are you just setting this in the ADMIN or are you also passing it to the job as a parameter (which is what you should be doing).
by ArndW
Tue Jun 23, 2009 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: the record is too big to fit into block
Replies: 22
Views: 18414

If you are getting the same error message, then obviously the change isn't being accepted. Can you check the value in the director log for your run?
by ArndW
Tue Jun 23, 2009 5:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Master job fails
Replies: 22
Views: 5086

There is not enough information to give an answer. I would also highly recommend to use a Sequence job instead of a server job, transform stage and executing a routine to start jobs.
by ArndW
Tue Jun 23, 2009 5:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: the record is too big to fit into block
Replies: 22
Views: 18414

I seem to recall that the block size is allocated as a power of 2 and rounded from the number specified in the block size. Try specifying 1048576
by ArndW
Tue Jun 23, 2009 5:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: scratch space
Replies: 5
Views: 1934

DataStage will attempt to clean up the scratch space files on successful job completion as well as when a job aborts.