DSXchange

Try going through this Technote too:

http://www-01.ibm.com/support/docview.w ... wg21460111

Perhaps you have done this already but it's not clear: Double check that there are no VarChar data types set on any column, and also for every column ensure there is a length value.

That doesn't sounds like too many, although there has to be a physical limit at some point. Again, which version are you using? Please give a specific example showing the different data values and elaborate on the data types involved in source, stage var, and target. Have you opened a support case a...

I would guess it depends on the data type you selected, or did not select, as well as the nullable properties and what specific version of DataStage you are using. Which version are you using? Please give a specific example showing the different data values and elaborate on the data types involved i...

IBM has already gone down that road and provided a database schema and web console. Just configure it and turn on some settings, and the stats are already loaded into a database for you. Have you looked into the IBM InfoSphere DataStage Operations Console? It has been part of the product since versi...

Just curious; have you queried the target database to be sure? The row count may not jump from 0 until it reaches 50,000 records on the link.

What is the sharing concern exactly? Not clear.

I also recall another method discussed on the MDM site which involved directly loading the base tables. That would be the fastest way to do an initial bulk load, however I seriously doubt it would be recommended for any subsequent loads because you would need to turn on the history triggers and then...

I am not aware of any restriction on sharing the server resources. You may want to double check with the vendor you purchased MDM from about that. My interpretation was that MDM was bundled with a PVU license for using a certain edition of DataStage. You should be able to install that on separate, d...

Thank you for the information.

Here is a link to the IBM InfoSphere Information Server, Version 11.3.1 fix list.

I suggest starting by creating a new project using the original project name. When you create a project, the name is embedded many places. My theory is that it's so extensive, that's why there is still no function available to rename a project. Copy your backed up files into the original project nam...

Test the Oracle connection from your DataStage server, outside of DataStage. Test using sqlplus and/or tnsping commands.

The newer versions of MDM typically include a bundled license for using DataStage (and possibly QualityStage too; I don't recall) with MDM, up to a certain PVU license value. I'm not sure what version of MDM started bundling such licenses. We started MDM with version 10.1 and it was included, but we...

I believe the answer depends on which of three user registries you have Information Server configured to use--internal (default), local OS, or LDAP. With the first two, those attributes are stored in XMETA, otherwise they come from LDAP. Someone else may correct me if needed.