DSXchange

Hi, We have a requirment where we need to bring a value into the primary flow of data from a reference table without matching on a key. The source is a sequential file. We just need to add an additional column from a reference table into this stream. There is no column on which we could do a match t...

Hi, We would like to know if it is possible to read a file from Mainframe using FTP Enterprise stage. If so, what is the format in which the value has to be given for the URI property. We tried it and were unsuccessful in the attempt. When we gave the value for URI as, ftp://<Mainframe_ServerName>/<...

Thanks All for your inputs.

We would look into having the DB2 Enterprise stage configured. Looks like it has a long set of configuration steps.

Thanks.

bcarlson wrote:We have yet to find a good reason to use anything but the Enterprise stage and have had extremely good performance.

Hi Brad,

When you say extremely good performance, what is the approximate rows / sec processed from the DB2 stage?

Thanks.

Hi, We have a parallel job where we use a DB2 API stage as the source. By default, this stage runs Sequentially. As we needed to improve the performance, we changed the property of the stage to run Parallely. The source table originally had 1 million records. But what we noticed was, when the job is...

Thanks Brad for your detailed information. We dont have a setup like the one you have mentioned. We have a database only on the Mainframes and nothing on the DataStage server. In this scenario, would it be possible to use the DB2 Enterprise stage? Our other question is, what would be the value you w...

Thanks Ray.

I would try this method.

Does the DB2 connect client software allow you to run a query against the DB2 mainframe table from your local DB2 server? Could you please let us know what do you mean by "local DB2 server" We are able to connect to this DB2 database and query on it from the client software thats on the d...

Hi,

We have DB2 on the Mainframes and the connection from the DataStage server is using DB2 Connect client software.

Does it mean that we cannot use the DB2 Enterprise stage to conenct to the DB2 database?

Thanks.

Hi, We have some kind of uncertainty when we are trying to implement a Server job's Aggregation logic to a Parallel job. We have 4 columns - A, B, C, D; as input to the Aggregator. The grouping keys in the Aggregator is all the 4 columns. The output of the Aggregator is also the same 4 columns. Our ...

Thanks for your suggestions. But I missed one point to tell. We would need to do 'Sum' and 'Max' on certain columns. That was the reason we use Aggregator here. In a Server job's aggregator, I could group by on certain columns, then get the 'Sum' and 'Max' for the columns we want and then for the re...

Hi, We are in process of converting our Server jobs into Parallel jobs. There are some Server jobs that use Aggregator and that uses the Aggregate function 'First' in them. When I convert these jobs to parallel jobs, I see there is no similar property to set, in the parallel Aggregator stage to get ...

ArndW, Ok, you say to write it to a SQL-capable source and then do the Range Lookup. But there is no feature in parallel job to write to a Hashed File and then reading it using a stage like UniVerse stage. So, is the only solution in parallel job is to write it to a database table and then read it f...

Hi, Is there any way to do a Range Lookup when the reference link is either from a Sequential File stage or from a Data Set stage? In Server jobs, we have written the records to a Hashed File and then read it through a UniVerse stage to accomplish a Range Lookup. Is there some kind of means to achie...

Hi, We are using DataStage version 7.5 on AIX server. We were making use of the feature Multi row result set (in ODBC and UniVerse stages) in Server jobs. Now we are moving into Parallel jobs, and there is no such similar kind of option in the parallel stages. Could anyone please point us on how cou...