DSXchange

Could 7.5 and 6.0 be installed on the same server?

Hi, Finally our company agrees to upgrade DataStage from 6.0 to 7.5. Because we have so many processes that use datastage, we plan to do it process by process instead of migrate everything at once. I have a question, if does upgrading datastage from 6.0 to 7.5 require any job change? (Of course, we ...

if no function is performed on user defined SQL, why use it. Simple just use the generated sql and then see the difference in performance. Tried that. Still does not work. And I also notice a very strange thing. If I don't specify order by in my query, the datastage job starting to write to sequent...

DSguru2B wrote:How many rows are you extracting? Do you have user defined sql?
Are you performing any functions in the user defined sql?

The number of row I'm extracting is around 300,000. It is used defined sql, but no function is performed in user defined sql.

kris007 wrote:What did you set your Array size to, in the OCI Output Tab? Increase it and see if it helps.

My initial size is 1000, later, I increase to 10000. The speed is 30 row/second now. Still not good.

Hi, I have a very simply ds job. It has one Oracle stage and one Sequential file stage. I was trying to extract records from Oracle server and write to sequential file, since there is no transformation needed, I omitted the transform stage. The problem I am getting is that when I ran the query on Or...

Thanks. As I could see from past posts, reseting the job could fix the problem next time. My question is whether I need to re-run this time? All the record count looks fine to me.

Hi, I'm encountering a very strange warning message I have never seen before. I was running a job which reads from one table, and update existing rows/insert new rows of another table. The job finished OK with logs. The log shows following message: JObname..Trans1: Synchronization error Resource = J...

I just found that after I re-compiled the job, everything is OK now.

Hi, I have this job which has a container inside it. This job has been running fine since it was created. Today, this job got stuck for no reason, when I looked the performance statistics, it seems it got stuck in one of the transformer in the container. Has anyone encountered such problems before? ...

Hi, Just wonder how do you implement ETL auditing in your company? In our company, we have some high level auditing, like how many input rows, how many output rows and how many rejected rows. In each table, we also have DW_UPDATE_BATCH_KEY, DW_CREATE_BATCH_KEY auditing fields. But business wants mor...

Hi, I'm having this job. OCI stage--> Transformer --> OCI stage The first OCI stage reads from a table, the second one updates the same table. The problem is one the volum of data is small, everything is OK. Now the job is trying to update nearly 20 millon records, it aborted because of following er...

I enabled the 'In process' row buffer, the buffer size is 1024 K. Is that the problem?

logic wrote:Hi,
Did you try enabling or disabling the row buffer?

Hi,

I have a job that has following design

Oracle Stage --- Tranform -- Aggregate -- Oracle Stage

When I running the job, I encountered following error:

ToAggr: ds_intput() - row too big for inter stage rowbuffer

What does that mean?

Anything I could do to prevent this happening?

Thanks,

Carol

kduke wrote:Try to delete it in Manager.

It did not work. The error message I got is
'Cannot open executable job file RT_CONFIG3187'. 3187 is the job number.