DSXchange

So, I informed a developer that the lookup stage (non-sparse) should typically be used when referencing data in smaller tables, which allows the structure to fit into memory. He asked two very good questions for which I didn't have an answer. 1) Does it use standard virtual memory to buffer the look...

Banned and deleted!

If you are going to move to Big Integrate on Yarn, the Hadoop environment needs to be configured to support BI from the start. The Hadoop team will probably not like some of the changes that need to be made to support BI, and they'll like it even less if they have to retrofit those changes and disru...

SQLState 40504: A system error has caused the unit of work to be rolled back. SQLCode -1229: The current transaction has been rolled back because of a system error. https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.messages.sql.doc/doc/msql01229n.html Doesn't say "wh...

I am assisting a client with loading some highly qualified XML schemas that came from a vendor. The schemas contain import statements to load other "sub"-schemas. And of course, the sub-schemas have numerous imports that nest down even further. It's a poor design in that the included sub-s...

What you are being asked to do is already performed by an IBM product that is integrated in DataStage: InfoSphere Change Data Capture https://www.ibm.com/support/knowledgecenter/en/SSX3HK_6.5.2/com.ibm.cdcdoc.mcadminguide.doc/concepts/overview_of_cdc.html A good example of usage on DeveloperWorks is...

Yup - 8.7 went "EOS" (End of Service) on April 30, 2017. I checked the Oracle client / database compatibility matrix which says the Oracle 11.2 client is certified to access the Oracle 12 database. If you could at least upgrade to 9.1 , you might have a chance. IIS 9.1 did support the 11g ...

Banned ploy2018 - deleting posts now...

edit: Done! thanks for the text!

Yes - you might have to establish some sort of key structure / row count in order to reassemble the chunks. Just realize - if the resulting data record including the re-assembled CLOB exceeds 128K, then it can't be done in DataStage. On the release you are on, 131,072 bytes is the hard limit on reco...

It isn't supported. I heard they are adding better support for CLOB in 11.7 (mainly for Hadoop), but don't know if it would apply in this case. Customer services should be able to confirm if its in 11.7 or not. However, that doesn't really fix your current issue. I encountered this once and had to s...

Splitting it up later is not trivial and is time consuming. You did mention they are VM's. Virtual Machines are usually very cheap, and as you say, there's no licensing issue for splitting out the Services and Repository tiers. I'd recommend doing it up front. You can always start out with smaller V...

All 100+ posts for hildac07 have been removed...

Now starting on that ray.wurlod spambot that keeps posting!

hildac07 has been banned....

Working on removing the entries....

...This is on par with taking the math coprocessor off the chip for us old guys :) I prefer "seasoned" or "experienced"... thank you! :-) ...and yes - this is going to be a real pain if your system is already stressed. One of the major game platforms patched their Linux servers ...

User / email banned. Posts deleted...