I have used Embarcadero products for a long time - they have DBArtisan as
a nice GUI tool for Administration as well as a change manager, job
scheduler, ER diagramming tool, and tools to help make your SQL more
efficient. They have been very robust and easy to use. I have used them
for MSSQL, DB2, Sybase, and Oracle.
Thanks,
Lisa Greetham
Database Administrator, Corporate Internet Group
Bank One
"Mullins, Craig" <[Email Address Removed] 01:07 PM
To: [Email Address Removed] cc:
Subject: RE: DB2 Newbie
If you are looking for a good method of implementing, managing, and
tracking
database changes, then take a look at BMC Software's Change Manager. This
product simplifies and automates change across multiple RDBMSs including
DB2
(mainframe and distributed), Oracle, Informix, SQL Server, and Sybase.
More
details can be found at:
http://www.bmc.com/products/proddocview/0,,0_0_0_2095,00.html
Craig S. Mullins
BMC Software
http://www.BMC.com
http://www.DBAzine.com
http://www.CraigSMullins.com
-----Original Message-----
From: Farnsworth, Dave [mailto:[Email Address Removed] Thursday, January 23, 2003 11:59 AM
To: [Email Address Removed] Dakshinamurthy Ghatikachalam;
[Email Address Removed] RE: DB2 Newbie
Does it also help in the tracking of change control? That is an area that
we erally need to get a grip on in our DB2, Oracle and SQL Server
environments.
Thanks,
Dave
-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Thursday, January 23, 2003 11:39 AM
To: Farnsworth, Dave; "Dakshinamurthy Ghatikachalam";
[Email Address Removed] RE: DB2 Newbie
Check out Quest. www.quest.com. I dont work for them but I like their
product. I am forced to support 4 DBMSs and db2/udb has by far the
biggest
hole in product line. Monitoring , managing etc + a really lousy GUI
makes
a good DBMS a real pain in the [Email Address Removed] to work with. Quest makes the day to
day
stuff manageable (changing objects, reorgs , finding/resolving locking),
it
installs easily and just plug in the IP address of the server and you're
done. In other words you can do it the hard way (RTFM) or the easy way
with
$$+Quest.
This is the lazydba.com correct?
"Farnsworth, Dave" <[Email Address Removed] wrote:
>RTFMing is fine. I did it with Oracle but my problem is I need a jump
start. That is where a class is very valuable because my timeline to
learn
is very short. I figure, take a class or two, get some familiarity with
the
system, and then I can RTFM for the rest. I just had a production system
handed to me so I need to learn fast.
>
>Dave
>
>-----Original Message-----
>From: Dakshinamurthy Ghatikachalam [mailto:[Email Address Removed] Thursday, January 23, 2003 8:15 AM
>To: [Email Address Removed] RE: DB2 Newbie
>
>
>Practically the get the expertise in DB2, the best
>resouces are its documents itself.
>
>I never took any Course,-- Just hands on just by
>reading online online manuals is far enough.
>
>Dak'
>
>--- [Email Address Removed] wrote:
>>
>>
>> I took that course in the 5 day version. It was
>> very good.
>>
>> Thanks,
>> Lisa Greetham
>> Database Administrator, Corporate Internet Group
>> Bank One
>>
>>
>>
>>
>>
>> "Stephane Paquette"
>> <stephane.[Email Address Removed] 01/20/2003 10:08 AM
>> Please respond to Stephane.Paquette
>>
>> To: "Dwayne Cox"
>> <[Email Address Removed] cc: <[Email Address Removed] <[Email Address Removed] Subject: RE: DB2 Newbie
>>
>>
>> We only went to the 2 day course.
>> If there is none with more days, I would recommend
>> it.
>>
>> Unfortunately, our project was canceled so back to
>> Oracle.
>> I would have like to go deeper in DB2.
>>
>>
>> Stephane
>> -----Original Message-----
>> From: Dwayne Cox [mailto:[Email Address Removed] Sent: Monday, January 20, 2003 10:09 AM
>> To: Stephane.[Email Address Removed] Cc: stephane.[Email Address Removed] [Email Address Removed] [Email Address Removed] Subject: Re: DB2 Newbie
>>
>>
>> Yes, it is thru IBM. I went to the office in
>> Atlanta. It was nice
>> as well but nowhere near as nice as the one in
>> Montreal, I'm sure.
>>
>> -D-
>>
>> On Mon, 20 Jan 2003 09:51:32 -0500
>> "Stephane Paquette"
>> <stephane.[Email Address Removed] wrote:
>>
>> > Yes, we went to IBM.
>> > The IBM building is one of the nicest in Montreal
>> (Quebec, Canada).
>> >
>> > Stephane
>> >
>> > -----Original Message-----
>> > From: Farnsworth, Dave
>> [mailto:[Email Address Removed] > Sent: Monday, January 20, 2003 9:47 AM
>> > To: Dwayne Cox
>> > Cc: [Email Address Removed] > Subject: RE: DB2 Newbie
>> >
>> >
>> > Is that a class through IBM??
>> >
>> > Thanks,
>> >
>> > Dave
>> >
>> > -----Original Message-----
>> > From: Dwayne Cox [mailto:[Email Address Removed] > Sent: Monday, January 20, 2003 8:48 AM
>> > To: Farnsworth, Dave
>> > Cc: [Email Address Removed] > Subject: Re: DB2 Newbie
>> >
>> >
>> > Hi Dave,
>> >
>> > A good book is DB2: The Complete Reference
>> (Complete Reference Series `)
>> > by Roman B. Melnyk, Paul C. Zikopoulos.
>> >
>> > As far as classes go, I recommend the Fast Path to
>> DB2 UDB for
>> > Experienced Relational DBAs. There is a three and
>> a five day version.
>> > Opt for the 4 day version. They cover more and
>> you should get a couple
>> > more manuals. I only attended the three day
>> course. It was good but
>> > I wanted/needed the material covered in the
>> additional two days.
>> >
>> > HTH,
>> >
>> > --
>> > Dwayne Cox
>> > Oracle Database Administrator
>> > Info Tech, Inc.
>> >
>> >
>> >
>> >
>> > On Mon, 20 Jan 2003 08:13:28 -0600
>> > "Farnsworth, Dave"
>> <[Email Address Removed] wrote:
>> >
>> > > I just inherited the DB2 databases that are on
>> an AS400. I am
>> currently
>> > the SQL Server and Oracle DBA. Can anyone
>> recommend a good database
>> > administration class that I can go to? I see on
>> the IBM site that they
>> have
>> > some but am not sure what admin classes are worth
>> going to. Would you
>> also
>> > recommend that I take an AS400 class also? I am
>> not very familiar with
>> the
>> > AS400. ALso, any good books on DB2 database
>> administration that anyone
>> can
>> > point me to.
>> > >
>> > > Thanks,
>> > >
>> > > Dave
>> > >
>> > >
>>
>---------------------------------------------------------------------
>> > > PLEASE CLICK REPLY-ALL TO SEND A REPLY TO
>> EVERYONE
>> > > To unsubscribe, e-mail:
>> db2udbdba-[Email Address Removed] > > For additional commands, e-mail:
>> db2udbdba-[Email Address Removed] >
>> >
>>
>---------------------------------------------------------------------
>> > PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>> > To unsubscribe, e-mail:
>> db2udbdba-[Email Address Removed] > For additional commands, e-mail:
>> db2udbdba-[Email Address Removed] --
>> Dwayne Cox
>> Oracle Database Administrator
>> Info Tech, Inc.
>> 5700 SW 34th Street, Suite 1235
>> Gainesville, FL 32608
>>
>> email: [Email Address Removed] phone: 352.381.4521 fax: 352.381.4444
>>
>>
>>
>---------------------------------------------------------------------
>> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>> To unsubscribe, e-mail:
>> db2udbdba-[Email Address Removed] For additional commands, e-mail:
>> db2udbdba-[Email Address Removed] This transmission may contain information that is
>> privileged, confidential and/or exempt from
>> disclosure under applicable law. If you are not the
>> intended recipient, you are hereby notified that any
>> disclosure, copying, distribution, or use of the
>> information contained herein (including any reliance
>> thereon) is STRICTLY PROHIBITED. If you received
>> this transmission in error, please immediately
>> contact the sender and destroy the material in its
>> entirety, whether in electronic or hard copy format.
>> Thank you.
>>
>>
>>
>---------------------------------------------------------------------
>> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>> To unsubscribe, e-mail:
>> db2udbdba-[Email Address Removed] For additional commands, e-mail:
>> db2udbdba-[Email Address Removed] you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscape.com/ns/browsers/download.jsp
Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
DB2 & UDB email list listserv db2-l LazyDBA home page