Any website or book for studing IBM DB2 since I'm new to it and no database
experience.
Thank you for your reply.

- DT

Try DB2 for Dummies - It starts at the beginning and includes many examples


"DT" <odn@sinaman.com> wrote in message
news:bf98r7$eor2@imsp212.netvigator.com...
> Any website or book for studing IBM DB2 since I'm new to it and no
database
> experience.
> Thank you for your reply.
>
> - DT
>
>
>

"Mark A" <ma@switchboard.net> wrote in message
news:Z4XRa.38$eI1.59679@news.uswest.net...
> "Erik Hendrix" <hendrix_erik@hotmail.com> wrote in message
> news:57a0830215afe13627e71216f4e96d39@free.teranew s.com...
> > Actually, on books. Maybe 2 suggestions for some IBM people or so
> > interrested in writing a book:
> >
> > 1) A book about performance. Not like the redbook which just explains a
> > little bit, but real life experience. How to determine how well a
> production
> > system is doing. How well the disk IO is going, which tables are mostly
> > used, how to determine which indexes are not used at all, if you have a
> > bottleneck on the DB2 log process, how to detemine if you have enough IO
> > cleaners/servers, how fast their IO is going, how to find bottlenecks
when
> > inserts are going slow, how to benchmark things for testing and how then
> to
> > check your production system on which you can not do benchmarking, ....
> >
> > 2) A book on UDB and SAP (Unix/Windows) would be nice.
> >
> > If both books are good and go into detail (and real-life, examples, not
> just
> > explaining to look at this in the snapshot and if it's too high then do
> > this, if it is too low then do this), then you already sold 1 book to
me.
> >
> It's a lot more profitable to do a consulting engagement. Writing a book
is
> not profitable, and is only done by consultants to build credibility so
that
> customers will hire them. If one is very luck to get the book published,
one
> can expect about $2 per book in royalties. Most of the time the author
gets
> nothing if the book does not sell a minimum number of copies.
>
> Mark
> InfoStar Solutions LLC
>
>

But to be fair it really is difficult to write a good book on performance
tuning. There
are just so many variables that you can't really generalize except by just
describing the low level concepts and tools. You really do need an
experienced expert who can integrate those things with the actual
implementation. I'm not a DB2 person or even a performance person,
but I've worked on engagements where performance is an issue (and
when is it not? and in every case there has not been a "cookbook" way
of dealing with the performance issues. It's always been a process of
trying this, trying that, do some head scratching, and so on. In many
cases you need to come up with a really innovative solution to address
the performance, and again you really can't generalize such solutions.

A lot of the things that the original poster was talking about are
addressable with the existing DB2 tools, or with third party tools.
For example there is a freeware tool called, as I recall, iotest, which
will exercise your drives very extensively and thus will pinpoint
problems with the raw drive I/O. DB2 v8 has explain as well
as a tuning wizard.

And there is a DB2/SAP book, look at amazon. I'm not familiar with
it but amazon does have sample pages, and the sample index page
does have entries regarding performance.

Bruce