DSXchange

Hi All,
Thought of posting the way the problem was solved.
Just cleared the &PH& file in the project and its working fine now.

Thanks all of you for your time.

Om

is hash partitioning and sorting the data set before change capture are same? even sorting both set is not helping.....

Kumar, You are right , its working when i hash parton both the input set....but am i doing the right thing???? :?: Change capture stage is build to run on parallel execution mode. It shouldnt give you any undesired result. But you could mention what is that you desire to get and what is the output f...

Hi, I'm using change capture in my job. I'm testing with a small set of data. I'm not geting the desired result when i try to run change capture stage in parallel mode, but it works fine and gives the desired result when run in sequential mode, and this doesn't solve my purpose as i'm going to run t...

I'm using the same table name as Partition Table and it gives me multiple records for that.In my case 8 ties the data(we are working on 8 nodes) The Partition Table property allows you to specify a table that provides the partitioning algorithm. If you are selecting from a partitioned table, you can...

Hi,
I want to use DB2 Enterprise Stage to read data from a specified table and use Partiton Table Property so that the execution is parallel.
Can anyone tell me what shall I specify for the property?

Structure of the job is like: DB2 UDB API---->Transformer-------->Dataset But my colegues are using different structure and have DB2 UDB API in it and they are also facing the same problem So have you tried to loading the table directly into a sequential file? What is the structure of the job?

yes
You are right !

kumar_s wrote:Let me reconfirm.
Is it view data succedes immediatly everytime, where as job gets aborted often. Am I right.

Yes it is a remote database, and there is no chances that somebody else is using that.I would like to add that my fellow developers are also facing the same problem. Is it a remote database? Try to write into a Sequential file directly. Was there any other user accessing the same table. There can be...

Hi Kumar, Its a simple select query and there is no problem when trying to run from command promt even doing a "view data " from the stage is also no problem. Try running this job alone in the server. What is the operation performed, it is select operation? If so do the same from the comma...

How long between the stage starting and the error message appearing? How busy is DB2 doing other things? How busy is the DataStage machine? ... Job started at: 3/30/2006 1:49:42 PM Error Received at: 3/30/2006 1:50:45 PM How busy is DB2 doing other things? Not much How busy is the DataStage machine...

Hi,
When using DB2 UDB API stage gives the following error and aborts :

"DB2_UDB_API_0,0: Fatal Error: Fatal: SQLFetch: Error retrieving results from server. "

Only succeeds when try several time

How do I get the file names? Do I have to do some changes in setings? Coz I get File Column Name as "/dir/filepattern*.txt" the same thing I pass in File Pattern. If you just want to get the file name, just pass the path name alone, it will read all the filename present in the directory. ...

How do I get the file names? Do I have to do some changes in setings?
Coz I get File Column Name as "/dir/filepattern*.txt" the same thing I pass in File Pattern.

DataStage doesn't have one, but many file systems default to a 2Gb limit for sequential files. If your OS or installation doesn't have a limit then DataStage doesn't have one, either. ... Thanks a lot or the reply.... I'm strugling at one more point ..when I use read method as file pattern and I wa...