DSXchange

Thanks a lot Ray, I will look into these routines further. I am also thinking other ways like using Job sequencer or Shared Container.

Thanks again for your response.

Regards,
KB

HI , How to compare the rows in data stage? thanks in advance fareeda Server jobs have a CRC32() function that you can use to determine if any part of a row has changed. Comparing the new CRC32() result with the previous CRC32() result. I have seen this done two ways. One is to populate the CRC col...

Anyone can share a sample Rules based DataStage server job?

Thanks
KB

Howdy! What is the database engine for this? The Database Engine is SQLServer 2000 If it is SQL Server 2000, then you would need to give a parameter or something that would segment the data so each job isn't trying to process the same rows. I don't thinks we need this as all these jobs handle diffe...

Are you trying to use the same table for all 5 jobs? --> No they access different Tables and they do different funcntions Are you using a stage to extract and another to update tables in the same job? The jobs will Read a STG table and Insert New or Update Existing on a Target tables in the SAME job...

Well Of course , if you run more jobs at the same time all the five are going to hit the CPU at the same time --> If this argument is true then we should see the CPU is being used 100% or at least 50% (when we do the performance monitor). When we run these jobs simultaneously, we don't find any bott...

Hello, We are having a problem; we developed DS Server jobs for our DW. While sequencing we decided to run 5 server jobs at the same time. If we do that the jobs are running VERY SLOW. If we run them as standalone they run fast. The concerns I have here is When I run all the 5 jobs the jobs slows do...

Hello, We are getting the same error on a Win 2003 Server. RLTABSZ = 75 GLTABSZ = 75 MAXRLOCK = 74 UVSYNC - 0 Is there any patch for this? All these jobs are very very simple ones and it shouldn't take any resource. I am not sure what is causing this issue. DS Version is 7.5x2 (Server Job Sequence) ...

I am facing the same problem with Win 2003 and 7.5x2, any Idea how you guys fixed this? Any DS fix is available for this?