DSXchange

:? Depends on why it is being shutdown, I would think. The answer could range anywhere from 'nothing' to 'everything'. Backups of the engine and project directories, exports of all projects, supporting files (like scripts), landed data, etc etc - whatever you think you may ever have the slightest ne...

First issue is going to be your definition of what a "month" is. Were you given any business rules around how to compute your difference in months?

He means the same Data Set.

In the meantime, you've not involved your official support provider or were they not able to help? Also, did you run the commands it mentioned?

Nothing, really, pre-8. It's not like you would lose anything by shutting it down. Or are you asking about things you should archive before a permanent shutdown?

You didn't answer the 'version' question. I'd also be curious if this (Oracle connectivity) stopped working or has never worked.

Out of curiosity, why the proscription against sqlldr? Bulk loads are at their simplest when the target table is empty, ruling that out makes your work harder and the job run longer. The 'Load' option can handle the truncate and index rebuild parts automatically, plus give you access to the open/clo...

So, not DataStage TX as you've marked it?

Regardless, there should be an 'uninstall' script just like there was an 'install' script for the server. That should be pretty much it for a pre-8 installation.

Just an aside - the EE installs the MKS Toolkit on your Windows server so you do in fact have the ability to run a 'UNIX' script. FYI.

Or that of course, with 'sendmail' or 'mailx' or whatever you like.

Please mark this topic as Resolved using the button at the top of the screen!

Sure it has Before/After - in the OE stage they're the 'Open command' and 'Close command' options, respectively.

Nothing there is an 'error', simply informational. Show the mentioned 'sendmail_Mail.sh' to your Admins and see if they notice anything wrong in what it does based on your setup.

As noted, you can't. So either use the routine mentioned or perhaps send the details as an attachment.

Well... figured it must have something to do with 8.x over what I've seen (and see) in 7.x. Someone with more 8 experience would need to help, it seems, that or your official support provider.

Odd. What do they mean by 'the Dynamic SQL introduced in 7.5.3'? Only have 7.5.2 and 8.1 here.