DSXchange

Hi,

I anderstood that you work with DB2.
What plug do you use for update ?

Hi Steve, Did you check oracle table constraints e.g. : primary key, checks, not null. All of them usually slow insert/update operation. Nevertheless your load speed is very low for OCI stage. I loaded using this stage 4000-5000 records per second on less powerful server. Try to ask DBA to check fol...

Possible solutions: 1. If you have indexes in table that might slow the insert operation. 2. You can split your input file and load by two OCI jobs in parallel. 3. Use sql*loader for straight forward move. 4. Ask you DBA or Sys Admin to monitor disk operations. Might be you run into bottle neck on s...

Hi, I am not sure that this is performance problem. I run into this behavior once and I did next to spot the problem : 1. Check performance after getting rid of routines in transformer. If it works better try simplify your logic in routine. 2. If not, continue getting rid of rest of logic in your yo...

Use DataStage scheduler in Director to submit batch that must loop through all the subdirectories. You can adjust time interval and frequency of execution on both Unix and NT platforms through. Allow multiple instance feature becouse you may kick off next instance before previos has finished. Regard...

I don't understand where is the problem. Do you have multiple input files for Sql*Loader or one step bebore ?

Other solution is to write FTP script in operating system including the kicking off of your MF job.
You can execute this script from DataStage job or post job event.

Regards.

Hi,

First of all try to connect to oracle using SQLPLUS interface from DataStage server.
My guess it won't work because of same adaptor error.
That mean you should reinstall oracle SQLPLUS client (on DataStage Server) in order to use OCI plugs.