DSXchange

Hi, We do have 30 sequencers for different countries. We do have a 1 Multi instance job which is called by 30 sequencers in intervals of 1 minute. It is business requirement of refreshing data for all every country every hour. We use in Target TPT stage with Immediate mode option. We do have a below...

Hi, We are having few jobs for 30 countries, which are running every 1 minute in every hour. Few times job gets aborted, when trying to insert the same table. Because of this we getting error like RDBMS code 2631: Transaction ABORTed due to deadlock. We are using TPT Stage with Immediate Option with...

Hi, Thank you for the reply. Iam into this \&PH\& folder, trying to get any log. In that folder iam able to see the lot of files names. like DSD.RUN_54751_15552_021242 DSR.ADMINDISPLAY_57373_15550_453503 How to identify for a particular job which ran today i.,e Sept 2, 2010 at 12:30 PM, whic...

Hi, We do have DataStage 8.1 running on Linux box. Few jobs has aborted in the DataStage Director,not able to get much from the Director log. My Question If I go and see the aborted job log in Unix, will the log be same or different from the Director log. BTW job aborted with error RDBMS code 507: C...

Thanks for the email.

"sendmail configuration" where exactly this file should be.

Any name of the file, if i need to tell him.

Thank you,

Hi, A scenario I work for company Switch, my client is Master. Notification Activity Stage SMTP Mail server name is blank. Sender email address is DataSTage@Master.com Recipients email address is ABC@Master.com Above works fine, i do get a email, no issue. But when I say, Recipients email address is...

Hi,

(1). If I use TD Enterprise Stage with Append mode, does Teradata creates internally a Fastload script?

(2). How and where to get the script created by TD Enterprise stage?

Thank You,

Probable Cause: Insufficient sessions available on the DBS for the FastLoad or MultiLoad job to connect all sessions. The database returns error 8024, but CLI erroneously returns the 507 error, instead of 8024. This problem is recorded in DR 123602. Note that once the DR is fixed in TTU 13, the prob...

DBA does not say anything, he is waiting for my response.

Thank you.

Hi, We are getting weird issue today, please check the below error LKUP,0: [IIS-CONN-TERA-005003] RDBMS code 507: CLI2: BADLOGMECH(507): Requested logon mechanism is not available. (CC_TeraConnection::connect, file CC_TeraConnection.cpp, line 796) All jobs are not getting aborted, few jobs are getti...

Hi, My Design => TPT Stage -> Transformer -> TPT Stage Most of the times job gets successfully finished, but sometimes job gets aborted with below reason. RDBMS code 2631: Transaction ABORTed due to deadlock. The no. of records which gets inserted is very less, its around 1000 rows. Any suggestions ...

Hi, My design ODBC Connector -> Copy Stage -> TD Connector Stage. Source SQL Server Target Teradata The job is getting aborted with the below reason. TDC_MSPMP100,0: [IIS-CONN-TERA-005004] RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum. The issue here is in the target iam having ...

Hi, Source -> SQL Server Target -> Teradata Flow :> ODBC Enterprise -> TPT Connector In TPT Connector when I use Access Method Immediate, the job completes without any issue. But when Access Method Bulk, the job aborts with below error. [img]TDC_SGRP_INF_Insert,0: /is/app/IBM/InformationServer/Serve...

Hi, I tried to run a job using a 2- node config file. The job has an 2 input datsets being joined (INNER JOIN) to 1 teradata table and the output being sent to a teradata table (target). There are no records dropped in this process and data gets successfully loaded into the target DB table. Note: Th...

Thank you, Priyadarshi Kunal.

Iam able to get the expected result with the conversation give by you.