Search found 15603 matches

by ArndW
Mon Jun 23, 2008 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Load option - Encountering a error
Replies: 8
Views: 3636

Apart from being cryptic, there seems to be nothing wrong with the name. I am not at a DataStage PC right now, but recall that you can set the load stage to keep the control files and scripts that it writes, could you set that to "true" and use a binary text editor to ensure that there are no excess...
by ArndW
Mon Jun 23, 2008 5:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Load option - Encountering a error
Replies: 8
Views: 3636

My first guess is that you have an invalid character in your table name. Can you cut-and-paste the name to this thread?
by ArndW
Sun Jun 22, 2008 11:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Job Compile Error
Replies: 8
Views: 4490

I've been encountering the same type of issue on a new AIX V8.0.1 machine. I was the only one on the box and had no Designer clients open, but the multiple job compile would give me that error, or after the multiple job compile completed I would get a warning when opening up a job (one that didn't c...
by ArndW
Sun Jun 22, 2008 11:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to see Show performance statistic
Replies: 1
Views: 717

This is a topic which has been discussed at length in many other threads. Has "Search" not pointed you towards an answer? If not, what have you checked?
by ArndW
Sun Jun 22, 2008 11:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: messages getting truncated when writing into MQ
Replies: 3
Views: 1325

That means that your "some data" is different from the rest. Does it contain 0x00 characters?
by ArndW
Sun Jun 22, 2008 11:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Warning
Replies: 4
Views: 2911

That is an odd error - I'Ve just checked and x2019 is the back apostrophe see here and it does not seem to have a ISO8859-1 counterpart! The error is valid and you will need to handle it by either removing the character, or defining a replacement. The xFFFD is a "replacement mark" for a character wh...
by ArndW
Sun Jun 22, 2008 12:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fileset data not found on some nodes
Replies: 3
Views: 1015

from UNIX, what does "orchadmin describe -c {file}" return?
by ArndW
Sun Jun 22, 2008 9:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delete existing record before insert
Replies: 12
Views: 4002

N.B. - you cannot "update" anything in either sequential or dataset stages. It is all-or-nothing.
by ArndW
Sat Jun 21, 2008 8:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unix commands on 8.0
Replies: 4
Views: 1367

Aren't the MKS Toolkit components installed automatically anymore?
by ArndW
Sat Jun 21, 2008 8:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with ORCHADMIN
Replies: 15
Views: 6586

ROFL - how right you are, Craig :oops: - I was thinking of him assigning the value, not displaying. That's what I get for working 13 days solid :(
by ArndW
Sat Jun 21, 2008 7:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with ORCHADMIN
Replies: 15
Views: 6586

Drop the "$" sign from the echo command.
by ArndW
Sat Jun 21, 2008 4:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSParam file values not reflected in ADMINistrator
Replies: 3
Views: 1889

I am fairly sure, but not certain, we did this on some of the other 8.0.1 installations here - although they were on Solaris and this is AIX. There must be information stored elsewhere - in the ADMIN tool one must type in a prompt for each user defined setting. The DSParams file doesn't contain the ...
by ArndW
Sat Jun 21, 2008 4:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with ORCHADMIN
Replies: 15
Views: 6586

Could you output the result of "env | grep ORCH"?
by ArndW
Sat Jun 21, 2008 3:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSParam file values not reflected in ADMINistrator
Replies: 3
Views: 1889

DSParam file values not reflected in ADMINistrator

I've just encountered a very odd scenario that I am at a loss to explain. I've installed a fresh V8 AIX system, created a project and then added the "[EnvVarValues]" section information (about 30 values) to the DSParams file in that project. This was done when no clients were active. When I go into ...
by ArndW
Sat Jun 21, 2008 1:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Improving Performance in server jobs
Replies: 5
Views: 1496

sreddy, those recommendations are more specific to your site and installation and might not be general rules. I don't understand (2), and (3) is not necessary when you configure your jobs to use interprocess row buffering.