DSXchange

Hi Craig,
Can I use the DB2 Bulk Loader stage to upload the file created after doing all the validation/processing.
I went through DB2 Bulk Loader Stage properties but there are so many parameters that we have to specify.
Also can u give me any doc on DB2 Bulk Loader stage?

Thanx !!!

So Ray you want to say that as i have a server job so it would not use all the processors while running on a multiprocessor server??

Hello friends, I have a job which is reading a sequential file containing 2 million rows and after doing some processing/validations inserting the data into the DB2 Database(DB2 Stage). Can anybody suggest me,which option will be a good one,Reading the data from sequential file and do all the valida...

Hi Ray,
Can u tell me how should i find out in a job that which link is slowing down the processing of the job.I m using Hashed file for some lookups.

Thanx

In Monitor window it is showing me the %CP less than 100% For some stages it is very low like 20%. Can u tell me whether i m rite or wrong in my perception that Ascential works row by row.I mean Data will flow row by row ..not like 5 or 10 in some batch or something. Is there any other way to flow t...

Hi..But i m using 6 transformers in my job. Job design is something like this: Seq File -> xformer1 -> xformer2 -> xformer3 -> xformer4 -> DB2 Table At xformer1,xformer2,xformer3,xformer4...i m doing some look ups to fetch some values. So according to you it shud use 4 cpu's but the full job is runn...

Hello friends,
My job use only on a single processor even while running on a multiprocessor server.
Do i have to check some checkbox to run my job on all the available processors.I have checked the 'Multiple Instance' checkbox in job properties.

Thanx in advance!!!

Hello friends, I m loading a sequential file input into DB2 tables after some lookups and validations.The job starts at a good rate but as the size of the table(Data in the table) increases,the rate decreases.and now it has decreased to 45rows/sec level.My job is handling 3 million rows. Also made m...

ok..
Can u suggest me some value for Array size/Transaction Size.
My job has to handle approx. 30 million rows.

Thanx !!!

Hello friends, I am inserting data from a sequential file into Database using DB2 Stage(SQL Action-Insert rows without clearing).I am using Array size value as 1 and transaction size value as 100.The rate of insert into the table is not very promising. Should i increase the value of the Array size a...

Hi,
Here we have Ascential on Windows and we want to read a file from Mainframes while running jobs on Windows.How to specify the Pathname in the Sequential stage when the file resides in Mainframes.
Can anybody tell me how to do this.

Thanx in advance!!!

Hello friend, I ran my job for performance test purpose. The job is reading from a sequential file and putting that into DB2 Table.The job ran at a rate of 300 rows/sec. I want to know that is there any number of rows read/sec limit for sequential file or it depends on the Hardware on which we are r...

Thanx KcBland...!!

Hello friends, Can u tell me how much Data Aggregator processed for aggregation(sorting,computing total etc....).As far as i know..aggregator stores the incoming data in memory and then processed that data accordingly for the Output. My doubt is that if i m using aggregator for summing/grouping then...

Thanx Ray...
Can u please explain this..as i m not able to see ur full message.