DSXchange

Have you imported the metadata?

First steps after adding a data source is to import the tables and columns under Home->Metadata Management ->Import Metadata

There should be two extra pdf documents. A user guide and an admin guide. These should be on the client computer where you installed the RTI console.

There is a brief example on using these stage in the following developerworks article: http://www.ibm.com/developerworks/libra ... datastage/

There are two types of web services in DataStage. Which one are you referring to?
1. Web Services Pack - allows you to call web services with your DataStage job flow
2. Real time integration - allows you to expose DataStage jobs as a web service

The files produced are used by the performance analysis tool, new in version 8. Selecting the option "Record job performance data" will write out information to an XML file containing: - Record throughput - Utilization of your machine (CPU, disk, memory) You can then view this information ...

As Pagadrai mentioned, you will need to alter your record delimiter. This usually means altering the process that creates your sequential file. You may not have the ability to change the format. If you do choose an ascii character for your record delimiter that is unlikely to occur in your data e.g....

Have you created a DSN for the information analyzer database (IADB)?

You can edit this information in the odbc.ini file in the DSEngine directory

Have a look at the system requirements at this link http://www-01.ibm.com/support/docview.w ... eswwindows

APT_COMPILEOPT and APT_LINKOPT only need to be modified when using Visual Studio .NET 2003 compiler.

After installing the patch for the documentation there is still no mention of the DB2 connector. So it looks like we will have to wait for IBM to release more details. From my limited use of the DB2 connector, you need a DB2 client installed on your server machine. No other configuration was require...

I would avoid using a fork join, it is possible that your job will wait forever. See the advanced developers guide under chapter 4: Link Buffering: Deadlock situations can occur where you have a fork-join in your job. This is where a stage has two output links whose data paths are joined together la...

Just got the DB2 connector installed. Note: This stage is only available in Parallel jobs. After installing I am able able to insert data in parallel. No complicated configuration required. The bulk load did not work out of the box. Looks like there is an issue with the default DB2 client installed ...

Folder should be C:\IBM\InformationServer\Clients\Classic\QS_TEMP

The DB2 connector stage and distributed transaction stage are downloaded as a separate patch. There are 7 patches in total that need to be installed, 4 on the server side and 3 on the client side. You can download the patches from the following link: http://www-01.ibm.com/support/docview.wss?rs=14&a...

One aggregator stage (execution mode parallel) to count the rows in parallel then another aggregator stage (execution mode sequential) to sum up the counts from each partition. No need to use hash partitioning, round robin in this case would be better.

Your concept of "containers" can be implemented by using multiple job sequences. Job Sequence 1: Run A-E concurrently Job Sequence 2: F->G->H->I Job Sequence 3: J-L concurrently You then need a master job sequence to control the 3 job sequences above. This will have the three job sequences...

Option 1: Remove 4 CPUs
Option 2: Purchase additional licenses