DSXchange

Looks like a wide exam scope. I find myself loathing the idea of memorising all the EE environment variables! Hopefully they will just test on the commonly used ones such as config file, combine operators and tracing. Some notable exclusions are job control BASIC, version control tool and the XML in...

Some database engines optimise queries that are used more then once and you can find it runs a lot faster with repeated use.

When Ascential bought Mercator and turned it into TX it came with a very large number of adaptors and connectors including some EAI queues that DataStage did not have. Couldn't tell you the exact list, it used to be listed on the Ascential web site but in recent times they have made this type of inf...

To expand on Craig's answer, the table definitions are really just a design tool, when the job is running it only looks at the local job column definitions. You need to compare the cost on the user defined SQL of adding the third table, whether database optimisation will improve this SQL, or whether...

Well done. It is a tricky little business copying sections of DSParams. Do a search check on a parameter name and make sure it is not duplicated. If you get the copy wrong the DS Administrator tool can end up duplicating a section and it becomes difficult to make changes.

The install process should stop and start the server for you and handle any shared memory. It should retain your existing config files but take backups just in case. You should also backup your dsenv file as you may lose your Oracle settings and need to reapply them.

Sequence job: - start loop with a very high number of loops defined using a job parameter in case you need to run the sequence with a limited number of loops. - a set variables stage that calls a routine that determines how many seconds until 10PM, two outputs with a different trigger on each, jump ...

Your target table has the surrogate key and the fields that comprise the natural key, even if they are not defined as key fields. You update your mapping table by retrieving the surrogate and natural key fields from your target table using some type of incremental load filter such as processing id o...

It's a plain text file.

So how are you passing replicated data to your DataStage jobs? Are you using the SOA edition and building jobs as services? People might remember Mimix Replicate under the old name Omni Replicate. Would be interested to know how it interacts with DataStage.

According to a thread at developernet Ray saw a demo at IILive. I've heard that certification for DataStage EE is ready and we should see something at the start of next year. I don't think there will ever be a version for server edition.

Okay, no replies so I'll take a shot. DataStage has a definition of the cluster within the configuration file of the main server. Some server software needs to be installed on each machine in the cluster but I'm not sure how much. Yes you do need rsh communication between the nodes though I believe ...

Part of your problem when adding descriptions may be understanding what the job is really doing. My vote for the fastest method for screening the job and adding a description is to generate full HTML documentation using the dssaveasbitmap script posted on devnet. Allocate them to whoever is doing de...

BASIC programming in DataStage can be easy. Just refer to the DataStage BASIC Guide or the basic chapter in the Server Job Developers Guide and search for specific commands on this forum for examples.

If the table you are comparing is also the table you are loading here is a good design: cleanse, compare then load. Clean your data in a transformer, compare it in another transformer and then load the inserts and updates. You want cleansed data in your DB2 table. You don't want to have to guess whe...

Your QualityStage text log file will tell you a lot, it has an entry for each step with a timestamp so you can roughly tell how long each step is taking (I hope!). Strange that it is slower in prod, are any traces turned on?