DSXchange

A reson (literally "thingy") is one of the fundamental units of magic - it's a subdivision of the thaum. "U" is one of the participants on this forum: the second person personal pronoun is "you". You provide no definition of performance, but ask us to comment on how something undefined can be chang...

No, because we have no idea how big one record is. You can determine the size of each field based on its data type, and sum these to get the record size. Multiply by the number of records and round up to the next higher multiple of 128KB. That's the Data Set calculation. For scratch disk and free sp...

Welcome aboard. The problem is that you have not filled in the WHERE CLAUSE property in the Filter stage for the second output link (the first is number 0). On the Outputs tab in the Filter stage, select the output link name from the drop down list, choose the second, and you will see that there is ...

Ah. No. Further research is required.

Why do you hope that?

There IS a make_null() function for the Modify stage. Unfortunately the Parallel Job Developer's Guide documents this incorrectly. You also need to read the Orchestrate Operators manual.

Can you please post the eCase number, so others can get the same problem resolved more quickly?

If you want to use a File Pattern, then the metadata must be identical, or you must rely upon runtime column propagation, which may limit what you can do downstream - you will require at least partial metadata to use constraint or derivation expressions, for example.

Why do you want this information? For all I know you might be from the dark side, seeking to cast FUD on DataStage to sell your own product! That there are more than 17,000 participants registered in DSXchange should tell you that there are a lot of DataStage sites out there. Some of them are major ...

Just 'cause you read it in the paper doesn't mean it's true. Probably looked for it in the project directory.

Yes, I believe it's per process. So with 10 processes there exists the potential to be demanding 10GB of virtual memory for cache. This might explain some of the prevalence of add_to_heap() errors when folks imagine that the server can deliver an infinite amount of resources. Remember, too, that vir...

WHY use Execute Command activity to invoke dsjob command ?!!!!!

Use a Job activity. You can then use "reset if required, then run" as its mode of operation, and everything is automatic. No coding, almost no thought, needed.

Are there files called .developer.adm and .operator.adm (particularly the first) in the project directory?

Welcome aboard. :D

The answer is no, because DataStage does not have its own authentication - it relies upon operating system authentication.
That said, you could include the su command (or sudo command) in your script.

Then your enterprise's communication processes need better management.

The best improvement will be obtained with multiple simultaneous SELECT queries, as I already said. The PARALLEL hint is not helping much since the result set is still being delivered sequentially. Read what I said earlier, this time more carefully. Don't bother with a Link Partitioner - use paralle...