DSXchange

One suggestion:

Run a before job routine that does a "head -200 #inpufile# > #outputfile#"

Read the output file in the main stream.

Contact Ascential Support and inform them of this problem. There has been several patches and fixes for this stage throughout EE 7.x, and you may have to upgrade to take advantage of these bottlenecks.

You can always append a target file with more data, just not at the same time.

The framework actually insert in partitioning tasks where it is necessary/set by default. Read the online help for each stage, and use $APT_DUMP_SCORE to oserve this behavior. The information shared is a bit hard to read, though.

Is that the sound of your fingers creaking, Ray?

Bear in mind -- "scratchdisk" (as seen in your configuration file) is totally separate from "disk" -- Datasets disks, which are used exclusively for... Datasets!

Behind the scene, when DataStage compile a transformer stage, they actually use your specified C++ compiler. /opt/SUNWspro/bin/CC -KPIC -O -I/opt/dsadm/Ascential/DataStage/PXEngine/include -dalign -O -PIC -library=iostream -c If your paths are wrong, then your compiler simply will not work, and ther...

Oracle_Enterprise_8: Access to sys.dba_extents required but not available. Please see your dba for select privileges Do exactly what it suggested. Go to your DBA. Tell them, "HEY! Stop restricting my account so tightly, and let me have access to sys.dba_* tables. Kthxbaibai." DataStage PX...

Yes, you can use the job's parameters within the buildop. Think of the buildop as a function call. You need to set up the stage parameters on the buildop stage to obtain values from those job parameters. See the following pages on the Parallel Job Guide (my copy is 7.0.1, so your may be different) -...

Did you attempt to run a very simple 1 column file using the FTP stage with source from the same location? Have you been able to FTP to it directly from the DataStage server successfully? (i.e. use the right paths, using the same username, and so on forth?) Have you ever been successful using a diff...

Are you using DB2? If so, there is a known issue with DB2 libraries using the same name as your DataStage's libraries. In setting up your paths, make sure that your DataStage paths comes FIRST before anything else. Especially in "bin/dsenv". Bounce the server, and see if this problem conti...

You also can use the Adminstrator's option to limit number/days of job runs, and allow DataStage to automatically purge old log files for you every time you run a job.

You will get an informative message that you can safely ignore.

This is yet another perfect example of why it is important to remember: No matter what we use, it must be PRECISE. If you want a flexible rule-based comparison, check out QualityStage. DataStage is superior when it is dealing with precise data comparison. Leading/trailing spaces, extra whitespaces, ...

It really depends on what you are looking for. Are there any specific situation you wish to find answers for? We could easily answer those type of questions for you. For general purposes, you are welcome to read the DataStage Parallel Job Guide PDF file which comes with your installation of DataStage.

Wooooooooooookay.

*chuckles* And I thought it was a nice way to say, "upgrade! Avoid the evil feds!"

Be careful. Configurating the db2nodes.cfg will take effect across the entire server. Standard practice is to include $APT_CONFIG_FILE parameter on every job to allow for granularity in controlling number of nodes. One job flow may work best for 4 nodes with 2 DB2 nodes. Another job flow may not eve...

Hi All, I am facing a strange error, which is aborting my jobs. The log file shows "Parallel job reports failure (code Internal error - missing script file RT_SC35/OshExecuter.sh)" I am running few jobs in sequence and sometimes this error occurs and job aborts. If you rerun the job again...