DSXchange

In the job design, did you try to hash partition that data based on the key combination?

Speaking of using the correct tool for the data movement job, have you all tried InfoSphere Data Click? It provides the user self-service data provisioning through a simple web based interface. The admin has to setup what the user is allowed to move, including limits, if desired. Data Click generate...

How exactly is it not working? What is the XYZ data type and the values you are using in XYZ?

I was just joking about the return code. To list the possible return codes for istool, give it a command followed by the -help option. Not sure how much that will help you, because the export return code (or Exit code) of 3 means "Export failed." I would hope there is some more detailed er...

Post the exact error message.

Also try searching on keywords from the error message.

Search DSXchange and the IBM Support Portal.

Let us know what you find.

I have run up to 4 istool exports in parallel, on a nightly schedule, on AIX, without having run into any errors like that.

I guess the return code is dropping you a hint as to the limit on Windows.

You're welcome. It is documented here: http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_8.7.0/com.ibm.swg.im.iis.ds.commservparjob.doc/topics/c_dsnls_Internal_Character_Sets.html Also, now that I read a bit more, I am wondering myself if the UTF-16 statement may only apply to ustring data types ...

Yes, that is correct. I learned about it in an IBM training class one time. I edited my post above to add that last paragraph too.

The parallel framework processes only data sets, no matter what the external format is. The links between stages are virtual data sets. The internal data format is UTF-16. Import and export operators are used to perform the conversions. If subsequent parallel jobs need to process the same data as th...

As far as coming up empty on searching the error goes, I searched the IBM Support Portal on "WSWS3084E" and got a result in the WAS Knowledge Center: WSWS3084E: Error: {0} encountered a child element, which is NOT expected, in something it was trying to deserialize. Explanation This messag...

In case there was a question on certain symbols getting replaced, there are 5 invalid XML characters that must be escaped when in the data, in order to have proper XML content. Examples: > > < < & & ' &apos; " " Hopefully the source XML column has already been validated and you...

Make sure you don't have any local or organizational firewall blocking the connection. It seems like a strange error; you may want to check with Support.

In 8.x and other versions you can use the ODBC Connector stage along with one of the newer, bundled Progress DataDirect ODBC drivers for SQL Server, or so I've been told. The older ODBC driver does not support bulk loads.

The Oracle Connector stage properties are fairly well documented in the Connectivity Guide for Oracle Databases (i46decor.pdf). If database connection is enabled for transparent application failover (TAF), the application that is connected to the database (i.e. your job) is transparently reconnected...

I voted for it. I also added a comment on that site, but something went wrong and I lost the first part about "circumventing the WLM at the queue level." "Administrators need control over which queues are accessible and visible for various projects/users/groups to select when running ...