DSXchange

Is there any reason for going to 6.0 instead of 7.5.2? DataStage jobs look and run pretty much the same between 5 and 7. The main changes are sequence jobs and the underlying Universe engine. I would expect your 5 jobs to upgrade smoothly to 7.5.2 and save you the bother of future upgrades.

Pity, I would have flown to the US for free minibar.

Does that include the contents of the hotel minibar?

You will have to do it through IBM-Ascential support and have a valid serial number or evaluation agreement with IBM. They can send you the software on CD or DVD or they might be able to set up an ftp link. This is not like DB2 Express with a free version or even like Sunopsis with an evaluation ver...

There are sites out there running DataStage on hundreds of servers in a grid. The speed and throughput depends on how many CPU, disk and RAM resources you throw at it and the bandwidth of your network and the performance of your source and target databases.

Good to see people passing the exam. It's a great way to round out your knowledge of the product. Currently the only certification help out there is the overview on the IBM website and my blogs: Can I prepare for certification on an old version of DataStage? and DataStage Certification - how to pass...

Has the company you are with spent money for EE and yet does not have a solution for Change/Version Control for other non-EE software? Yes! All the time! DataStagers are usually on specific project teams with a standalone server setup with just DataStage software. On a lot of these projects no one ...

Thanks Guru, great to get some feedback.

I have used it to control shell scripts and I think it works very well. It is a lot safer then hoping that developers remember to ftp the right scripts between envs. Read the vc manual section on custom folders. I believe it can control any type of file in that directory including programs.

I did some comparisons that revealed that sorting was significantly faster in parallel then server and that even without using massively parallel jobs you could still get better performance. See DataStage server v enterprise: some performance stats . Also read my article in DB2 Magazine that gives s...

Assuming that you have an administrator login (such as dsadm) that the developers do not have the password to you could try setting the permissions of the DSPARAMS file in each project directory so that only the dsadm user can modify that file. When user defined variables get moved from testing into...

The temp directory setting is under the project environment variable settings in the DataStage Administrator and is set for each project. I think this is the one the DB2 load will use.

Have you been through all the teradata setup steps from the Install and Upgrade Guide? It might be a missing dsenv value. You might find the Teradata API if you open your Designer repository and from the right mouse click menu display stage types, browse through the parallel stage types the missing ...

Do you have a copy of the pre-upgrade dsenv file (in the DSHome directory) or the DSParams file (in each project directory) that you can run a text file comparison on. Have you reverted to a default config file? Is there a trace parameter turned on? Is the deterioration only in jobs that insert or u...

I use Ken's parameter all the time. It is quite flexible, you can use it to copy one parameter or multiple parameters, it can add just the missing parameters or wipe and create new sets. Look for the link to Ken's website on his profile page.