DSXchange

Mike wrote:It would be an interesting exercise to compare the job score between the 2 designs to see if operator combination combines any of the lookups.

Agree. I will make the exercise and post the results. I will mark post as resolved for now.

Thanks for your support

Since you want to do range lookups on 2 different reference links, you will have to use 2 lookup stages. Thanks Mike for the clear response, it really helped. In my case I use range lookups heavily (up to seven range lookups per job) along with hash file sets as reference stage for better performan...

We had to create a separate job with source stage and dataset stage only and use the dataset later on the original job instead of the source stage.

But we didn't manage know the root cause of such an issue.

Thanks for your support.

Thanks Ray for your reply. But I think if was about the connection timeout, the test job wouldn't have run with a dataset as a target. Also the query is not that complex and it retrieves results quickly while running from tools like DBVisualizer. I don't really understand the error message, and not ...

Hi, We've deployed one job to the prod environment but it's aborting due to below errors. The job is working fine on dev environment and dev & prod servers with same version 11.3.0.0 Error #1: SUB_STATUS_QUERY,0: The following error occurred on the parallel engine: APT_Operator::UnControlledTerm...

Thanks Ray.

Grant 777 permission on ValidateUsers tool has fixed the problem.

Simple & efficient . It has worked perfectly

Thanks, Eric

Hi, I have my data source as sequential files. They are monthly files with such a file name structure 'KPI_20140501.txt'. The requirement is to load multiple months during one run. The input parameter is DateFrom & DateTo. I have daily files and in order to loop on them for a week for example, I...

Hi, We're trying to install IIS v9.1 on Linux Redhat. All DataStage components are on one machine (except client of course), abd a fresh WAS & DB2 are getting installed through IIS installation. The installation creates successfully wasadmin & isadmin users through wizard. But while configur...

Problem is solved. Thanks Eric & Ray for your support. The main clue is testing the connection from the command line, it gave a different error which is the correct one. SQLConnect error: Status = -1 SQLState = IM003 Natcode = 0 [ODBC] [DataDirect][ODBC lib] Specified driver could not be loaded ...

The instructions say: I believe I'm using the same driver '3.51'

ray.wurlod wrote:Have you compared the files?

Yes I did but I didn't capture any difference.

Thanks Ray, here's the values at production server for the same files: .odbc.ini file data source entry is: [MySQL] Driver=/opt/mysql/lib/libmyodbc5a.so Description=Connector/ODBC 3.51 Driver DSN SERVER=10.10.4.107 PORT=3306 USER=<> Password=<> Database=NEWSMS OPTION=3 SOCKET= DriverUnicodeType=1 ds...

Dears, I'm trying to configure MySql community edition on DataStage server. I'm using this version 'mysql-connector-odbc-5.3.4-linux-el6-x86-64bit.tar.gz '. The configuration went smooth at the production server but It's not working at Dev server. I've followed the same steps mentioned in the below ...

Hi Ray, The error message was: buffer(0),9: APT_BufferOperator: Add block to queue failed. This means that your buffer file systems all ran out of file space, or that some other system error occurred. Please ensure that you have sufficient scratchdisks in either the default or "buffer" poo...