DSXchange

Hi All, In my view this problem is occuring because the connection you are having with Oracle is getting timed out due inactivity. So, in order to get rid of this problem you have to get in touch with your DBA and increase the time-out time for your user name. I was facing a problem like this with S...

Hi All, Congrats and Thanks for all the guidance that everyone on this website is providing others. Thanks a lot to the Great Gurus of DataStage for all the help that they have extended. We have learned a lot and we are going to learn a lot from this master piece. All of you have been really helpful...

Hi Kumar,

Thanks a lots for the guidance.

Hi Ray/Kumar, Thanks a lot for the quick reply. I got the answer. Now i have one more doubt. In the OCI stage what is the purpose of the Derivation column.I went to the columns tab and loaded the columns of a table, after that i decided to load columns of some other table which is having the same st...

Hi Everyone, I am using an OCI stage to read some data from Oracle 10g table. In the SQL i am selecting the 'Column Generated SQL query' option and trying to select a date field from the source table.Everything is working fine but the problem is that in the generated SQL it is using TO_CHAR function...

Hi Ray, Thanks a lot for the quick reply. In a few jobs we are processing the data sequentially but in most of the jobs that we have we are using the parallelism only. But the problem is that when we try to run a no of jobs parallely(sometimes a single job also) in a sequence then we get a no of har...

Hi Everyone, In my current project we are moving 20GB of data from the source to the target. While processing this data sometimes we are blowing up the records to form new records. So, while processing the data that is moving through the system can go up to 60 GB. As the business requirement most of...

Hi Ray/Kumar, This is a lovely piece of information. Thanks a lot for providing insite into this topic. I am really thankful to you for this. But i still have a few questions like this. If youi find some free time then please help me by giving some inputs on these.The question is: 1. How the transfo...

Hi Ray, I did search the forum.But the problem is that no solution or probable reason has been provided for this thing. If this is a resource problem then for sure i can raise my concern about the same and i can request for more hardware resources. But none of the posts is saying this thing clearly....

HI Ray, Sorry for keeping you busy.But,I wanted to check can i delete all the entries in the /opt/Ascential/DataStage/Datasets folder also,Because when i am checking this folder,its having huge amount of entries.This folder is being used to holding the Datasets. Please provide your valuabel views on...

Hi Ray,

Thanks alot for the help. I will be getting this thing done.

Thanks a again for all the help.

Hi Everyone, In one of my job i am facing "Scrtach Space Full" Problem. After going through all the posts that are presetn on the forum i came to know that my scratch spcae is almost full. I am having 4 processors on my server and my config files looks something like this: { node "nod...

Hi,

This problem is not related to a particular job.Its like this sometime a job will fail with this error and sometimes some other job will fail with this error and sometimes the sequencer will run fine without any issues. So, there is no problem with the config file as such.

Thanks for your help,

Hi Everyone, I am facing the ghost of SIGKILL in my jobs.I am calling thsi a ghost because after going through the posts in here i came to know that we don't have any particular reason and solution for this problem. I am posting the log of the job in here.The log for the job goes like this : Occurre...

Hi Ray, I have checked the log of the job. I am running my job with a UserId 'sidhartb' but in the job log i am getting LOGIN as 'dsadm' FOr my id the ulimit has been set as unlimited but for the dsadm id i think its not the same.I am posting the environment variables from the job log. Please have a...