DSXchange

Also In which guide is uvsh discussed in detail? regarding its abilities, syntaxes and features etc......

Thank you. Now i am able to launch uvsh from $DSHOME but i am could any one help me with what is next step to run the uv query.

do i need to log on to the project after issuing uvsh? if yes how? or do i need to log on to the project before issuing uvsh?

Thanks for that..... But i am aware of this stuff.... I was asking about the underlying reason and not the explanation of what multi instance jobs are. Why normal jobs run only in a single instance and muti instance jobs can be invoked simultaniously, is there any architectural difference between th...

What is the underlying difference between the two kind of jobs and what feature when added to the jobs makes it capable of running in different instances.

Thank you.

Yes I guess you are speaking about the dsjob -lognewest and dsjob -logdetail...... But here the requirement is to fetch all WARNIGS for the last run , this can be impelented by fetching the newest log event before and after the job run and then using the dsjob -logdetail to fetch all entries lying b...

I need to fetch entries from the Job Log where the Warnings matches a pattern for the latest run, can anyone share the name of the Job Log file (I tried using DS_JOBLOGS, it didnt work) My plan is to fetch the records from the file using UV query with filter conditions on Event Number, Event Type an...

And One more question,

How to retreive only the last run log events, is there any built in funtionality?

Is it possible to fetch the Log events with one event in one line rather than all concatenated onto one line?

Thank you ..... I have one more query here.... I was trying to insert a warning into the log using call DSLogWarn ("[IBM][CLI Driver][DB2/AIX64] SQL1476N The current transaction was rolled back because of error -964. SQLSTATE=40506","MyRoutine") but i am facing problem while inse...

Can anyone help me with fetching all entries of job log from unix. I need to grep for a particular entry from the log.

Thanks

I guess both kind of routines use the same BASIC code (Please correct if wrong), then why is it so that a server routine cannot be used in Parallel job and vice versa

Thank you.

oooops............ was checking that in the development environment not sure why i did not get the error you mentioned. In other environment i am facing this $ uvsh This directory is not set up for DataStage. Would you like to set it up (Y/N)? so could you please share how to run the above UV query ...

could you please mention which document of datastage discusses tsort.....

I didnot find anything mentioned in the DS parallel job developer guide saying the sort stage inserts a tsort operator.

My concern is only sorting the data, no other options required

While i am using the look up stage, I have observed that files are being created..... As per my knowledge (Please correct if wrong), the look up stage operated in Primary memory (RAM) then why are the files created in the scratch disk, is it because the data is too large to be placed in the RAM ? Th...

I am joining two datasets using the join stage, to sort the incoming data which of the two is best:

1) In link sort
2) using 2 sort stages explicitly on both links

It would be of great help if the reason is specified.

Thanks..........