DSXchange

I am able stop and start the server wiith the following commands. (it asks for dsadm password) $DSHOME/bin/uv -admin -stop $DSHOME/bin/uv -admin -start I don't think it should ask you for password. Try to start the engine while loged in as root. We have similar problems as you (something missconfig...

Thanks!

My document version is: Version 7.5 June 2004 Part No. 00D-030DS705 There really isn't APT_ORACLE_PRESERVE_BLANKS anywhere in the document. I just need to let people know this, so they don't get desperate when they can't find something that everyone is talking about. Now some weird stuff. This optio...

Try to connect with sqlplus, but not from your PC. Instead use the unix sqlplus from your ETL machine where your DataStage is installed. You may want to examine the tnsnames.ora on the machine to see how the database name is stored there.

To see the files mentioned above go to the scratch directory. On my site it's location is "/asc/Ascential/DataStage/Scratch". It contains more than 40000 files. Maybe your destination table has a field named TIMESTAMP or some other word that is a keyword to sqlldr.

If you are selecting from Oracle, then I think I can help you...

ArndW says in one of his posts: please read the Parallel Job Advanced Programmer's Guide , page 6-25 for the specific information for the APT_ORACLE_PRESERVE_BLANKS information; I haven't found this in my version of the guide, but there is something similar called APT_ORACLE_LOAD_DELIMITED. Neverthe...

Thanks Ray.

If you do what previous posters said, the main sequence will start from subsequence #4. Also be sure for all job activities to have "Reset if required, then run", instead of just "Run"

I just hope my last post wasn't offensive. What could be the reason I don't get any replies?

Here it is: Details for DataStage Engine release 7.5.1.1 instance "ade" =============================================================================== Install history : Installed by root (admin:dsadm) on: Nov 11 2004 13:10:58 Instance tag : ade Engine status : Running w/active nls Engine ...

Nothing happens!
I thought maybe something was setup wrong with the dsadm rights, because I also cannot start and stop DataStage server engine if not root.(I can start it but clients couldn't connect)

Enable job administration in Director is checked. Cleanup resources dialog is always empty. It lists nothing, no matter if a job is hanginng, locked or running. Is this feature available only when you login as a root? I'm logged as dsadm.

I just installed Visio, and it doesn't pop-up any more.

After the fresh installation of DataStage client, when I start any of the programs from the package (Designer, Director etc.) I'm being prompted with Microsoft Office installer telling me to insert CD with Visio 2003. Is this normal? How do I get rid of this annoyance? Why does DataStage need Visio?