DSXchange

Does DRS stage use ODBC?? or the native client connection?? That's exactly what's weird. The DRS stage for connecting to SQL server from Unix, always uses ODBC. It does not fail. Also, other projects ODBC stages do not fail when this occurs. That is, this problem when it occurs does not span the Da...

Beware that loading the TCL/TK package on AIX on the same datastage server that houses the Sybase 12.5 or prior Open Client will cause problems for the datastage environment due to library files having the same name! I did not need the TCL/TK package on the datastage server, so I removed it to fix t...

the error is because of this . it is because of the license issue. i was having this issue, and the IBM support advice me about this. What is the license issue? This error is only sporadic and nothing about it so far conjures up any thoughts about a license issue? I hope you are right. I will menti...

keshav0307 wrote:Do you see anything like QEWSD=...... , just next to the ODBC name in the .odbc.ini file

[DSO9ITMP]
QEWSD=39646
Driver=/u01/app/Ascential/DataStage/branded_odbc/lib/VMor820.so

Yes, but not for Oracle. We use the ODBC stage and the DRS stage for connectivity to SQL server and DB2.

pneumalin wrote:Ensure you have latest DataDirect ODBC Driver 5.2.

I have been using the 5.2 ODBC drivers for almost a year now.

pneumalin wrote:Ensure you have latest DataDirect ODBC Driver 5.2.

I have been using the 5.2 ODBC drivers for almost a year now.

Does this occur after you reset the job? There is no "template" used for dsjob. Wave number is an internal number used by DataStage to identify unique runs (for example a reset run or multi-instance ... wave number in dsjob -logdetail is used to identify which log to dump. -wave 0 (defaul...

kduke wrote:Maybe you are running out of connections on the database. ...

No, has nothing to do with the database side. It is all ODBC stages to any ODBC source or target. DB2, SQL Server, etc... All fail. I will try what Ray has suggested the next time it happens.

On newly created projects in test and production, when we try to pull out the log information using dsjob, we get a -1003 error. I suspect that this means that the Template is corrupt. How do we fix it? $ dsjob -logdetail SMds02 LIR_DlySvcCshrCriteriaPfrmHst_060_Ld Error -1003 getting details for wa...

Hello, We have an issue that comes up from time to time and IBM has not been able to help after opening 4 different cases on each of the occasions that this problem occurs. Now, from time to time, we will all of sudden start getting the below error: Event Id: 12701 ..... Time : Mon Sep 29 02:27:08 2...

We asked that passwords NOT be output in any logs at any time with any option. That the passwords, should always be stars in the logs. We also asked that the export facility no ... Unfortunately, I cannot see your entire post. Some of the issues I noted: If you go into director and click on job you...

Ultramundane, What has been the response from IBM when you raise this issue with them? They got really really mad at me for pointing this flaw out. I was able to get them to fix several other security flaws. They said to make sure that you only give access to your very trusted developers. They also...

Ultramundane, What has been the response from IBM when you raise this issue with them? They got really really mad at me for pointing this flaw out. I was able to get them to fix several other security flaws. They said to make sure that you only give access to your very trusted developers. They also...

Maybe because no-one else cares enough to harrass the vendor about it, mainly for the reasons in Vincent's post. As a sometime contractor, I know that I sign some fairly heavy duty non-disclosure agr ... I don't see anything in Vincent's post that is being related to this issue. I do agree that it ...

Ok, so stop using it and "do it yourself". Ray, I am afraid the world doesn't work that way or at least my view of the world. I believe that we all rely on others whether we like it or not. Anyways, who is to say some other solution won't have pitfalls. I see no merit in your response. Al...