DSXchange

I'm glad you tested the performance questions yourself.

Yes, it is quite normal to create one ODBC entry per database. IBM does have a Federation Server companion product, which is DB2 that allows one to connect to nearly any types of remote databases (SQL Server, Oracle, ODBC, others), and other systems. Then you could access everything from Information...

Try reaching out to Support. They can probably tell you what got missed when your hosts were renamed.

I have only used a personal password manager which encrypts a file of passwords. I have seen certain situations in DataStage, such as when storing password values in parameter sets (type=encrypted, and it's not an environment variable), that require all dependent jobs to be recompiled upon making pa...

What I gathered from an IBM session last year is that IBM had purchased the Initiate component, which used to be a separate product made by some other company, and they integrated it as a feature into MDM in order to change the old MDM deterministic matching engine to a new and improved probabilisti...

Ask an IBM sales rep and/or IBM Support about it.

Sorry, I don't know the answer. My passport is expired.

The first argument is total number of digits. The second argument is number of digits after the decimal point.

Commands:
ftp
sftp
rcp

There may be others too.

Four for Four...

Welcome aboard. The methods may vary according to your files and requirements. Same can normally be done within DataStage itself. Please post what you have tried so far and whether you have a more specific question.

Only ideas at this hour: 1) make sure all tracing and extra logging / debug levels are turned off and 2) try running the job with different degrees of parallelism.

Not to confound the matter, but the Transformer stage has been native to DataStage since day 1; just not native to the Orchestrate operators. Confuted?

got ilk?

Please note as per product installation documentation that the minimum AIX maxuproc value must be "1000 or unlimited."