Search found 30 matches
- Thu Mar 05, 2009 5:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with Multiple Instance
- Replies: 10
- Views: 4625
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 ...
- Thu Mar 05, 2009 3:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with Multiple Instance
- Replies: 10
- Views: 4625
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...
- Sun Mar 01, 2009 8:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence Taking Longer time to Completion
- Replies: 3
- Views: 2273
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...
- Sun Mar 01, 2009 3:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence Taking Longer time to Completion
- Replies: 3
- Views: 2273
Sequence Taking Longer time to Completion
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 ...
- Tue Feb 17, 2009 12:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error
- Replies: 6
- Views: 3348
- Mon Feb 16, 2009 6:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error
- Replies: 6
- Views: 3348
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 = ...
- Mon Feb 16, 2009 6:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error
- Replies: 6
- Views: 3348
Phantom Error
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...
- Mon Feb 16, 2009 3:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Regarding UVSH Processes
- Replies: 1
- Views: 1719
Regarding UVSH Processes
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 ...
- Mon Feb 16, 2009 1:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while using ODBC in DRS stage
- Replies: 7
- Views: 3076
- Mon Feb 16, 2009 11:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while using ODBC in DRS stage
- Replies: 7
- Views: 3076
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...
- Mon Feb 16, 2009 10:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while using ODBC in DRS stage
- Replies: 7
- Views: 3076
- Mon Feb 16, 2009 9:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while using ODBC in DRS stage
- Replies: 7
- Views: 3076
Error while using ODBC in DRS stage
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 ...
- Sun Feb 15, 2009 5:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with Multiple Instance
- Replies: 10
- Views: 4625
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...
- Sun Feb 15, 2009 4:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with Multiple Instance
- Replies: 10
- Views: 4625
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...
- Sun Feb 15, 2009 1:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with Multiple Instance
- Replies: 10
- Views: 4625
Performance Issue with Multiple Instance
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...