DSXchange

You need to put together a DataStage job to extract data from your DB2 Database then ask if you're having problems.

I don't think you have provided enough info to get help here.

Bryceson

Welcome Aboard

You may use DataStage DB2 Stage pluging as you called it to accomplish your task.

Also I encourage you to read the DataStage Manual (The PDF that comes with your product)

Bryceson

ArndW, I will put together a test job with each row as 1 column and see what happen. I also have another file that has few columns (about 70) with 13 Millions rows and the throughput is 5530 rows/sec doing: CFF ------->Transformer------------>DB2 Stage (Good performance) Is this typical of CFF stage...

Folks, I hope someone has run into this before . . . . I am receiving Data file from Mainframe along with a copybook. I loaded the metadata from the copybook in DataStage (Complex Flat File Stage) as a results I have 192 elements to load into Flat File (using Sequatial File) or DB2 (using DB2 Stage)...

This is a question of choice and good design that will enable you maintain your Master Sequence.

Beyceson

Welcome Aboard :D Yes, there is two way you can hendle you restartability in sequencer: 1. Add check point on the job level (Job Sequence - Parameter - And check the box Add checkpoints so sequence is restaetable on failure). 2. Add check point on the Project level in Administrator (Sequence Table A...

Still Happy . . . . can't get both. Lost top posters and got new learning center

Bryceson

Good make over!! Let's wait for the announcement and may include new color on the log.

Bryceson

Thanks Craig!! Will dive in that section of the Server Developer to get more light.

Bryceson

Folks, I would like to make use of the DSGetLogSummary function, but I guess I have not quite understood where in DataStage I need to palce this function and extract the information it returns. I see the info in Diretor by viewing the log, but I want to get a dump of that where else. Preferably I wa...

Folks, I would like to make use of the DSGetLogSummary function, but I guess I have not quite understood where in DataStage I need to palce this function and extract the information it returns. I see the info in Diretor by viewing the log, but I want to get a dump of that where else. Preferably I wa...

It sound like you have a corrupted RT_CONFIG1303 Login to your Unix Session as dsadm And be at $DSHOME source dsenv first then run uvsh command that will put you at great than sign >LIST RT_CONFIG1303 If it is indeed corrupted you will get this message below: Read operation failure. Internal file co...

At least, I think will worth market value price for those who will need it.

Bryceson

Let's hope Andy's message got to Walter!! If that doc become available, it will be very helpful.

Bryceson

Try to make the native type as DISPLAY_NUMERIC for your last three:

FD_STKOUT_AGA DISPLAY_NUMERIC (04)
FD_STKOUT_AGB DISPLAY_NUMERIC (04)
FD_STKOUT_AGB DISPLAY_NUMERIC (04)

Hopefully this will work for you.

Bryceson