DSXchange

Hi All I tried in many ways to optimize the performance in DataStage for loading the 10M rows we are getting now. I was not able to achieve any improevement after a point of time. So, I have switched all my process to SQLLOADER. I was able to apply all the Trims and NULL conditions without any probl...

Hi all we have got this issue fixed :roll: .. at last !!!! After denying for 3 weeks :x and making life horrible to me and my Admin, the help desk finally gave us a new license which went through successfully Out come .. we both have become proficient in downgrading itanium 11.31 servers to 11.23 .....

Ray i got it checked again and the people who gave the dump insist that the license keys are correct. Chulett - We checked it like hundred times to make sure we gave a correct entry One more think i would like to know is DS 7.5.2 compatible with HP-UX 11.31? I am trying to google for the information...

Thanks ray

I checked for that as well and all the 11 characters are entered properly.
What amazes me is the CPU count is given as 999 .. is it possibel we have such a number for CPU count?

Thanks again

Hi all We are trying to install 7.5 EE on HP-UX 11.31 server. the dump is available in the same server. We are running into the below error no matter how many times we re-enter the authorization codes. Error: Server authorization failed or Enterprise Edition authorization failed We have checked the ...

yes .. I hit STOP on the director ..

or you can try this

go to Director > Job > Cleanup resources

and kill the Process id related to your job

The jobs sometimes do not stop as the resources are more busy waiting for some other response, may be for a response from the database ..am myself waiting for a process to be force aborted .. still waiting

Sainath wants you to go to the DSEngine folder and see if the dsenv file is existing or not .. i have pasted the steps from MY environment (Folder names and path will vary) . Try doing it along the same lines dsstg@omzpnr1:/dsstg/data/src [1157] $ cd /dsstg/Ascential/DataStage/DSEngine dsstg@omzpnr1...

You can also call a UNIX script after job 3 is completed. Depending on the output from the script you can trigger the required stream of jobs.

Chulett - I have never tried the "nested condition", and i will make sure to give it a try

Thanks
Srividya

will you be able to give a more specific screen shot of data than what you have already given? That would help us understand how the feed would look like

May be the data is record type driven, say the first 3 places are 001 then it is for one kind of data , if it is for 008 it is another set of data

It will be a challenge to read such a HUGE set of data in a single column. the max size i have seen is I have done more research on the job, and observed that the SORT stage was taking exceptionally long time, i did HASH partition on the Sort keys, and the job performance has improved drastically, i...

yes, it is a simple Truncate table statement. Have a call with the DBA tomorrow morning. Probable i will have more information after the call :D how much ever i get work on this table, i will need to re-design the data flow. Bad design :evil: ... took over the code couple of days back and it looks m...

Hi Chullet

It took approximately 30 mins , to give me the message that the Before subroutine has been implemented

I have just got the table analysed and raised a request for manual extension, hopefully, it will improve the performance.

I agree on that Chulett, the Tables are in good shape, perfectly indexed, manually extended with more storage space, no other processes are running on the server as of now. However, there is one interesting thing i have noticed, in the before sub-routine, there is a script which is being called to t...