DSXchange

Is there anyway where we can find out the list of DS jobs that have been modified viz. in the last 1 week? Iam assuming this information is kept by DS Engine somewhere in the Universe DB

Cheers
Kris

Hi Chulett, Please kindly advise in the light of the new details i have provided. Only those files which i have mentioned has got deleted and is it ok if i restore the same from Test which is exactly having the same datastage version and DS jobs. Thanks KN Yikes. What is left in $DSHOME, anything? R...

Hi Rajesh, Thanks for the reply. The directory has not got deleted. The below files got removed from &COMO& and &HOLD& directories. ./DataStage/XXXXXXX/&COMO&/.Type1 ./DataStage/XXXXXXX/&COMO&/.uvnlsmap ./DataStage/XXXXXXX/&COMO&/INSTALL ./DataStage/XXXXXXX/&a...

All, We are in dire straits as following files got accidentally removed from ETL server inside project directory eg $HOME/DataStage/MY_PROJ_DIR -------------------------------------------------------------------------------- ./DataStage rm: ./DataStage is a directory ./DataStage/XXXXXXX/&COMO&am...

Is it project specific issue, do some projects work and not others? Maybe the internal STATUS files are messed up, you could try re-importing all of the Sequence jobs and recompiling. Thanks Kenneth for your suggestion. Its not a project specific issue as this is happening to all the projects which...

Dear All, I'am facing a strange problem with datstage Server. Our prod box was recently migrated from one location to another and it was basically a lift and shift thing. We have had to change the authentication mode for DataStage as part of the migration(PAM) and user and group set-ups have been mi...

Since the Operating System is a virtual machine layer between the application and the hardware, it is more appropriate to ignore the actual hardware and concentrate on the OS. If you are staying in the UNIX world or even staying within the HP-UX implementation then the steps you have illustrated ar...

Thanks Guru and Ray for your replies. < I write parameter values to sequential files for another job to use as a parameter value. We run our jobs as scripts. The parameter values are stored in a directory below the project called JobParams. So if you want to know the last extract date in the fact ta...

Hello All, I want to pass some values getting calculated in JOB A and want to export to the environment so that many other jobs down the line can use it. One way this can be done is to write to a dataset/sequential file and then use it as lookup or use execsh to cat the contents & pass it on to ...

Hello All, What things need to be taken care of if one wants to migrate Datastage jobs(say 1000) from one platfrom to another ,for eg from PA -RISC to Itanium. Is it as simple as exporting all the jobs and then import it and recompile it on the new architecture. Is datastage compatible with 64 bit a...

This is the ideal scenario to go for Unix tools like AWK scripting.
This can be easily done in awk.

Hello All, I was reading an internal FAQ related to DS and there its mentioned that DS job compiled on one server won't run on another server. You have to import it and then compile it on the new server. But as far as i know since DS jobs on compilation generates Orchestrate script that script shoul...

Very True Ray ! I tried a round about way when the thing was already taken care of in a simple effective way. Thanks :wink: The Sequential File stage, when asked to read multiple files with identical schema, actually generates a File Set control file to manage the same. You can see this by dumping t...

I was looking at contents of file set. Since usage of fileset is to distribute large file across nodes so I think we can utilise this by writing a small script which will create a file set (since its in ascii unlike dataset) by fetching all the files from the required directory and writing to the fi...

Oh,Yes!! Its working fine now. Thanks Kumar :D

kumar_s wrote:Provide the full path where the script resides.