Reviews (2)

If you want to learn DB2/SQL this is a MUST HAVE
Buy this book!!! ... I wanted All You Need To Learn DB2
This is an excellent resource for all those baffled programmers who need to learn DB2 fast. Thos book provides clear-cut examples, syntax, and the results of the various SQL commands that are most likely to be needed byany programmer. All the basics from simple SELECT statements are coveredall the way up to ORDER BY clauses, joins and so on. A special chapter onusing SPUFI was also a big help. The emphasis here is on the COBOL languageand mainframe computers, but it is an excellent learning tool for anyone.The book teaches by example and can be finished easily within a week (Theexample programs are what make it look so big). A must-read for anyoneinterested in relationall databases. ... Read more

Subjects:  1. COBOL (Computer program langua    2. COBOL (Computer program language)    3. Computer Books: Web Programming    4. Computers    5. Computers - Languages / Programming    6. Database Management - General    7. Database management    8. IBM Database    9. Programming - General    10. Programming Languages - COBOL    11. Programming Languages - SQL    12. SQL (Computer program language    13. SQL (Computer program language)    14. Sql (Programming Language)    15. Cobol    16. Database software    17. SQL   

Reviews (4)

Want to advance your DB2/SQL skills?A "MUST HAVE"!
Buy this book!!! Some computer books are written by computer geeks who know An excellent choice.You get MORE than your money's worth!
Buy this book!!!Some computer books are written by computer geeks who know their technical stuff cold.They can't teach worth a darn, but they are deep technical wizards highly versed in techno-babble.The people who wrote the Murach series are NOT (let me repeat, the Murach folks are NOT) such people.It was the most amazing experience to have read this book, and to have the feeling that either Curtis Garvin or Anne Prince were looking directly over one's shoulder anticipating the various questions that inevitably arose.This book is incredibly well structured.It is written clearly, concisely, and with relevant in-depth examples.The authors take pains to ensure that they present their programming examples without (WITHOUT!!!) falling into the trap of disjointed techno-babble so common to such books.Again, you get more than your money's worth with this book.Buy it, and recommend it to anyone else who wants to learn or refresh their DB2/COBOL skills.

DB2 for the COBOL Programmer
I started a new job and needed to learn DB2 in a hurry.I bought part 1 and part 2.I was coding in no time.But the best part is they make excellent reference books because they are laid out so well.These books are well worth the investment. ... Read more

Subjects:  1. Cobol (Programming Language)    2. Computer Books: Web Programming    3. Computers    4. Computers - Languages / Programming    5. Database Management - General    6. Programming Languages - COBOL    7. Relational Databases    8. Cobol    9. Database software   

Reviews (5)

It would be a MUCH better book with a different title
While this work may be "The Official Guide" it is a long way from complete or authoratative. It is much more of an overview than a guide. It is an excleent overview or enhancements book for readers with a technical background.
A great TECHNICAL review of DB2 UDB V8
This is a great book for what I do. I needed to keep on top of the new features in DB2 -- though for the wrong reasons (we are an Oracle business partner), I def'ly got to see all the new features with deep technical explanations and even examples; pretty neat stuff from IBM I must say. I looked at the What's New Guide that was referenced in other comments before buying this book, hoping to save a buck. Too bad they don't have a review forum for that book, horrible. All marketing fluff. Don't bother trying to find it -- it will only make you mad. Buy this book.

Already covered in What's New Guide
I was disappointed in the depth of the material. I had already read the What's New manual and found much of that repeated here. ... Read more

Subjects:  1. Certification    2. Computer Books: General    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database management    7. Electronic data processing per    8. Electronic data processing personnel    9. IBM Database 2    10. Relational Databases    11. Study guides    12. Computers / Database Management / General    13. Databases & data structures    14. dBase   

Reviews (19)

good reference book
I use it frequently when I want more details, use it in addition to redbooks and manuals

Very extensive
[A review of the 5th EDITION 2004.]
Great Reference Book
This book was very useful in providing me a greater understanding of the material. ... Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Database management    6. IBM Database 2    7. Relational Databases    8. Computers / Database Management / General    9. dBase   

Reviews (4)

DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition
Has been extremely helpful. Good information

A very good book on DB2 SQL PL
I didn't know anything about writing DB2 stored procedures until I bought this book. After reading it I have written several procedures to aid in data migration. It is well laid out and has all the necessary information. The best part is that you don't feel like you are reading a technical book.

embed yourself in db2
The book describes IBM's Procedural Language, which runs on their db2 servers. It is not a general purpose language, like C or Java. Rather, it is tied directly to db2 and IBM's implementation of SQL. But within this context, the book explains the expressive power of PL. It shows at length how you can write stored procedures, triggers and functions in PL. The level of detail and the cited examples should reassure you of PL's capability.
Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Database management    6. Programming Languages - SQL    7. Relational Databases    8. SQL (Computer program language)    9. Sql (Programming Language)    10. Computers / Database Management / General    11. Database software    12. SQL   

Reviews (11)

Good Book for Exam 700
I took the exam within one month from the day I bought this book and scored 87%.Read the book twice and took the sample test on IBM site.

Just what you need
Great book. covers everything you need to know for the exam. Completed one chapter each day after reading the tutorials on the IBM site and gave the questions at the back. Wrote the exam on the 8th day and got 92%. Will definitely recommend the book

A very good book for exam 700
This book helped me to prepare for the exam well but I felt this book should have had some more information about UDT /UDF .
Read more

Subjects:  1. Certification    2. Computer Books: General    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database management    7. Electronic data processing per    8. Electronic data processing personnel    9. Examinations    10. IBM software    11. Information Storage & Retrieval    12. Relational Databases    13. Study guides    14. Computers / Database Management / General    15. Databases & data structures    16. dBase   

Reviews (9)

Worst Book
When I first started with DB2, this book was recommended to me by someone who read the v7.2 book by the same authors.This was the most confusing techie book I have ever read.Amongst all the typos, my biggest gripe is the index.You may as well rip the index out of the book because it is useless.There hasn't been one time where I wanted to look something up, referring to the index, and found what I was looking for.Its like a 900 page book with a 7 page index... useless.

NOT a good book
So it claims that Chapter 1-8 covers the objectives for Exam 700. It should have said - and MORE, SO MUCH MORE. Which borders on garbage.
Lo que necesitas para certificarte/What you need to get certified
Realmente estoy muy complacido con este libro, el cual me ha servido para prepararme y poder certificarme, lo recomiendo ampliamente.
Read more

Subjects:  1. Certification Guides - General    2. Computer Books And Software    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. IBM Database 2    7. Interactive & Multimedia    8. Relational Databases    9. Computers / Database Management / General    10. Computing and Information Technology    11. Databases & data structures    12. Object-oriented programming (OOP)    13. dBase   

Reviews (15)

Not for Mainframe DB2
I should have done my homework before i bought this book. If you are using db2 on the mainframe im not sure you will find this book too helpful as it caters to windows and linux users. Im very new to db2 and did not find this book that helpful as far as laying down the basics.

DB2 Simplified
I found this book extremely comprehensive.The use of screen captures in partnership with textual descriptions are so much better.Bravo to those who took the time to create a fantastic learning and reference tool!

The book lives up to its name
This book has something for every level of DB2 expertise from beginner to intermediate to expert.The books name implied there would be lots of visual images and the books was loaded with charts, pictures and screenshots.These make learning about DB2 much easier and more fun, than reading plain text. Read more

Subjects:  1. Computer Bks - Data Base Management    2. Computer Books: Database    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. IBM Database 2    7. Relational Databases    8. Computers / Database Management / General    9. dBase   

Reviews (16)

Quick,, Handy Reference for a former DB2 for z/OS DBA
If you are coming from mainframe DB2, this is the book for you. Phil Gunning does a great job of explaining the many parameters and settings that make up DB2 UDB. Explanations are clear and straight to the point. It helped me to understand the DB2 UDB architecture and to get up to speed quick.

Good Tips from A DB2 Veteran
This book has helped my get started on monitoring and tuning my databases. Coming from Sybase, I had no idea where to start. I picked up this book and it guided me through all the monitoring setups and provided a monitoring and tuning methodology -- along with recommendations. This stays on my desk and is very handy.

One of a Kind
This book is really well organized. The section on logical and physical design was a good review for me. It reminded me how important a good design is to a successful database implementation. The SQL Tuning, Buffer pool tuning, and DB and DBM CFG tuning chapters have helped me take care of my problem databases and suboptimal SQL. ... Read more

Subjects:  1. Certification    2. Computer Books: General    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database management    7. Electronic data processing per    8. Electronic data processing personnel    9. IBM Database 2    10. Microcomputer Operating Environments    11. Operating Systems - General    12. Operating Systems - UNIX    13. Operating Systems - Windows    14. Operating systems (Computers)    15. Relational Databases    16. Study guides    17. Computers / Database Management / General    18. Databases & data structures    19. Systems management   

Reviews (15)

Worthless
Very disappointed with the book, returned it within a week. Written in a rambling and scatter-brained manner, gives no clear details of database creation or errors regarding db2X commands. May be useful for advanced users but Oracle DBA's wanting a quick insight into DB2 database creation and administration, stay away. Goes into other aspects of DB2 very well, but pointless if you are not taught how to create/troubleshoot the damned database in the first place.

Excellent book for Beginners
I bought this book when I started out in DB2.It's interesting, humorous style made for easy-reading and I covered most of the book within 2 weeks.This book is not a reference text or a thorough description of the more advanced areas of DB2, but covers the entry level to intermediate levels brilliantly.

Good rewrite of basics, advanced stuff not complete
As an experienced DBA and DB developer in just about every major DB product except DB2, I was disappointed that there is no book on the market explaining "in DB2, feature A works like this; feature B goes like that; feature C is entirely unique, etc. etc."Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. General    6. IBM Database 2    7. Information Storage & Retrieval    8. Relational Databases    9. Computers / Information Storage & Retrieval    10. Database software    11. Databases & data structures   

Subjects:  1. Computer Books: Internet General    2. Computer security    3. Computers    4. Computers - Computer Security    5. Computers - General Information    6. Data protection    7. Database Management - General    8. Database security    9. Internet - Security    10. Security    11. Security - General    12. Computers / Security    13. Data security & data encryption   

Reviews (13)

Best book available for DBAs working with DPF
I used this book to write Exam 704 (Advance DB2 UDB DBA certification). I cleared the exam with flying colors.
Absolutely the best DB2 book!
I just found this book, and after reading it wish I had found this years ago.This is the most comprehensive book on DB2 that I have ever seen.This book has already saved me a lot of time. The performance chapter is great and helped me improve the performance of my DB2 server by over 30% in less than a week.

Excellent book
This is the book I was waiting for long on DB2UDB. This not only covers topics for certifications but also good (very good) reference material for all UDB DBAs on LUW platform. ... Read more

Subjects:  1. Certification    2. Certification Guides - General    3. Computer Books: General    4. Computers    5. Computers - Data Base Management    6. Database Management - General    7. Database management    8. Electronic data processing per    9. Electronic data processing personnel    10. Examinations    11. IBM Database 2    12. Relational Databases    13. Study guides    14. Computers / Database Management / General    15. Computing and Information Technology    16. Databases & data structures    17. Systems management    18. dBase   

Reviews (4)

A practical quick introduction
A very practical and focused book, that can quickly get you up and running with the basics of using dB2. There are two roles described here. One is that of the Database Administrator. You'd be the person to act as sysadmin of a dB2 database. Doing the install and later creating users with various privileges, and in general keeping an eye on things. Corresponds exactly to being sysadmin of a computer. DBAs aren't made in 21 days
...and certainly not by the tame treatment of DB2 database administration found in this tome. *Not* worth the money or time to read it....competing titles are much better to assist in learning DB administration.

No way to learn the product in 21 days
There is no way that this book will make you a good DBA in 21 days.It teaches very basic concepts but not enought to help a true DB2 DBA on the job. ... Read more

Subjects:  1. Computer Books: General    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. IBM Database 2    6. Relational Databases    7. Computers / Database Management / General    8. Databases & data structures   

Reviews (2)

The Official Introduction to DB2 for z/OS
This book is a good primer for anyone who is just beginning to work with DB2 for z/OS.It covers all the basic concepts well, however if you are looking for a detailed reference book, this is too basic.

A great introduction...
This book is a great introduction to a very complex product and subject.There is so much more to learn about DB2 on the z/OS platform, but this book does a fine job of getting you started. ... Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Database management    6. IBM Database 2    7. Operating Systems - General    8. Os/2 (Computer Operating System)    9. Relational Databases    10. z/OS    11. Computers / Database Management / General    12. dBase   

Reviews (3)

Best book on the subject
Besides getting you ready for the certification examination this book is an excellent reference source and covers some material far better than other similar books on the market. If you only want to buy a few books on this subject, start with this one. You may find you don't need any others.

Excellent
This is an excellent book that gives an overall picture of what to expect for the z/OS 702 Examination. The certification portions have all been covered well. Except for a few typos in a few places, this book is an excellent material and is a handy book for a DBA. I certainly recommend it to anyone wishing to pursue DB2 702 certification.

Excellent Material:
This is an excellent book that gives an overall picture of what to expect for the z/OS 702 Examination. The certification portions have all been covered well.
Read more

Subjects:  1. Computer Bks - Data Base Management    2. Computer Books: Database    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Computers / Database Management / General    7. Computing and Information Technology    8. dBase   

Editorial Review

IBM's competitor in the database server wars is DB2, and an IBM certification that proves your skill with that database is valuable in any IBM shop. Read more

Reviews (12)

Excellent Book but Nearly Obsolete!
This is a title that's desperately needed, but it's November 2005 and DB2 is bordering on version 8.3 or 9.1 already. Where's the update? I know, I know. People say 8.2 isn't THAT different. I disagree, especially if I'm going to shell out $30 shipped.

You cannot afford not to buy this book for your 512
You cannot afford not to buy this book for your 512. A must have. Make sure you read everything, the author has extracted all the goodies from the exam and put it into this brief book. Excellent help for passing DB2 Certifications!
I truly got my money's worth from this book...I passed 2 exams based on this book's study guides and practice tests.Especially wonderful tips are included for areas they like to pose 'trick' questions on to make sure you know the difference between ORDER by and GROUP by, for example.Those tips were right on the money.It made it easy for me to refresh my skills and very confortable with what the tests were like, so that did not add to my nervousness.It is true they don't have the most up-to-date information....they should keep it up and come up with the new version 8 features, and a book for the Advanced tests. ... Read more

Subjects:  1. Certification Guides - General    2. Computer Bks - Certification    3. Computer Books And Software    4. Computers    5. Computers - Certification    6. Database Management - General    7. Database management    8. IBM Database 2    9. Relational Databases    10. Computers / Technical Skills    11. Computing and Information Technology    12. dBase   

Editorial Review

Read more

Reviews (9)

Very good Intro to DB2
If you aren't a database expert and you want to learn DB2, this book will do it.After using this book, you will be able to use DB2 very effectively.The authors did a great job. Horrible customer service at publisher of the Dummies books
The book itself might be fine. I don't really know yet as I've been waiting for TWO WEEKS to get a replacement CD for the defective one that came with the book. The problem with the CD is that once you uploaded DB2 from it, you couldn't actually USE DB2 because you get a 'license has expired' message whenever you try to create or DO anything with the software. An error that could have been caught if ANY Quality Assurance had been performed. I called the 800 number they give you in the back of the book (800-762-2974) and got the 'Wiley Customer Care Center'. Red flag goes up. The guy on the phone was responsive, no problem, they'll send out another CD. But "Oh yeah, I think they fixed that problem"? One would HOPE so you know? 8 days later I get an invoice in the mail confirming that I've ordered the CD. They say to allow 7 business days for it to arrive. On the 8th business day, I phone back. "It was sent on the 7th (the day after my initial phone call), give it another couple of days." I gave it another couple of days. No CD. I phone back. My third call. "We don't have that CD in stock." They couldn't tell me this TWO WEEKS before? The lesson here? DON'T BUY THIS BOOK NEW. Buy it with a CD that has already been used. Or, if you buy ANY 'for Dummies' book new (that comes with a CD), phone 800-762-2974 to find out if there are any 'problems' with the CD FIRST. They found a CD lying around for my copy of 'DB2 for Windows for Dummies' but they "couldn't" overnite out to me. I have to wait another 7 business days for them to send it out by hitchhiker.

A good quick reference!
I admit it, I am biased. I know Lily so take my review with agrain of salt ;-). However, I am a DB2 for UDB application developer/tester , and I love this small light weight book . It is a good summary and lets you know where to go for more info. ... Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Database management    6. IBM Database 2    7. Relational Databases    8. Computers / Database Management / General    9. Databases & data structures    10. dBase   

Reviews (4)

Wating for version 7 update
Must have book , excellent ! This Book Is GREAT!!!
Our company uses this book as the DB2 reference bible! We recently had a DB2 failure and could not find reference to the problem in any DB2 manual. We found the answer to our problem in this book - saving us several thousands of dollars and many hours of downtime. Everyone has a copy on their desk and uses it for everyday activities for all DB2 platforms.

DB2 Answers! : Certified Tech Support (Osborne's Answers Ser
It is not for you, if you are not using DB2 on OS/390 and you are not an absolute novice to the Database world. It talks only about the IBM Mainframe, does not cover UNIX, NT and OS/2 well. Does not cover any topic in substantial details. Read more

Subjects:  1. Computer Bks - Data Base Management    2. Computer Books: Database    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database management    7. IBM Database 2    8. Database software   

Reviews (2)

Good explanation of DB2 high availability features
Having seen Chris talk at several IDUG events, I knew he had a deep knowledge of DB2 and its high availability features.This book highlights that knowledge.
A lot more to dB2 than just standard SQL
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.Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Relational Databases    6. Computers / Database Management / General    7. Database software   

Reviews (4)

A must-have !
I wish I had this book as soon as it was published. After programming on the S/38 and the AS/400 (in RPG) for over 14 years now (with some interruptions), I consider this one the best AS/400-related computing bookI have purchased - ever! And compared to other computer books, well, ifonly that kind of quality would be available on other topics as well morefrequently, either DBMS's or programming languages. The book saved one ofmy clients hours of work: with no previous SQL knowledge but having thisbook they were able to do some work with SQL that otherwise would haverequired them to write a program. Another client (and myself for my ownsystem) took advantage of the chapters on Referential Integrity. If you'reserious about accessing your data on your DB2/400 database, you owe it toyourself to buy this book !

Encore! Encore!
It has become my daily Bible in my job as an AS/400 DBA.Even after reading the whole book last winter, I still seem to read a passage from it everytime I need inspiration on doing something new or different (or that Ican't remember how it is done) with DB2/400. If you program the AS/400, you need this book!
Having programmed the AS/400 since its inception, I thought I knew everything about the DB2/400 database. But Conte's insightful volume reveals new possibilities and capabilities. Read more

Subjects:  1. Computer Books: Database    2. Computer Books: General    3. Computers    4. Computers - Languages / Programming    5. Data Modeling & Design    6. Database Engineering    7. Database Management - General    8. Database design    9. Hardware - Mainframes & Minicomputers    10. IBM Database 2    11. Programming - Software Development