DSXchange

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.

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

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.

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

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

How to check what is included in 'startup 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

If i run this from command line under dsadm .. do i still need to provide the credentials. I guess the credentials would be of dsadm?

I removed the path from the project name and run the following -
/opt/app/ibm/InformationServer/V87/Server/DSEngine/bin/dsjob -run -mode NORMAL -warn 0 -rows 0 xxx_dev1 JobNightly_Dynamic_Lookups

getting the following error -

Output from command ====>
ERROR: Failed to open project

if i don't include -param .. get the same 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...

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...

Thanks! all .. it worked perfectly.

Any idea which function to use for converting string to date in user activity stage? It be a great help

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