Category Archives: IBM Universe (U2)

UniVerse and .Net: Give or take a period

q Continue reading

Posted in .Net, IBM Universe (U2), Programming | Tagged , | 1 Comment

IBM UniVerse and .Net, BFF

This article is the third and final part of a series that covers some lessons learned when trying to plug Visual Studio into our IBM U2 UniVerse database using IBM’s ADO.NET driver.  Part 1 was an overview of how well … Continue reading

Posted in .Net, IBM Universe (U2), Programming | Tagged , | Leave a comment

The Meaning of Everything: UniVerse Dictionaries for the .Net Programmer

This article is a continuation of my previous post about using IBM U2 UniVerse‘s ADO.NET driver with Visual Studio.  Today I’m going to deal with the part of the process that makes .Net programmers cringe but is the key to … Continue reading

Posted in .Net, IBM Universe (U2), Programming | Tagged , | Leave a comment

Visual Studio and IBM UniVerse – Playing the Matchmaker

It has been a couple of months since we switched database APIs for accessing our IBM U2 UniVerse database from .Net.  We had a lot of reasons to leave UniOLEDB behind, and pretty high expectations from IBM’s new "DB2 Client" … Continue reading

Posted in .Net, IBM Universe (U2), Programming | Tagged , | 2 Comments

Silent But Exasperating: Automated Install of the IBM DB2 Client

Having made the leap over to IBM’s new "DB2 Client" ADO.Net driver for the U2 UniVerse database, we recently spent some time figuring out how to get it onto users’ PCs.  This turned out to be harder than I expected, … Continue reading

Posted in .Net, IBM Universe (U2) | 5 Comments

U2 and ADO.Net: Relatively Relational

I come to bury UniOLEDB; not to praise it.Which won’t be a big surprise if you’ve seen by previous whining and kvetching on the subject.At the time we adopted UniOLEDB, it was only ADO.Net-compatible driver for our IBM U2 UniVerse … Continue reading

Posted in .Net, IBM Universe (U2), Programming | Leave a comment

UniOLEDB Performance Enhancements – Bullseye!

My last post described various attempts to improve the response time of a large SELECT statement from a very large table in IBM Universe. I’m pleased to report that we finally found the trick, though it turned out to having … Continue reading

Posted in .Net, IBM Universe (U2), Programming | Leave a comment

UniOLEDB Performance Optimization: Hits and Misses

Having made some progress on the .Net memory usage issue, my UniOLEDB application’s biggest performance problem is now the time required to retrieve large amounts of data from the Universe database. After working on this with Universe’s tech support team … Continue reading

Posted in .Net, IBM Universe (U2), Programming | Leave a comment

Asking for the Same Thing Twice

Our .Net app has been running for over a week now with its new “persistent database connection” architecture intended to reduce the # of IBM Universe licenses (see “Failing to Let Go” ). The new design is having the desired … Continue reading

Posted in .Net, IBM Universe (U2) | Leave a comment

Failing to Let Go

Predictably, the first client roll-out of our new .Net / U2 (aka IBM Universe) application hit a snag and, predictably, it wasn’t one that I saw coming. And, boy, what a snag. The first time we tried to login to … Continue reading

Posted in IBM Universe (U2) | 2 Comments