Just a reminder to those of you outside of the United States, some of our publishing partners have set up local online bookstores that provide a discount, allow you to use your own currency PLUS reduce the duty, taxes, and shipping costs of the books. For details on all of the international sites, see ibm.com/software/data/education/bookstore/international.html.
For the direct URLs:
Europe, Middle East and Africa (EMEA) Orders: www.pearson-books.com/ibmpressbookshop/Canadian Orders: www.pearsontechnology.ca/DB2/
Keep on Learning
svisser1 2700018UK9 2,644 Views
svisser1 2700018UK9 2,633 Views
I posted information about this offer last month, but the publisher had a few problems on their end. These problems have been fixed, so I wanted to once again make you aware of this special offer:
Buy any two DB2 V8 books from the IBM Press Bookstore and save 50% off cover price as well as free ground shipping in the U.S. Be sure to make space on your library shelf for these invaluable resources. Quantities are limited, so order soon as this offer ends on July 31, 2007! Please be sure to enter the case sensitive promotion code: DB2DEALS during checkout to receive this discount.
As always, check out our bookstore page for the latest releases and offers: ibm.com/software/data/education/bookstore/
I'm on vacation next week - to all: have a wonderful Canada Day and Independence Day :)
svisser1 2700018UK9 2,675 Views
I was talking to Sam Lightstone yesterday about his book that published in March: Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more.
It covers DB2 very heavily, but also some competitive products (Oracle, SQL Server, and to a lesser extent some others).
From the back cover of the book:
The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration.
Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book.
Features* The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, 4th edition. * Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft). * Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!
Currently there are no customer reviews on amazon.com. If you have read the book and can give us feedback, post here or on amazon.
svisser1 2700018UK9 2,977 Views
Top 10 Reasons To Deploy DB2 9 For z/OS Now! is a 90-minute webinar that will examine the top 10 most compelling reasons that will convince managers, database administrators (DBAs), and application developers to install and deploy DB2 9 for z/OS as quickly as they possibly can!
DATE: Thursday, June 28, 2007TIME: 2:00 PM - 3:30 PM EDT
Featured speakers Troy Coleman of SoftBase and Roger Miller of IBM will review real-life success stories from companies already receiving significant benefits from using DB2 9 for z/OS and provide a live Q&A session for attendees.
The Top 10 Reasons to Deploy DB2 9 for z/OS Now! will be presented from the following perspectives:
Corporate Officers and Managers * Plug and play CPU cycle reductions with DB2 9 for z/OS* Business agility - new pureXML™ enables companies to include DB2 9 for z/OS into their SOA and XML application initiatives
Database Administrators (DBAs) * Improved database availability and performance including LOB, reorganization, backup and recovery, and partitioning enhancements* Easier role-based security and improved DBMS regulatory compliance* DB2 9 for z/OS enhancements to improve ERP application and data warehouse functionality and performance
Application Developers * Powerful new SQL enhancements including MERGE and TRUNCATE statements, INSERT and EXCEPT set operations, and spatial support for geographical data * Improved SQL and data definition compatability with other DB2s * PureXML adds a powerful SQL and XML interface to access all XML data stored in DB2 9 for z/OS.
To register for this event, please complete the following form: http://www.softbase.com/db2v9top10/
svisser1 2700018UK9 2,757 Views
Informix Dynamic Server (IDS) 11 was announced to the world on June 12. Thanks to hard work by the team, we were able to produce a 100-page book written by Carlton Doe that introduces all the latest features: IBM Informix Dynamic Server 11, The Next Generation in OLTP Data Server Technology. Did you get a copy of the book? Likely not.... we're only distributing the book through our marketing teams. If you want one, check with your rep or attend one of the many IDS events planned for the coming months. See the IDS 11 Launch page for further details.
svisser1 2700018UK9 2,696 Views
I spent the day presenting to Lab employees about the process of publishing external publications about IBM products and technology. I hope you feel that you reap many benefits from employees sharing their knowledge and experience in the form of articles, conference presentations, tutorials, white papers, redbooks, and published books. In most cases employees are asked to write this information while continuing to focus on their day jobs. This means that employees quite often give up their evenings, weekends, and vacations to write this information.
IBM very much appreciates these efforts and has recently promoted Paul Zikopoulos... not entirely because of his publishing efforts, but certainly that helped increase his profile! Congratulations to Paul! Congratulations and Thanks to all of our authors!
As always, here is the best website to go in order to see what books we've published to support the many products within Information Management: http://www.ibm.com/software/data/education/bookstore.
Since I volunteer to proctor exams to employees of the Toronto Lab, I quite often get questions about how to get certified. At this point the most common question is whether people who have not received any DB2 certifications, where should they start? Here is the path I recommend.
If you are using DB2 V8, start there. The exams are experienced-based, so you'll likely have an easier time preparing for the exam since you are using that level of product. The V8 exams are: 700, 701, 702, 703, 704, and 706
If you are using DB2 V9 and have little experience with previous releases, stay with the V9 path. The V9 exams are: 730, 731, 732, 733, 734, and 736
Exam 700 and 730 are equivalent in that they are fundamentals exams for their respective version and they are valid prerequisites for EITHER the V8 or V9 exams. But at least one of these must be taken.
If you want to be certified on BOTH V8 and V9, start with Exam 700 and follow the V8 path. Then all you need to do is to take the upgrade exam, 736 to upgrade to a DB29 DBA certification.
Exam 706 and 736 are upgrade exams. Exam 706 allows those certified as a DBA on DB2 V7 to upgrade with a shorter test. Exam 736 can only be taken by people who already have their V8 DBA cert. So you will not take this exam unless you wanted to get certified on both versions.
As for study materials, both versions have free tutorials. Book availability is a more difficult issue. The V8 certification guides were published by Pearson Education, and most of them are now out of print. Long story as to why they are out of print, but I'm trying to find a workaround. So if you are trying to buy a book and find that it isn't on amazon, you'll need to look for a used copy. If you have V8 books that you no longer need, consider passing them on to those who may need them.
Only one of the V9 study guides has published so far... the one for Exam 730. More are coming, but you'll have to wait till fall.
If you weren't able to follow all these exam numbers, you can find roadmaps and legends on www.ibm.com/certify. For all book information, see www.ibm.com/software/data/education/bookstore/.
As always, feel free to contact me if you need further information.
I've pretty much caught up with my work after a two week vacation to Tuscany, so hopefully I'll be able to post regularly again.
svisser1 2700018UK9 2,720 Views
Join us October 14-19th, 2007 at the Mandalay Bay Hotel and Convention Center in Las Vegas, Nevada for the econd annual IBM Information On Demand 2007 global conference. Book before the end of August to qualify for the discounted rate.
Attending the conference is a great way for you to learn about IBM's Information Management software, industry trends, and how to maximize the value of your existing investments. If you are an IT professional, a line of business manager, a developer or compliance officer, you won't want to miss this event.
See the agenda that provides 500 Technical Skill Building sessions, 120 Business Leadership sessions, the addition of the IBM ECM UserNet Conference, and an EXPO of more than 200 Business Partners. You'll have an opportunity to meet with experts to discuss topics of your interest, use our Hands On Labs to experiment and test solutions for your business, and utilize our Onsite Certification to enhance your personal skills. Attend our executive keynotes, breakout sessions and more than 130 demonstrations.
As for entertainment... that's in place as well: Dana Carvey will be our conference master of ceremonies; Steven Covey is our keynote speaker; and Donna Summer is the featured entertainer.
I hope you are able to make it to the conference for the learning opportunities, certification exams, networking, and of course, for a bit of fun in Vegas!
PS... Signing off for a couple weeks of vacation. Ciao![Read More]
The Version 9 books are slowly arriving, so now is your chance to pick up any Version 8 books that you may want for 50% off the usual price. Here are the details:
************************************************************SPECIAL OFFER - Save 50% on DB2 8 Books************************************************************
BUY any two DB2 8 books from IBM Press and save 50%, plus free ground shipping in the U.S. Make room on your library shelf for these invaluable resources, quantities are limited.
DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide, 5th Edition The V9 book will publish this summer. It is still worth buying this book if you have not yet earned your V8 certification.
Understanding DB2: Learning Visually with Examples, 1/e The V9 book is expected in the first half of 2008.
High Availability Guide for DB2 There are no plans to update this book for V9. The book is amazing, but is missing information on some of the latest features related to High Availability. It is still worth reading this book as you can find articles related to the missing features on dworks.
DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS There are no plans to update this book for V9. This is, however, an IBM Redbook about to publish. It is worth reading this book and getting the updates from the IBM Redbook.
DB2 for z/OS Version 8 DBA Certification Guide The V9 book is coming out this summer. It is still worth buying this book if you have not yet earned your V8 certification.
DB2 Universal Database V8.1 Certification Exam 700 Study GuideDB2 Universal Database V8.1 Certification Exams 701 and 706 Study GuideDB2 Universal Database V8.1 Certification Exams 703 Study GuideThis is an extremely popular series of books and excellent for helping you prepare for 4 of the 5 DB2 V8 Certification Exams. It is worth buying these books, if only for the library of sample questios! Also, there are currently no plans to create a study guide for the V9 Application Development Exam.
Official Introduction to DB2 for z/OS, The: Covers DB2 Universal Database for z/OS V8, 2nd EditionWhat an excellent way to come up to speed on DB2 for z/OS. The book is at the Version 8 level, but there are currently no plans to update this book for V9. There will be online help with the product... but get this book instead.
DB2 Express: Easy Development and AdministrationThere are currently no plans to update it for Version 9, but the DB2 Express team is looking into creating an electronic version that is similar to this book. This book is worth buying since it gets you up to speed very quickly in both the DBA and AD areas.
Quantities are limited. Promotion ends June 30, 2007. Click here for more details and for a complete list of the DB2 8 books on promotion.
For this offer and more, see our Offer Page
Several people have notified me that Prometric was listing our upgrade exam (Exam 736) for the price of $150 per take. This was an error and it's now been corrected.
Roger Sanders is currently working on follow-ons to his DB2 9 Fundamentals Certification Study Guide.... one for Exam 731 and one for Exam 736. These books will continue with the tradition started by Roger in that they'll contain as many sample questions as possible. The Fundamentals book just arrived last week at our site's library and there is already a huge waiting list for the book.... perhaps the library needs to buy more copies to keep up with the demand! I hope the book is as popular for your company as well. If not... it should be!
Speaking of Roger Sanders, Part 1 of his in-depth LBAC article can be found on db2mag.com: Understanding Label-Based Access Control, Part 1.