DSXchange

I agree, the AIX Visual Age compiler can be a pain to install and expensive to license for multiple developers. The documentation suggests Visual Age for AIX but maybe you can put a free compiler on your AIX box and try that instead. I haven't tried USS but I am guessing the compatibility between Li...

The full list of new features in all version 7.x releases can be found in the file upload section of Ascential Devnet at m. Putting aside all the minor useability changes these are the major decisions to make after a long break from DataStage usage: - Parallel jobs via Enterprise Edition. Do you hav...

I'm going to take a wild stab in the dark, if selecting from DEV2LIB/INVDPT worked and selecting from COMPVIEW/DEV2LIB.INVDPT did not work then shouldn't you alter your SQL and take the COMPVIEW out? You may be over qualifying your table names. On the columns tab and the table name tab it should be ...

Use the ODBC Stage, on the General table you will see a radio button "Select using:" with a choice of "Generated Query", "Stored procedure" or "User defined SQL query". If you have any problems getting it to work do a forum search for ODBC stored procedure as there have been a few threads on it in t...

I use an XML export style sheet to extract a list of input and output datasets for each job. This gives me a list of all datasets and the jobs using them. There is an XLS stylesheet already in the DataStage client directory. I modified it to show just datasets. If you do regular backups of your Data...

If you don't have a fully version of Access you can use MS Query instead (which is installed on most Windows machines) or your own ODBC query tool, just point it at the DataStage Reporting ODBC driver created by the DataStage installation.

In the next release in September they are merged into a single product. At the moment ProfileStage is a data profiling tool with sets of defined profiling functions. After an initial profile it does not have very good ongoing monitoring and metrics. With AuditStage you have a greater range of busine...

Do your before and after datasets have exactly the same metadata definitions? Did your before dataset have any additional transformations applied when it was originally populated such as data conversion or string trimming?

Our job compile times are all over the place. This morning I did a compile job with about 20 stages and three transformers and it took 20 minutes. Half an hour later I compiled the same job and it took 30 seconds. There is no one else doing anything on the server but the compile times seem to be ran...

The number of Readers Per Node has a complex start up involving counting the size of the files, dividing the file across the specified number of readers to partition your data. I'm guessing that they don't allow this option for File Patterns due to complexity it adds to the stage code. It may be an ...

I think the install.sh unpacks the plugins to a subdirectory of the install file. Have a look at the script to see what it is doing.

It comes with a couple plugins so you need to run the install.sh and then run the register plugin. I think you can do that from the Manager or the command line. It also has some sample jobs that you need to import. The samples are very important as the log reader has some funny codes and the example...

My comments refer only to the web site. IBM software have been promoting DataStage for years now and have done a good job in Australia at selling it even before they owned it. Just concerned that the Ascential web site has stopped posting new content while the IBM web site is dragging its heels. We ...

I noticed today that when I google a typical DataStage problem, such as the word dsjob or parallel job or a similar phrase, I don't get any search results from www.dsxchange.com threads. I do see threads from other forums such as the tek-tips forum and the datawarehouse.com forum. Is there any way y...

I've just been to the www.ibm.com website to see how they have integrated the Ascential product information into the web site. What I found was a train wreck. It would take Jacque Cousteau and a team of divers a week to find anything about DataStage. Most DataStage searches take you to generic produ...