The job is not running when i extract data from oracle 10G

praburaj · Post by **praburaj** » Thu Apr 20, 2006 4:35 am

Hi all
I am using oracle 10G
In datastage i am connecting using Dynamic RDBMS
I am able to view the data from table.
But when i run the job it is not getting completed.
But the status shows running
The same i tried with server jobs its working fine
In server jobs native connection also working fine
Let me know how to solve this
regards
prabu

ray.wurlod · Post by **ray.wurlod** » Thu Apr 20, 2006 5:20 am

Is it a complex query? The same query is executed on every node - can your database handle identical copies of the same query without locking itself up?

kumar_s · Post by **kumar_s** » Thu Apr 20, 2006 6:09 am

What is the total volume of records.
View data will show you partial data. Is server and PX server residing in the same machine.
Try to run the job in sequential mode. Try to change the configuration file and make to on the node where server job runs.

praburaj · Post by **praburaj** » Fri Apr 21, 2006 3:59 am

Hi ray/kumar,

Thanks for the reply.I am just testing the connectivity.Records are very few(say 100).Its not a query. The config file i am using is only one node.Yes both server and px residing in the same machine.

Where can i find the dsenv in file windows.when i browsed the documentation its says to check the dsenv file. I used windows search option but i could not.

It works well with server jobs.It also handles million of data but only parallel jobs i am having this prob.any suggestions.

Regards,
Prabu.

kumar_s · Post by **kumar_s** » Fri Apr 21, 2006 4:06 am

Is both server and parallel edition runs on same OS?
dsenv is not for windows.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 21, 2006 2:51 pm

Does it work if you replace DRS with Oracle Enterprise stage? If so you've identified the culprit. Otherwise the next thing to explore is the for-Oracle environment variable settings. These can be set via Windows Control Panel (System applet), or as user-defined in the DataStage Administrator. There is no dsenv file for DataStage on Windows.