DSXchange

Thank you Craig. I was not experiencing a problem - just trying to understand the parameters better.

I am not concerned or interested in v11 The key here is running multiple versions of PXEngine on the same server. If these memory variables are offsets then I would think they should be different for every version running. If they are the same then perhaps the Engines will conflict and walk over eac...

We are running multiple versions of DataStage all using just PX not the DS Server version. 7.5.2, 8.1.2 & now 9.1.2 I see that the shared memory parameters are different in 7.5 and 8.1 and when I install 9.1 they end up being the same as 8.1. Shouldn't the 9.1 values be different. I have found n...

Well it's probably easier to write a query against DS_JOBS/DS_JOBOBJECTS, but you have to find someone who knows the internal structures. I hadn't realized the original question was for V7. I worked with the whole set of tools last July on V8 and I posted a few opinions/questions. Conclusion - defin...

Well it's probably easier to write a query against DS_JOBS/DS_JOBOBJECTS, but you have to find someone who knows the internal structures. I hadn't realized the original question was for V7. I worked with the whole set of tools last July on V8 and I posted a few opinions/questions. Conclusion - defin...

Submit to IBM as what a metadata respository SHOULD do. So far the reporting capabilities of their new and improved V8 intergrated suite are woefully sad.

If all of the lookup keys are on the source file you can do it all in one transformer. If any of the lookups need to build a key with columns from a previous lookup you need to have more than one transformer. You may also find it easier to have multiple transformers for rejecting rows and deciding w...

Are you only doing updates? If not, you are probably doing upserts. Split the file into two, one for inserts and one for updates. Then run each file through the proper load. If you are doing all updates, consider generating a key file and delete all the rows with those keys. Then bulk insert all the...

In my experience, the best practice has always been to have the ETL resolve referential integrity. The number of jobs is not relevant. You could have 3 jobs for each table, depending on complexity and modularity. The load images for the related tables would be generated as seq files or datasets and ...

You can see if a routine is read-only by double clicking on it in designer and at the top of the window it will show (Read-Only) Also all the buttons are grey except Close and Help, so you cannot save or compile it. If your routines are not read-only then it must be something in the new projects -ma...

You can see if a routine is read-only by double clicking on it in designer and at the top of the window it will show (Read-Only) Also all the buttons are grey except Close and Help, so you cannot save or compile it. If your routines are not read-only then it must be something in the new projects -ma...

Are the routines marked read-only in the project you export from?

Do they already exist in the project you are importing to and are they read-only there?

inspect the dsx file and search for ROUTINE - are there other routines in the dsx besides the 3 you want?

Interesting discussion. Rather emotional on all sides I think. The message to IBM is simple - IMPROVE YOUR TRAINING - at least keep up with the competition. Whether you think the money leads to revenue or not. I for one think you will get a bountiful return on investment. The better the world of dev...

#!/bin/ksh ####### ################################################################################ ####### ####### FILE: dsjob_logwarns.ksh ####### ####### DESCRIPTION: Retrieve Warning and Fatal error messages from datastage job ####### log for latest run ####### ####### Steps: ####### 1) Use dsj...

Where are all the testimonials to how good the IBM training classes are?? The issue is not whether certification is important or whether IBM has better consultants than the independents. There are a few alternative education alternatives that are better and cheaper than IBMs - always have been - DSX...