Search found 53125 matches

by ray.wurlod
Thu Dec 20, 2012 9:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to allocate communication resources
Replies: 2
Views: 3378

Why do you think "unable to allocation communication resources" is a disk space issue? Does your configuration file mention more than one fastname value? What stage types are upstream and downstream of the Aggregator stage? What operators are upstream and downstream of the group operator i...
by ray.wurlod
Thu Dec 20, 2012 9:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error:blockSizeActual >=v4BlockHeader::size():C:
Replies: 4
Views: 2406

How large are the records that you're attempting to process?

Do a search of DSXchange for "block size".
by ray.wurlod
Thu Dec 20, 2012 9:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sorting at different record levels
Replies: 4
Views: 1418

Indeed. I meant to type that. I've amended my earlier post.
by ray.wurlod
Thu Dec 20, 2012 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Field 'column name' has keyprep export buffer overrun error
Replies: 1
Views: 11565

Don't push. You posted at 4:50am my time. Your push came in at 7:50am. And you didn't actually ask any question. Why not involve your official support provider? After all, they're collecting a percentage of your licence costs. The answer is staring you in the face in your example data. Read your own...
by ray.wurlod
Thu Dec 20, 2012 4:14 pm
Forum: General
Topic: Need to list the jobs using a same file(filename)
Replies: 2
Views: 1408

Assuming that you have been vigilant about your metadata (table definitions), right click on the table definition of the Data Set in your repository and perform a Where Used analysis.
by ray.wurlod
Thu Dec 20, 2012 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sorting at different record levels
Replies: 4
Views: 1418

Looks like you need to sort by CLIENTID then by EMPNO then by GROUPPOLICYNO then by RECORDTYPE and specify Nulls Position as First.
by ray.wurlod
Thu Dec 20, 2012 4:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal error while using Oracle connector for deletes.
Replies: 8
Views: 4119

I don't think you're missing any options. Array and commit size need to be 1 for DELETE. You have these.
by ray.wurlod
Thu Dec 20, 2012 4:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which partition type I need to use in the JOIN stage
Replies: 7
Views: 3953

Once more with feeling... (Auto) partitioning yields the following results. On a sequential-to-parallel link --> Round Robin On a parallel-to-parallel link --> Same (On a sequential-to-sequential link partitioning is not applicable.) On the reference input link to a Lookup stage --> Entire On an inp...
by ray.wurlod
Thu Dec 20, 2012 3:55 pm
Forum: General
Topic: Problem with DataStage logs and how to clear them
Replies: 6
Views: 2631

Yes it's safe.

Operational metadata is managed in an entirely different way - you have to run a command to import them into XMETA.
by ray.wurlod
Thu Dec 20, 2012 3:47 pm
Forum: General
Topic: ERROR: Failed to open project
Replies: 6
Views: 1879

Can you do anything at all with dsjob, such as -lprojects or -ljobs ?
by ray.wurlod
Thu Dec 20, 2012 3:44 pm
Forum: General
Topic: memory fault
Replies: 5
Views: 1321

So you're saying that "Memory fault" was the only error message on the screen. Have you looked in the WAS logs, particularly SystemOut.log ?
by ray.wurlod
Thu Dec 20, 2012 4:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue generating multiple surrogate key state files
Replies: 2
Views: 1355

How many times are you proposing to run this? If only once then two hours ought not to be a problem. You have provided no information about how you are creating the state files. For example, are their initial values obtained from a database query? That will take some time - to establish the connecti...
by ray.wurlod
Thu Dec 20, 2012 1:22 am
Forum: General
Topic: memory fault
Replies: 5
Views: 1321

What is the exact error message? What can you glean from it? How many entries are there in the log?
by ray.wurlod
Thu Dec 20, 2012 1:10 am
Forum: General
Topic: How to find jobs using shared container?
Replies: 18
Views: 4024

:idea: Please refrain from contacting DSXchange contributors via email or private message (or both) seeking responses to questions. You can be assured that regular contributors do read each and every post on DSXchange. They resent having to spend even more time reading emails and private messages co...