DSXchange

DataStage cannot tell that data is sorted if it is sorted outside of DataStage. By default it assumes data is not sorted. If there is a stage in the job that requires sorted data such as Remove Duplicates or Join then DataStage will automatically add a tsort before that stage. There are only two way...

Try finding the metadata at a higher level - do a browse of database schemas to see if it is there. You can also go to the metadata management tab in IMAM (9.1.2) and browse posted metadata to see the full hierarchy of metadata imported and see what was imported and what host/database/schema it sits...

Version 9.1 also comes with the launchpad - the webpage that has all the launch icons in it. Worth bookmarking or putting on your desktop.
<servername>:9080/ibm/iis/launchpad/

This will show you icons for every web application in your Information Server - Admin console, BG, DQC, IMAM etc.

First off you can modify the message handler and either downgrade that warning to an information message or suppress that message from appearing in your log - that will get your job running again without filling up the log and running slowly. Second - what has changed start triggering this warning? ...

There is no Mac client - but it has an API so you could write one. IBM has a Developerworks article demonstrating how to build your own term finder widget. With MS Office the BG Anywhere works the same as with a PDF or Notes - you highlight one or more words and type the hot key and the glossary pop...

This year IBM has made more than half the presentations from the IBM IOD Conference in Las Vegas earlier this month available for anyone to download. IBM IOD Presentations for anyone . See me earlier blog post for a list of sessions that have information server content: All the IBM Information Serve...

Information Server 8.5 was compatible with Windows 2003 and 2008, Information Server 8.7 and 9.1 are only compatible with Windows 2008. When IBM was announcing what was new in version 9.1 they believed the removal of MKS emulation would make the product run more efficiently on Windows.

I think there is an Apache license JDBC driver for Cassandra but the ODBC drivers cost money. You would need to move to DataStage 9.1.2 to be able to use JDBC from DataStage. There is a version of DataStage coming out early next year with even better NoSQL support.

There is an exception to the BYO license for Amazon, you can use a non-production PoC instance and only pay for what you use. On the Amazon IBM page: Proof-of-Concept Development Many projects begin by creating an environment to test a particular use-case before any significant investment is made. A...

WebSphere Application Server is running - the error ADMA5014E is coming back from it - it is failing to implement the new EAR files. You can do some googling of the ADMA5014E error code - one potential answer: You can modify the MaxHeapSize of JVM in the related WebSphere server to 1500 MB or larger...

The architecture of 8.1 and 9.1 is the same but you do get some new free apps of information asset manager, blueprint director and operations console. These may require extra install steps if you want to use them. You can also move to 64 bit windows and you don't need the MKS emulation. You may be l...

I have found win diff to be good at comparing export files, it might be easier to compare a category at a time since it is no good if the files go badly out of alignment. You can also do a search on modification dates to spot suspicious job edits.

There is address standardisation, which QualityStage can do out of the box, then there is Address Verification where a postal address file is used to verify it is a real address and return a delivery point identifier (DPID). With QualityStage the DPID is an add on module with a different license fee...

Well, this is what QualityStage is for. Breaking the string fields into tokens and standardising it. Try QualityStage Investigation and Standardise steps. You could spend a year writing DataStage code to parse all the combinations, you need QualityStage.

It shows up on the palette of my 9.1.2 Windows installation but no idea if it works.