Updates Running Very Slow
Posted: Thu May 06, 2010 4:01 pm
I have a job which will do the updates to a database table .The job design is as follows :
Sequential file -------> oracle enterprise ( update only mode ) .
Please check the log below
Can someone help me in resolving the same ?
Thanks
Sequential file -------> oracle enterprise ( update only mode ) .
Please check the log below
Here if we observe the log there is a lot of delay between "3:25:13" and "3:46:43" . Can anyone has any idea what exactly datastage is doing during that time ? Its taking lot of time to read the sequential file .Previous it was running very fast .At datastage job level nothing has changed .
Occurred: 3:25:11 PM On date: 5/4/2010 Type: Control
Event: Starting Job jobname. (...)
Occurred: 3:25:12 PM On date: 5/4/2010 Type: Info
Event: Environment variable settings: (...)
Occurred: 3:25:12 PM On date: 5/4/2010 Type: Info
Event: Parallel job initiated
Occurred: 3:25:12 PM On date: 5/4/2010 Type: Info
Event: OSH script (...)
Occurred: 3:25:13 PM On date: 5/4/2010 Type: Info
Event: main_program: IBM WebSphere DataStage Enterprise Edition 8.0.1.5272 (...)
Occurred: 3:25:13 PM On date: 5/4/2010 Type: Info
Event: main_program: conductor uname: -s=AIX; -r=3; -v=5; -n=pedwbt01; -m=00C1C3A04C00
Occurred: 3:25:13 PM On date: 5/4/2010 Type: Info
Event: main_program: orchgeneral: loaded (...)
Occurred: 3:46:43 PM On date: 5/4/2010 Type: Info
Event: main_program: APT configuration file: /opt/IBM/InformationServer/Server/Configurations/configiguration6x6_prod_ods.apt (...)
Occurred: 4:02:19 PM On date: 5/4/2010 Type: Info
Event: SEQF_Load_Updates,0: Progress: 10 percent.
Occurred: 4:14:31 PM On date: 5/4/2010 Type: Info
Event: SEQF_Load_Updates,0: Progress: 20 percent.
Can someone help me in resolving the same ?
Thanks