Quest Central for DB2 (OS/390 and z/OS)

Raymond Bell

Quest Central for DB2 (OS/390 and z/OS)
Colleagues,

Does anyone have any experience with Quest Software's product, Quest Central
for DB2? Specifically the one to administer DB2 on OS/390 and z/OS. I see
from a casual glance at their website the only version that would be
appropriate for what we want would be the Professional Edition. Does anyone
(that's not a sales person) have any comments to make regarding the product?

This is just a feeler-type question. The purse strings haven't even been
looked at, let alone prised open, so it's still very early days. But if the
word is good, maybe I'll download the 50MB v3.1.1 demo/trial and give it a
go. I've heard good things regarding their tools for non-MF platforms and
wonder if the MF version(s) is/are just as good.

Cheers,


Raymond Bell
Database Administrator


This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned.

Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom.

Representative only of the Legal & General marketing group, members of which are regulated by the Financial Services Authority for the purposes of advising on life assurance and investment products bearing Legal & General's name.
Legal & General Group PLC, Temple Court, 11 Queen Victoria Street, London, EC4N 4TP.
Registered in England no: 166055.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tom Willis

Re: Quest Central for DB2 (OS/390 and z/OS)
(in response to Raymond Bell)

Raymond, I have been a DBA for 8 years on OS/390 and am currently working on UDB Solaris and have used quite a few different DBA tools over the years and far and away the best tool I have used is Quest Central.  Its almost not even a contest between that and any other product.  Unfortunately I cannot speak to its use on OS/390 but if its close to what it can do on the Unix platforms then its well worth it.

Hope this helps

Tom Willis
Database Analyst Consultant Email : [login to unmask email] From: "Bell, Raymond" Reply-To: DB2 Database Discussion list at IDUG To: [login to unmask email] Subject: Quest Central for DB2 (OS/390 and z/OS) Date: Tue, 30 Dec 2003 10:49:43 -0000 Colleagues, Does anyone have any experience with Quest Software's product, Quest Central for DB2? Specifically the one to administer DB2 on OS/390 and z/OS. I see from a casual glance at their website the only version that would be appropriate for what we want would be the Professional Edition. Does anyone (that's not a sales person) have any comments to make regarding the product? This is just a feeler-type question. The purse strings haven't even been looked at, let alone prised open, so it's still very early days. But if the word is good, maybe I'll download the 50MB v3.1.1 demo/trial and give it a go. I've heard good things regarding their tools for non-MF platforms and wonder if the MF version(s) is/are just as good. Cheers, Raymon d Bell Database Administrator This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned. Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom. Representative only of the Legal & General marketing group, members of which are regulated by the Financial Services Authority for the purposes of advising on life assurance and investment products bearing Legal & General ' s name. Legal & General Group PLC, Temple Court, 11 Que! en Victo ria Street, London, EC4N 4TP. Registered in England no: 166055. --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Worried about inbox overload? Get MSN Extra Storage now! --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Dale Hardy

Re: Quest Central for DB2 (OS/390 and z/OS)
(in response to Tom Willis)
We are primarily a DB2 OS/390 shop and have had Quest Central V3.1.1 for about 6 months. Our prime motivation for getting it was to have automate migrations and alterations from devwelopment to QA and production.

Our application tend to have a lot of dependent views, aliases, triggers and stored procedures and the tool does an excellent job of identifying all the dependent objects for a table or a set a tables; creating a migration script(s) and executing the migration. It does a great job of extracting SQL from both the performance monitor and directly from DBRMs into a SQL tuning session, where you can modify, execute, explain and compare the performance of different versions of the SQL.

It can run almost all the DB2 utilities (MODIFY RECOVERY, MODIFY STATISTICS, MERGECOPY & REPAIR are the exceptions). It can optionally migrate a script and execute it from a PDS member on the mainframe, but we found it to be a lot easier to execute it from windows, even if it requires re-starts. It also will not run the stand-a-lone utilities such as DSN1COPY. We bought it for the DBAs but gave it to all the developers, who use it to clone tables to their own databases, as a query tool, table editor, and SQL tuning. I do not know if the trial version will let you test all the features. In order to create and execute migrations, alterations, the space manager and the performance monitor you need to install the mainframe components which also require their own WLM.

Over-all it is a very good tool. We use it heavily and only have to log on to the mainframe to execute the long running or REPAIR utilities or to deal with unsupported features such as lobs, clobs and XML

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Bell, Raymond
Sent: Tuesday, December 30, 2003 5:50 AM
To: [login to unmask email]
Subject: Quest Central for DB2 (OS/390 and z/OS)


Colleagues,

Does anyone have any experience with Quest Software's product, Quest Central
for DB2? Specifically the one to administer DB2 on OS/390 and z/OS. I see
from a casual glance at their website the only version that would be
appropriate for what we want would be the Professional Edition. Does anyone
(that's not a sales person) have any comments to make regarding the product?

This is just a feeler-type question. The purse strings haven't even been
looked at, let alone prised open, so it's still very early days. But if the
word is good, maybe I'll download the 50MB v3.1.1 demo/trial and give it a
go. I've heard good things regarding their tools for non-MF platforms and
wonder if the MF version(s) is/are just as good.

Cheers,


Raymond Bell
Database Administrator


This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned.

Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom.

Representative only of the Legal & General marketing group, members of which are regulated by the Financial Services Authority for the purposes of advising on life assurance and investment products bearing Legal & General's name.
Legal & General Group PLC, Temple Court, 11 Queen Victoria Street, London, EC4N 4TP.
Registered in England no: 166055.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm