Just published: IBM DB2 9.7 Advanced Administration Cookbook by Adrian Neagu and Robert Pelletier.
This book was published by Packt Publishing and is available in several formats. The book contains over 120 “recipes” focused on advanced administration tasks to build and configure powerful databases with IBM DB2 V9.7. Although there is a new release coming out soon, there are many people still at the 9.7 level.
The book allows you to:
- Master all the important aspects of administration from instances to IBM's High Availability technology pureScale
- Learn to implement key security features to harden your database's security against hackers and intruders
- Empower your databases by building efficient data configuration using MDC and clustered tables
DB2 for Linux, UNIX and Windows offers industry leading performance, scalability, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. With lots of new features, DB2 9.7 delivers one the best relational database systems in the market.
IBM DB2 9.7 Advanced Administration Cookbook covers all the latest features with instance creation, setup, and administration of multi-partitioned database.
This practical cookbook provides step-by-step instructions to build and configure powerful databases, with scalability, safety and reliability features, using industry standard best practices.
This book will walk you through all the important aspects of administration. You will learn to set up production capable environments with multi-partitioned databases and make the best use of hardware resources for maximum performance.
With this guide you can master the different ways to implement strong databases with a High Availability architecture.
What you will learn from this book
- Learn to make best use of scalability with multi-partitioned databases
- Get to grips with advanced technological breakthroughs with RBAC, and pureScale technology
- Sharpen your troubleshooting skills
- Design and implement the best backup strategy
- Master the new exciting features added to the DB2 9.7 version
- Get step-by-step instructions to tune and optimize DB2 to achieve best performance
- Understand the database objects and their integration
This cookbook has recipes written in a simple, easy to understand format, with lots of screenshots and insightful tips and hints.
Who this book is written for
If you are a DB2 Database Administrator who wants to understand and get hands on with the underlying aspects of database administration, then this book is for you.
This book assumes that you have a basic understanding of DB2 database concepts.
About the Authors
Adrian Neagu has over ten years experience as a database administrator, mainly with DB2 and Oracle databases. He started working with IBM DB2 in 2002.
He is an IBM DB2 Certified Administrator version 8.1.2 and 9, Oracle Database Administrator Certified Master 10g, Oracle Database Administrator Certified Professional 9i, 10g and Sun Certified System Administrator Solaris 10. He is an expert in many areas of database administration such as performance tuning, high availability solutions, replication, backup and recovery.
In his spare time he enjoys to cook, take photos and catch big pikes with huge jerkbaits and bulldawgs.
Robert Pelletier is a Senior DBA Certified Oracle 8i, 9i, 10g, and DB2. He has twelve years experience as a DBA, as production/development support, database installation and configuration, tuning and troubleshooting.
He has more than thirty years IT experience in many applications in development in central Environments, client-server, and UNIX. More recently he has added expertise in Oracle RAC 11gR2, 10gR2, 9i, DB2 UDB DBA, ORACLE 9iAS, Financials, PeopleSoft and also SAP R/2 and R/3.
His expertise has been recognized by many major organizations worldwide, and he has a solid consulting background in well-known firms.
Previously I blogged about the benefits of getting certified. If, after reading that, you decide you want to earn a DB2 certification, what is the process?
Choose Job Role
First you need to decide what job role you’d like a certification for. For many people this is easy. If you work as a DBA, get the DBA certification… easy. But some people end up performing multiple roles in the course of their job. The primary job roles that affect DB2 users are: Academic Associate, Database Associate, Database Administrator, Advanced Database Administration, Systems Administrator Solutions Developer, and Application Developer.
My suggestion? If you are a student taking database courses, start with Academic Associate. From there start with Database Associate and the other job roles that may interest you. If you work with DB2 in any manner, start with Database Associate. These two job roles are least specific and can be taken by a very wide audience. The others will need much studying and / or experience in order to achieve.
Choose Exam Release
Many of the exams are available for different product releases. My suggestion would be to take the release that you are currently using. If you’re using DB2 9, you’re best choice would be to take the V9 exams.
Once you’ve decided on a certification role and exam, follow these instructions:
1. Read the exam objectives. The ibm.com/certify website lists the objectives for every IBM certification exam. Read these carefully as each question on the exam links directly back to one or more of these objectives! (That’s a huge hint!)
2. Use the recommended study materials to refresh your skills. For each DB2 exam, you can find the recommended study material on this site: ibm.com/software/data/education/certprep.html. Also see these blog entries:
3. Take an assessment exam. These exams cost $10 per take. See ibm.com/software/data/education/cert/assessment.html for the latest information.
4. Take the test. Where? IBM exams are offered worldwide at Prometric Testing Centers. To find a site near you call 1-800-959-EXAM or visit www.prometric.com.
5. If you do NOT pass, use the score report to determine the areas you need to increase your knowledge and start these steps over again.
6. If you PASS, make sure you let your manager know! Your results are confidential to YOU and no one will know you passed unless you tell them!
Once you’ve achieved a certification, your certificate will be sent to you via e-mail (or you will be sent instructions on how to retrieve the certificate from the Certification Member Site, if this is the first certification for this candidate/testing ID).
7. Determine if you want to take another exam to earn another certification.
** DB2 Certification exams are experience-based, so the more practical experience you have using DB2, the easier it will be for you to prepare and pass the exams.
Occasionally throughout the year, there are promotions available that you can take part in. You may find that there are free exams offered at a conference or user group meeting that you are attending, discounted vouchers, or take it again offers. I suggest that you check the promotion site to keep up to date with current offers.
Every year at the IBM Information on Demand Conference (IOD11) we have a Women in Technology event where conference attendees gather together to network and learn. Our host, Debbie Landers, will this year welcome Alyse Passarelli as our special guest.
Date: Wednesday October 26
Time: 6-7 pm PDT
Location: South Seas A-B Mandalay Bay South Convention Center
Session # 4106A
Appetizers and refreshments will be served and the theme this year is building relationships to stimulate ideas. Discuss how we can use existing relationships to drive innovation and progress in our products, services and business. Share your experiences and build a larger network from which you can draw from in the future.
I’ve been lucky enough to have met Debbie and Alyse several times over the course of my career, and strongly encourage you to come to this event to meet these very successful & real women.
Debbie Landers is IBM VP and Neteeza Integration Executive
Alyse Passarelli is IBM VP WW Information Management Sales
Thanks to Katherine Franklin, Jennifer Gibbs, and Adrian Zubiri for setting up this event. I hope you can make it. Bring a friend or two with you… or come alone and make a new friend!
It’s finally here!
DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes
by Roger Sanders
I can’t tell you how many people have asked for this book in the past few years! And look at the great price: Less than $15!
What’s in the book?
- All test objectives for this exam are covered in the same degree as they are covered on the exam.
- Roger was a member of the exam development team, so if fully aware as to what questions are on the exam!
- This book isn't like Roger’s previous books, rather this is a copy of the slides that he uses for his Crammer Courses to teach people at conferences what they need to know to pass the exam. The material has been tested multiple times and updated based on feedback from people after they’ve taken the exam.
What do you need to know to pass the exam?
This is an outline of the Exam Objectives. You can see the details on the website: Exam 541 Objectives
Section 1 - DB2 Server Management (10%)
- Demonstrate the ability to configure/manage DB2 servers, instances, and databases (e.g. scope)
- Demonstrate the ability to schedule jobs
- Demonstrate the ability to use autonomic features
Section 2 - Physical Design (20%)
- Demonstrate the ability to create a database and manipulate various DB2 objects
- Demonstrate knowledge of partitioning capabilities
- Demonstrate knowledge of XML data objects
- Demonstrate knowledge of compression
Section 3 - Business Rules Implementation (5%)
- Demonstrate the ability to create constraints on tables
- Demonstrate the ability to create views WITH CHECK OPTION
Section 4 - Monitoring DB2 Activity (15%)
- Demonstrate the ability to use Admin views and SQL functions for monitoring
- Demonstrate the ability to use Work Load Manager
- Demonstrate the ability to use additional auto-monitoring tools
- Demonstrate the ability to identify the functions of Problem Determination Tools
- Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
Section 5 - Utilities (15%)
- Demonstrate the ability to use the data movement utilities
- Demonstrate the ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
- Demonstrate the ability to use the DB2 Advisor utility
- Describe the purpose of Data Studio Administrator (basic concepts - replacing existing DB2 tools)
Section 6 - High Availability (20%)
- Describe DB2 data integrity actions
- Demonstrate the ability to perform database-level and table space level backup and recovery operations
- Demonstrate the ability to configure and manage HADR
Section 7 - Security (10%)
- Describe DB2 authentication
- Describe DB2 authorizations and privileges
- Describe the ability to set and remove user, group, and role authorities and privileges
- Demonstrate general knowledge of the Audit facility
- Demonstrate knowledge of the DB2 Security Infrastructure
Section 8 - Connectivity and Networking (5%)
- Demonstrate the ability to configure database connectivity
- Demonstrate knowledge of using JDBC/SQLJ connections with DB2
Roger Sanders was featured in the latest edition of the DM Magazine.
The Man to See About Certification - The guru of DB2 certification tests talks about how he puts them together—and how they can help your career
by Howard Baldwin
Q&A with Roger Sanders who has helped IBM develop 17 DB2 certification exams, more than any other individual. Want to know why certification is important? Roger Sanders is the man to ask. We talked to him about how the tests are put together, how they can help a DBA’s career, and—oh yes—about the certification test he failed.
I wrote an entry on my blog some time ago that I still recommend: Certification 101. I do need to update the entry to include the DB2 9.7 exams such as Exam 541, but the content is still accurate in most ways:
Benefits of Earning a Certification
New in Certifications
How to Prepare to Pass a DB2 Certification
Details about DB2 Certification Program
Once you are Certified... What Next?
Study Materials Electronically
Roger Sanders Books, Videos, and Crammer Course
Good luck on your exams!
IBM Cognos Analytics and Cloud Computing: Best Practices for Deploying
Cognos Business Intelligence to the IBM Cloud
by Anant Jhingran, Stephan Jou, William Lee,
Thanh Pham, Biraj Saha
This book introduces cloud computing, workloads in cloud computing, analytics as a service, and its implementation using Cognos Software and provides guidance and considerations for your cloud solution, such as “Where should the data be located” and “How many images should I create?” Step-by-step instructions on how to install, configure, secure and test a Cognos Business Intelligence deployment in the IBM Cloud are provided to help you get to a point where you have a saved private instance to an image that you can then deploy in minutes on demand.
Learn how to graduate from single images to multiple images and more complicated topologies that are better suited for production workloads and how to secure your Cognos cloud solution.
More advanced topics include moving from a single image to multiple images, scalability and performance, and how to plan for scaling to ensure a high performing solution. Finally, tip are provided to ensure that your Cognos BI cloud solution is highly available and handles failover scenarios.
Today I launched a Certification Checklist on My Developerworks
that you can use to track your progress on following the steps required to earn a certification: Getting Started Guide to DB2 Certification
You can use most of the steps in this checklist to track your progress
for any IBM software certification, but many of the steps are specific
to DB2. I would like to expand the list in the future, but started
with the basics. Please note that you'll need to be logged into My Developerworks in order to access and use the template.
What is a checklist template?
A Checklist template allows you to create a copy of the steps that must
be take to achieve a specific goal (in this case to earn a
certification). By creating a copy of the checklist, you are able to
check off the tasks as you complete them (or if they are not applicable
to you) so you can keep track of your progress. You can set specific
deadlines for completing each step and use My Developerworks to keep
you on top of the schedule.
This is the first checklist that I've created, so I'm sure there are
areas for improvement. If you have suggestions for how I can improve
this checklist, I'll be happy to hear from you.
Frances Pastuszenski was my mentor for creating this template and I encourage you to follow her checklist for "Getting Started with My DeveloperWorks
" and to read her blog entry about her checklist.
I subscribe to many newsletters and was reading through them this week..... the one that caught my attention the most was this:5 surefire ways to get fired by Denise Dubie
I don't want to get fired... and I'm sure most of you don't either! So, reading the article I found that one of the best ways to KEEP your job is by continually growing your skills! I can give plenty advice as to how you can grow your skills... and not all of them require a great deal of time or money!
I've blogged about how to get certified many times. The only thing I want to add at this point is that you can use the path to get certified as a roadmap for building skills. You will learn a lot but will also have validation that your skills are up to par by passing one or more certification exams. For further information on how to start, see my blog entry "Certification 101"
. To make it even more cost effective for you to get certified, we have Certification Days where exams are offered half price
, and a Try it Again offer
that allows you to retry your exam if you failed to pass. In my opinion, getting a certification is the FASTEST and most COST-EFFECTIVE way to build skills... bar none!
Travel is expensive, so take a look at the new way to take an IBM class where you choose the time, place, and best of all, no travel involved! Self-paced Virtual Classe
s are one option, ILO
classes are another. Right now, you can take a free SPVC
to see how it works.
Another very cost-effective way to build skills. You can buy a printed book, read a book online, borrow from a library... whatever works for you. There is a wide selection of books available... that cover just about every topic imaginable. For the entire list of books that we have available for Information Management topics, see either DB2 in Books
or IM Bookstore
. The online engines where you can read books are Books 24x7 or Safari Books Online. You can read more about these options in my blog entry
OK... a conference is very expensive... but is it really? If you factor in all that you get when you attend a conference, you may find that it is very cost-effective. The IOD conference has free certification exams, 400 technical sessions, demos... not to mention networking! See Kate's blog for a series of entries about the IOD conference
. Another option is to attend a virtual conference. I don't know of any that are scheduled at this moment...but when I learn about one, I'll blog about it. Sure it is quite different than attending a conference in person in a city away from your home / office, but it still provides some training, demos, and networking, but is usually free to attend.
So, please! Don't get fired because you've let your skills stagnate! Keep up to date with the many options that are available to you!
If you haven't yet upgraded your skills to DB2 V9, here is some incentive for you:
Today I received my copies today.... what a great book! Expert Preparation for Exam 734 - DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide
. This book contains everything you'll need to study for Exam 734
AND is full of reference details that go far beyond the exam!
With this book, you will:
• Gain the knowledge necessary to pass the DB2 9 Advanced Database Administration for Linux, UNIX, and Windows exam (Exam 734)
• Receive an explanation of every topic included on the test…by experts involved in the creation of the actual exam
• Find appendices with information beyond the test requirements on monitoring buffer pool activity, using MQTs, employing advanced joining techniques, and using the Explain Tools.
• Discover over 100 sample questions plus a 120-question practice exam, all with comprehensive answers and explanations
Congratulations to authors Dwaine Snow
and Roger Sanders
on the release of their latest book!
Thanks also to the team of reviewers who ensured that the book was accurate and had the quality that you demand:
Bob BernardRoger ArchambaultMelanie StopferMatthew RheaDan TuckAdil SardarNick TchervenskiEmilia CifaniSalma ElshatanoufyTariq Al-OmariKevin See
I received amazing feedback from a reader that I want to share with you:
This person took Exam 734 and didn't pass. She asked me for a recommendation, so I gave her an early version of the book on the condition that she would give me feedback. She read the book and tried the exam again... and this time passed. She says the book was essential to her passing the exam!
I can't send out an early version of the book to everyone, but this testimonial is very encouraging to me in my quest have quality, useful books published. I hope everyone who reads the book can say the same thing... and please say it publicly as we all benefit from your feedback.If you are attending IOD
, you can purchase a copy of the book while at the conference for a discount that is offered for attendees.
You can also meet the authors Roger E. Sanders
and Dwaine R Snow
and have them sign YOUR copy ofDB2 9 for Linux, UNIX, and Windows Advanced Database Administration...on Wednesday Oct 29, 1:30 – 2:30
at the Book Signing Area in Bayside Foyer.
Enjoy the book... and make sure you get your copy ASAP... they'll go fast!
Are you aware of the The Future Runs on ??????
Join the call to find out "what IS going on?" first hand. Join Bob Hoey
and Jim Stallings
tomorrow, February 26, 2008 at 02:00 PM
Eastern Standard Time. Audience members may arrive 15 minutes in advance of this time.
Hear about a new product that will be introduced.
PS, check out Kate's new blog
: www.ibm.com/developerworks/blogs/page/katedawson[Read More
ILO, ILO, ILO.... ILO everywhere! Have you noticed all the hype about this new learning method? Yesterday in a call with our VP going over the results of 2007, it was mentioned that there was a 120% increase in this type of education. And the feedback has be extremely positive.
I know that sometimes it is very nice to go away for education so that you can completely focus on the material away from the usual distractions of your job. But how many of us are able to "be away" for any period of time these days?
I like to promote self-study education through books... but know full well that not everyone is able to sit and read a book to learn what they need. We all have our preferred method of learning. Classroom education is a great way to be interactive with the instructor and to be driven with a purpose through the material that you need to absorb to learn the new skill.
With ILO (Instructor Led Online) Learning, you get the best of all.... live instruction, hands-on labs and group interaction with the convenience and cost savings of online and self-study training.
How does it work? ILO courses are taught by a live instructor on a specific date and time.
These courses are exactly the same as their classroom equivalent, including the course length, content and student materials. Students receive their course materials in advance by mail. To participate on the day of the class, all you need is a high-speed Internet connection. This allows you to connect to a virtual classroom enabling you to interact directly with the instructor to ask questions or clarify material...just as you would in a physical classroom.
Now that you know what ILO is... and hopefully you're interested in giving it a try.... answer the IDUG Instapoll
about this topic. You never know, it may be the start of a whole new way of building your skills.
I've been working with Aziz Shroff lately.... the owner of Shroff Publishers & Distributors Pvt. Ltd.
Shroff buys the publishing rights to retail books published in the US and reprints them in India using local people and resources, and pricing the books in the local currency.
Shroff also runs a series of bookstores throughout India and is happy to sell books at IBM conferences that we have planned for the year. The one I'm working on right now is a conference that is taking place in Bangalore in early March.
Here are some of the books that you can find at Shroff's online bookstore:DB2 9 Fundamentals: Certification Study Guide
for Rs. 500DB2 9 for z/OS Database Administration
for Rs. 800DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade
for Rs. 300DB2 9 for Linux, UNIX, and Windows Database Administration
for Rs. 675DB2 9 for Developers
for Rs. 550IBM DB2 9 New Features: Maximize All The Latest Features And Functionalities
Enjoy these new books!
Hmmmm this could be interesting! If you were at the IOD conference last October in Las Vegas, you may have seen Rav Ahuja
walking around looking for interesting people to film. Finally we can see the results! DB2 Street Talk - What happened in Vegas...
I'll give you one hint... I'm in the video, but not till the last segment, which starts at around 8:20. Many others in the video too, but you'll have to watch to find out who.
Speaking of videos, did you know that Rav has a series of videos, podcasts, blogs, photos and discussions? Here's where you can find them: ChannelDB2
Although an amazon link is provide for each book, they are also available through most other book channels and directly from the publisher for bulk orders. See Information Management Bookstore
for an ongoing update of all the books that are available for Information Management. PUBLISHED in 2007Understanding DB2 9 Security (IBM Press)
by Rebecca Bond
, Kevin Yeung-Kuen See
(IBM), Carmen Ka Man Wong
(IBM), Yuk-Kuen Henry Chan
Understanding DB2 9 Security is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. Direct from a DB2 Security deployment expert and the IBM® DB2 development team, this book gives DBAs and their managers a wealth of security information that is available nowhere else. It presents real-world implementation scenarios, step-by-step examples, and expert guidance on both the technical and human sides of DB2 security. IBM DB2 9 New Features (McGraw-Hill)
by Paul Zikopoulos
, George Baklarz
, Leon Katsnelson
, Chris Eaton
Enhance productivity, profitability, and efficiency using IBM DB2 9 and the detailed information in this comprehensive resource. Written by experienced IBM data server professionals, IBM DB2 9 New Features covers the technical details of the major new aspects of DB2 9 alongside real-world business uses, syntax examples, and insider tips. Learn how to manipulate and manage XML data using pureXML, automate maintenance tasks, and seamlessly integrate Java, PHP, and Perl scripts. Plus, you'll get vital coverage of the brand-new DB2 Developer Workbench, enhanced .NET developer support, Ruby on Rails, and database security. DB2 9 Fundamentals Certification Study Guide (MC Press)
by Roger Sanders
Starting with the certification process itself and ending with the concept of isolation levels and locking, this guide covers everything needed to know to pass the DB2 9 Fundamentals Certification Exam (Exam 730). The prerequisite for all intermediate and follow-on DB2 certifications, XML usage, basic table creation, a rich set of sample questions, and detailed answers are all included, forming the foundation for understanding the newest version of IBM’s flagship database product. Regardless of what future certification path the reader is planning on pursuing, this study guide will chart a course for proficiency in DB2 9. IBM Informix Dynamic Server 11, the Next Generation in OLTP Data Server Technology (MC Press)
by Carlton Doe
Also known as “IDS Flash Book”Published 4000 copies, June 13, 2007; paid for by IBM, distributed by IBMLearn what's new in the latest Informix IDS release.Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more (Morgan Kaufmann)
by Sam Lightstone
(IBM), Toby J. Teorey
, Tom Nadeau
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. Mining the Talk: Unlocking the Business Value in Unstructured Information (IBM Press)
by Scott Spangler
, Jeffrey Kreulen
Written by IBM researchers, and describes, techniques used in research assets used internally at IBM and by IBM consultants on customer service engagements. IBM Alphaworks provides a free demonstration copy of one of the early text-mining tools called IBM Unstructured Information Modeler, as an adjunct to this book: alphaworks.ibm.com/tech/uimodeler.DB2 Viper Strikes Again - New Features In DB2 9.5 (McGraw-Hill)
by Belal Tassi
, Paul Zikopoulos
, Dwaine Snow
, Aamer Sachedina
Also known as "Viper Flash Book".Not currently available for purchase.... but I'm working on it!Published 8000 copies, October 15, 2007; paid for by IBM, distributed by IBMLearn what is new in DB2 9.5.DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep (IBM Press)
by George Baklarz
and Paul Zikopoulos
Everything a DBA needs to know about DB2 9... from installation to XML to security.DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 (MC Press)
by Susan Lawson
(IBM Gold Consultant) and Dan Luksetich
Written by two members of the team who participated in the actual writing of the exam, this specialized study guide covers every topic that you will need to know to pass Exam 732, including database design and implementation, operation and recovery, security and auditing, performance, as well as installation and migration/upgrade. But that is only the beginning. It also covers the new features of DB2 9 for both database and application development. Building an Intelligent Web: Theory and Practice (Jones & Bartlett Publishers)
by Rajendra Akerkar
Includes DB2 Express; book is a university text book. DB2 9 Database Administration Certification Study Guide for Exam 731 (MC Press)
by Roger Sanders
This comprehensive study guide steps you through all of the topics that are covered on the test, including server management, data placement, database access, analyzing DB2 activity, DB2 utilities, high availability, security, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers. DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 (MC Press)
by Roger Sanders
In DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade Certification Study Guide, Roger E. Sanders—one of the world’s leading DB2 authors and an active participant in the development of IBM’s DB2 certification exams—covers everything a reader needs to know to pass the short—but notoriously challenging—DB2 9 for LUW DBA Certification Upgrade exam (Exam 736). Getting started with DB2 EXPRESS-C 9: A book by the community for the community
by Rav Ahuja
, Don Chamberlin
, Akmal Chaudhri
, Raul Chong
, Ian Hakes
, Clara Liu
, Matthias Nicola
, Cindy Saracco
, Ted Wasserman
, Paul Yip
- (all IBM)Online book.Understanding DB2 V9.5 (IBM Press)
by Raul F. Chong
, Xiaomei Wang
, Michael Dang
, Dwaine R. Snow
IBM DB2 V9.5 and V9 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2®: Learning Visually with Examples, Second Edition is the easiest way to master current versions of DB2 and apply their full power to your business challenges. ABOUT TO PUBLISHDB2 for Developers (MC Press)
by Phil Gunning
Written by an "in-the-trenches" consultant, this guide hails the newest version of DB2 as a major release, highlighting the large number of totally new features, most notably the addition of XML capabilities. Packed with the information DB2 developers and administrators need to know when implementing version 9, the discussion covers upgrading from prior releases of DB2, converting relational data to XML data, and how DB2 supports industry standard schemas. With detailed examples and useful scripts, users learn how to develop DB2 XML applications, design an XML database, and tune the DB2 XML hybrid database. Extensive information on DB2 optimization of SQL and XML is a particularly useful feature of the book and includes a rundown on import and export utilities that database managers can use in their own installations. Going far beyond the standard manuals and certification guides, this is a truly comprehensive resource that teaches the "why" and "how" of a well-designed and well-implemented DB2 database. Coming first half of 2008Administering Informix Dynamic Server, Building the Foundation (MC Press)
by Carlton Doe
(IBM)Enterprise Master Data Management: An SOA Approach to Managing Core Information (IBM Press)
by M. Oberhofer
, D. Wolfson
, P. van Run
, I. Milman
, E. Hechler
, A. Dreibelbis
- all IBMAdvanced DBA Study Guide for Exam 734
, by Roger Sanders
, Dwaine Snow
What an amazing year! Congratulations to all authors for all their very hard work in pulling these books together.... and also to all the people behind the scenes who are needed to support the authors.
We all know how important database security is -- no one wants to hear that their precious data was hacked or compromised in anyway. According to the article The Job of Securing the Database
published on DATE: 21-SEP-2007 by Deborah Perelman
, a Forrester Research study shows that DBAs are only able to spend 7% of their time ensuring that data is secure.
The worst message in the article is that DBAs are so overworked in their day to day duties that they are typically unable to spend more time on addressing security issues AND they are unlikely to have time to upgrade their skills in this area.
I have some good news for you if you are in this situation. Earlier this year, Rebecca Bond and three database security experts from the Toronto lab published a book about database security. The book, Understanding DB2 9 Security
, is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. This book gives DBAs and their managers a wealth of security information that is available nowhere else. It presents real-world implementation scenarios, step-by-step examples, and expert guidance on both the technical and human sides of DB2 security.
Those who have read the book have found it very beneficial. Buy the book... you won't be disappointed and you'll be able to quickly expand your knowledge of security issues. If you are one of the lucky DBAs who is attending the IBM IOD Conference, October 14 - 19, 2007 Mandalay Bay Resort, Las Vegas
, you'll be able to buy this book at a 20% discount, and you'll be able to attend one or more of the following sessions related to DB2 Security:
BTC-2125 Secure Your Data before It Leaves Your Data CentersDr. Arvind Sathi
, IBM, Associate Partner, IBM Global ServicesTUESDAY, 02:30–03:30PM— MBCC SOUTH: JASMINE AData security is a major concern in today’s virtual environment, where leakageof sensitive customer data could cause major economic and legal repercussions.At the same time, the need is growing to share this data withresellers, suppliers and outsourcers. This presentation discusses data maskingas a solution for protecting confidential data. Approaches to data maskingand related case studies are also discussed. ••
TLU-1033 A Sneak Peek at the Next Version of DB2 (in Two Parts)Matthew Huras
, IBM, Distinguished EngineerWEDNESDAY, 09:30–10:30AM— MBCC NORTH: ISLANDER E;WEDNESDAY, 10:45–11:45AM— MBCC NORTH: ISLANDER EThis two-part presentation (consisting of two 60-minute sessions) providesan in-depth, behind-the-scenes, technical look at the features and capabilitiesof the next version of DB2® on Linux®, UNIX® and Windows® (the next versionafter DB2 9). Topics include new advancements in high availability, storagemanagement, concurrency, compression, backup and recovery, security, andperformance. Each topic includes key information about how to use the feature,its key internal design points, and expected best practices. ••
TDZ-1019 Best Practices in DB2 SecurityRoger Miller
, IBM, DB2 for z/OS evangelistTUESDAY, 01:15–02:15PM— MBCC SOUTH: SOUTH SEAS G;FRIDAY, 09:30–10:30AM— MBCC SOUTH: SOUTH SEAS GSecurity is in the headlines and growing much more important. This sessiondiscusses various practices for security and how you can make improvements.We’ll include various security objectives. Most sites have a range ofneeds and objectives. For some situations, basic security is adequate. Forothers, better or standard security techniques are needed. In other cases,best security practices are demanded. Our tools range from very-tight systemsecurity to basic techniques. Application security techniques are moreflexible, but require much more work by more people, so they are generallyweaker. Choices and guidelines will be our primary points, discussing howto provide improved security for your situation. ••
TDZ-1346 A Deep Dive into the Mechanisms of DB2 9 for z/OS Security EnhancementsDave Romack
, IBMTHURSDAY, 04:00–05:00PM— MBCC SOUTH: SOUTH SEAS IDB2® Version 9.1 for z/OS® added some significant security functionality toaddress key customer requests such as providing better access control fromapplication servers, removing object dependency from users, and audit ofSYSADM/DBADM users. This session contains detailed information aboutthese new functions and includes a discussion of where these functions canapply in your environment. ••
TOD-1159 Data Security for SOAErrol M. Back-Cunningham
, IBM, IM ArchitectWEDNESDAY, 09:30–10:30AM— MBCC NORTH: TROPICS BData Security poses one of the biggest challenges to implementing a secure,auditable, end-to-end SOA environment. In this presentation, we will look atData Security standards, requirements, methods of implementing DataSecurity and the solutions and tools that IBM can provide in order to do so.We will cover Data and Service Classification Schemes, Audit Trails, IdentityManagement, Access Control and the ability to retrofit Data Security to SOAenvironments. ••
HOL-1959 Security and Label-Based Access Control (LBAC)Laura Hammond
, IBM, Program Co-ordinator of "Ready for IBM DB2 data server software" validationTUESDAY, 01:15–04:15 PM— MBCC SOUTH: BREAKERS ALabel-based access control (LBAC) greatly increases the control you haveover who can access your data. LBAC lets you decide exactly who has writeaccess and who has read access to individual rows and individual columns.During this hands-on lab you will learn to: Grant the SECADM authority;Define components of various structures; Define a policy that includes multiplecomponents; Define labels; Grant labels to users; Grant exemptions tothe db2lbacrules to users; Protect a table with a policy; and, Protect columnsof a table. ••
HOL-2613 Database Security on LinuxSpencer Shimko
, Tresys Technology, Senior Security EngineerTHURSDAY, 01:15–04:15 PM— MBCC SOUTH: BREAKERS E"Tresys Razor™ makes it economical to enhance the security of DB2 withSELinux. DB2 is a complex environment, but the components interact in apredictable manner. Tresys, partnered with IBM, analysed DB2 and created atightly confined SELinux policy that builds a “firewall” around each systemprocess. Tresys Razor protects the system from unexpected attacks on theapplication or other services running on the system.The management GUI is designed to be familiar to DB2 admins, allowing theSELinux configuration to be customized with no specialized knowledge ofSELinux. This lab session will discuss the benefits of SELinux in an enterpriseapplication environment, describe and provide a hands-on opportunityto use Tresys Razor for DB2. " ••[Read More
A total of 19 Technical Education sessions are being offered at the IOD conference on Sunday October 14 in Las Vegas. The sessions are spread across the following segments:
Information Platform & Solutions (3)Enterprise Content Management (3)Data Servers (12)Support (1)
The fee for these classes is set at $399.00 which is the same price as offered at last year's conference.
I've listed most of the available sessions in this entry. Click on the link to see the list and to register for the class.Successfully Transitioning with DB2 9 for z/OS
Considering an implementation of DB2 9 for z/OS? Then you won't want to miss this 1-day course. Designed to provide you with technical information on the new features, you'll learn what's required for a successful implementation. 9:00 AM / 4:30 PM Mark WilsonSpotlight on IDS 11 - Transition Topics
The newest addition to the Informix Dynamic Server family, IDS 11 boasts a wealth of new functions and features. This 1-day course will take a deep dive into the technical information behind these features, providing a better understanding of and ensuring a smooth transition to this new product. 9:00 AM / 4:30 PM Jeff Bohm** DB2 9 for Linux, UNIX, and Windows DBA Certification Crammer (Exam 731)
This high level certification preparation review is intended to help you take IBM Certification Test 731. Gain an intense overall review of those areas that are on the certification exams. 9:00 AM / 4:30 PM Bob Schwan ** DB2 9 for z/OS DBA Certification Crammer (Exam 732)
This high level certification preparation review is intended to help you take IBM Certification Test 732. Gain an intense overall review of those areas that are on the certification exams. 9:00 AM / 4:30 PM Susan Lawson DB2 9 Fundamentals Certification Crammer (Exam 730)
This high level certification preparation review is intended to help you take IBM Certification Test 730. Gain an intense overall review of those areas that are on the certification exams. 9:00 AM / 4:30 PM Roger Archambault ** Getting to Know DB2 Warehouse
This 1-day course is a must for those wanting to understand the components of DB2 Warehouse. Topics for the class include an overview on the SQL Warehouse Tool, DB2 Intelligent Miner, Cube Views, and their common interface, the Design Studio. 9:00 AM / 4:30 PM Warren Pettit Preparation is Key: DB2 9 for Linux, UNIX, and Windows Advanced Recovery Topics
Recovery is top of mind for many businesses today. In this 1-day lecture you'll gain a deeper understanding of how DB2 9 for Linux, UNIX, and Windows addresses the issue with its many advanced recovery features. Topics may include recovery log management, dropped table recovery, table space recovery, crash recovery, disaster recovery, incremental backup & recovery, redirected restore, and additional recovery facilities. 9:00 AM / 4:30 PM Melanie Stopfer**Unleash the Knowledge: An Introduction to Data Sharing Learn the basic purpose, justification, and planning considerations for employing DB2 data sharing in your enterprise IT system.
This 1-day class will also cover the basic knowledge of the architecture and major components of DB2 data sharing and provide an overview of the steps to implement a DB2 data sharing environment. 9:00 AM / 4:30 PM Wayne Cope Informix Dynamic Server System Administration - A Beginner's Look
This 1-day class will enable you to develop the skills necessary to successfully administer one or more database servers. You will learn how to configure and initialize a database server instance, configure and test client connectivity, configure and manage memory and disk usage, plan and implement system maintenance tasks, and configure the server for optimal Online Transaction Processing (OLTP) or decision support. 9:00 AM / 4:30 PM John Zucchero Maximize Your Optimizer: A Guide to DB2 9 for Linux, UNIX, and Windows Optimizer
This 1-day class will enable users to understand optimizer's decision making process, influence optimizer decisions, identify problems from optimizer access plans and most importantly, fix them. By the end of this 1-day course, participants should be able to leverage fully DB2 optimizer for best query performance. 9:00 AM / 4:30 PM Yasir WarraichArchitecting the Dynamic Warehouse - a How to Guide
Are you interested in dynamic warehouses but don't know the first thing about how to build one? This 1-day class is your answer. The course offers practical methods and techniques for designing and constructing a dynamic warehouse. Whether you intend to create one or just want to learn more, this class will broaden your understanding of the data warehouse 9:00 AM / 4:30 PM Joe Cullen Behind the XML Buzz: Querying & Using XML with DB2 9
Much noise has been made about the XML features in DB2 9 and this 1-day class will show you why. The course introduces participants to XML found in DB2 9 for LUW and provides a lightening tour of the fundamentals. From XPath/XQuery to defining/building indexes on XML data to sophisticated queries using combinations of SQL and XML data, you won't want to miss this engaging look at one of DB2 9's most popular components. 9:00 AM / 4:30 PM Glen Mules
None of the sessions are full at this point, but demand is increasing. If you are interested in attending one of these sessions, be sure to register soon.
Roger Sanders' latest book DB2 9 Fundamentals Certification Study Guide
continues to sell extremely well... and has received 6 customer reviews on amazon.com.... all rated 5 stars! What are people saying? Click the link above to see all the customer reviews (or to add your own if you own the book :)
The ITSO sends out lists of the most popular IBM Redbooks each month, in terms of the number of downloads. The list covers all IBM Redbooks, across all product areas. This past month, there were 2 DB2 book in the top 10 list:
* DB2 9 for z/OS Technical Overview
* Up and Running with DB2 for Linux
Congratulations to all authors!
I hope you'll be able to find this book: DB2 9 Fundamentals Certification Study Guide
in actual bookstores... but if not, check out amazon.com
. Today they put the book on sale with a 37% discount!
Today I received my copies of the book. They look amazing. The most unique thing about the book is the large number of sample questions. Each chapter has several study questions along with reasons why the correct answer is the right one. Each of these study questions are repeated in Appendix B... and take up 105 pages of the book. By far the most complete study guide for a DB2 exam that has ever been produced.
This book prepares you to pass the DB2 9 Fundamentals Exam (730
). Roger is working on the second book in the series and has plans for a third book as well.
Last Tuesday, IBM announced the availability of DB2 9 for z/OS
and the reception has been red hot!
From the press release
: DB2 9 promises to provide users of System z with advanced security, superior data compression, enhanced disaster recovery and reduced system administration costs. DB2 9 for z/OS brings advancements to the mainframe that include patented pureXML™ technology as well as the ability to manage both relational and XML information within the same database.
Related to this, the newest V9 certifications are arriving:DB2 9 Fundamentals Exam 730
is currently available and by passing, you'll validate that you have acquired V9 skills at a database associate level. To study for this exam, I recommend the DB2 9 Fundamentals certification 730 prep series
. Ensure that you are fully prepared by taking a professional certification on-line assessment exam
. Roger Sanders is updating his extremely popular study guide and it will be available for purchase in May. I'll post information about the book as soon as it is available for you to pre-order.
Also coming soon is Exam 732: Database Administration for DB2 9 z/OS. Susan Lawson is working on an update to her study guide as well and hopes to have it published in July. Keep visiting my blog and I'll let you know as everything becomes available.
Many of us are unable to take the time to go to a conference for a week to build our skills. If you would like to go to a face-to-face event to learn about a new product or technology with taking the time or expense of a full conference, see if there is a technical briefing
planned for your city.
As an example, you may wish to consider attending the following technical briefing: Experience the power of Information Management solutions
This is a half-day briefing that covers the following:
* Learn how DB2 9 can help you reduce costs and improve service levels.
* Learn about DB2 9 enhancements for working with SAP.
* See how Information Management software integrates data better than other vendors.
* Gain an understanding of how the new IBM data server can unlock the latent potential of XML with performance and development savings.
* See how "Information as a Service" delivers business information accurately, consistently, timely, and coherently across disparate operating systems, applications and legacy systems.
* Learn how IBM solutions can break down information silos by connecting product, location, trading partner, organization, and terms of trade seamlessly across the Web, intranets, collaboration workspaces, file shares, and content management systems.
* Minimize the total cost of ownership by implementing a solution that provides pre-built, secure integrations to Lotus Domino, WebSphere Portal, FileNet, Documentum, and Open text. Mitigate the risk of exposing content by delivering a highly secure search experience. During this briefing, you'll see demos for:
* DB2® 9 * DB2 9 Development Center and pureXML™ * IBM Information Server (including WebSphere QualityStage, WebSphere DataStage, and WebSphere Federation Server) * Dynamic Warehousing Solutions -- DB2 Data Warehouse Edition & Alphablox * IBM OmniFind
Note: Click on Select location and register
to find where and when this technical briefing is taking place.
The SOA Compass book continues to be a fast moving book. Have you had a chance to look at it yet? To download one of the chapters, see http://www.ibmpressbooks.com/bookstore/product.asp?isbn=0131870025&rl=1 This site also contains many customer reactions to the book such as this one:
"Service-Oriented Architecture offers a pathway tonetworking of intra- and inter-corporate business systems.The standards have the potential to create far more flexibleand resilient business information systems than have beenpossible in the past. This book is a must-read for those whocare about the future of business IT." –Elizabeth Hackenson,CIO, MCI
If you have access to Books 24x7 or Safari, you should be able to read this book entirely or in part electronically.
The second edition of the Information Management Professional Certification Newsletter is now available:http://www.ibm.com/software/data/education/cert-newsletter.html.
In this edition, find out about the certifications that are currently under development and when they are expected to be live. You'll see a list of the events where certifications are being offered for free or at a reduced price. Also, you'll have links to the latest white papers and offers.
Have you ever used an online book engine such as Safari
or Books 24x7
? Both Safari and Books 24x7 are online book engines that give you access to thousands
of retail books. These engines are quite powerful and very suitable in today's electronic world. IBM Press books are now available in both engines.
Safari is an online book engine that is jointly owned by Pearson and O'Reilly. All books that are published by these publishers are automatically formatted for Safari and made available to anyone who has a subscription to Safari. If you have a subscription, you can read the entire book electronically, search for a keyword across the entire library or a subset of the library, bookmark well-used pages in the books you've read, make notes for your co-workers who also have subscriptions, download chapters to print or read offline, or copy code directly from the book into your programs. You can sign up for a 2-week trial from http://safari.informit.com/
. Monthly subscription rates can be as low as $19.99 depending on the number of books you choose for your bookshelf.
Books 24x7 has all the same features as Safari, but a slightly different set of books. Books 24x7 is a direct competitor to Safari and as such, typically carry only the books published outside of Pearson or O'Reilly. Exceptions are made when Books 24x7 buys the electronic rights to use a Pearson or O'Reilly book. This was an arrangement that was made for the IBM Press books that are published through Pearson. You can get further information about the subscription details and prices from http://www.books24x7.com
IBM employees have a paid subscription to Books 24x7 and you can sign up to use it through this internal site: http://w3.ibm.com/education
I've used Books 24x7 to review books and table of contents, searched for specific topics in a set of books, but one of the key benefits is their newsletter. At least every week I'm sent a note telling me about the new books that are available on the engine. I end up seeing titles that are very interesting and useful that I wouldn't have known about without this newsletter! Another thing that I've recently discovered is that some of the books have a mp3 teaser available that allows you to listen to someone reading part of the book to you. This is great for commuters or for anyone who wants a break from reading!
Let me know if you've tried these engines and if you see benefits to using them.
IBM Press Program Manager
The postings on this site are my own and don't necessarily represent IBM positions, strategies or opinions.[Read More
Modified on by svisser1
Can you think of an industry that is changing more drastically than publishing is at this time? More books are now being sold for devices such as Kindle than printed books. There are so many Kindle-like book readers available that it is pretty difficult to name them all. I’m not sure if “books on tape” or audible forms of books were popular in the past, but I’ve personally become a huge fan and am listening to about half the books I consume in a year.
Another big change is the movement away from large books. Remember when the technical books you used to purchase were at least 2 inches thick? These types of books are not selling well now… nor are publishers eager to get into such a venture.
But, what is one to do when the topic is huge and deserves a large number of pages to cover it effectively? Take a look at what publisher MC Press has decided to do with the certification study guide by Susan Lawson and Dan Luksetich: “DB2 10 for z/OS Database Administration (Exam 612)”:
Purchase individual chapters in electronic format as needed. The chapters are priced from $2.99 to $9.99 (depending on length).
This link takes you to the “Database & Data Management” category on the MC Press ebook site. When you scroll down, you’ll see the individual chapters for sale, followed by the entire book item.
Let me know what you think of this offering. I am working on having other books made available in the same way.
Here is the master list of current and upcoming books for DB2 on Linux, Unix and Windows. Updates will be made to this page as books are published, so bookmark this page and come back often.
Warp Speed, Time Travel, Big Data, and more: DB2 10 for Linux, Unix and Window New Features
By Paul Zikopoulos, Walid Rjaibi, George Baklarz, Matt Huras, Matthias Nicola, Dale McInnis, and Leon Katsnelson
DB2 10.5 with BLU Acceleration - New Dynamic In-Memory Analytics for the Era of Big Data
By Paul Zikopoulos, Matthew Huras, George Baklarz, Sam Lightstone, Aamer Sachedina
Modified on by svisser1
As usual, IBM Champions are well represented at IDUG this year. Gain knowledge from this group of talented and hardworking people, who I consider IBM’s best friends!
I’ve done my best to pull out all the sessions that IBM Champions are taking part in at the
IDUG DB2 Tech Conference in Orlando, Florida, USA 2013
April 29th - May 3rd, 2013
If I missed any, please let me know and I’ll update this entry.
Monday April 29 - Full Day Educational Seminars
Tuesday April 30: Technical Sessions
Wednesday May 1: Technical Sessions
Thursday May 2: Technical Sessions
Friday May 3: Technical Sessions
very popular item on the developerWorks site is the series of
Certification Tutorials. The V10 Tutorials are starting to be published
now. We were hoping to have them all done by the end of September, but
it didn’t happen.
very happy with the quality of the tutorials that we are getting and I
hope you find them very helpful while preparing to pass for your exam.
Many thanks to the authors who found the time in their regular life to
put these together. It wasn’t easy for any of them, but an achievement
to be very proud of!
I’ll post here as others are published.
Updated Nov 1 with Part 5.
DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning
Norberto Gasparotto Filho, Database specialist, IBM
This tutorial introduces you to the basics of the IBM® DB2® 10.1
product editions, functionalities and tools, along with underlying
concepts that describe different types of data applications such as
OLTP, data warehousing / OLAP, non-relational concepts and more. It will
briefly introduce you to many of the concepts you'll see in the other
tutorials in this series, helping you to prepare for the DB2 10.1
Fundamentals certification test 610.
DB2 10.1 fundamentals certification exam 610 prep, Part 3: Working with databases and database objects
Gerald Kupris, Solution Migration Specialist, IBM
This tutorial shows you the basic steps and requirements to create and
connect to a database in DB2® 10.1. This tutorial also introduces you
to the objects that make up a DB2 database, as well as how to create and
manipulate them. This tutorial is third of a series of six "DB2 10.1 fundamentals certification exam 610 prep" tutorials that will help prepare you for the DB2 10.1 fundamentals certification exam 610.
DB2 10.1 Fundamentals certification exam 610 prep: Part
5: Working with tables, views, and indexesSummary:
This tutorial discusses IBM DB2 10.1 support for data types, tables, views,
triggers, constraints and indexes. It explains the features of these objects, how to
create and manipulate them using Structured Query Language (SQL), and how they can be
used in an application. This tutorial is the fifth in a series that you can
use to help prepare for the DB2 10.1 Fundamentals certification exam 610.
DB2 10.1 fundamentals certification exam 610 prep, Part 6: Data concurrency
Roger E. Sanders, Senior Consultant Corporate Systems Engineer, EMC Corporation
tutorial is designed to introduce you to the concept of data
consistency and to the mechanisms DB2 uses to maintain data consistency
in both single- and multi-user database environments. This tutorial will
also help you prepare for Section 6 of the DB2 10.1 Fundamentals
certification exam (Exam 610).
I have a few other blog entries about Certification that I recommend:
Certification Offer: Assess & Save, until Dec 14, 2012
Three DB210 for LUW Certification Exams are now available
A new way to study for DB2 Certifications
Get Certified at the IBM Information on Demand Conference
How to Prepare to Pass a DB2 Certification Exam?
DB2 10 for z/OS Certification Roles, Exams and Study Materials
Certification Study Guides for DB2 LUW Exams
DB2 9.7 for Linux, UNIX and Windows: Certification Roles and Exams
Certifications: Beyond DB2
Certification Tips on the DB2Night Show
Web-based Training Courses to Consider
Congratulations to DB2 for getting into the Guinness World Records for the largest data warehouse! Here are some details:
The largest data warehouse resides at the IBM Technology Campus in Dublin,
Ireland and contains 3 petabyte (3,000 terabytes) of raw data.
The software is IBM - DB2 Information Management and the official date of the
record is January 18, 2012.
According to wikipedia:
A petabyte (derived from the SI prefix peta- ) is a unit of information equal to one quadrillion (short scale) bytes, or 1 billiard (long scale) bytes.
The unit symbol for the petabyte is PB. The prefix peta (P) indicates the
fifth power to 1000:
- 1 PB = 1000000000000000B = 10005 B = 1015 B = 1
million gigabytes = 1 thousand terabytes
The pebibyte (PiB), using
a binary prefix, is the
corresponding power of 1024, which is more than 12% greater (250 bytes = 1125899906842624bytes).
According to Gizmodo:
How Large Is a Petabyte?
13.3 years of HDTV content. That's approximately 58,292 movies, which means
an equal number of large pizzas. So one petabyte equals 52 tonnes of pepperoni
pizza. Yes, my head has assploded. For other equivalents, click and zoom in.
How big are 20 million four-drawer cabinets? As big as the Sears Tower? I
have a hard time visualizing that. Strangely enough, I don't have any problem
visualizing 52 tonnes of pepperoni pizza.
Click the link to see a cool graphic that represents the
With the amount of data that is being collected and analyzed these days, I
expect this record to be broken sooner than imaginable!
After a long delay, I can finally announce that this long awaited book has published.
DB2 10 for z/OS Database Administration: Certification Study
by IBM Champions Susan Lawson and Daniel Luksetich
I can also tell you that the covers for the certification series of books by
have been redesigned and will be launched on this title. I hope you like the
What’s in the book?
- Read this book to prepare to pass Exam 612 – DB2 10 for
z/OS Database Administration.
- All test objectives for this exam are covered in the same degree as they are
covered on the exam.
- Susan and Dan were members of the exam development team, so are fully aware
as to what questions are on the exam!
- Susan and Dan use DB2 every day and have 22 years experience.
DB2 10 for z/OS Database Administration: Certification Study Guide is
the definitive guide to preparing for IBM’s Certification Exam 612: DB2 10 for
z/OS Database Administration. This book provides a comprehensive review of all
the topics covered on the exam and introduces you to important new features
found in DB2 10 for z/OS.
Written by two industry experts who were members of the team that created the
612 exam, this book guides you through all the areas you need to know about to
pass the exam: Database Design and Implementation, Operation and Recovery,
Security and Auditing, Performance, and Installation and Migration/Upgrade.
At the end of each chapter, you’ll find practice questions with answers to
help you review that chapter’s material. The book concludes with a comprehensive
85-question practice exam (plus detailed answers) that lets you verify what
Beyond certification prep, the book covers new Version 10 features for
both database and application development. It also includes a wealth of
practical details about working with DB2 for z/OS, tips for best performance and
best practices, and loads of examples illustrating usage of DB2. It will serve
both as an essential tool for studying for exam 612 as well as a reference guide
that all DB2 for z/OS DBAs will want on their desktops.
With DB2 10 for z/OS Database Administration: Certification Study Guide,
- Learn how to effectively administer a DB2 10 for z/OS database
- Discover the changes to DB2 for z/OS in Version 10 that you’ll need to know
about to be successful when taking exam 612, and the pre-requisite Exam 730
- Receive an explanation of every objective on the test. . .from people
involved in the creation of the actual exam
- Find 85 practice questions based on the actual exam’s format and approach,
with detailed answers to help you gain understanding
While the book does cover all topics on the test, it also covers much more
than that. It covers the new features of DB2 10 for both database and
What do you need to know to pass the exam?
This is an outline of the Exam Objectives that this book covers:
Section 1 - Database Design and Implementation (30.5%)
Design tables and views
• Explain the different performance
• Design indexes
• Create and alter
• Perform table space and index partitioning
Normalize data and translate data model into physical model
Implement user-defined integrity rules
• Use the appropriate method
to create and alter DB2 objects
• Encoding schemes
Section 2 - Operation and Recovery (29%)
database-oriented commands for normal operational conditions
database-oriented commands and utility control statements for use in abnormal
• Identify and perform actions that are needed to protect
databases from planned and unplanned outages and ensure that timely image copies
are taken periodically
• Load and unload data into and from the
• Reorganize objects when necessary
Monitor the object by collecting statistics
• Monitor threads
• Identify and respond to advisory/restrictive statuses on objects
• Establish timely checkpoints
• Identify and perform
• Perform health checks
• Describe the special considerations for
availability in a data sharing environment
Section 3 - Security and Auditing (7%)
• Protect DB2
• Protect connection to DB2
Section 4 - Performance (29%)
• Plan for performance
monitoring by setting up and running monitoring procedures
• Analyze and respond to RUNSTATS statistics analysis
• Determine when and how to run the REORG utility
Understand and implement Real-Time Statistics & DSNACCOR(X)
• Evaluate and set appropriately the performance
parameters for different utilities
• Describe the performance
concerns for the distributed environment
• Describe DB2 interaction
• Interpret traces (statistics, accounting, performance)
and explain the performance impact of different DB2 traces
Identify and respond to critical performance thresholds
I/O wait times
• Identifying lock-latch waits and CPU waits
• Identifying and resolving deadlocks and timeouts
Review and tune SQL
• Dynamic SQL Performance
Section 5 - Installation and Migration/Upgrade(4.5%)
catalog health checks using queries and utilities
• Identify the
• Identify the migration/upgrade modes
• Identify and explain data sharing components and concepts
About the Authors:
Susan Lawson is an internationally recognized consultant and
lecturer with a background in system and database administration. She currently
works with several large clients to help develop, implement, and tune some of
the world’s largest and most complex DB2 databases and applications. Susan also
conducts performance and availability audits to help clients reduce costs
through proper performance tuning and ensure availability. She also writes
articles and white papers, presents at user group meetings, and teaches a
variety of DB2 courses. Susan is an IBM GOLD Consultant for DB2 and System z and
an IBM Champion.
Daniel Luksetich is a DB2 database professional with more than 26
years of experience in high-performance design and tuning of very large
databases and highly available, high-volume database applications. He also
teaches DB2 courses and has authored books, guides, whitepapers, and magazine
articles. Working as a DB2 application architect, Dan has been involved in
several very large DB2 application designs. An IBM Champion, Dan specializes in
DB2 for z/OS but has worked with DB2 on a variety of platforms. His specialties
include performance audits, SQL education, backup and recovery, stored
procedures, UDFs, triggers, application design, high-availability design, and
DB2 high performance.
PS, for all my z/OS friends, check out this new BLOG that focuses on
technical information that will interest you: DB2
for z/OS Exchange Forum
The next Chat with the Lab takes place next Thursday, Jan 26 from 12:30 – 2:00 pm. Join Rav Ahuja and Bill Minor (DB2 Tooling Development Team) for a discussion about Advanced Recovery Solutions.
Date: Thurs, Jan 26, 2012
Time: 12:30-2:00 PM Eastern / 11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 11 PM
The availability and integrity of data is critical to the business enterprise. When a problem occurs and your data is compromised or unavailable, it is paramount to be able to recover from such an 'outage' as quickly as possible. Equally important, is the ability to recover efficiently by quickly identifying recovery assets and minimizing the recovery scope, required resources and effort. This session will explore in detail the Advanced Recovery Solutions for DB2 LUW. The solutions are comprised of the Recovery Expert, Merge Backup and High Performance Unload tools. The Advanced Recovery Solutions for DB2 LUW provide unique capabilities for changed data analysis, elimination of physical or logical data errors and maximizing data availability. We will examine in detail the features these solutions present and demonstrate, through realistic user scenarios, the business value that can be gained by complementing and extending your data management and recovery strategies with these tools.
Presentation slides will be available for download from ibm.com/db2/labchats shortly before the webcast starts.
DB2 Chat with the Lab is a free webinar series from the IBM labs.
The chat is recorded and available for replay. Here are some previous chats you may be interested in:
For more information, see the DB2Channel.com page for DB2Chats.
SusanChat with the Lab: Advanced Recovery Solutions for DB2 LUW