DSXchange

ray.wurlod wrote:What is the NFILE setting in your kernel? It is this value, not the ulimit value, that drives the maximum legal value of MFILES.

How would i get the NFILE setting......any command???or location where i can look at??

My values in the uvconfig and the values what smat -a will show were not matching, so i recycled the datastage server and regenerated the file. But when i restart the server, it says Warning: could not open MFILES +8 files. The value of the MFILES should be at most 8 less than the kernal per user fi...

We are using the DB2 7.0, oracle 9i, sequential files, CFF files as the source. We are not upgrading them. Regarding the JObs, all are in production. The count might be around 2000 jobs. We are getting a dedicated server for doing the POC. Does solaris 5.8 support DataStage 7.5??? We do have Basic r...

We are maintaining around 10 projects in DataStage 6.01. One of the projects is using parallel extender. We are planning for upgradation of the DataStage from 6.01 to 7.5. Our current OS is Solaris 5.8. I would like to know the points of concerns when we are doing such migration? I hope some of you ...

So , if you change the UVConfig and not regenerate the file , does it still use the default values or does it use the changed values

I would like to know the command smat -t, the data shown by this command is from where ??? is it from uvConfig file or from executable.
The content in the UVConfig and the content displayed by the SMAT -t command are different for me?????

Hi What is the order of execution of Upsert strategy ( Update and Insert / Insert and Update) I have implemented the UPSERT strategy for the Dimension load. Iam using a oracle sequence as the surrogate key. In the Target stage i have specified seq.nextval for the surrogate key First Run: Source Rec...

Hi all,

This is regarding datastage basic concepts e-classroom.If anybody have any idea how good this CD-BSDS course is for datastage concepts please let me know

Thank you

bobby wrote:this command give me whole body of excel file i want attachment
$mail bobby@express.com</datastage01/nin/Act_Sub.csv

cat /datastage01/nin/Act_Sub.csv >> /tmp/email.msg
mailx -s "$SUBJECT" -c $CCADDRESS $TOADDRESS < /tmp/email.msg

Hi, I'm having very strange situation. The job status in Datastage Director indicatd the job is still running, but when I asked Datastage Administrator, he told me he did not see anything running at all. I tried to stop the job, it does not work, and Clear Status File Menu is grayed out. When I use...

hi i did this ,its not working i went to EXECSH and in input i wrote $mail bobby@express.com</datastage01/nin/Act_Sub.csv thanks bobby mailx -s "ur subject" -c 'any CC address' 'TO address' < /tmp/email.msg Use the above command. The last part is the path of the file you want to attach an...

Sainath.Srinivasan wrote:You need to use sendmail routine.

SendMail routine will not handle the Attachment. So, use the shell script to do that.

Hi, I want to send that file so u mean routine activity i should use , can u advise wht routine name as i have not seen any mail in there thanks bobby if you want to send the file as an attachement, call the shell script from the routine activity or from after subroutine. In the shellscript write t...

Hi, I want to send that file so u mean routine activity i should use , can u advise wht routine name as i have not seen any mail in there thanks bobby if you want to send the file as an attachement, call the shell script from the routine activity or from after subroutine. In the shellscript write t...

hi, i have an execl file which i load then i send to client for test data , can i automate that as soon as the job complete it automtically get emailed to them , i mean any automatic process i can do. thanks bobby Once the job for load is complete you can use the after routine to execute a shell sc...