DSXchange

Supposed to be that functionality in 8.x but for now I still do it the Old Fashioned Way: two dsx exports and a good compare utility, like Ultra Compare for example.

Via the Import / Table Definitions / XML Table Definitions goodie. Should be available in your version... is it? Have you tried using it yet and are having issues?

DSguru2B wrote:They consider partitioning for billions of records. But maybe thats just my DBA.

It's just yours.

Would be nice, sure, but there's no such thing.

vijayrc wrote:As per IBM,DS-VC isn't that helpful, and most of them use PVCS/VSS etc for Version Control.

Really?

They can be found in the dsapi.h file under $DSHOME/include: /* 'jobStatus' values... */ #define DSJS_RUNNING 0 /* Job running */ #define DSJS_RUNOK 1 /* Job finished a normal run with no warnings */ #define DSJS_RUNWARN 2 /* Job finished a normal run with warnings */ #define DSJS_RUNFAILED 3 /* Job...

You should setup a stage variable and call this routine once in its Initial Value column, if at all possible.

The jobs are ran from Datastage Director and Transaction and Array size was given as 50 and 100 respectively in DB2 API stage . Do you think the rows are not commited because of the above settings. Possibly... Transaction Size should be a multiple of Array Size, not the other way around. Either try...

Still would appreciate confirmation of no warnings in the log, which I don't see as being possible unless the DB2 stage isn't good about reporting them. While the OCI stage may log reject information incorrectly without an array size setting of 1, it will log any issues encountered. Nothing personal...

We need to wait and see who has been jumping what gun, if any.

And you can't have rejects without warnings in the log - have you looked there?

Rows written can be a fairly useless statistic, need something more like 'rows accepted'.

Job design? Update action? Warnings in the job's log?

Can you clarify your question, please? "Multiple ports on a single server"? I don't see how that's related to using the dsjob command... or are you referring to multi-instance jobs?

Izack wrote:In what situation we have to use ? And what is the advantages of this stage to use in a job?

IMHO - none and very few. Use it if you have to.

I just recently did the same thing for an XE (not EE) installation and it worked fine. Are you connecting to the Administrator with your dsadm id?