DSXchange

We are planning to use always on job, which will be accessed by concurrent users. The reference data with minimal number of columns is around 2 GB. And when we expose this job as webservice, we might need minimum 3-4 instances of the service running in ISD for supporting concurrent requests. Since i...

Ray, The deisgn is for a web service, where we will have one request (one record), which will have to find records in a reference database where we have few million rows. So I thought Sparse is a best fit here. And the performance I am talking about is firing the query on database and get the result...

We are planning to use this sparse lookup in a DataStage Job that will be exposed as a web-service. The web-service performance should be very high. These are the two options I am thinking of 1) use ODBC connector and do a sparse look on Mainframe db2. 2) Load Mainframe db2 data into local aix db2 a...

Can we do Sparse look-up on Mainframe db2 table. As per my understanding DB2 EE stage in 7.5 does not connect to Mainframe and DB2 API does not support sparse look-up.

Do we have any extra features in v8.1 to do a sparse look-up on Mainframe db2

I have a COBOL File coming from mainframe as follows: 1) Contains 60 different record types. 2) Record type can be identified based on a fixed header field 3) Based on header field, identify the record type and we have separate copybook for each record type. eg: For record type 99, the data will be ...

Ernie, Thank you for your explanation. I will try with database and sparse lookups. SURA, Please find answers for your questions. 1. How much changes will you expect a day? The web service would be used at enterprise level and we are having huge number of users who will be invoking it. 1a. How frequ...

SURA,
I am not able to see your reply. If you have added some information in the thread, could you please update it again.

Thanks
Raghav

Ernie,

Sparse lookup option may not be a good option for us as we need to hit the database for each web-service invocation.

Could you please provide some input on " crafting your own in-memory objects using Java or some other technology".

Thanks
Raghav

We have created a webservice for customer search (both deterministic and probabilistic matches). The customer will be searched on a reference data of 200 million records. Currently we have designed the webservice for static reference data which needs to be updated for realtime scenario. Current desi...