DSXchange

Did you check thiks link
http://www-01.ibm.com/support/docview.w ... wg21320296

Get the compute node names and ask your DBA to configure that database in them.

No need to compile former N jobs as long as new parameter is not used in them.

Hi,
There is one shared container having 4 output links. I want to use that in my job accessing only 2 links alone instead of all. Remaining 2 links will be accessed in other job.

Is it feasible ?

Thanks

Did you check Paul's response for this thread.
Are you in a grid/cluster environment? If so, do your compute nodes also have that tns update?

Try with this derivation in EC stage which generates YYYYMMDDHHMMSS.
Convert(@FM,'',Execute_Command_3.$CommandOutput)

Did you check the monitor in director. Any records went into target file ?
Seeing in any warnings in log ?

Identify any particular record and try with combinations of different key columns in change capture instead of 15 at a time. It will help to find the column having mismatch.

Is it 2099-21-31 or 2099-12-31 ?

Enterprise DB stages are not present in 9.1. IBM will provide some utilities to convert them to connector stages. In those scenarios, if you performing UPSERT using user defined sql, it might throw some errors. Null handling is very strict in 9.1 whereas in 8.1 it will throw an warning and run. But ...

Did you set preserver partitioning flag as clear in all stages present in your deisgn.

Please remember that DST start date and end date differs for each year.
Also DST is defined till 2019 till now.

The job fails at aggregator stage with the fatal error for huge no. of records: write failed: Output file full, and no more output files Fatal Error: Tsort merger aborting: mergeOneRecord() punted Please let me know if anyone has faced the same issue for large no. of records and the possible solutio...

Thanks. You guys rock as always..

Hi,
How can I change date format from "YYYY-MM-DD" to "DD-MON-YY" in parallel jobs.

Thanks
Vinoth