Skip to content

DBAzine.com

Sections
Personal tools
You are here: Home » DB2 » DB2 Mainframe Articles Archive » Database Utilities
Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.
Who Are You?
I am a:
Mainframe True Believer
Distributed Fast-tracker

[ Results | Polls ]
Votes : 3554
 

Database Utilities

by Craig S. Mullins

Every DBA uses database utilities to manage and control their databases. But there is a lot of confusion in the field as to what, exactly, is a database utility. There are a lot of definitions floating around out there. DBAs constantly refer to utilities, tools, solutions, and suites.

So, first of all, let's be clear on what is a utility and what is a "tool" or "solution." A utility is generally a single purpose program for moving and/or verifying database pages; examples include LOAD, UNLOAD, REORG, CHECK, COPY, and RECOVER. A database tool is a multi-functioned program designed to simplify database monitoring, management, and/or administrative tasks. A solution is a synergistic group of tools and utilities designed to work together to address a customer's business issue. A suite is a group of tools that are sold together, but are not necessarily integrated to work with each other in any way. Of course, these are just my definitions. But there are useful definitions that make it easier to discuss DBA products and programs.

Why is this important? Well, let's examine an issue going on right now in the mainframe DB2 world. In the current release of DB2, Version 7, IBM decoupled the core utility functionality from the base DB2 engine and is charging their customers extra if they choose to use IBM's utilities. In all past releases of DB2, core utility functionality came free with the DB2 base product. This is causing confusion and angst for mainframe DB2 customers.

Why did IBM choose to do this? Well, IBM is using the utilities as an entry into the database tools market. IBM recently began selling tools to manage DB2. It seems that IBM has decided to use its 100 percent install base for utilities to try to branch out and sell other tools like performance monitors, change managers, and the like.

IBM has competition in the database utility field from companies like BMC Software, CDB Software, and Computer Associates. These companies thrived by selling more functional, faster utilities than IBM - and they did so by selling products that IBM was giving away for free. Now many organizations are faced with a decision - "Do I buy the IBM utilities or third party utilities for DB2?"

This is a more difficult question than it appears to be on the surface. First of all, IBM does not sell individual utilities, but suites of utilities. The third party vendors all sell individual utilities (as well as suites and solutions that include utilities). Additionally, the functionality of the IBM and third party utilities is not 100 percent exact. Many of the third party offerings still provide more functionality at higher speeds than the IBM offerings. But the IBM utilities are cheaper than the third party utilities.

And many shops bought third party utilities with the comfort level of having the IBM utilities as a back up in case problems were encountered with the third party products. Additionally, most shops bought only a few of the third party utilities. Now those shops may have to purchase both the IBM utility suites and the third party utilities to get the same functionality they had before. So, in essence, IBM is forcing them to buy two utility functions twice.

To be fair to IBM, their DB2 utilities are better than they used to be. IBM is finally putting the appropriate development effort into their utilities. But the third party utilities still provide unique features not available in IBM's utilities. And in many cases, organizations are relying on those features to run their business.

To be critical of IBM, though, IBM has been claiming that their DB2 utilities are improved to the point that they are all their customers need since Version 3. This was not true for V3, V4, V5, or V6, and it still is not true for V7. If it were true, the third party vendors would not be able to sell any products. Customers have a right to be skeptical about IBM's speed and functionality claims with regard to DB2 utilities.

An additional complexity that needs to be understood is the way that IBM packages and sells utilities as of DB2 V7. As mentioned before, IBM has also chosen to package the utilities into suites instead of allowing customers to purchase individual utilities. IBM sells two DB2 utility suites:

      • Operational utilities (including COPY, LOAD, REBUILD, RECOVER, REORG, RUNSTATS, STOSPACE, and UNLOAD)
      • Recover and diagnostics utilities (including CHECK, COPY, COPYTOCOPY, MERGE, MODIFY, REBUILD, and RECOVER)

As you can see, some utilities are in both suites. And if a customer desires to own one specific IBM utility, he is forced to purchase an entire suite of utilities - some of which he may not want, or need.

So DB2 V7 customers have some decisions they need to make - do I buy IBM utilities or can I go with a third party? And if I go with a third party, can they offer everything that IBM offers? And furthermore, if I need third party functionality and speed, will I have to buy something from IBM that I do not want or need?

It is confusing. But the DBA must be able to understand the options available and make an informed decision about the functionality needed to run his databases and his business. Even if he is constantly shaking his head and asking "Why is IBM making me pay for something that I previously got for free? And why did they let me use some of these utilities to manage portions of my databases if they were just going to come back at a later date and start charging me for it?"

It just doesn't sound fair, does it?

--

Craig Mullins is an independent consultant and president of Mullins Consulting, Inc. Craig has extensive experience in the field of database management having worked as an application developer, a DBA, and an instructor with multiple database management systems including DB2, Sybase, and SQL Server. Craig is also the author of the DB2 Developer’s Guide, the industry-leading book on DB2 for z/OS, and Database Administration: Practices and Procedures, the industry’s only book on heterogeneous DBA procedures. You can contact Craig via his web site at http://www.craigsmullins.com.


Contributors : Craig S. Mullins
Last modified 2006-01-16 04:40 AM

Update

Posted by cmullins at 2005-06-07 02:11 PM
Since this article was originally published a couple of things have changed. One is that there are no longer two IBM utilities suites. Now, there is only one. If you choose to buy DB2 utilities from IBM the only choice you have is to buy them all.

Now that is not necessarily a bad thing. Most shops want to have the complete set of IBM utilities in order to be make sure that they support all utility functionality as envisioned and supported by IBM. This usually is the case even if they have one or more third party DB2 utility products.

Also, the IBM utilities are very functional and serve the needs of the vast majority of DB2 users. The third party utility offerings are useful mostly to serve the needs of very large databases having extreme availability requirements.
Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper
Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!
 
 

Powered by Plone