DSXchange

Do a ps -ef | grep ds and there they are or as people said in Administrator command do a LIST.READU EVERY

Do not stop the Engine....Do not kill Unix processes....refer to topics here "how to unlock" and your answer will set you free....you can unlock via dssh or via Administrator command.....anyway its well documeted here...

Well nothing special except do not keep all versions over time. If you do not delete versions then the Project gets extemely large. For example, exporting or upgrading to new versions impacts Projects and an average Project to do these tasks takes about 5 to 10 minutes whereas a large Version Projec...

You can use a Sequencer Routine Activity Stage and call the Stored Procedure from there as another option. You can also write Job Control.

YES no problem, to me a non-root install simply means needing to run post install scripts to make it look like root such as setting impersonation mode.

I like root install with dsadm as the acccount designated

YES

Just do a root installation and assign dsadm....there are no pros and cons...if you do a non-root then you have post install scripts to run such as setting impersonation mode and so on....just do root....non root has no value....

Just to summarize here because the answer was said in several ways. If your running the Job via your Director Client then "no limits" is fine....If your running the Job via dsjob the the "no limits" won;t work because "no limits" is stored on a developers individual Cli...

Thanks a bunch

In the Universe Stage I know I can write some SQL type code. I'm doing something silly when trying to execute a substring function as follows: SUBSTR(FULL.TEXT,1,254).....I even tried @SUBSTR(FULL.TEXT,1,254) but still no go.... The error I get is "call to SQLFetach failed.....row length exceed...

The server you have DataStage installed....what is the name of the SMTP server this server points to? The SMTP appears not to be on the DataStage server so find out the name and point it to there....

Hmmm....your IP Address is "UK01WRS6004"? This doesn't look right?

Well your entry in the Project uvodbc.config of MERCURY looks fine....Now yes you need a entry in the .odbc.ini file within $DSHOME....Did you name the entry in .odbc.ini MERCURY? At the beginning of this file are examples of the data direct drivers so I presume you selected the right one....and it ...

When I try to log into the PS client I get "Message switch is unavailable - please start the message switch service to allow analysis to be perform"....I need to know how to resolve this but feel I have tried the obvious....any ideas? OK, I believe I have done the obvious.... 1. The MGXPgm...

The person indicating the use of MetaStage is right on....This will allow you to perform an impactanalysis of where columns are used in what Projects and what Jobs. In addition if you use the specific MetaBrokers to your situation (e.g,, ERwin, Business Objects, Cognos, and so on) then you can know ...