Search found 53125 matches

by ray.wurlod
Thu Aug 20, 2015 7:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a way to force a column to be SQL type of Unicode?
Replies: 9
Views: 2051

Then you can't do Unicode. With NLS disabled, all you have available is extended ASCII.
by ray.wurlod
Thu Aug 20, 2015 6:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a way to force a column to be SQL type of Unicode?
Replies: 9
Views: 2051

Even if NLS is configured (which it sounds like it isn't), check also that the map selected for the job is not NONE.
by ray.wurlod
Thu Aug 20, 2015 6:25 pm
Forum: General
Topic: PVU Comparability of AIX vs Linux on 11.3.1 (or any version)
Replies: 10
Views: 4956

They may be being simplistic, comparing only the GHz rating of the i386 and the POWER chips.

That is not the same as "performance" except in an extremely restricted sense.
by ray.wurlod
Thu Aug 20, 2015 5:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a way to force a column to be SQL type of Unicode?
Replies: 9
Views: 2051

It's in the Extended properties. If your data type is Char or VarChar (or one of the Long variants), then "Unicode" becomes available as an Extended property. If you can't see an Extended column in your Columns grid, right click in the title area or the background area of the grid, and edi...
by ray.wurlod
Thu Aug 20, 2015 5:07 pm
Forum: General
Topic: PVU Comparability of AIX vs Linux on 11.3.1 (or any version)
Replies: 10
Views: 4956

Start by getting them to define what they mean by "performance".

Performance in an ETL environment is not about raw cycles/second. There's always heavy demand for memory and I/O to factor in, and the efficiency with which context switching is performed.
by ray.wurlod
Thu Aug 20, 2015 5:05 pm
Forum: General
Topic: Fetching userstatus from commandline whilst detecting abort?
Replies: 6
Views: 2609

The -userstatus option on the dsjob command returns the contents of the job's user status area. No more, no less.

In particular it does not return an exit status. That is the purpose of the -jobstatus option.
by ray.wurlod
Thu Aug 20, 2015 5:03 pm
Forum: General
Topic: DS 11.3 Windows AD Authentication
Replies: 3
Views: 1878

It's in the Planning, Installation and Configuration Guide. Basically you have to configure the global security settings in WebSphere Application Server, providing details about the primary Active Directory server, port number (usually 389), base DSN (where to begin tree search in AD) and bind DN an...
by ray.wurlod
Thu Aug 20, 2015 4:59 pm
Forum: IBM QualityStage
Topic: NLS Map for Special Characters
Replies: 9
Views: 7416

So, just looking at the first one, the hex bytes between "Infospher" and "Information" are e296 9249 (positions 0026 through 0029 in your dump). You will need to find an appropriate Unicode map that tells you what this four-byte sequence is supposed to be. You will also need to f...
by ray.wurlod
Wed Aug 19, 2015 10:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rejecting data without any logic from transformer to seqfile
Replies: 6
Views: 1753

Almost.

In parallel jobs, database errors are not handled by the Transformer stage's reject link but, rather, by a reject link from the stage that connects to the data source/target.

It is true that is server jobs database errors are handled by the Transformer stage reject link.
by ray.wurlod
Wed Aug 19, 2015 10:18 pm
Forum: General
Topic: unable login via designer
Replies: 12
Views: 6139

When you are logging in to DataStage using HTTP (port number 9080 by default), it temporarily switches to HTTPS (port number 9443 by default)while validating your password. So it may be that your error is occurring during the password validation phase of your login. Though why you are getting "...
by ray.wurlod
Wed Aug 19, 2015 5:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rejecting data without any logic from transformer to seqfile
Replies: 6
Views: 1753

A reject link from a parallel Transformer stage handles any row that causes an exception. Parallel Transformer stage also has an "Otherwise/Log" link that handles any row that has not been transferred to any previous output link. It is this link type that is the equivalent of the server/BA...
by ray.wurlod
Wed Aug 19, 2015 5:02 pm
Forum: General
Topic: PVU Comparability of AIX vs Linux on 11.3.1 (or any version)
Replies: 10
Views: 4956

The PVU for AIX is higher than that for Intel/AMD exactly because the POWER processors are more powerful. To get the equivalent processing capability you would need more Intel/AMD cores.
by ray.wurlod
Wed Aug 19, 2015 5:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Container Error
Replies: 7
Views: 2144

Do you have RCP enabled?

That would be one explanation for the differences in numbers of columns not being reported by the validation process.
by ray.wurlod
Wed Aug 19, 2015 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data element in MQ connector stage
Replies: 5
Views: 2269

Data element has been in DataStage since version 1.0. It's like a data classification that extends the technical "data type". If you review the data elements that are stored in the MQ folder, you will understand that they document different structures in messages, such as header and body.
by ray.wurlod
Wed Aug 19, 2015 4:55 pm
Forum: IBM QualityStage
Topic: NLS Map for Special Characters
Replies: 9
Views: 7416

We can't see your "special" characters in this dump. Can you highlight the hex codes that correspond to them?