<< 1 >>
Rating: 
Summary: A lot more to dB2 than just standard SQL
Review: If you have been a sysadmin and are familiar with the concepts of full and incremental backups of an operating system, then this book's descriptions of dB2's abilities in this field are very impressive. dB2 offers far more fine grained control/resolution over the backing up of its data. Like the means of having circular or archival logging. So if you are just starting out as a dB2 administrator, you have quite a bit more to learn, just in this field.On a tangential note: Suppose you have your own non-database application, with its own native data file format, and you want to regularly save its activities. Try looking at the ideas in this book for how dB2 does its duties. You might be able to abstract out the ideas and reinstantiate them in your context. The book presents the right level of discussion for this. One caveat is that IBM has a portfolio of patents around dB2, and I do not know the extent that you might be able to implement some of the book's ideas without infringing on the patents. Of course, there is far more to dB2 than backups. The book goes into other topics. Like how to define and run a standby database, by sending log files to it in a systematic fashion. Or, how to make a "split mirror" warm standby. My overall impression is that IBM has engineered a vast amount of backup and availability into dB2, to handle almost any level of transaction load. There is a lot more to dB2 than just being able to handle standard SQL.
<< 1 >>
| 
