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 :)
The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
Keep on Learning
From archive: June 2007 X
svisser1 2700018UK9 3,996 Views
svisser1 2700018UK9 4,195 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 4,307 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 4,274 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 4,082 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.