Keep on Learning
If you or someone you know is looking to learn DB2, I recommend these two books:
Beginning DB2: From Novice to Professional (Expert's Voice) by Grant Allen
Understanding DB2(R): Learning Visually with Examples (2nd Edition) by Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
Both of these books are excellent choices if you are trained on a competitive database and wish to quickly transfer your skills to DB2.
Finally the most essential DB2 book for DBAs has been updated for the latest release of DB2: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition).
Congratulations to both George Baklarz and Paul Zikopoulos! As you may know, Bill Wong was George's co-author for the fourth and fifth editions to this book (as well as one of mine :). Bill had moved to a job in Tivoli, but is now back in DB2... which I'm quite happy about. Paul joined the team and I'm sure that this edition follows the tradition of the previous editions: well-written, easy to read, thorough, and essential!
What can you find in this book? Well, 1136 pages, for starters! As you can tell from the sheer size of the book is that you'll find much more than exam prep details! In fact, I would suggest that you continue to buy / read the Exam Study Guides by Roger Sanders to prepare for DB2 Certification Exams, but buy this book as your way to learn what you need to know, beyond the exams.
The sections of the book that I'd like to draw your attention to include:
1) Security. Although it doesn't cover the topic as thoroughly as Understanding DB2 9 Security does, it does include important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator role
2) SQL. There is an entire section of the book devoted to SQL. In my mind, there IS no other book you need for SQL beyond this one. Coverage includes pure XML, advanced SQL, and yes, even SQL for beginners. George is somewhat of an SQL expert and creates examples of all sorts to demonstrate a variety of SQL. But, George and Paul rarely rely solely on their own knowledge alone. They are well-connected with the entire development team and the book benefits from additions and reviews by the top experts in the area.
3) Autonomics. Want to make your environment more automatic? Learn about the operational improvements that can enhance your efficiency. Coverage includes self-tuning memory allocation, automated storage management, and storage optimization.
4) Partitioning. Perhaps an advanced topic, but important none-the-less. Learn about the new table-partitioning features that improve scalability and manageability.
5) Development. My dream would be to publish a book for this area alone, but since that isn't in the cards right now, read this book to learn about the powerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all data.
I plan to work with both George and Paul to further feature unique aspects about their book, so stay tuned.
Interestingly, this book is not on special on amazon.com. I'm not sure why that is, but I'll keep watching to see if they put a sale on this book that matches their usual 37% discount. You may buy the book from the IBM Press websites at a discount:
United States - Use the coupon code DB2SAVE to get 35% off this and other books.Canada - 35% off all IBM Press titlesEMEA - 35% off all IBM Press titles.
IBMers may choose to purchase the book through an Internal Site.
Buy today and keep up to speed on the latest features.
What do you think? Has the use of XML increased in the past two years? Find out... first answer the current poll question and then check on the change in usage over the past two years:
Database Magazine Poll Question: How much do you use or manage XML?
Did you know..... Information Management will have a major presence at this year's Lotusphere conference with four pedestals and 11 sessions featuring Information On Demand solutions.
It is easy to see that the world is changing very quickly in front of our very eyes.... so does that mean we should begin ACTING differently? I think so. Where to start?
Faster decision making: IBM's next generation Lotus collaboration and WebSphere Portal technologies facilitate closer relationships among employees, customers, and partners - resulting in faster decision making.
Trusted information: Making great decisions requires the use of trusted information. Recent surveys indicate that almost 50% of business users lack confidence in their company's information. Information On Demand is designed to help enterprises unlock the business value of information by delivering timely and trusted information to employees, customers and partners.
So....By linking people with people - and people with trusted information - Information On Demand solutions tightly integrated with Lotus collaboration and WebSphere Portal technologies empower people to act on trusted information faster and with greater confidence.
Here are some of the ways for you to learn more about our integrated solutions:
IBM Enterprise Content Management and Lotus Quickr: the most complete single-vendor end-to-end content management solution in the industry.
IBM Content Collector and Lotus Domino: the comprehensive e-mail archiving and retrieval solution for any Notes database or server platform.
Cognos 8 BI and WebSphere Portal: out-of-the-box Cognos portlets for WebSphere Portal.
InfoSphere MashupHub and Lotus Mashups: the first complete mashup portfolio for business, empowering individuals to create situational applications. (Bundled & sold as IBM Mashup Center)
DB2 pureXML and Lotus Forms: efficient, integrated, and cost effective electronic forms solutions.
For a full agenda, see Lotusphere Agenda.
I won't be at the conference, so if you are there, send those of us back in the office some details about what you liked the most.
New IBM Redpaper for you to download and read: DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration
This IBM® Redpaper provides information about exploiting client load balancing and fail over capabilities across a DB2® data sharing group or a subset of the group members. The information provided will help network specialists and data base administrators in appropriately configuring data sharing groups as TCP/IP servers.
We show how to use the functions of DB2 sysplex workload balancing functions, supported by DB2 Connect™ Server and the IBM DB2 Driver for JDBC and SQLJ, in conjunction with the functions of TCP/IP Sysplex Distributor, configured with Dynamic Virtual IP address (Dynamic VIPA or DVIPA) and automatic VIPA takeover, to provide superior load distribution and fail-over capability for transactions and connections across the members of a data sharing group. The two functions work together to ensure the highest availability possible for remote applications accessing a DB2 location in a sysplex.
Thanks to Sabine Kaschta for providing this information to share with you!
I use google to find links to just about anything I'm interested in. I'm not always successful in finding what I am looking for, but I'm sure it is just because of my bad search arguments.
Mark Wilding, a member of the Toronto Lab Development team, was looking for DB2 sites and was frustrated at not being able to find what he wanted to. So, always a problem solver... Mark created the following site:
Forever growing, this site should be one of the first places to go if you are looking for specific DB2 information.
Just a quick comment about Mark. Mark is one of the many prolific authors that we seem to attract in the Toronto Lab. He's been involved with a few books with many ideas still unpublished. He was the driving force behind the latest DB2 Best Practices initiative. If you don't know about this yet, check out the bookmark list to find it.
Also, Mark, along with Dan Behman, wrote a book about Linux that should be popular with many people: Self-Service Linux(R): Mastering the Art of Problem Determination .
Thanks Mark for the bookmark list as well as your passion for writing!
Do you think that you are ready to pass the certification exam that you've been studying for? Try a practice exam to gauge your readiness. Usually offered through Prometric for $10, you can enjoy them for free from October 12 through October 26.
Be well prepared for the complimentary certification exams at Information On Demand 2008 with free Information Management Certification practice tests.
How should you study: see the exam preparation documents.
Trying to figure out which book to use to study: see the DB2inBooks group on channeldb2.com.
Do you prefer to take a class? Check out the pre-conference crammer courses:
DB2 for z/OS DBA Certification Crammer (Exam 732)
Speaker: Susan Lawson
This high level certification preparation review is intended to help you take IBM Certification Test 732, DB2 9 DBA for z/OS. Gain an intense overall review of those areas that are on the certification exam.
DB2 9 for Linux & Windows DBA Certification Crammer (Exam 731)
Speaker: Roger Sanders
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9 DBA for Linux, UNIX, and Window certification exam (Exam 731). The material for this course is aligned with the 731 exam objectives.
Remember: Those who are certified are eligible to attend the certification lounge at the IOD conferences... for FREE MASSAGES!
You're invited to a free session about Driving Business Innovation with Smart Analytics at the Sheraton Centre in Toronto the morning of February 10th.
The topic is Driving Business Innovation with Smart Analytics and it is being offered by ComputerWorld Canada’s Technology Insights.
Join Network World Canada editor Greg Meckbach and his guests Glen Sheffield, IBM Information Management Technical Specialist and Jason Gartner, IBM Business Analytics Development Executive.
WHAT WILL BE COVERED:
• The software, hardware, storage and infrastructure requirements for data warehousing and business analytics initiatives
• How to reduce the cost and time of deployment;
• How the business can leverage these analytical tools to turn information into insight and make sound business decisions
Glen Sheffield, IBM Information Management Technical Specialist
Jason Gartner, IBM Business Analytics Development Executive
“Work smarter, not harder” How many times have we heard this phrase? Working smarter means analysts and key decision makers have the right information and insight. It means analysts can quickly access the right data points to evaluate key performance indicators. And yet, working smarter may be more important today than it has ever been. Learn how by attending ComputerWorld Canada’s Technology Insights session in Toronto on February 10th. Seating is limited so don’t delay in reserving your place.
Working smarter means your front line business leaders know where to find the new revenue opportunities and which product or service offerings are most likely to address the market requirement. It means corporate risk and compliance units can recognize regulatory, reputational, and operational risks before they become realities.
Within your organization you have billions of bytes of information stored on your computers. We will examine how to give your organization the insight it needs to work smarter in this challenging environment by putting the right answers in the hands of your decision makers today while putting your business in the best position to quickly adapt and grow to answer the questions of tomorrow.
8:30 AM - 9:00 AM Registration & continental networking breakfast
9:00 AM - 9:15 AM Welcome address & content introduction.
9:15 AM - 10:00 AM Building the Foundation
Bringing a multi-terabyte data warehouse into production can be an insurmountable task. Find out how to overcome the challenges of bringing an enterprise database into production by employing the right software, hardware, storage and infrastructure. Learn how to reduce the time and cost of deployment.
10:00 AM - 10:15 AM Networking & coffee break
10:15 AM - 11:15 AM Turning Data into Decisions
Businesses need a range of analytics capabilities to address the variety of decisions that need to be made every day—and the confidence that those capabilities can be easily expanded as new demands arise. IT managers need to ensure they can quickly get the solution up and running and that it remains as relevant and powerful in the future as it is today. Learn how you can help the business quickly and efficiently turn your information into insight for smart business decisions.
11:15 AM - 11:45 AM Panel of experts - Q&A
11:45 AM - 12:00 PM Wrap-up
12:00 PM Program concludes
If you are in Toronto... come out and join these fabulous speakers and get inspired!
Have you heard of the DB2 Detective Game? I was part of a small team that created this game a few years ago with the objective of teaching people how to query a DB2 database. Our original audience was a SHAD Valley group of high achieving high school students (http://www.shad.ca/). One of the people on our team was a former SHAD grad who was on a coop term at IBM. Teaching the students was an amazing experience. They like the competitiveness of playing a game, but it was astonishing how quickly they picked up the skill of writing queries to get important information from the database.
The game has gone through many iterations of improvements and is now called the DB2 business game and is available on developerWorks for all to "play". Give it a try....
Here are the details:
The DB2 business gamehttp://www.ibm.com/developerworks/edu/dm-dw-dm-0609cao-i.htmlTest your DB2 querying skillsLevel: Introductory
If you're a beginner with IBM® DB2® and SQL, you may wonder how the technical skills you're learning are used in the "real world." Here is a chance for you to put your DB2 SQL skills into play in this interactive game! Jump into a "run your own business" scenario, where your company's future depends on a key report needed to secure funds for a critical upgrade. Use your relational database skills to build this report.
Put your DB2 SQL skills into play using a "real world" business scenario.
I'm quite pleased to see the number of social community groups that have become quite active lately... largely thanks to Adam Gartenberg... but many others as well.
Here is the list that I have... there might be more. Check them out, and join one or more!
I've just added a discussion group in channelDB2 that I'd like you to specifically check out, join, and comment on! It is called DB2 in Books. I hope you like it :)
planetDB2Viral VideosDM YouTube ChannelIDS Facebook Fan PageDB2 Facebook Fan PageInfoSphere Facebook Fan PageData Studio Community
See you in the community :)
Over the past year I have been working with a geographically dispersed author team who have been writing a book to explain the meaning of Master Data Management to the world! I'm happy to say that the book is now ready for you to preorder... delivery in June.
Enterprise Master Data Management: An SOA Approach to Managing Core Information by Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul van Run, and Dan Wolfson.
As a favour to the authors, I read the majority of the book in order to give feedback on what was written. I found the book very informative and for a complete newbie like me... I found it understandable and can see the potential for every company in the world to want to have MDM!
Dr. Ambuj Goyal wrote the foreword for the book, and I am copying a piece of it here so that you can get a glimpse into the importance of the topic and the book... from an expert who knows what he's talking about:
Unlocking information and letting it flow rapidly and easily to the people and processes that need it, is easier said than done. Over the past 20 years or more, the IT industry has focused on automating business tasks. This has created a very complex information landscape; individual automation projects have led to disconnected silos of information. Little trusted information exists – there are multiple versions of the truth. Redundancy reigns – both logically and physically. Few common definitions of key data elements exist or are shared across the enterprise. No common processes to manage and ensure the integrity of critical data domains exist. These facts define today’s environment. They blind the business from the information it needs, add cost to the IT infrastructure, and slow the ability of the business to move forward with confidence. Solving these problems is what Master Data Management and this book are all about.
The book is written in a generic way so that any one who is considering implementing an MDM system will benefit from reading it. Now the author team is committed to writing about how to implement the solution using IBM technology, and they've just published their first article with many more to come: Implementing a transaction hub MDM pattern using IBM InfoSphere Master Data Management Server
Synopsis of the article: Learn to use the transaction hub Master Data Management (MDM) pattern to implement your MDM systems. This typical architectural pattern is described in terms of capabilities of the MDM Reference Architecture. Get an introduction to the IBM® InfoSphere™ MDM Server and see why this software solution is a good choice for implementing this architecture pattern. Finally, learn about an upcoming book, Enterprise Master Data Management: An SOA Approach Managing Core Information, that deals with these topics in greater detail.
Join us at the IBM Information On Demand EMEA Conference 2008 taking place June 3 - 6, 2008 The Hague, Netherlands. Enterprise Master Data Management: An SOA Approach to Managing Core Information is being launched at this conference and we've arranged for an author signing. I've been told that there are quite a few sessions related to MDM taking place at this conference, so for multiple reasons, this is the place to be!
Thanks to the authors for the tremendous dedication that they have to this topic and for the incredible work they put into creating this book.
svisser1 2700018UK9 4,230 Views
I’m a big fan of the DB2Night Show and attend as many shows as I can. Friday June 20th Leon Katsnelson was the guest on Scott Hayes’ award winning webinar series.
Leon is a great speaker and is passionate about many things including building databases in the cloud. Leon is managing the team of people who have brought us IBM BLU Accelearation for Cloud ( BLU for Cloud).
BLU Acceleration for Cloud is a data warehousing and analytics solution available in the Cloud. It is powered by the next generation in-memory technology DB2 with BLU Acceleration and is combined with Cognos BI. With BLU for Cloud, you’ll experience a powerful, simple, agile Cloud solution.
Try the Beta in your browser or use it through a Cloud provider such as Softlayer or AWS, or let IBM handle it for you through managed services.
During the webinar, Leon explains why IBM is so passionate about Cloud technology and why you should care (your career may depend on it). The way companies approve IT budgets is changing. Be sure you are part of the change.
During the polling questions it came out that many people are afraid of the cloud due to security issues. This isn’t a new requirement. IBM has built its reputation on keeping data safe and secure, and if we suggest you put your data in the cloud, you can be sure that we have technology built into the solution to keep your data safe. Leon gets into details about the security technology including encryption that is built in.
The best thing about this solution is that it is easy! Really easy! Someone else looks after the hardware and the underlying software, leaving you with quality time to explore your data. Data isn’t very valuable on its own. The value is in analyzing it to get the answers to move your business to the next level.
The other thing that is great bout this solution is that it’s fast. Really fast! The buzz word for the past several years has been “big data”. Most of our customers have been managing big data for years. What we need is fast data. BLU for Cloud makes your big data fast data.
Watch the replay: http://www.dbisoftware.com/blog/db2nightshow.php?id=515
Read the storify: https://storify.com/IBMDB2/why-database-in-the-cloud
Try BLU in the Cloud: http://bluforcloud.com/
Quite a few people in the Toronto Lab are upgrading their certifications to the V9 level this summer, and I thought I'd pass on study tips for Exam 733 that I learned from the candidates this week.
1) There isn't a book available for Exam 733, nor is there one in plan. People recommend reading the V8 book by Roger Sanders to help prepare for Exam 733. If you work for IBM, remember that you can access this and other books through Books 24x7.
2) The two biggest additions to the 733 exam versus the 703 exam is .net and XML content. Of course, neither of these topics are covered to a great extent in the V8 book.
3) There are free tutorials for Exam 733, and it is recommended that you use these to prepare for at least the .net and XML areas, but perhaps reading all the 733 tutorials would be beneficial.
4) Not many of the people here take the assessment exams, but they are still valuable at helping you gauge your readiness to pass the exam.
svisser1 2700018UK9 4,250 Views
Blogs about IDUG
IDUG starts next week!
April 29th - May 3rd, 2013
Many blogs have been written about the upcoming event and more will be written. Here is a summary:
New Flashbook: 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
IBM Certification Exams at IDUG 2013 by Rebecca Bond
Blog Sessions at IDUG by Troy Coleman
Security Cost Saving Tips at IDUG by Rebecca Bond
Heading to IDUG 2013? Learn from my experience. by Mike Krafick
Heading to IDUG? by Holly Hayes
IDUG Specific Tweets: Bookmark bit.ly/idugna13
I’ll update this post with blog entries as I discover them. If I’m missing any, do let me know!
svisser1 2700018UK9 4,255 Views
I hope you are aware that we have a Bookstore website where we showcase the books that are related to IBM's Information Management products. Nicole from my team is in the process of redesigning the site and has asked me to update the content. I'm glad we're doing this as I noticed that there are quite a few changes that are needed!
I'd like to ask for your help to make sure that I have the right set of books listed in each of the categories. Today's post is for the Data Management area. Let me know if you think there are books that should be deleted from this list or if there are some that you think should be added.
I'll be posting more lists in my blog each day until I'm finished.
Thanks for your help!