DSXchange

This can be the issue with ODBC data type support. Not all data types of db2 are supported in ODBC, if you can change the ODBC to DB2 client you can avoid warnings.

Can anyone list the best practice in performance tuning of datastage jobs? This is to get knowledge and we can share all the tips we know.

Thank you.

ETL stats in Kim Duke site is for server jobs...

well, could you please tell in detail how to do that?, i like to write every small job log too.. Ray, you are the man of datastage

thank you.

Is there any way to load the job report stats into the audit table at the same time when job runs without adding any processing stages...

Does any one have idea of auditing the datastage job in the job level for no.of records extracted, transformed, inserted or rejected. I have been using @INROWNUM which is not a workaround.


Thank you.

try usprep rule set

Try running job by constructing new Oracle stage without any parameters.

Let me know if the Oracle database is on same server, if not whats the database version and the client connector version.

PX in Datastage started from version 7.5, you can install in Windows XP professional. Before installing Datastage install .net framework, Java, C++ compiler (Visual Studio Express Edition).

PX needs a C++ compiler to compile and run the parallel jobs.

Were you able to figure out the issue?

Yes, you have to copy...

I did not copied the configuration file but configured the new server as the old one.

I think you are using the database stage in this case, if am right.... try reducing the number of lines in the custom sql query at input.

let me know if that doesn't work..


-----------------
MKR

"Sharing skills improve knowledge, not by selling..."

Thank you Ray, got it.

I do not have login credentials as admin