DSXchange

Sounds like a High Availability solution in Clustered mode. Not a grid. You are basically trying to test grid on a single SMP box. Please correct me If i am wrong.

Please confirm whether you want an active passive cluster or a Grid.

DB2 connector will also use the catalog information. If you read the documentation that if DB2 client fails to connect to the server then DB2 Connector will also fail. Try to catalog xmeta on engine then try running the job again.

You should check the query in db stage and run the query by providing this value replacing the variable in any other database client. How many records are you getting?

where does this error coming from, is it from the target oracle stage or source oracle stage or any other stage?

What has changed during maintainance?

The date has no specific storage format like YYYYMMDD. It is stored in database's internal format and only display format will change. The format you provide in string to date is the format of your input string and the defined format is used to convert the input string to date. If you want to store ...

http://www-01.ibm.com/support/docview.wss?uid=swg21593545 Check this link and see if this helps. There are many threads on this error with different configuration issues causing the same error, please do a search and check if any of those help. Do you have anything else running on that server that u...

hash partition, sort and join. Do you have any question in particular regarding join? 10 million is not huge IMO.

Details on how to export users with credentials, groups, roles, credential mapping etc using ISTools. http://www-01.ibm.com/support/knowledgecenter/#!/SSZJPZ_9.1.0/com.ibm.swg.im.iis.iisinfsv.assetint.doc/topics/security_cli.html Please copy paste the link in browser, a character is messing up the l...

Please read this which has some disucssion on NLS.

Also read this. which is also present in the post above.

Too many things to explain at once. To be precise, You need to avoid character set conversion as this may cause incorrect replacement of characters which are not present in that particular character set. The character set you are using in the job or target should be same or a superset of the charact...

that means there is logic issue, it just means that the record which were unique on primary index, were not unique based on secondary index. You should look at data whether you can have both unique indexes or not.

as per your reply that when you create a job and then when othere developer open it, it has the problem.

If thats the case, can you first please check if your client and server versions are synchronized?

I have seen such behaviour when I was on Fix pack 8.5.1 and server was without fix pack, and oracle connectors reject link was not getting any column and the job was failing to compile. So you never know what surprises you may find if server and client are not synchronized.

Are you migrating to a newer version of datastage, or is it a new installation and you are trying to create a new job, or does it happen when connecting from your machine or all the clients have the same problem? And was it working fine earlier?

As Arnd already noted, you will have to look through all the different error or warning messages. If you are not able to, then Try posting error and warning lines.