What’s Wrong with ClearQuest II

My long-term business partner, Trent, told me the other week he was going to write a rebuttal to my previous rant, “What’s wrong with ClearQuest“, called “What’s getting slightly better about ClearQuest”. I think he’s struggling to fill a few paragraphs though, because it hasn’t been forthcoming.

He recently wrote a reply on the forum [...]

Relocating, moving or copying ClearQuest schema and user databases using database vendor facilities

This blog describes the process for moving or copying ClearQuest schema and user databases between two separate database instances using the database vendor’s native facilities. This approach has a few of advantages over the standard Move /Copy Database facilities provided by ClearQuest (either those used via the Maintenance Tool or Designer, or via command [...]

All you ever wanted to know about ClearQuest IDs…

I’ve done some pretty masochistic ClearQuest database migrations in my time. By masochistic I mean that instead of using the Rational recommended approach for a database migration (I don’t even know what that is. Fiddling around with the import/export tool? No thanks!), I’ll write routines in Transact/SQL or PL/SQL (SQL Server and Oracle’s procedural [...]

Useful Python Decorator Idioms

I seem to be using decorators in my Python code more and more each day. Given that I’m meant to be giving a short presentation on decorators to the New York Python User Group tomorrow evening, I figured I’d whip up a quick blog post to get some ideas flowing. (Update: the presentation is [...]

Fix Window Placements

I’m a big fan of spreading my desktop over as many monitors I can find. When I’m working from home, this usually entails four monitors, each with 1920×1200 resolutions (made possible due to the excellent software MaxiVista, which I highly recommend). When I’m travelling or working on a client’s site, I’ll typically have to [...]

Changing the logical name of a ClearQuest user database.

During the normal course of ClearQuest development, I often want to create a new development database from a production backup and have it available from the same schema (i.e. I don’t want to create a separate schema database from a production snapshot as well). Because you can’t have two user databases registered to a [...]

Create your very own ClearQuest dbids…

I’ve done some pretty masochistic ClearQuest database migrations in my time. By masochistic I mean that instead of using the Rational recommended approach for a database migration (I don’t even know what that is. Fiddling around with the import/export tool? No thanks!), I’ll write routines in Transact/SQL or PL/SQL (SQL Server and Oracle’s procedural language [...]

Counting lines of code in ClearQuest hooks (SQL Server)

I was going through old SQL snippets I’ve collected the other day and came across this little chestnut that counts the lines of hook code in a ClearQuest database. Horrendously useless in the grand scheme of things, unless you enjoy distracting yourself from real work with useless info. (Apparently I do.)

[...]

IBM Rational ‘Classics’: Sample ClearQuest and RequisitePro Projects (and who knows what else…)

I’m not aware of the history behind it, but Classics is quite a handy little collection of resources when it comes to testing our products against a standard run-of-the-mill ClearQuest schema. It contains all sorts of things like RequisitePro databases and testing stuff, but what I rely on it most for is the ClearQuest CLSIC [...]