RE: DB2 Newbie

RE: DB2 Newbie

 

  

This was in today's copy of the DB2 Today newsletter.

--New zone: DB2 for Newcomers
New to DB2? Begin here for the big picture of how relational database
originated at IBM, where it is today, and where it's going. Then
check out our selection of articles and tutorials, written especially
for those less experienced with DB2.
http://www.ibm.com/software/data/developer/newcomers/


> -----Original Message-----
> From: [Email Address Removed] [mailto:[Email Address Removed] Sent: Thursday, January 23, 2003 12:22 PM
> To: Mullins, Craig
> Cc: [Email Address Removed] Subject: RE: DB2 Newbie
>
>
>
>
> 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/23/2003 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] Sent: Thursday, January 23, 2003 11:59 AM
> To: [Email Address Removed] Dakshinamurthy Ghatikachalam;
> [Email Address Removed] Subject: 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] Sent: Thursday, January 23, 2003 11:39 AM
> To: Farnsworth, Dave; "Dakshinamurthy Ghatikachalam";
> [Email Address Removed] Subject: 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] >Sent: Thursday, January 23, 2003 8:15 AM
> >To: [Email Address Removed] >Subject: 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] >>
> >
> >
> >__________________________________________________
> >Do 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] >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] >
> >
>
> __________________________________________________________________
> The 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] 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]
>
>
>
>
> 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]
>
DB2 & UDB email list listserv db2-l LazyDBA home page