DSXchange

An idea. How about approaching Ascential for a deal where they top up a discounted rate for certified practitioners to access premium services? They could use discounted access to DSXChange as another incentive to get certified. Another idea. Can DSXChange be a site through which the certification e...

There's probably a need to announce on the front page that some Q&A may have been lost. I've certainly posted about 50 responses in the past two days.
Then again, Walter/David may have plans to roll forward. Who knows?

I always prefer to separate the DataStage component from the Red Brick component. This means that you can apportion blame accurately - is it DataStage or Red Brick? Disable automatic execution of rb_tmu in the Red Brick stage. Use ExecSH as an after-job subroutine to execute the TMU script instead, ...

Only the obvious ones. Get a faster ODBC driver. Make your SELECT statement as efficient as possible (for example index any constraining columns). The answer to your next question is no, I don't have any comparative statistics on ODBC drivers out there. Perhaps you could ask IBM about the fastest me...

Time to log a call with your support provider. The OCI stage is requesting just over 6KB of memory, and is hitting some per-process memory limit, but not the obvious ones reported by the ulimit command.

ORACLE_HOME ORACLE_LIB ORACLE_BIN ORACLE_SID perhaps The tnsnames.ora file should be at $ORACLE_HOME/network/admin/tnsnames.ora You should check this to see whether the service name for your putative connection is correctly defined, along with all of the associated information. Only the user oracle ...

The command is the same as you would use in a CMD shell - the full pathname if the BAT file's parent directory is not in your PATH, or just the BAT file name if it is.

It's how it is. There is NO package installer GUI if your server is UNIX.

DataStage Packages must be installed on the server machine. If your server is a Windows O/S, then there is a GUI, but if it's UNIX there isn't.

DSExecute is what you need - it is a subroutine that you must call from your own DataStage routines. The fourth argument captures the exit status of the BAT file. The "Batch" that you create in Director is NOT a Windows BAT file; instead it is a batch of DataStage jobs to be executed one after anoth...

Have you searched the forum? Search also for "hashed file", which is the more technically correct name. In short, a hashed file is a kind of table in which the location of a record is determined by applying an algorithm to the primary key value, rather than performing a table scan or index scan. Key...

Login to the UNIX machine as the user ID you use to run DataStage jobs (or su to this user ID), and execute the command ulimit -a before discussing with your UNIX administrator the requirement to increase the data, stack and memory settings for that user.

Are all your environment variables correctly set? TOAD runs its own startup script that makes sure that they are. If you're going to use sqlplus it's up to you to make sure. But this is irrelevant to solving the question that DataStage (as an Oracle client) gets this error. What's important is the a...

The out of the box Ascential installation is only able to perform 100 rows per second for most my jobs (simple loads too). Wrong. Create the following job. SeqFile -----> Transformer -----> SeqFile On the output link of the Transformer stage add @FALSE (system variable) as a constraint expression. ...

Could you connect using sqlplus from the DataStage server machine ? That you can connect from your client PC means that tnsnames.ora is OK on your PC. DataStage server is also an Oracle client, so there must be Oracle client software (including tnsnames.ora) on that machine too. Check that it is the...

What is your specification of the conditions under which a fictitious record is to be inserted? Do you have a full specification of the requirement? If so, please share that, too. If you don't understand the problem fully, and ask us to solve a portion of it, then the "help" may not end up being ver...