DSXchange

The ping utility tells you nothing more than that the server machine is visible on the network. In particular, it tells you nothing about software. Can you connect via telnet? If so, can you verify whether the dsrpcd process is running? ps -ef | grep dsrpcd | grep -v grep If dsrpcd is, in fact, runn...

... to which table you lack sufficient privileges for loading.

Only your Oracle DBA or the owner of the table can help - we can not.

Operator combination is an optimization whereby multiple adjacent parallel operators are caused to execute in the same process, provided certain conditions are met. Disable it either using the APT_DISABLE_COMBINATION environment variable or setting the combination setting in individual stages' Advan...

DataStage clients connect via port # 31538. Check that this port number is open through your firewall.

chulett wrote:ps. And how fast Toad is in returning the first few records is a fairly meaningless metric.

Craig, you ought to be more assertive. It's a totally meaningless metric.

It's almost certainly not the read from the Data Set that's slow. To prove this create a copy of the job but replace the Oracle Enterprise stage with a Copy stage or a Peek stage. Run that job to get an estimate of the true read speed of a Data Set. That means that the problem must be with upsert. T...

Did you mean to post this in the QualityStage forum?

The short answer is yes. You run the QualityStage jobs in parallel extended mode, via the Plug-In stage.

If you are on version 8.0, you have additional stages to directly run investigations, standardizations, matches and undups.

UnZip 5.50 of 17 February 2002, by Info-ZIP. Maintained by C. Spieler. Send bug reports to the authors at Zip-Bugs@lists.wku.edu; see README for details. Usage: unzip [-Z] [-opts[modifiers]] file[.zip] [list] [-x xlist] [-d exdir] Default action is to extract files in list, except those in xlist, t...

Look at the "job starting" event in the log - the first event in the log, to verify the job parameter settings that were used, and in the "environment variables" event in the log (usually about the fourth event) to verify what environment variable settings were actually used.

I agree that it's most unusual - this hashed file is typically only written to when new stage types are added. Usually this is when the project is being created or updated only. Has anyone created a Custom stage, a Build stage or a Wrapped stage? A glitch in index updating during the saving of same ...

Some math, to keep you amused. 500 rows took 8 sec. 194120 rows is 388.24 times 500, so you would expect - if things scaled linearly - that it would take 8 times 388.24 seconds (which is 3105.02 seconds, or 51.76 minutes) to select 194120 rows. You're getting it in 5 minutes 47 seconds. Where's the ...

What I advised you to do (in person, not here) was to add a constraint to the Transformer stage. The constraint expression should be the system variable @FALSE.

This will isolate the "problem" to the extraction from Oracle or not.

Let us know how long that takes to execute.

You can not perform a range lookup to a hashed file using a Hashed File stage. The Hashed File stage can only look for exact key values (which it does via the file's hashing algorithm, which is extremely efficient). You can perform such a lookup against a hashed file using a UV stage, which accesses...

You can specify unzip, gunzip, etc., as the filter command in a Sequential File stage. Then DataStage reads from the output of the command via a pipe.

I have a Oracle table Date1 which contains d_date field. Now i want to use this d_date as the load date in many of my jobs. I cannot use hashfile to Store this date as i need a key to do a lookup and extract the d_date. Can anyone suggest how to do this . Thanks Sheema SELECT 'X', D_DATE FROM DATE1...