DSXchange

Maybe Dennis needs to get a new generation of younger hamsters to run in the treadmill.

What were the error messages in the job log? It may simply be that the job aborted before any rows were emitted by the Sort stage or Join stage.

qt_ky wrote:I saw a few php database error pages

That can happen if you try to connect at the time that they're backing up the database.

Perhaps you could supply the password as a job parameter, and have the value of the job parameter itself begin and end with "#" characters.

You need to have the firewall configured so that the particular ports needed for Information Server processes are left open.

It'd certainly be easier. That's what "shared" registry means - both IIS and the OS are using the same user registry.

Try changing the character set at the top of the DSX file to the same that your Windows system uses then attempt the import again.

You may also need to convert the UNIX linefeeds to Windows line terminators using a utility such as unix2dos.

It's not just you. Over a minute per page load.

When entering the password replace each "#" with "__035__".

PATH in particular, as specified in the error message itself.

I think the CSV extract processed by DataStage would offer the best performance, and invoking Maximo via its web service the worst.

Do you mean "dropped" the XMETALOCKINFO table, or "deleted (all records from)" the XMETALOCKINFO table? If the former, a whole lot of things are about to stop working for you. For the rest, let's wait till you've reported whether RT_CONFIG205 exists. You might also tell us whethe...

For example, your tnsnames.ora entry might look like TRADES_APP.WORLD = (DESCRIPTION = (ENABLE_BROKEN = TRUE)(CONNECT_TIMEOUT = 3)(TRANSPORT_CONNECT_TIMEOUT = 2)(RETRY_COUNT = 3) (ADDRESS_LIST = (LOAD_BALANCE = ON)(FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = itgsing120-scan.trades)(PORT = 1521...

Basically you need to have the tnsnames.ora entry changed so that there is only one ADDRESS component in the ADDRESS_LIST. Most DBAs put each ADDRESS component on a separate line, so it should be a simple matter of commenting out all but one. Once the installation is complete, you can reinstate them...

Stick some echo commands into the script to see how far it actually gets.

For example, some variants of FTP do not allow the entry of the password to be subjected to redirection.