DSXchange

I have started a PMR with IBM on this, of course they want all the usual stuff to be sent to them first (version.xml, .odbc.ini etc...).
Still waiting to hear back from them...
Will post updates if any...

I am doing a new install of IS 8.5 on Linux Red Hat 5.7, switching from 8.1 on Windows Server 2003. When creating an ODBC connection in Windows environment for the AS400 DB2 connections, we used to check the box under "Translation" that said "Convert binary data (CCSID 65535) to text&...

Ray - Yes, Row Buffer is enabled with Inter process checked, Buffer Size of 256, and Timeout of 600...

Update: I was able to remove the datatype mismatch, but am still getting the abnormal termination of stage error. I did notice that my DSParams did not have RTLogging or ORLogging entries in it. I did add
RTLoggin=1
ORLoggin=0
to it. Didnt really help.
Any other ideas?

We are upgrading from 8.1 to 8.5 and after installation and migrating jobs manually (because we are switching platforms from Windows to Linux), I am getting started on testing jobs in 8.5. The first error I ran into is a job that ran fine in 8.1, but has failed repeatedly in 8.5. There are two warni...

It was my understanding that the tns names file can be used in case of Oracle conncetions, and it hasnt failed me. The connections work fine and jobs work great. It's just these minor annoyances that I am trying to fix.

I am upgrading from 8.1 to 8.5 and am in the process of setting up all the Database connections. This question relates to the Oracle piece of it. We have Oracle 11g as our database and we have installed the client on the 8.5 server which is on Red Hat. We changed platforms from Windows 2003 to Linux...

I figured it out. Craig's last reponse is basically what I wasnt doing, I did not have the ODBC entry in the uvodbc.config file in the Project folder. I had created another ODBC connectio previously for SQL Server, but did not recall having to add it to the project level uvodbc file. But once I adde...

This is from my .odbc.ini: [TESTCRPQ] Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb224.so Description=DataDirect DB2 Wire Protocol Driver AddStringToCreateTable= AlternateID= Collection= DynamicSections=100 GrantAuthid=PUBLIC GrantExecute=1 IpAddress=xxxxx.xxxxx.com IsolationLevel=C...

Another question I have is do I need to specify the "Collection" variable in the odbc.ini? We connect to various libraries on AS400 and I was wondering I can list them all in the same line, rather than creating a new DSN entry for each library. We do fully qualify the file name with librar...

Craig - Thanks for the suggestion, but doesnt look like mine allows typing in the DSN name. I have an email in to the concierge service, but that's like watching paint dry. You guys reply so much quicker! I did go ahead and reboot the box too, just in case, but doesnt seem like that helped either. A...

Thanks to everyone who replied. I was able to find my bind command a level up as suggested. I ran the commands after running my . ./dsenv. [root@chfoh-vls-etltstapp1 DSEngine]# cd /opt/IBM/InformationServer/Server/branded_odbc/bin [root@chfoh-vls-etltstapp1 bin]# ls -ltra total 1176 -rwxrwxr-x 1 dsa...

We are currently in the process of upgrading from 8.1 to 8.5 and are also switching from Windows based servers to Linux Red Hat. I am working on setting up the odbc.ini and uvodbc.config files. Our primary source of data is AS400 and we have existing jobs that all use the ODBC stage to connect to AS...

Hello all, I am new to quality stage and I was trying to create a new match specification and wanted to test the passes. But when I try to add the information for the test database, I can't find any DSNs listed. I tried adding the IBM Oracle Wire Protocol DSN, IBM Oracle DSN and Oracle Client DSN, b...