DSXchange

I'm having issues with the Merge stage as well. I received the Abnormal Termination message the first time, but now I'm seeing the one below. Unfortunately, I tried so many different things, I'm not sure which one switched the error message at this point. tempDirStageStuDemogCateService2002up..soCAT...

Well, I get the same response when I check system tables. I can see the tables if I try going through the plug-in rather than ODBC, so I kinda doubt it's something on the Db configuration. I've asked our DBA to run an ODBC trace and I'll post the results as soon as I have them. Thanks for all the he...

I just had our DBA add a new DB2 ODBC connection to our DataStage installation and when I attempt to import table definitions from it, I get the following (non-error) message.. "Data source 'XXXXX' appears to have no tables. Now, I know there are tables in there, and I've seen errors when the O...

Did anyone go in and change the 'defaults' via the Director? This has been known to case the problem you are seeing, even if you don't touch the password field. Yeah, I've run into that one before. The defaults you save in Designer are one way, so everything looks fine in design time, but someone's...

We have a test v8 database on another server, but only one datastage server installation, so testing becomes tricky, as we'll need to install the new ODBC drivers, test, then revert back to the old drivers until the upgrade is scheduled to happen. I know previous version upgrades went fairly smooth,...

The project I've inherited uses a combination of the plug-in and ODBC, supposedly because the ODBC drivers were much faster over lengthy loads (of which I have many.) I see from Ascential's site that the latest version of the DB2 plug-in is designed to work with DS6 and DB2v8, but unfortunately, a m...

Has anyone had any problems using DS6.x with DB2 v8? We've been told the DBAs want to migrate all our DB2 7.2 boxes (running AIX 5.1 or 5.2 if that matters) to version 8, and we're not ready to do the DS upgrade just yet, as we're in a rather busy load time right now. If anyone knows of any "go...