DSXchange

Hi Seema, Thanks for the Reply. The only problem i have identified is calling of Individual jobs in sequence. Detail Description of Sequence: 1. Sequence has around 80 jobs with Multiple Instance property checked 2. Sequence when executed for 1 country taking 20 Min ( Specifies job execution is not ...

Hi, I have been monitoring the CPU utilization on server. when Interface sequence is running for multiple countries at same time, i could see CPU utilization is less than 10 percent. So i can say it is not problem with server handling the resources. Can anyone suggest performance tuning steps like d...

Hi Chulett, Thanks for the reply. As this is production box, we need to raise ticket for removing the virus scanning. Can you please tell whether excluding the virus scanning on Datastage process generated (uvsh.exe) will do or do we need to remove scanning completlyon Datastage Installation directo...

Hi, We have Single Set of Interface Jobs around 100 jobs in a sequence. When run for each country Individually it is taking only 20 min to Completion of Entire sequence. But when we are scheduling 2 or 3 countries it is taking 6-8 hours for completion. Observations while running 3 countries at same ...

Hi,

Any Updates on why we get Access Violiation errors like this? I need to fiX this ASAP

Hi Chulett, Find the log asked by you. I had Highlighted the 105 line in Red color. Can you plese suggest me why these errors occur frequently? WHILE NOT(ERROR) * Primary Key derivation code for pin DSLink5 STAGECOM.PINNO = 2 IF STAGECOM.TRACE.STATS THEN CALL $PERF.BEGIN(-2) Pin%%V0S0P4.Column%%4 = ...

Hi, While running the job iam getting the Phatom error message and job is aborting. I am getting this message very frequently while running different jobs. Sometimes job is running and sometimes it is giving this error message. Any Idea on this? Error Message:- DataStage Job 302 Phantom 12284 Progra...

Hi, When I am Executing an Interface Sequence, In the datastage Server task manager i could see lot number of UVSH processes getting created. If the sequence is getting aborted, the UVSH process are not getting cleared from the task manager. Can anyone please tell when UVSH process are generated in ...

Hi,

While running the job I am ensuring that I select No Limit parameter for Warnings.

In my case if I switch from ODBC to Oracle Using the same DRS stage will there be any implications. I guess that is only way i can go with minimum changes preventing the job from getting aborted.

Hi Chulett, I agree with what you had said. But because of this why job is getting aborted. Warnings should not abort the job right? In All the places as common practice we are using ODBC. For making the changes mentioned by you, as the code is already in production, I need to go with minimum change...

Hi Chulett, The warning message received was "..Transformer_0: SQLExecute: No row was found for UPDATE", "'..Transformer_0: At row 19, link "DSLink4" Row rejected.' It was basically an update job, When using ODBC in DRS stage after some warning messages the job is getting ab...

Hi, Datastage Server Details: OS: Windows server 2003 Database: Oracle10g System DSN Created:- Driver Used: Oracle in Oraclient10g_home1 Issue:- Job had DRS stage uisng ODBC as output. Job is getting aborted on warning messages without any Fatal Errors. When same job is executed using Oracle in DRS ...

Hi, Previously we had 15 different projects for 15 countries in production. At that point of time, we used to Schedule all the 15 countries at same time. we Faced no such issues with the Interface run. But due to maintanace problems we are asked to move to single datastage project for all 15 countri...

Hi ray, Thanks for Replying. Let me put you simple. When I am running the Interface for Single Country, it is taking 20 Mins. If I am running the same for 15 countries, It is taking 7-8 Hrs for Completion for each country. In the sequence i had checked timings of all Individual jobs. But all jobs ar...

Hi, We had an single Interface code in production scheduled to run for Multiple Countries at the Same time. When scheduled at same time, the interface sequence is taking much more time than the normal Execution time. After Intial analysis some problem areas were identified. I could see that in a seq...