DSXchange

Naveen,

What had happen is I did took Export of each projects separate with the option of (whole project). I have done this many times . . .not sure what went wrong today.

Thanks . . . Bryceson

Hi All, We unistall DataStage 7.0 and did Install of DataStage 7.5.1A on the Windows 2003 Sever. Before the two activities I took an Export of the projects (whole project) from DataStage 7.0 Server jobs. I am having issues with the Import of dsx projects into the new installed DataStage 7.5.1A, the ...

Folks, Can someone out thre tell me What is the diff btwn DataStage Extended Edition Vs DataStage Enterprise Edition? In our contract w/ Ascention it says "DataStage Extended Edition" and we did receives Authorization codes for both DataStage Enterprise Edition and DataStage Server. The Se...

ArndW,

Yes, This is a Server job!! Last time I ran this job with 100,000 rows Limit it took 15min/14sec, by the time it was done (110 rows/sec) the speed keep on going dwon.

Thanks . . . Bryceson

ArndW,

Nothing significant in the log. The table I am loading has one index on the indentity column. This is the only table that I am loading that much data. Any other suggestion?? PX could be an option going forward if this doesn't get improvement.

Thanks,

Bryceson

Hi all, I have a job that is reading complex flat file (ASCII format) about 13+ millions rows and loading them to a DB2 Table using DB2 Bulk Stage. It takes forever to load and I also get this warning message "LOADPSTREELEDGERSTAGE..TargetPSLedgerStage: ERROR occurred : loading table, SQLCODE 3...

I feel the knowledge I have gained from dsxchange is wealth to $$ fee.
I hope all the Gurus will continue to spent their time in answering questions and sharing their valuable knowledge.
I express my support to the dsxchange community by becoming a Charter Member. :D

Bryceson

Hi All, We are running jobs in Testing environment sporadically different DataStage Jobs Abort with this Warning "Abnormal termination of stage LoadDMDriver..Transformer_4 detected" in the log from Director. So far we have managed to recompile the aborted jobs and re-run the Sequence. Has ...

Hi All, We are interested in sorting the output of IBM's DB2 UDB High Performance Unload Utility. It appears that Ascential DataStage Version 7.5 has Sort Stage capabilities. 1. Has anyone used this feature for large (100GB+) volume sorting within Ascential DataStage?. 2. Have you found this feature...

Hi Ken,

We have One column for the source data VarBinary 9999 and One column for target data VarBinary 9999. How could that Metadata not be matching??

Thanks . . . Bryceson

We are using FTP Stage to FTP Binary Data from Mainframe to Sequential file - We are getting this warning "Mismatch in number of column between data and link". Why does DataStage give this warning??

Any idea/thoughts in dealing with FTP Stage is appreciated.

Thanks . . . Bryceson