DSXchange

Ya, it would have been nice if they included an environment variable to have an auto purge of those files based on X amount of days of age.

Saves us all from writing CRON jobs to do it.

I would say it is best done in the most economical environment which still meets your SLA agreement with the end customer. If your Database is VERY busy servicing reports for your end users, every CPU second saved on that system is important, then do it in DataStage. Statistically your database will...

Like Ray said, to many variables. Quality of coder is also a huge factor. Volume of data, speed of your Database to provide your data back to you, sorts, data repartitioning, parallelism of your job... We code and try to replicate production volume of data in DEV and / or QA and estimate that way. O...

Well, I wish I would have known about that &PH& before doing the 8.1.2 Foundation Tools rollup patch. The patch process scans every single filename in each subdirectory in your projects path. ouch. It's just a good practice to follow as you don't want that space being chewed up for nothing. ...

I'm an admin in our environment, we've informed our customers that they should automatically extract their job logs via "dsjob -logdetails..." command and archive them outside of the DataStage server (as we protect our production environment quite a bit). They FTP the log to a file server ...

"They cannot read ..." where are you trying to read it from? Downstream database? Sequential file on your DataStage server? If you are doing a "View Data" then please make sure that your local character set for your client machine can display your chinese character set. You could...

Hi, I'd be interested in hereing from those of you (admins) who have set up WISD jobs on top of a GRID deployment. I'm setting up a new 8.5 environment and I want to make sure I'm not setting myself up for a redesign because of some assumptions. So rather than reinvent the wheel... could someone who...

Hello everyone.

I was wondering who else out there was using DataStage with Platform LSF as their Grid Resource Manager.

Thanks

What is the initial SQL statement and which stage are you using?

I think it's important to ask if you are currently running 8.0.1 or 8.1.

With 8.1 you can import DSX files on the server side via command line.
With 8.0.1 you are still stuck with Client side dsx file importing.