Thanks! for advice
The fetch query is very simple select * from a stg table and we have tested he query is super fast at source also in data stage there is no transformation dumping into tmp table. I will check the array size and try to play around with that.
Search found 39 matches
- Sat Oct 11, 2014 8:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data PUll is slow in Datastage 7.5
- Replies: 4
- Views: 5240
- Fri Oct 10, 2014 11:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data PUll is slow in Datastage 7.5
- Replies: 4
- Views: 5240
Data PUll is slow in Datastage 7.5
Hi,
I am using datastage 7.5 server jobs. The stage used to get data from oracle system is ODBC and data pull is very slow there is no network issue something in datastage is slowing it down. Is there any parameter setting like increasing any buffer size that can help.
Thanks,
Vishal Gupta
I am using datastage 7.5 server jobs. The stage used to get data from oracle system is ODBC and data pull is very slow there is no network issue something in datastage is slowing it down. Is there any parameter setting like increasing any buffer size that can help.
Thanks,
Vishal Gupta
- Wed Feb 05, 2014 7:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job is successful even after oracle error
- Replies: 3
- Views: 3498
Job is successful even after oracle error
The strange thing is ds is shoeing it as warning, however it should be fatal error. I could not find anything in stage properties for this kinda settings.
- Wed Feb 05, 2014 4:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job is successful even after oracle error
- Replies: 3
- Views: 3498
Job is successful even after oracle error
Hi,
I see ORA-00904 as a warning in my server job, also the job completed successfully. This is strange, ideally the job should fail because of oracle error.
Thanks,
Vishal Gupta
I see ORA-00904 as a warning in my server job, also the job completed successfully. This is strange, ideally the job should fail because of oracle error.
Thanks,
Vishal Gupta
- Thu Dec 20, 2012 1:37 pm
- Forum: General
- Topic: Need to list the jobs using a same file(filename)
- Replies: 2
- Views: 2254
Need to list the jobs using a same file(filename)
Hi,
I have a situation. One of my job is writing data to a dataset, now i need to find all the jobs using the same file.
How to do that? Please help
Thanks,
Vishal Gupta
I have a situation. One of my job is writing data to a dataset, now i need to find all the jobs using the same file.
How to do that? Please help
Thanks,
Vishal Gupta
- Fri Dec 07, 2012 3:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Startup time is more than Prodcution Run time
- Replies: 10
- Views: 6730
- Fri Dec 07, 2012 2:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Startup time is more than Prodcution Run time
- Replies: 10
- Views: 6730
Startup time is more than Prodcution Run time
Hi,
In one of my job, i can see the following -
Message: main_program: Startup time, 1:39:42; production run time, 34:23
What may be the issue here? I am loading data in 3 tables (1.5 Million, 21 Million, 13 Million)
Thanks,
Vishal Gupta
In one of my job, i can see the following -
Message: main_program: Startup time, 1:39:42; production run time, 34:23
What may be the issue here? I am loading data in 3 tables (1.5 Million, 21 Million, 13 Million)
Thanks,
Vishal Gupta
- Mon Oct 22, 2012 9:19 am
- Forum: General
- Topic: dsjob -run error
- Replies: 10
- Views: 5281
- Mon Oct 22, 2012 8:58 am
- Forum: General
- Topic: dsjob -run error
- Replies: 10
- Views: 5281
- Sun Oct 21, 2012 8:25 pm
- Forum: General
- Topic: dsjob -run error
- Replies: 10
- Views: 5281
- Sun Oct 21, 2012 8:14 pm
- Forum: General
- Topic: dsjob -run error
- Replies: 10
- Views: 5281
dsjob -run error
Hi, I am running the following from a datastage sequence (because i don't have access on dsadm) - /opt/app/ibm/InformationServer/V87/Server/DSEngine/bin/dsjob -run -mode NORMAL -param -warn 0 -rows 0 -wait -jobstatus /opt/app/ivrr/shared/projects/xxx_dev1 JobNightly_SubSeq2 it fails with the followi...
- Fri Oct 12, 2012 2:15 pm
- Forum: General
- Topic: Executing Unix script in Execute stage of Sequence
- Replies: 1
- Views: 2001
Executing Unix script in Execute stage of Sequence
Hi, I am using the 'execute stage' of sequence and running a invoking a shell script in this. The script failed - xxxx_Trend..JobControl (@execute_send_mail_script): Executed: /opt/app/abc.sh "vg189d@xx,com" "11-OCT-2012" "04-aug-2012" "27-aug-2012" "20-S...
- Tue Aug 07, 2012 8:27 pm
- Forum: General
- Topic: I need to reformat string to date in job parameters
- Replies: 7
- Views: 4061
Thanks! All
Thanks! all .. it worked perfectly.
- Tue Aug 07, 2012 2:49 pm
- Forum: General
- Topic: I need to reformat string to date in job parameters
- Replies: 7
- Views: 4061
- Tue Aug 07, 2012 1:57 pm
- Forum: General
- Topic: I need to reformat string to date in job parameters
- Replies: 7
- Views: 4061
I need to reformat string to date in job parameters
Hi, I have a situation, where i need to convert the string to date in job parameters. I am passing the date in a job parameter as '01-Jan-2012' but the parameter is defined as string. I need to extract '20120101' from this parameter and use it in the file name. Can somebody help ? Thanks, Vishal Gupta