DSXchange

OOPS...

i got an error

"DataStage/SQL: Table "DS.AUDIT" does not exist."

What can be done on it?

how can i see the content of this DS.AUDIT table?

Is there a way i can query that

I got a problem. Today when I logged in to my development enviorment, I could see many of the jobs are got deleted. Is there a way to find out / Trace how that happend, why that happend? Who has did that? Is there any place Datastage keep track of these things? Any suggestion will be of great help. ...

great


let me try this tomorrow and i promise my result will be posted here

but where should i specify the job name in that command.

if i run it will it clear all the logs of all the jobs ?

I have gone through some posts and many places i found, I should clear the job log. but bit confused by your reply 'Clear/repair hashed log files'. can you clarify this point to me or you can give me link to any post where it is addressed. sorry for bothering u as i have to do it in production envio...

I have ran a job which produced so many logs. and currently when i view the log from directory i am getting an error. Error selecting from log file RT_LOG34 Command was: SSELECT RT_LOG34 WITH @ID LIKE '1N0N' COUNT.SUP Error was: Read operation failure. Internal file corruption detected. File must be...

I would like to share that the merging of two files i done through join command in unix. I called the join command from the before job subroutine. It helped me to merge 27 million records in less than 5 minutes. Here is the full solution. Its a sample. FILEA.TXT ------------- D,1 E,1 FILEB.TXT -----...

Thanks for all the inputs...

Awesome

yep..

i well aware of hash files, but the thing is that my data size is more than 2 gb. So i am not able to store in hash.

anyways, from your input i understood, i should not use it anyways.

thanks.

i will lookout for some other options.

I have a following scenario which I would like to get an expert openion before spending time on it. Please provide osme help in this regard Q1 . Can I use the universe database provided by the Datastage for my local calculation and some storage to ease the joins? Q2. Is there any storage limit for t...

u know what.....

My problem resolved.....

I modified the sort according to the aggragation and i assorted the sort in the aggragator stage......


a 1000000000000000000000 thanks for your help

I am in trouble....... Ok. It might solve the sort by filter command. The issue is when it reach aggragator stage, my record count is close to 6 million. The aggragator stage is terminating abnormally. The chances are that, I may need to push more than 10 billion to aggragator stage. So it is defnit...

u mean filter command is unix command to sort......

is that rt?

what should be the command i should give in the filter command text box.

i have 3 columns Col A, ColB and ColC. I would like to sort col A as asc and colB as dsc

yep.... m in kind of hell
anyway...i will redesign my logic in merging......

thanks for all inputs and i am marking the thread as resolved