DSXchange

I tested the bottleneck by replacing the database stage with another sequential file. It read roughly 2500 rows per sec. I'm working with the DBA to look at the stats on this table as it has been inserted & deleted into numerous times. I was reading the file sequentially. I'll have to change the...

I have a simple job that reads a sequential file passes it through a transformer and then deletes those records from a table. The seuqential file has about 250 million rows. I'm experiencing very low performance reading the file. (71 rows/ sec) according to stats in designer. I've verified that the ...

ray.wurlod wrote:On all nodes (fastnames) mentioned in your configuration file? ...

Yes on all nodes

More information. I deployed the QS job in File Mode. After talking with the contractor who wrote the application. I should've deployed the job in Parallel Extender mode. Once I re-deployed it in, Parallel mode, I still received the error. I've narrowed it down to the QS job because I ran a Dstage j...

osh (Orchestrate shell) is the underlying architecture required for parallel execution. It lives in a directory called something like /.../DataStage/PXEngine/bin Its parent directory must be visible ... I checked it and the bin directory is visible /edw/di/home/Ascential/DataStage/PXEngine] $ ls -l...

ray.wurlod wrote:Is PXEngine visible to (copied to or mounted on) all nodes mentioned in your configuration file? ...

Sorry guys, I'm new to QS. How do I check?

ray.wurlod wrote:Posting the same question in multiple forums is annoying and wastes our time. Please refrain from doing so.

My apologies. I was trying to get it in the proper place. Thanks for letting me know of your angst.

I modified a standardization QStage job. Added two extra columns to be o. When I run the QS job it runs as expected. However, when I run the sequencer that calls the QStage job. I get the error below. The sequencer didn't change but I recompiled it just in case. Sqnc1DailyHHStgExt..JobControl (@QS_S...

I modified a standardization QStage job. Added two extra columns to be o. When I run the QS job it runs as expected. However, when I run the sequencer that calls the QStage job. I get the error below. The sequencer didn't change but I recompiled it just in case. Sqnc1DailyHHStgExt..JobControl (@QS_S...

I changed both input links to integer 10 on in the join stage. Had the same result.

I dind't see the condition in the join stage. I looked under the general, properties, and advanced tabs

I've tried to change the data type in the join stage. That didn't work. I received the same error. Also, where can I modify the lookup condtion on the join. I'm very new with Dstage. Any help is greatly appreciated!

Hi all. I have a question. I'm using a join stage and I get the error below when running the job. The join key is defined differently in the tables themselves. i.e. the join key in table a is defined as an integer 10 while in table b it is a small int 5. Any assistance is greatly appreciated! Join_3...

Thanks, Kumar! It worked!!!!! I used the 1st solution you provided. I didn't do it through Unix however. I went under administrator.

Thanks, Kumar_S for the welcome and the insight. I've found some threads concerning this topic. I've run the list readu. command. Now i'm trying to figure out my next steps

When trying to import a job, I receive the message "cannot get exclusive access to job log". I've verified no user has the job log locked.