DSXchange

Sorry I missed to update the resolution last time.

We have contacted Teradata Support team and as per their suggestion we have added cop entries in host file (with the help of admin team). After adding cop entries we have not faced any Teradata connection issue till date.

Yes that box is checked, but still not getting the status if procedure is failing.
If procedure ran good then status is coming in the file as below,

"0",""

Populating 'xml file name' in the table through Oracle Connector by calling parameter in the insert statement ( Generate SQL at runtime=No).

I am calling the procedure through stored procedure stage and pasing procedure status to sequential file. General-->Database Vendor=Oracle Syntax-->procedure type = source. no parameters and no error code I am intentially failing the procedure to see the procedure status in the file, but status is n...

I have used External Source stage and carried xml file name till output step of XML stage but giving below error in the mapping (XML Stage -->output step-->mapping), Job: External Source stage -->XML Stage --> Oracle Connector Error: CDIUI2820E The mapping is not applicable due to an invalid type co...

In the job XML file is the source and target is oracle. Along with xml data i want to insert the xml file name in the oracle table, there is a bug in XML STAGE in datastage 8.7, cannot able to assign the parameter value to the column (XML Stage -->output step-->mapping) http://www-01.ibm.com/support...

Some records are going into reject file even if values are match with key value in Lookup stage. How should I get the rejected records into output link. Can you please give some more input which test you want me to perform after lookups completed.

I checked the datatypes which is exactly same VARCHAR 255. Input dataset (main link) have three columns (A,B,C) Reference dataset contains one column (X). Using copy stage splitting reference column into three links and matching with input 3 columns. Currently there is no lookup condition. If we add...

I am facing the issue with lookup . I am doing lookup on dataset with other dataset matching three key values. If any one of the three keys are matched then the data will be processed to next level else goes into reject file. The issue is for some values even I gets the match with key value then als...

Datastage executing on Cluster environment and not on Grid. As I said this issue we are facing on Production only, and not on QA or Dev server. We implemented one shell script to ping database server but it is not helping to find the root cause, log is not showing any error. I will implement below B...

This scenario we are facing only in PROD and very rarely in QA. No issue in Dev enviornment. We are using ZEKE schedular (on mainframe) for scheduling the job. So restart of the job is trough scheduler.

Can you please give more input on grid?

DBA also unable to see any problem. Today we have increased the Sync timeout from 300 to 600 second. Also opened a ticket to IBM support.

We have implemented with IP address but still problem persists. Even getting more no of job failure as compared with URL. There is no specific day or time jobs are failing. Also there is no maintenance on teradata. Each day we are running three cycles. For each cycle getting 1-2 times getting this c...

Currently we are facing teradata connectivity issue, we are using Datastage 8.5 to connect to Teradata (Version - 13.10.05.02). We are using complete URL to connect teradata server instead of IP address. There are around 200 jobs on Datastage which runs on every 4 hr, in every cycle 1 or 2 Jobs are ...