DSXchange

Try updates only using the Oracle Connector first. I would not use both types of stages in the same job at the same time to do the same thing. You can play with the settings on either stage. You might want to make sure the key columns used on the update are indexed in Oracle, especially considering ...

Unfortunately all that migration was done on site by the vendor before I arrived and I don't really have any details as to the rhyme or reason they did what they did. We didn't have any XML jobs to migrate so this problem was not tested until now, when I try to create a new job with XML stages. I've...

Are you putting the ODBC Connector stage in place of the Oracle Connector stage or connecting those two together? What version of DataStage are you on? In DS 8.5 the ODBC Connector stage has "Write mode" choices of Insert, Update, Delete, Insert then update, Update then insert, or Delete t...

When you connect directly to the table and it runs fine, what stage and settings are you connecting directly with? How long does it take as is?

But why should i enable RCP in source when the column count is the same. Thanks in advance. Did you say the input columns inside the first shared container stage are empty? If so then the column count is not the same between there and what you pass to there from the source stage. Seems like that sh...

The AIX server with the DLL not found issue was migrated (by the vendor) from IIS 8.1 WIN to IIS 8.5 WIN, as an intermediate step, to IIS 8.5 AIX. I have found that the xml*.so files do exist on the server, but of course the xml*.dll files do not, as expected. The stage type definitions are read-onl...

When I open the XML Output stage in the repository under Stage Types, the properties show .dll files. When I compare those to the new server I just setup, the new server has .so files in the same properties. Both servers are on AIX. I am guessing now that the way the other server was migrated was no...

I've run across an interesting fatal error on a relatively new server: main_program: Fatal Error: Fatal: Shared library (xmloenu.dll) failed to load: errno = (2), system message = (0509-022 Cannot load module . 0509-026 System error: A file or directory in the path name does not exist.) This is from...

2 GB is 2147483648 bytes, so your file is a bit over 2 GB. This may not be the issue, but it's worth trying to rule it out. Go into your test job, the one that does not hang, and go into Job Properties. On the General tab under Before-job subroutine choose ExecSH. For the Input Value, enter an OS co...

I am not Ernie, but thanks for the compliment. Just to be sure because ulimit is such a common problem, have you tried running the "ulimit -a" command as part of the before-job subroutine (ExecSH) and is the output you sent obtained from the job log? I'm just highlighting that now because ...

It looks like your DSSendMail string is missing the concatenate colons surrounding your parameters. Have you tried "From:" : FromID : "\nTo:" : ToList : "\n ... etc. ?

Another thought is that it may be time to start a new topic on this matter.

This is an interesting question. I'm waiting for my premium membership to kick in to read all the responses so far, so I don't really know what answer you have got in detail just yet.

You asked about cataloging hashed files in bulk. What do you mean by catalog in this case?

I don't understand how changing the link order could resolve this. It seems like both tables would load simultaneously no matter what the link order is. What am I missing? I guess I would lean towards two jobs run in sequence for this. If it is resolved, then you can mark the topic as resolved. I wo...

Make sure the information for the .odbc.ini file entry matches what is in the tnsnames.ora file from the oracle client on your server: HostName (or IP), PortNumber, SID. It sounds like there is a mismatch. Or just use the Oracle stage instead since you can already view data using it.

I see this post is marked as resolved. What was the resolution?