Earlier I posted a blog about the DB2 10 Certification Tutorials for Fundamentals Exam 610
that are being published on developerWorks. There is also a series of
tutorials that are being published to help you pass Exam 611- DB2 for
Linux, UNIX, and Windows DBA.
I’ll update this post as more tutorials are published. Here is what is available now:
(Update Feb 7: Part 2, Physical Design; Dec 6: Part 7, Security now available.)
DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 2: Physical designMohamed Obide, Consulting IT Specialist, IBMAnas Mosaad, IT Specialist, IBMAdel El-Metwally, IT Specialist, IBMMohamed El-Bishbeashy, IT Specialist, IBMSummary:
This tutorial discusses the creation of IBM DB2® databases, as well as
various methods used for placing and storing objects within a database.
This tutorial focuses on partitioning, compression, and XML, which are
all important performance and application development concepts you need
to store and access data quickly and efficiently. This tutorial is
second in a series of eight that you can use to help you prepare for the
DB2 10.1 DBA for Linux®, UNIX®, and Windows® certification exam 611.
The material in this tutorial primarily covers the objectives in Section
2 of the exam.
DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 3: Business rules implementation
Ramalingam Srinivasan, DB2 LUW Consultant, IBM
This tutorial is designed to introduce you to the skills you must
possess to implement business rules in a DB2 database environment. This
tutorial will also help you prepare for Section 3 of the DB2 10.1 for
Linux, UNIX, and Windows Database Administration certification exam
DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 4: Monitoring DB2 activity
Mohamed Soliman, IT Specialist, IBM
tutorial introduces you to the set of monitoring tools that are
available with DB2 10.1 and to show you how each is used to monitor how
well (or how poorly) your database system is operating. This is the
fourth tutorial in a of eight that you can use to help prepare for Part 4
of the DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611.
DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 5: DB2 utilities
Mohamed El-Bishbeashy, IT Specialist, IBM
skills that help you to properly manage your DB2 database servers. This
is the fifth in a series of eight tutorials to help you prepare for the
DB2 10.1 for Linux, UNIX, and Windows Database Administration (Exam 611).
DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 7: Security
Piotr Pruski, Technical Enablement Specialist, IBM
Andre Albuquerque, Technical Enablement Specialist, IBM
This tutorial introduces the concepts of authentication, authorities,
privileges, audit facility, trusted context, RCAC, and LBAC as they
relate to DB2® 10. It is the seventh in a series of tutorials designed
to help you prepare for the DB2 10.1 for Linux®, UNIX®, and Windows®
Database Administration (exam 611). You should have basic knowledge of
database concepts and operating system security.
DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 8: Connectivity and networking
Darliene Hopes, DB2 Solution Migration Consultant, IBM
tutorial is created to provide you with the process of configuring
communications and the processes of cataloging databases, remote servers
(nodes), and Database Connection Services (DCS) databases. You will
also get introduced to DB2 Discovery and learn how to manage connections
to System z and System i host databases. You will also learn about
Lightweight Directory Access Protocol (LDAP). This tutorial prepares you
for Part 8 of the DB2 10.1 DBA for Linux, UNIX, and Windows
certification exam 611.
Here are a few other blog entries about Certification that I recommend:
DB2 10 Certification Tutorials for Fundamentals Exam 610
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
Certification Promotions and Discounts
Modified on by svisser1
Coming in time for the IDUG conference in Philadelphia is the latest DB2 certification guide:
DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration: Certification Study Guide
I'm very pleased to congratulate first time authors Mohankumar Saraswatipura
, Robert Collins
on the great work they did on this book. They worked with the content that was originally created and published by the certification master, Roger Sanders, and updated it to include the knowledge you need to know to pass the 10.1 (C2090-611
) and 10.5 (C2090-311
) certification exams.
Before I go further on the book, let me tell you a bit about these new authors. If you pay attention to the rising stars of the DB2 community, then you've certainly noticed these two before. Mohankumar was the winner of the 2013 DB2's Got Talent Competition via The DB2Night Show hosted by Scott Hayes. Watch the replay of Mohan's winning presentation: DB2 9.7 Performance Tuning for Siebel 8.1 Application - A Complete Success Story
As in the Roger Sanders' versions of the Study Guides, you'll find that Mohan and Kent have continued the established traditions:
The book is organized to match the exam objectives which you can find on the IBM Certification Site.
There are sample questions in the book that are different than the official sample test.
The correct answers to each question are provided in the book. You do not get the answers on the official sample test.
Reasons for why the correct answer is correct are provided for each question. You will not get this information in any other place.
The authors have created "flash cards" to help you study for the exam and the publisher is looking for ways to deliver this to readers.
As we noticed in the show today (episode 150) many people need to read this book to pass!
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!
Modified on by svisser1
We’ve been talking about this release for the past few months and the time is now here where the product is available to be purchased. You can begin realizing the amazing benefits of this technology at once.
Rather than tell you what DB2 BLU is, I’m going to tell you what others are saying about it.
DB2 for Linux, UNIX and Windows Product website:
Here you’ll find the official announcement information about the product and IBM contact information if you need prices or details for your unique environment.
See what’s under the hood. New DB2 10.5 with BLU Acceleration with Free Trial Software
It’s here! The DB2 10.5 with BLU Acceleration software trial is now available! Test drive game-changing features like BLU Acceleration for “Speed of Thought” analytics. Find out how pureScale enhancements help ensure always available transactions Explore advanced compression technologies. Learn about No SQL enhancements that help you position for the future. Try out autonomic management features and much more.
The free trial download of DB2 10.5 is a fully featured 90-day trial.
Article "What's new in DB2 10.5 for Linux, UNIX, and Windows”
This article by Roman Melnyk outlines the key features and enhancements in IBM® DB2® 10.5 for Linux®, UNIX®, and Windows®. To be released in June, this latest version delivers a wide range of new function that directly addresses your business needs in the areas of cost reduction, application performance, productivity, and reliability.
DB2 Express-C 10.5
Get a free copy of DB2 Express-C in the latest release. Use this to create apps or to try the features. Free to develop, free to deploy, free to distribute
Information Center - What's changed in 10.5
Product documentation that shows what's changed includes information about changes in existing functionality from Version 10.1.
Watch the recorded webinars to learn more.
New Flashbook: DB2 10.5 with BLU Acceleration
Read the chapter excerpt specifically about BLU from an upcoming Flashbook. The authors include Paul Zikopoulos, Matthew Huras, George Baklarz, Sam Lightstone, and Aamer Sachedina
DB2 Tech Bits: Hear impressions of BLU from IBM Champions
Thanks to IBM Champions Jean-Marc Blaise, Iqbal Gorawalla, and Tony Winch who joined Rick Swagerman on a special edition of Tech Talks, called Tech Bits, to share their impressions of the new DB2 10.5 with BLU Acceleration. These are short but very informative and worth the time it takes to listen.
Customer Success Story Videos
More are added all the time. Hear directly from customers who spent time using the new technology with their own data and how the technology fared.
Article: Super Analytics, Super Easy: Introducing IBM DB2 10.5 with BLU Acceleration
Read this article that was published on April 3, 2013 in the IBM Data Magazine (ibmdatamag.com) by Guy Lohman, Sam Lightstone and Berni Schiefer. “Imagine a database technology that gives you 10-20 times faster performance right out of the box, requires dramatically less storage, and nearly eliminates the need for tuning. Too good to be true? Not anymore.”
Fact Sheet: IBM DB2 10.5 with BLU Acceleration
Download this PDF for a brochure that describes the product features of DB2 10.5 .
Blog: DB2 10.5 Upgrade – 10 Reasons to Implement immediately!
Learn the 10 reasons to upgrade your database technology for your business to DB2 10.5 from DB2 performance expert, IBM Champion, Dave Beulke.
Blog: Be a Hero the Easy Way : DB2 10.5 with BLU Acceleration
The DB2 Development team spends hours/days/weeks/big bucks determining what features clients want or what the other guys are doing as well as throwing in our own insights. Then there are the thousands of hours doing the implementation & testing and then we do a lousy job of explaining why you care. After all, moving to a new release means extra work for you and there’s got to be some payoff if you’re going to give up a few hours of your life to do the upgrade. Bill Cole – Competitive Sales Specialist,Information Management, IBM wants to burn some of your time to explain what these new features mean to your life.
A lot is going on in the twitterverse in regards to this release. If you want to take a look for yourself, learn how via this blog entry: Learning to Tweet with DB2.
Administration: The Complete Guide to Practices and Procedures (2nd
by Craig Mullins
This is Craig’s second book this year! Make sure you congratulate him on
this amazing accomplishment!
The DB2 Developer’s Guide 6th Edition: A
Solutions-Oriented Approach to Learning
the Foundation and Capabilities of DB2 for z/OS came out earlier this year
Administration: The Complete Guide to Practices and Procedures (2nd
Edition)will be launched at the IBM
Information on Demand Conference.
If you're in Europe, you can purchase this book
and many others in the IBM Press series at 35% off the retail price,
plus free shipping in the UK and discounted in other countries.
About the book:
Database Administration, Second Edition is the definitive,
technology-independent guide to the modern discipline of database
administration. Packed with best practices and proven solutions for any database
environment, this book fully reflects the field's latest realities and
challenges. Drawing on his unsurpassed database experience, Craig focuses on the
problems today's DBAs actually face, and the skills and knowledge they simply
must have. Craig covers every aspect of the DBA role, including creating
database environments; data modeling and normalization; design; performance;
data integrity; compliance and governance; security; backup/recovery; disaster
planning; data and storage management; data movement/distribution; data
warehousing; database connectivity; metadata; tools, and more.
This edition's updates and improvements include:
- New coverage of "Big Data," database appliances, cloud computing, NoSQL, and
other crucial trends
- An all-new chapter on regulatory compliance and the DBA
- New material on data breaches, auditing, data encryption, data retention,
database archiving, data masking and sound metadata management policies
- Coverage of important new features in leading databases (e.g. temporal data,
- End of chapter questions that reinforce readers' understanding and can serve
as project-oriented classroom assignments
- New glossary and updated DBA "rules of thumb"
Meet Craig on Tuesday, October 23 from 12:00 – 1:00 pm at the IOD
bookstore. These books can be purchased at the IOD bookstore for a 20%
discount. Meet Craig and find out how he managed to publish two books in a
Also attend Craig’s IOD session: 1066A Ten Breakthroughs That Changed IBM
DB2 Forever; Thu, Oct 25, 2012; 10:00 AM - 11:00 AM - Islander B
Follow Craig’s Blogs & Twitter account as well:
Thanks to Norberto
for accepting my invitation to be a guest blogger on my site today. Norberto was one of our finalists in the DB2Night Show's "DB2's Got Talent" Competition". As in his presentations, you'll find this post very full of incredibly useful information. Norberto was concerned that his post was too long, but I assurred him that it perfect as is. I hope you'll agree.
It’s a pleasure to be here in Susan Visser’s blog today. I’ll talk about the contest, with special focus on my last presentation.
On the final round, at the beginning of our presentations, we contestants showed more info about our lives. It was nice to show the world more about our personal info. That made people feel closer to us I think.
I started talking about all my past presentations. I turned off my mobile, all messaging/mailing applications from my laptop, and even put Calopi (our cockatiel) in a room far from my office, BUT during that slide, my home phone started to ring! That messed up with that slide a bit, as I lost concentration.
After showing my past tips/lessons learned, I introduced some tips I use daily - which are not specifically related to DB2, but will surely be useful to any DBAs and other people. Here they are:
- Log everything you do on PuTTY. There are times you have to know something you did in the past. With the help of PuTTY logs, you can retrieve that.
- PuTTY Connection Manager - can be very useful when you have to have several sessions open at the same time.
- You can use PuTTY from your mobile - That can really help with situations when you don't have a computer near. (But you will have to have access to your server's network from your mobile.)
- This is an old set of executables that enables anyone to issue very nice Unix commands like grep, tail and so on.
- Very useful to write SQL queries, procedures and functions. It's built-in functions enable users to do complex text changes with just a few clicks.
The Win+M key
- You can clean your Windows screen by just pressing those 2 keys. Very useful (if you use dozens of apps at same time like me) .
After that, I focused on DB2, introducing some technical tips:
- For any problem you have, the best start is always the DB2 InfoCenter (in the same version you have your DB2).
- Next, a tip about changing several passwords on several servers quickly. I know user/password management can be a cumbersome task which can take a lot of time. Usually, the DBA team owns all DB2 users (instance owner, fenced, DAS), so they are responsible to keep them secure. With the approach I showed, and with some automation using the ATTACH command, the task can be extremely simplified. I'm planning to create a stored procedure to do that automatically, based on a table having server names, instance names and ports, user IDs and old/new passwords. When I have it created I'll post in my blog.
- Put DB2 environment variables in the right place - Most of the DB2 DBAs I know are not aware that using ~/sqllib/userprofile is the most correct place to put any environment variable and customization which would normally be on the instance owner's .profile. By using that, other users who call ". $INSTHOME/sqllib/db2profile, will have the same configs as if they were the instance owner.
- Using scripts to save your time - I commented about some scripts that I wrote in the past. They are really useful for me, and I wanted to share them in my blog. Some are already there, others are not (but I'll add all them there soon).
- Next I focused on how to execute SQL generated by SQL through a unique command line. Through help of sed, this very useful tip works smoothly on Linux and Unix. I’ll post that in my blog soon.
After those technical tips, I also gave some educational/networking advice.
Don't overlook the cloud - you can take advantage of it right now! BTW, I met Raul Chong here in Curitiba this week, and he showed us DB2 on cloud in a very nice presentation.
Another nice tip is about reading everything you can about new implementations and behavior changes on new versions of DB2 (through the InfoCenter). I mentioned that, for example, from DB2 v9.5 on, you don't need to issue db2iupdt, migrate database or even bind packages for all databases when applying fixpacks. If you know that, you can save time!
After that, I advised people to stay tuned by:
Regarding DBA skills, certifications are always welcome (you can see I showed the ones I achieved at the beginning of my presentation). Buying a good book for that is one of the best paths for ensuring your success on the exam. I also put a link to DB2University, a very complete website where you can find some free and other inexpensive courses, as the name suggests, all about DB2.
Putting all that together and presenting in just 6 minutes was not easy, so I had to hurry a bit.
That’s all about my presentation on the DB2’s Got Talent Finale.
I’m sure all contestants did their best showing their tips and lessons learned. We all have many roles, and finding time to present such info is a really hard task. I confess I went to sleep very late some nights to have my presentations ready!
I’m now in touch with some of the other contestants, and really like the idea of having such highly skilled DBAs in my network. Audience/replay watchers also added me on LinkedIn and started following my twitter and my blog. Thank you all! I’ll do my best to fill my blog with useful information!
I’d like to thank Scott Hayes for the opportunity he gave us, and also the judges – Susan, Martin, Klaas, and Cristian – your comments always brought value to the presentations.
I’ll finish saying it was a great pleasure to participate on this contest, and I encourage other DBAs to do the same in the future. I’m sure Scott will want to repeat this success :)
Thanks Norberto! I enjoyed your post very much.
Voter comments about Norberto:
- Very impressive presentations! I liked all of them, but Norberto's tips where simple and extremely usefull!
- Norberto's presentation, though had no out of box tool/new db2 functionality but he shared the tools n tips that surely gonna help any naive or even a seasoned dba
- Norberto is the best DB2 DBA ever!
- Vai Norberto Vai !!
- Norberto's presentation was fantastic!
- It has been quite interesting walking through the presentation and appreciate the way information has been compiled together and presented. I wish all 4 contestants the very best and especial mention for Noberto for making life really easier one :)
- Way to go , Norberto :D. You have been great. Fingers crossed. Good luck for the final round !
- Great presentation from Norberto, he deserves be the winner
You can see all voter comments on Scott’s Blog.
Join Serge Rielau, Conor O’Mahony, and Cindy Fung as
they take you on a tour of DB2 10 & InfoSphere Warehouse 10.
Details: DB2 Tech Talk: Technical Tour of New DB2 10 and
InfoSphere Warehouse 10
Date: Thursday April 26
Time: 11:30am – 1:00 pm EDT
Get the details behind these new product releases as announced on April 3.
Learn about powerful new features such as:
- Storage Optimization Advances, including Adaptive Compression and
Multi-Temperature Data Storage, which are designed to optimize your storage
environment and system performance.
- SQL Compatibility enhancements that make it even faster and easier to
migrate from Oracle Database to DB2.
- Time Travel Query, which provides native temporal support, enabling you to
better support your business and more easily meet compliance and data retention
- Real-time operational data warehousing, with features such as data ingest
and query performance enhancements, designed to enable better and faster
- NoSQL capabilities that help you implement models beyond relational, such as
unstructured XML data and RDF graph triple data. Handling these new types of
data along with your relational data is becoming a requirement in
Watch for additional webcasts that will be offered throughout 2012 to provide
in-depth discussion on the features in these releases.
This is the kick-off Tech Talk and you are strongly encouraged to attend.
Register now: http://bit.ly/IT7IGg
See also my other blog entries about DB2 10 and InfoSphere Warehouse 10:
New Flashbook for DB2 10 –
Launching at IDUG Denver
DB2 10 – From IBM Champion’s
DB2’s Next Major Release
I'm not sure where to start today... yesterday was such a momentous day! Obama's inauguration speech inspired much hope around the world (remember, I'm a Canadian and wasn't able to vote).. I can almost feel the change happening around me!IBM released their 4th quarter results
... and guess what? They were fantastic! I'm sure there are lots of reasons for such results, but maybe a part had to do with the Smarter Planet
initiative which... again is inspiring change in organizations world wide.
On a much smaller level... let me try to inspire some hope.. and perhaps change.Craig Mullins
recently blogged about Ten Tips for DBAs to Get a Raise
based on the article DBAs: Get a Raise! 10 Tips for Success at Review Time
by Bob Zurek
. When reading the article, I realized that it isn't very difficult to achieve what Bob suggests, especially since my team works tirelessly at providing you the tools that you need. 1. Expand your knowledge beyond the “Big 3” commercial databases to include popular open source database systems.
OK... for starters.. do you know all the "Big 3" commercial databases? If you don't yet know DB2... the best place to start is the book Understanding DB2(R): Learning Visually with Examples (2nd Edition)
. If you do know all three and are looking for an open source database to learn... look into DB2 Express
. Technically it isn't "open sourced", but it is free and easy to use.2. Get certified.
Now this is an easy one! I've been encouraging people to get certified for nearly 10 years now! We have an excellent program that allows you to go very deep in a technical way. You'll find everything you need on our Training and Certification page
. And don't forget the series of certification guides that we have published to help you deepen your skills and pass the exam. See a discussion of the books in the DB2 in Books
group on ChannelDB2.3. Learn about high availability, clustering, and replication.
I don't know of a recent book on replication... but you can learn more about high available with this book: High Availability Guide for DB2
by Chris Eaton
and Enzo Cialini
. And clustering with this book: DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification
by Roger Sanders
and Dwaine Snow
.4. Enrich your database administration skills with expertise and experience in data security.
Ah... security... it keeps coming up, doesn't it? Here is the best book on the market to help you as a DBA figure out what you need to know: Understanding DB2 9 Security
. Rebecca Bond
, the lead author, is a DBA and a security expert. Learn from her and her many experiences, including Katrina.5. Know about data quality and how to implement a data quality and auditing solution in conjunction with your database projects.6. Drive the adoption of metadata management capabilities across the organization including establishing a metadata business glossary.
For both of these points, I would suggest the book Enterprise Master Data Management: An SOA Approach to Managing Core Information
. 7. As a DBA, you might not be writing any application code, but you will need to become a SQL expert over time.
There are many resources available in this area. See my blog entry about SQL resources
. Soon a book on pureXML will publish, so stay tuned.8. Become a member of the customer advisory board of your company’s database vendor.
This item fits loosely in the category of joining a community. See my blog entry on several communities
that you might wish to join. Also remember that those who do get involved could get rewarded via the IBM Data Champion Program
.9. Mentor other DBAs in your organization.
See this brand new book for some tips on mentoring: Intelligent Mentoring: How IBM Creates Value through People, Knowledge, and Relationships
.10. Dig into the topic of database analytics.
There are several choices, but my suggestions are the following:Competing on Analytics
by Tom Davenport Managing Your Business Data: From Chaos to Confidence
by Maria Villar
and Theresa Kushner
Also, I recently watched Baseline's Career Slideshow: 10 Hot IT Jobs for 2009
. Again, I was pleasantly surprised to see that I am able to recommend books that may suit a few of these jobs.1. Business Intelligent Experts
See these two books:Competing on Analytics
by Tom Davenport Managing Your Business Data: From Chaos to Confidence
by Maria Villar
and Theresa Kushner5. Enterprise Architects
See this book: Enterprise Master Data Management: An SOA Approach to Managing Core Information 6. ITIL Managers
Check out this book: Implementing ITIL Change and Release Management
by Larry Klosterboer8. Security Architects
See this book:Understanding DB2 9 Security9. AJAX Developers
In the description for this job, they also mention XML Developers. There will be a book published this year specific to XML, but in the meantime, check out these resources listed in previous blog entries
I wish you much success in this year of change!
Today we had a very interesting tweetchat that was organized by our friends at @DB2Geek. The theme today’s debate was “Is the role of a DBA dead?”
If you weren’t able to join us, I’ve managed to pull together many of the comments in a really need way called “storify”: Is the Role of a DBA dead? http://sfy.co/r57H
A few comments came in after I built this story that I wasn’t able to include. The result of today’s debate: The DBA is definitely not dead... but are “Dedicated, Energetic, Advanced and Dynamic!”
Thanks to all who participated and we all hope to have more people join us for the next DB2Debate on June 18 “Is the database a commodity?”
On behalf of the entire DB2 community, I’d like to thank all those who took part.. in particular:
DB2 Users Group@IDUGDB2
Norberto G Filho@norbertogf
Hint: If you’re new to twitter.... follow these people if you’re interested in DB2 content!
I heard from several people who wanted to join this chat but were getting errors that twitter was down for maintenance. I did get that message as well, but was able to contribute by logging into tweetchat.com. This opens up a new window and once you sign in and search on #db2debate, you are able to see the entire conversation and can contribute without adding the hashtag. It works very well!
Articles by Craig Mullins
Craig wasn’t able to join us for this event, but he has written many articles on this topic that he recommended after the event was over:
Are DBAs Obsolete?
The Guide to Being a Successful
What is the role of a DBA?
Intelligently Automating DBA Tasks
DBA Best Practices?
Craig’s book: Database Administration: The Complete Guide to DBA Practices and Procedures (2nd Edition)
Inside Craig’s Data Reading Room
All DBA related articles from Craig.
Keep writing Craig! We all benefit from your knowledge and insight!
Other articles suggested during the debate:
Your DBA Role is Changing. Are you Ready?
The changing roles of developers and DBAs
Does the Role of the DBA Need to Evolve?
What would you ask a BigData expert if you could? Maybe the same as Marc Blaise asked Leon Katsnelson?
DB2 DBAs are not dead! They are watching The DB2Night Show for FREE Education! Over 264000 downloads!
The IBM Data Magazine - it's all about the data! Great articles. Come often.
The DB2 Facebook page continues to grow and I hope it has content DBAs find useful.
IDUG Facebook page.
DB2Geek Facebook page.
developerworks is full of great content for DBAs.
IDUG Specific Discussions:
Calling all non-Dead #DB2 DBAs! Don't miss @dbisoftware & HLS party at #IDUG Tues Night 8pm Visit Booth #103 for Free Invite! #DB2Debate
#DB2Debate reminder for #IDUGNA attendees: Bookmark bit.ly/idugna13 for a Twitter Search Feed of all #IDUG and #IDUGNA Tweets!
Let's #DB2Debate this further at #IDUG ow.ly/klhQk Plenty of Networking Opportunities and Tech Sessions. Alive DBAs welcome!
@susvis will be at #IDUGNA next week. If you want to give an opinion on this topic... she will be happy to listen & record. #DB2Debate
I asked my wonderful friend Rebecca Bond to give me her IDUG Conference
schedule for the Tampa conference during the week of May 10th. I asked Rebecca because she is working as a DBA and has for many years. I figure that her schedule will more closely match the target audience than a schedule I'd put together.
I had to make some REALLY difficult decisions. There are some EXCELLENT speakers and sessions this year.
These are the ones I finally decided to attend. I seriously hope that the ones I am going to miss will be presented at IOD so I can try to attend them then. IDUG has outdone themselves with this line up.
I may look at taking one of the classes on Monday. Just depends on how my writing projects are going and if they have any available spaces left when I make the determination.
I can't decide on which restaurant to sign up for on the Dine Around evening. Several good choices and I want to have dinner with everyone so I think I'll just have to put a blindfold on and throw darts at the sign up board....you might want to warn your readers to steer clear of the sign up board if they see a crazy lady in great shoes start to put on her blindfold.
May 11, 2010
8:00 K01: DB2 INNOVATION: POWERING INFORMATION WORKLOADS FOR SMARTER IT
10:00 S02: DB2 FOR LINUX, UNIX AND WINDOWS - TRENDS AND DIRECTIONS
12:30 D01: CAPITALIZING On DB2 LUW V9.7 Capabilities - A Data Management Feature Presentation
1:45 D02: Varsity SQL for the Busy DBA
3:00 C03: Enabling Oracle Applications on DB2 - an Early User Experience
4:15 D04: A VISUAL TOUR OF DB2 9.7 SQL AND PL SQL ENHANCEMENTS
May 12, 2010
8:30 C05: An Indepth Technical Look at DB2 pureScale
9:45 D06: DB2 SECURITY – AMMO FROM THE TRENCHES -- Presenting
11:00 D07: UPGRADING DB2 9.7 – BEST PRACTICES AND LESSONS LEARNED
1:30 V05: You Killed the ELEPHANTS but MOSQUITOES are Killing YOU!
2:45 D08: STUFFED WITH GREAT ENHANCEMENTS - DB2 9.7 FIX PACK 1 NEW FEATURES
4:00 I01: Data Privacy, Security and Audit Compliance -- Panel Participant
May 13, 2010
8:30 C09: pureScale - Why It's So Much Better than Oracle RAC
9:45 D10: LOCKING - WHAT LOCKING? CURRENTLY COMMITTED AND OTHER LOCK AVOIDANCE ENHANCEMENTS TO INCREASE PERFORMANCE AND THROUGHPUT
11:00 V10: END-TO-END MONITORING & PROBLEM DETERMINATION WITH OPTIM PERFORMANCE SOLUTION
1:30 D11: ENABLING FROM ORACLE TO DB2 COBRA THE EASY WAY.
2:45 F12: DB2 Back and Recovery - What Do I Really Need to Know?
4:00 I05: DB2 FOR LUW - HIGH AVAILABILITY & DISASTER RECOVERY
May 14, 2010
8:30 E13: All the FREE Things you can Do with Data Studio
9:45 E14: Diagnosing & Curing? Lock, Wait and Performance Bottlenecks
11:00 B15: Auditing options on DB2 for z./OS (Moderator)
Thanks Rebecca! I wish I was going so I could attend all these amazing sessions with you!
If you missed my posts in the past week, here's the rest of the IDUG coverage that you can find:
The educational seminars
are taking place that on Monday, May 10. Be sure to check out the offerings.
Check out the bookstore that will be onsite where you can purchase the book that Rebecca wrote:
Do you ever wonder what everyone else is making, and how your salary measures up? The CertMag’s 2007 Salary Survey
was recently released... and guess what? IBM Certified DBAs
are on top!
* IBM Certified DBA / Application Developer - $87,390 * Microsoft MCDBA - $78,420 * Oracle DBA OCA - $79,730 * Oracle DBA OCP - $84,520 * Oracle Developer OCP - $78,250
So... if you are working as a DB2 DBA.... I hope you're making this much and are happy that you are on top. If you are not working with DB2 yet.... there is always time to make a conversion
Craig Mullins also blogged about this news, so make sure you read his perspective
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!
If you are a DBA and only want to buy a single book to have as a reference, here's what I suggest:DB2 for Linux, UNIX, and WindowsDB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
Written by long time DB2 experts and DB2 evangelists, George Baklarz
and Paul Zikopoulos
, this book is the reference and guide that you will use over and over as you do your job!DB2 for z/OSDB2 Developer's Guide (5th Edition)
by long time DB2 expert and consultant, Craig Mullins
. This book keeps on selling and selling... so it may be that everyone who works on DB2 for z/OS already owns a copy! If you don't, you should!Informix Dynamic ServerAdministering Informix Dynamic Server: Building the Foundation
by long time IDS expert Carlton Doe
. At this point, this is the ONLY up to date IDS book that is available! Buy it because it WILL update you on all the changes in the product, but also, the more books that sell, the more likely it is that we'll have more IDS books published!
If you do not find that these books fill your needs... don't worry... we have many others! See our IBM IM Bookstore
and the channelDB2.com DB2inBooks
The book DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide
by Roger Sanders
and Dwaine Snow
is going through its final tech review right now.... and the reviewers are loving the book! Order your copy now... amazon.com is offering a 37% discount
This new book is essentially an update to the very successful book that was published to support DB2 V8: Advanced DBA Certification Guide and Reference for DB2(R) Universal Database v8 for Linux, UNIX, and Windows
by Dwaine Snow
and Thomas Phan
. The differences?
1) We changed publishers... This book will join the series of V9 study guides published by MC Press
. These books are very successful and are excellent resources to prepare people for the V9 cert exams.
2) We changed one of the authors: Roger Sanders
teamed with Dwaine Snow
... so together they bring their talents to this one book. Roger with his amazing writing skill and the creator of the study guide format that you will recognize throughout his books.... and Dwaine for his deep technical knowledge in the advanced DBA area.
3) Sample questions were added that are similar to the actual exam... along with explanations for the correct answers.What's the same?
1) Much of Dwaine's content is the similar to the old book... and if the exam doesn't cover certain topics, the content has been included in an appendix of the new book.
2) The first book had 14
5-star reviews... and one 4-star review. Of course there are no reviews of the new book yet... but I'm asking the reviewers to give their feedback so you can see it.
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.