DSXchange

I tried the method suggested by Craig. I had "Continue" option selected in "Lookup Failure" and in the next transformer I have checked for the column coming out of Lookup for NULL value(alslo checked for 0) which did not work. Both records does not pass through the transformer. O...

Hi We just migrated to EE from server. We would like to specify Lookup found condition in the lookup stage but there is no option for that. I can see lookup failure option but I don't see a lookup success option in there. For restartability of the jobs we usually do lookup to the target table and if...

Hi, We are migrating from Server to Parallel and we are trying to use DB2 EE stage to connect to remote database. We get the following error during view data. ##F TFPM 000279 14:03:30(002) <DB2_UDB_Enterprise_23,0> Fatal Error: Caught ORCHESTRATE exception in parallel process: APT_Archive::BadClass:...

That's interesting. So there is a job compare utility in 8.x. Good news.
Can you tell me which version particularly ? Is it in built in DS or Is it the one when DS is integrated with Clearcase ?

Thanks Craig...

I would like to know if there is any tool to compare two Datastage jobs as we are having problem when we migrate jobs to production. I know we can export both jobs and do the text compare using a tool like ultra edit or something. Is there any other better way of doing this ?

Please advise.

Thanks.

Hi Do we need to recompile all the jobs If I change a existing project to Protected Project ? It looked to me like that. I have created a project as unprotected and I changed it to protected. but when we ran the job it said job is not in the correct state even though in direcotr it shows as compiled...

We use DataStage to populate the EDW and Marts and also to transfer data between Legacy sources and Distributed source systems. Now some people are interested in using WTX for the same purpose. I can agree with them on transfering data to OLTP as they may want it in a queue as XML as that can be rea...

Thanks for the replies and I will post the samething there...I have the same thoughts like WTX is not meant for batch operation. But In future if we move towards real time DW then would this help or RTI would be the better choice for that ?

We use DataStage to populate the EDW and Marts and also to transfer data between Legacy sources and Distributed source systems. Now some people are interested in using WTX for the same purpose. I can agree with them on transfering data to OLTP as they may want it in a queue as XML as that can be rea...

I am talking about server/CPU licence.

Thanks

I am not sure this is the correct forum to ask this question. Please redirect me If it does not belong here. We have 4 dev and 4 test and 8 prod DataStage licences as of now. We want to split this like 2 for dev, 2 for test1, 2 for test2 and 8 for prod. I know the numbers does not match exactly but ...

Craig I read that also. It's windows installation and ours is unix. Moreover it's not like it's not working after an upgrade or somethong. This is the first time we are trying to use this stage. But I notice onething that APT_DB2INSTANCE_HOME was empty in Administrator so I set it to /opt/IBM/db2ins...

Craig I did read the forum before posting this question. This is the one I found useful out of many. This is a run time error. IBM gave a work around for this problem. It appears that this is a bug and will perhaps be patched up in the future. The work around is to create an EMPTY "db2nodes.cfg...

Hi We are in the process of migrating from Server 7.5.2 to EE 7.5.3. We installed EE in our dev server. We are getting the following error when trying to use DB2 EE stage. DB2_UDB_Enterprise_7: The file `/opt/IBM/db2inst1/sqllib/db2nodes.cfg' must exist and be readable by all users! When I checked f...

Thanks for the reply. I will give a try. If I am not wrong we don't need to bounce the service when you change values in dsenv file. Correct ?

Thanks