DSXchange

Are you perhaps trying to write to the same sequential file from two stages in the same job? This is not permitted (by the operating system) and will result in a fatal error with the message you received.

OK, then. You are going to need some means for getting at your MS Access data from UNIX. An ODBC-ODBC bridge is certainly a mechanism worth investigating. Otherwise you can dump the contents of the MS Access table or query in a text format (for example comma-delimited or tab-delimited), get that to ...

Get the jobs out of the text file and into a job sequence where you can directly connect triggers to Notification and other activities. Otherwise put a lot more work into your text file (shell script) to detect the exit status of jobs and log/notify those results. Or create a job or routine to scan ...

Does the command you gave as the telnet command in the FTP stage work when issued independently? The trace gives no hint; it invoked the tnet_exec() function to execute the command, but this did not complete successfully. It appears that your diagnosis must concentrate upon the command itself and wh...

Consider using Sort as the aggregation method rather than Hash Table.

That would count me out some of the time. I am a self-employed consultant; there are times when I am not doing DataStage things.

Were there any failures (aborted jobs) that may have left the bitmap indexes in an unusuable state? Get your Oracle DBA to check and, perhaps, to repair them, then try again. Have the DBA trace what is happening, to try to capture what it is that is damaging the bitmap indexes.

Please note, however, that DataStage Version Control ceased to exist with version 8.0. So maybe taking exports of components and checking these into and out of CVS is a better long-term approach. There's nothing in 8.0 or 8.1. There "may" be a mechanism in 8.2 that permits DataStage to interact with...

Please describe your job more completely. In particular what is the data type of the lookup key, what is the data type of that column coming out of the Aggregator stage, and what happens to the column in the Aggregator stage (is it grouped or does it have an aggregate function applied to it)? Mentio...

Even more pedantically, the account name that you give must exist as an entry in a system table called UV.ACCOUNT. This is a hangover from the days when DataStage was a UniVerse application; the UniVerse name for schema is "account". (That's a simplification, but will serve to explain the overlap in...

It is certainly possible; you have proven that by succeeding in starting the RPC daemon.

When you attempt to connect, do you specify the new port number as part of the address? For example, hostname:31568 or xxx.xxx.xxx.xxx:31568 ?

If you have DataStage Enterprise edition, import Oracle table definitions using Orchestrate (orchdbutil). It imports the data types more accurately than does the OCI stage, particularly decimal data types.

Or you could upgrade to version 8.0 and get range lookup capability in the Lookup stage.

Version 8.0 for UNIX will be GA "any day now".

And it's not just indexes. A DataStage project is a schema, and there are system table entries that need to be made/corrected also.

Roach Motel is a great name in this context, and a weird memory.