DSXchange

If you were particularly adventurous you could try and run your two VMs as a cluster, put one node on the main server VM and put two nodes on the other VM. This will take extra configuration steps and you need to keep both VMs running. There is a problem with VMs switching IP addresses each time the...

The license screen of the installation procedure accepts two licenses, one for server and one for parallel. You need to make sure both authorisation codes are present when you install your additional parallel engine. It should realise there is a 7.5.1a server engine already present and do the parall...

Dump your SQL into wordpad, search and replace , with '||'.

You can quickly convert any normal SQL into a concatenation SQL.

You can also generate lots of these by selecting table and column names from the RDBMS system tables and adding the concatenators as constant values.

You need a data dictionary that describes the file, such as a cobol definition file. You import it through manager to create your complex flat file hierarchy, you may need to jiggle it a bit to get it in, for example changing the level numbers or removing certain statements that the importer trips u...

This is probably a question for a specialised AIX forum. Can the operating system take RAM away from a process that is using it? When a parallel job starts up it allocates RAM to certain stages, the lookup stage for example tries to load all rows into memory and then overflows to scratch disk space....

You can use the less convenient $ENV in the older DataStage versions instead of $PROJDEF where the variables come from the operating system. You can also load your variables in from ini or text files using DataStage routines.

That was a clever move by Microsoft. We wont see a SCD stage in DataStage until the Hawk release.

I had a look at SQL Server 2005 and the new Information Services that replace DTS. DTS was never a strong competitor to DataStage in large data integration projects, but SSIS is a lot more like DataStage and could be a big threat. At the risk of getting contradicted from all sides I've compared them...

Think of the UserVariables stage as a code window broken into a grid. You can just go ahead and use the right mouse click menu within the derivation column and choose any type of function, routine, macro, system variable or job parameter you want. Also concatenations, strings, substrings etc. And ju...

You can also read the FAQ on project specific environment variables as this is the easiest way to maintain the encryption of your database passwords.

I recommend you make a routine that returns the value and call it from a sequence job via the UserVariables activity stage. It can then be passed as a job parameter into any job joined via a path of links to the UserVariables stage.

I once had a version of DataStage that had working SCD type 1, 2 and 3 intelligent assistants. Created sequence jobs and parallel jobs. Unfortunately I was only using that version for a couple weeks and I have not found any intelligent assistants on my subsequent versions. On my current project we h...

In DataStage 7.5.1 I've stopped using the routine stage and I only use the Variables stage to call routines that set values. The routine stage is expecting a true or a false, it's not expecting a value field, it should be used to return success/failure/warning rather then string/date/integer values....

If a sequence job has a status of aborted/restartable then you should be able to run it, and it will start from the failed checkpoint, or reset it to clear outstanding checkpoints. The likely problem you are hitting is that the child job the sequence is trying to start (that caused the original abor...

There are a few new sequence job stages and a couple new parallel job stages (such as conditional lookup), but no new server job stages.