DSXchange

I have seen other forums try to prevent duplicate posts by only letting someone post once every 30 seconds. This stops the double clicking / backspace / refresh accidents. It probably only needs to be turned on for new posts and not replies. It is rare to see duplicate replies and the submitter can ...

I had some success where the Sequence job layers used project specific environment variables and the parallel jobs used normal job parameters. The parameters had the same name, just the $ removed from the parallel jobs. The sequence jobs mapped the $ parameters to the normal parameters. This let the...

Would it use both dir1 and dir2 or just the first one found? Might make more sense to turn one into a specific type of pool.

The only version of DataStage parallel jobs that run on Windows are from version 7.5.2x. Nothing else will work. Have you got the right version?

I think you could write a server transformer to parallel transformer function that alters the export file. Maybe as a search and replace macro in a text editing tool. You will need to build a simple job with a server routine, export it, replace it with a parallel routine, export it. Compare the file...

Have a look at the DataStage installation guide to make sure you get the right AIX package and version number for the C++ compiler. You should find the install guide in the client documentation folder on the install CD or you can install your DataStage client and access it through the start menu - D...

Hawk supports parallel, server and sequence jobs. Server jobs are still supported but are not being enhanced and will not have the four new QualityStage plugins or the new slowly changing dimension stage or the new range lookup feature. Having said this server edition will still be a better product ...

All those differences you described are purely run time parameters, they are not "compiled" into a DataStage job. Therefore your executables should run fine regardless of what CPUs and config files you use. We tried promoting just the executables but we got some errors on some of our jobs. Cannot re...

If your company is a partner or potential client of IBM you may be able to get evaluation software and licenses. If not then you might be better getting some open source ETL like Ketl or free ETL like Microsoft SSIS and practice with that.

Still waiting for the results of the A sample drug test...

Probably no performance benefits to using the ODBC stage. In parallel jobs the only supported databases for the Enteprise ODBC stage are Oracle, Informix, DB2 and Teradata. The m204 ODBC or JDBC can be used but only with the single threaded odbc stage so it will probably be slower than a flat file i...

Hello folks, Features "looking forward" ================ 1)Jobs in Designer should have a last run parameter view , where it should automatically pick up the last run parameter. this is helpful when debugging [especially complex jobs]. example: view data should automatically fill in the last run pa...

I have been meaning to blog about this, maybe tomorrow, IBM have changed the CPU based pricing model to cater for dual core and hyperthreading. Each core is either worth 1 CPU or 1/2 a CPU depending on the type. The good news is that Intel and AMD dual cores will be priced as one CPU, while proper d...

Great tip Diddy. You should also have a look at capturing your sql codes from the failed delete statements. I am afraid you are suffering from row leakage , follow the link for instructions on trapping error messages from your DB2 enterprise stage. You might fix this one problem but you still might ...

Do you mean server jobs and parallel jobs? The best way to see the difference is to read the partitioning chapter in the Parallel Job Developers Guide as it has a good description of parallel processing and partitioning with some groovy diagrams.