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