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.
Keep on Learning
svisser1 2700018UK9 2,675 Views
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.
svisser1 2700018UK9 3,396 Views
Willie Favero gave an excellent summary of the best speakers at IDUG NA last week, but I don't remember seeing the complete list.... Melanie Stopfer who is on my extended team, was one of the top 10 speakers! Congratulations!
During the conference closing session on Thursday, May 10, IDUG announced the best-rated presentations from the conference. Listed in alphabetical order, the top 10 DB2 technical session presenters for this event, based on evaluations received from attendees, were:
• Bonnie Baker, Bonnie Baker Corporation • Leon Katsnelson, IBM • Bob Lyle, IBM • Dale McInnis, IBM • Roger Miller, IBM / Chris Munson, IBM • Bryan Paulsen, John Deere Corporation • Terry Purcell, IBM • Suresh Sane, DST Systems, Inc. • Bryan Smith, IBM • Melanie Stopfer, IBM
Congratulations to all the speakers!
PS..... I underlined the people who I've had the pleasure to work directly with over the past few years.
svisser1 2700018UK9 2,833 Views
The May 2007 DB2 Magazine Email Newsletter contains a number of excellent articles including:
IN THE MAY 2007 ISSUE:
1. From the Editor: DB2 Magazine gets the community spirit2. Poll Positions: Rate your company's information security efforts3. Asked and Answered: How do you clone just a portion of a database?4. Skills Set: News and information about IBM education5. Must Read: DB2 9 Fundamentals6. In the Zone: The latest articles on DB2, Informix, U2, and more
Of significance is the new DB2 Magazine Community Wiki... a great place for you to post your favorite tips and tricks for working with DB2, Informix, U2, Cloudscape, and related tools and solutions. Today, the DB2 Magazine Community Wiki is something of a blank slate. With your help, we can compile the best online technical resource for IBM information management software outside of IBM.
The mission of this wiki is to gather DB2, Informix, U2, Cloudscape and other IBM information management know-how and make it available to the DB2 Magazine community.
Thanks to Kim and her amazing team for continually making this magazine a must read!
The latest Certification Today ejournal was recently published on the ibm.com/certify website. In this journal you'll learn about all the latest IBM certification exams, study resources, and offers that are available to you.
If you were one of the many people to take an exam at an IBM conference or an employee who took an exam at one of the Labs, you likely used the PRIME system. Did you know that you may log into PRIME at any time, using the username and password that you indicated when you created your profile. From this site, you may change any of your demographic information plus you can review the score reports for any exam that you took using PRIME (under that username and password, of course).
If you don't remember your username or your password, you may recover them from this site as well. If you choose Method # 2, you won't need to have access to your mail system.
If you didn't take the exam through this system, you may find some of the same information through the Member Site on ibm.com/certify. Also from this site, you can request a missing certificate or merge IDs should you have multiple by mistake.
These may not be the tips that you were looking for... but they are questions that I seem to answer quite frequently.
svisser1 2700018UK9 2,683 Views
You must register ON or BEFORE May 15... You'll have the rest of the month to send in your proof of purchase:
Buy the IBM DB2 9 New Features Book & Save 50% off select DB2 9 Certification! For a limited time, when you purchase the newly released IBM DB2 9 New Features book (ISBN: 0072264594), you can receive a Professional Certification Voucher good for 50% off the list price of IBM DB2 9 Fundamentals Exam 730, or IBM DB2 9 DBA for Linux, UNIX and Windows Exam 731.
svisser1 2700018UK9 2,755 Views
A number of new classroom courses are now available from IBM to help you build your skills on DB2 9. Here are two of them:
Manage your XML data with DB2 9 -- Enroll in Course CG130 (US), CG13XX (Worldwide), and explore the non-traditional ways of using DB2 to work with native Extensible Markup Language (XML) data.
This 2-day course is designed to introduce you to non-traditional ways of using DB2 to work with native XML data. It is also designed to enable database administrators to manage the DB2-native XML environment.
You will learn how to store native XML data in DB2 and create XML indexes. Then you would analyze plan information for queries and take steps for improving query execution. The course also teaches how to manage the XML schemas and the techniques available for decomposing the XML documents.
DB2 9 for Linux, UNIX and Windows Performance Tuning and Monitoring Workshop -- In this 4-day class, you'll learn how to tune for optimum performance the IBM DB2 for Linux, UNIX and Windows relational database management system and associated applications for this environment.
Learn about DB2 9 for Linux, UNIX, and Windows in a single partition database environment. Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning. Use tools in class that are common across the Linux, UNIX, and Windows environments. During labs running on DB2 9, develop your ability to use monitoring tools, explain tools and DB2 utilities, such as RUNSTATS , REORG and db2batch, to tune a database running on your local Linux workstation.
IBM Education PackIf you are going to purchase training this year, purchase the IBM Education Pack-online account, and save big! The IBM Education Pack-online account is a prepaid electronic debit account that can automatically save you up to 10% on your IBM training. And with the precision payment option you get even greater flexibility with your account. That's like an extra $2,000 - $5,000 in IBM Training!
svisser1 2700018UK9 2,813 Views
I'm not at IDUG NA this week for a number of reasons, but a few of my team mates are there representing Education and Certification :)
Susan Dykman is keeping very busy giving primarily DB2 V8 and V9 certification exams, but is also offering other IBM exams as well.
Angela Moore is meeting people in the Expo to tell them about the latest classes, books, and tutorials that are available.
Lucy from Breakpoint Books is well stocked with the latest DB2 9 books such as:
1) IBM DB2 9 New Features2) Understanding DB2 9 Security3) DB2 9 Fundamentals Certification Study Guide
Susan Lawson and Roger Sanders taught Sunday education sessions to help people cram for their exams. Other authors I'm working with are there as well.
I hope if you are at the conference that you are finding it educational. If you have a story about certification, books, or something that isn't being covered by Willie or Chris, let me know.... I'll be happy to share your story :)
svisser1 2700018UK9 2,708 Views
Congratulations to Mark Wilding of the IBM Toronto Lab for his promotion to STSM! Mark Wilding is one of Information Management's top experts on problem determination, reliability, availability and serviceability. Mark's appointment to STSM is a testament to what he has accomplished leading the DB2 Linux/UNIX/Windows RAS/PD team. His innovation and leadership has driven a significant improvement in DB2 quality and RAS characteristics.
Learn from Mark's expertise by reading his book: Self-Service Linux: Mastering the Art of Problem Determination . Amazon has the book at a 34% discount right now and there are 5 excellent reviews posted for the book. Here are the headings provided in the amazon.com reader review section to give you an idea of how well-liked the book is:
* The high art of problem investigation and software debugging, June 14, 2006* Required reference for power users and administrators, December 15, 2005* Will likely have a long shelf life..., November 14, 2005* Nice chapter on explaining GDB , October 16, 2005* I don't give 5 stars lightly, October 13, 2005