[DB2-L] IBM DB2 Admin Tool Survey (z/OS)

Ruediger Kurtz

[DB2-L] IBM DB2 Admin Tool Survey (z/OS)
John,

late answer due to hols, but we use IBM's Admin Tool.

To put it in a nutshell: it does what we want it to do, notwithstanding the fact that there might be better tools out there.

We once did some evaluation after Candle's WorkBench went out of support, and, personally, I would have preferred a product by some Houston-based company, but then Admin Tool was part of a software package, thus cheaper, thus preferrable.

Hth

Ruediger

Ruediger Kurtz
Abteilung Informatik Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon 09561 96-44147
Telefax 09561 96-44104
E-Mail [login to unmask email]
Internet www.HUK.de
=============
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Werner Strohmayr.
Vorstand: Rolf-Peter Hoenen (Sprecher), Wolfgang Flaßhoff, Stefan Gronbach, Klaus-Jürgen Heitmann, Dr. Christian Hofer, Dr. Wolfgang Weiler.
=============


________________________________
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von JOANN GLAZEWSKI
Gesendet: Samstag, 20. Dezember 2008 00:32
An: [login to unmask email]
Betreff: [DB2-L] IBM DB2 Admin Tool Survey (z/OS)

Hello,

In January 2006 we converted from using BMC Catalog Manager to IBM's DB2 Admin Tool for the cost savings. The best analogy I can use to describe the changeover is an automotive one. We had been driving a Lexus and now we are driving a 'Vette. Unfortunately it's a Chevette, not a Corvette. The best thing I can say about the IBM Tool is that it's adequate, but I would not recommend it to anyone unless their other option was no tools at all. My main complaint is not the number of problems with the IBM Tool, it¢s the length of time it takes to get even the smallest problems fixed.

I would like to find out how many sites are using the IBM DB2 Admin Tool. My reason for asking is I don't feel it's a very large group of companies, so IBM receives a fairly small amount of feedback on problems and this contributes to the time it takes to get things fixed. I also stand guilty of not reporting every problem I encounter due to the time it takes to document what went wrong and pondering how long it will take to be corrected. I often wonder why a problem I've seen for two years hasn't been reported by another company and that's what leads me to the question, how many companies out there are using the product.

Thanks in advance for your responses.

John Glaszer


________________________________

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA < http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information<http://www.idug.org/lsconf>, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services< http://www.idug.org/lsms >

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Philip Sevetson

Re: IBM DB2 Admin Tool Survey (z/OS)
(in response to Ruediger Kurtz)
John,



I've used both the Admin Tool and BMC Change Manager, as well as M4 and
FileAid/DB2.



For managing DB2 structure change, BMC Change Manager is the
unchallenged best of breed, easiest to use and most powerful and
flexible. (It should be noted that you _must_ get training in it as
part of the acquisition package, or you will not be able to use it to
its full capabilities. Because it is powerful, it is also potentially
complex, and you need to absorb the correct approaches to change
management, best done in a classroom environment.)



The IBM DB2 Administration tool is ... manageable. It can be made to do
most change management tasks, with varying degrees of difficulty. (Note:
I did _not_ get a training package when I used it / am using it, with
training it may be easier) It is not ideally suited to a
multi-environment release-based change management strategy and if you've
got a large and complex release-driven environment you'll hurt yourself.
But it's good for multi-environment request-based (i.e. a few changes
migrated to one environment at a time) processing, its
reverse-engineering-DDL is simple and flexible, and it has all the
small-project (and many-small-project) capabilities we've asked of it.



Of M4, the less said the better. It's got catalog navigation facilities
(but using them requires a lot of memorizing the meanings of two-letter
codes), its function is marginal, and it doesn't have DDL change
management worth mentioning.



FileAid/DB2 has good data view and change (as it's designed for) and
good basic table-DDL reverse-engineering, but it's not really a DBA
change control tool (and is not designed for that, Compuware has
different tools for that purpose last time I looked).



Hope this all helps.



--Phil Sevetson, NYCAPS DBA Support

Financial Information Services Agency of The City of New York

450 West 33rd Street, 4th Floor

New York, NY 10001

phone: (212) 857-1688

mailto: [login to unmask email] <mailto:[login to unmask email]>





=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========



______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

mushtaq pasha

Re: IBM DB2 Admin Tool Survey (z/OS)
(in response to Philip Sevetson)
We use Admin Tool in our shop and we are satisfied with its functionality. It
came in very handy during our v8 migration. It is a very small shop though.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html