The latest edition of certmag.com has an article about using advanced certifications to advance your career:
After reading this article, I checked our database to see the how many people have been certifed at our Advanced DBA level (you need to pass Exam 704 after achieving a DBA cert): http://www.ibm.com/certify/certs/dbdvud81.shtml.
Although I can't tell you how many certifications have been achieved, I can tell you that only 7% of those who have earned a IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows have also earned the Advanced DBA certification.
I really believe that anyone who has passed Exam 701 also has a good chance of passing Exam 704. If you are one of these people, take the challenge and try Exam 704.
Exam 704 contains a total of 57 questions. Candidates are required to score 56% or better to pass the exam and will have 75 minutes to complete the exam.
Section 1 - Advanced Administration (32%)
Ability to design table spaces
Ability to create table spaces
Ability to manage table spaces
Ability to design buffer pools
Ability to create buffer pools
Ability to manage buffer pools
Ability to exploit intra-parallelism
Ability to exploit inter- parallelism
Ability to design and configure federated database access
Ability to manage distributed unit of work
Section 2 - High Availability (19%)
Ability to develop a logging strategy
Ability to use advanced backup features
Ability to use advanced recovery features
Ability to implement a standby database (log shipping, replication, failover, fault monitor)
Section 3 - Performance and Scalability (37%)
Identify and use configuration parameters that affect database system performance
Identify and use DB2 registry variables that affect database system performance
Knowledge of query optimizer concepts
Ability to manage and tune memory and I/O
Ability to analyze performance problems
Ability to manage a large number of users and connections
Ability to partition large amounts of data for performance
Ability to manage the number of partitions in a database
Ability to create and manage multi-dimensional clustered tables
Ability to determine the more appropriate index
Section 4 - Networking & Security (12%)
Ability to configure a partitioned database on multiple servers
Ability to manage connections to host systems
Ability to identify and resolve connection problems
Knowledge of external authentication mechanisms
Ability to implement data encryption
The best way to prepare for this exam is a combination of EXPERIENCE and STUDY. The only book that was written for this exam is:
Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
by Dwaine Snow and Thomas Phan
Notice that this book has received 12 customer comments on amazon: all 5 stars, except one 4 star.
One of the features of this book that I want to make you aware of is that there are excellent sample study questions in the book. Each chapter contains several questions that are similar to the questions that you'll see on the certification exam. The authors then tell you which answer is correct, and why. Dwaine was on the exam development team and helped create many of the questions that are on the certification exam, so make sure you benefit from his knowledge by reading this book!
The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
Keep on Learning
From archive: October 2005 X
The great buzz around the book Self-Service Linux : Mastering the Art of Problem Determination continues:
"This is definitely my choice for best book of the year. Yes, I know we have a few months to go, but I can't see this getting beat out. Buy this today; you will not regret it. "
The book is available on amazon.com for a discount of 34%. If you have read the book, add your review as well
For the past few months I have been thinking about the value of podcasting in relation to promoting technical books. Last week at CASCON the idea came up again, so I'd like to get your opinion on the idea.
My goal would be to put the preface of new books into podcast format. The preface of the book should answer the question, do I need this book? My vision is to have a podcast that is only a few minutes in length, for each book.
As a new book is published, a podcast would be made available. This would work well as a subscription series in that it would help people stay on top of the newest releases as they are made available.
Most book prefaces are written in a conversational manner, so I believe that this would make for an easy and interesting way to learn about the need for the book.
Whose voice should do the podcast? I'd prefer to have the author of the preface do the recording, but would do it myself if necessary.
Let me know what you think. I may go ahead and do a pilot of one of the books and post it on this site. The next book in my realm that will publish is Apache Derby -- Off to the Races : Includes Details of IBM Cloudscape http://www.amazon.com/gp/product/0131855255/102-8524566-1932154?v=glance&n=283155&s=books&v=glance.
Yesterday I participated in a workshop about business blogs - The Business of Blogging: Being Social in a Pervasive, Networked World.
The speakers discussed the history of blogging, tools that are available, research on who is blogging, as well as the issues of using blogs for business.
Speakers included Alvin Chin and Mark Chignell from University of Toronto, Joey de Villa from Tucows, Ian Graham from BMO Financial Group, and Veronica Holmes from Bell Canada.
From the research, it was shown that people who read blogs are highly educated people in their 30s or 40s who earn high salaries. Primarily, bloggers are looking for information that is hard to find in other places. You can see why businesses are getting more and more interested in setting up blogs to support their products / services.
For more information on CASCON, as well as details of all the conference proceedings, see https://www.ibm.com/ibm/cas/cascon/[Read More]
CASCON, The Centre for Advanced Studies Conference, is taking place this week in Toronto. CASCON is the premiere computer science and software engineering conference in Canada. This conference is an excellent venue for exchanging ideas, showcasing results, experiences and tools, and networking with researchers and practitioners from academia, industry, and government.
Here is a link to give more information: https://www.ibm.com/ibm/cas/cascon/
Yesterday I had lunch with Stephen Perelgut who ran a workshop on popular technologies such as blogging, podcasting, and RSS feeds. Stephen is running two sessions this week, and both are full to capacity. I was too late to sign up for either of his workshops, so I'm not able to attend. Stephen tells me that he may run another session in the Toronto Lab for employees in a few months.
After lunch I met with Dr. Imran A. Zualkernan who is working on a technology to turn flow diagrams into test questions. Dr. Zualkerman showed me this technology in action using a flow diagram for a few DB2 UDB task. Seems interesting, but I don't think it's ready for prime time use yet. I'll provide some user scenarios to Dr. Zaulkerman so he can further test this technology. Using this technology might be helpful when creating sample study questions. We'll see.
I spent the afternoon in a Women in Technology Workshop: Tenth Workshop on Women in Technology: Global Transformation for Women & ICT.
This workshop discussed the ongoing action needed to transform the global position of women in Information and Communication Technology (ICT). The speakers/facilitators included: Claudia Morrell, Kelly Lyons, Sophia Huyer, and Ann Holmes.
It is conceived as a follow-on to the First International Symposium on Women and ICT that took place June 12-14, 2005 in Baltimore, Maryland, USA. Two hundred and fifty participants, representing six continents and 29 developing and developed countries, including leaders from business, government, non-government agencies, and education, gathered to explore concrete ways to increase girls' and women's participation and leadership with Information and Communication Technology in order to effect economic, social, and political change.
The focus of the CASCON session was to discuss the messages that should be presented at the second United Nations World Summit on the Information Society, Tunis 16-18 November 2005. The goal is to change the gender disparity evidenced in Women and Information Technology: Fast Facts at http://www.umbc.edu/cwit/fastfacts.html and planning for continuing action.
Some interesting facts:
* Computer-related occupations, 2004, U.S.
* Computer and information systems managers, 31.0% female
* Computer scientists and systems analysts, 29.4% female
* Computer programmers, 26.7% female
* Computer software engineers, 25.0% female
* Computer support specialists, 29.7% female
* Database administrators, 33.6% female
* Network and computer systems administrators, 20.3% female
* Network systems and data communications analysts, 21.9% female
* Operations research analysts, 43.0% female
Source: U.S. Bureau of Labor Statistics, 2005
The database area has had very highly ranked women running the business until recently: Janet Perna and Pat Selinger. Both of whom have recently retired.
I can't say that I've overly passionate about this subject yet, but it does bother me to hear that fewer and fewer women are going to university and even fewer are choosing technical degrees. There are lots of studies that try to figure out the reason for the decline as well as many programs in place to help. One of the things that we discussed yesterday was the need to figure out what programs exist around the world and to share these ideas so we can make programs accessible to people every where in the world. A portal is being designed, so hopefully that will help.
Kind of in line with this topic, last night I volunteered to help out at a Girl Guides event in support of a technology badge. This is one of the many programs that IBM takes part in to encourage girls to take an interest in technology.
This book is on my mind this week:
Self-Service Linux: Mastering the Art of Problem Determination
by Mark Wilding, Dan Behman
The publisher sent me 40 copies of the book to send to people who helped review the book or to people who will read the book and tell others about it. Yesterday Dan Behman came by and signed more than 20 copies of the book and I'm hoping to see Mark Wilding some time today. Once they are signed, I'll send them to the many people who helped with the creation of the book.
Publishers are always looking for people who are interested in reviewing books: both books that are published or about to be published. If you are interested in becoming a reviewer, let me know. Opinionated people are always welcome!
Speaking of reviews, check out the reviews that are on amazon now for the SSL book. The book has two very positive comments so far.
This week the IMS Technical Conference took place at the McEnery Convention Center in San Jose. Although I wasn't able to attend the conference, I arranged for each attendee to get a complementary book:
"An Introduction to IMS"
Dean Meltz, the lead author for the book, was available to sign the books for the attendees.
I also arranged for Sharon Qi to sell IBM Press books at a discount. We didn't sell many books, but hopefully more people are now aware that there are books available.
Sharon tells me that many of the attendees were asking for more books on IMS. I'd like to have more published as well, but it mainly depends on how well the current book does.
Besides this book, there is a landing page on dworks for IMS content: http://www.ibm.com/developerworks/db2/products/ims/
There are also serveral redbooks:
If you're interested in more books about IMS, let me know what kind of topic you are interested in.
The first edition of the New DB2 Information Management Professional Certification On-line Newsletter is now available.
This newsletter was developed for IBM Certified Professionals who have successfully completed one or more certification exams. This newsletter will provide you with certification announcement special events, promotions, and other skills related news so you can stay in touch with IBM.
Check out the October edition at: http://www.ibm.com/software/data/education/cert-newsletter.html[Read More]
Last week I posted about DB2 for z/OS books and mentioned Craig Mullin's book. Unfortunately I mentioned the 4th edition instead of the 5th. Here are the details on the 5th edition:
DB2 Developer's Guide (5th Edition)
by Craig S. Mullins
I added a link to the right hand side of this page to link to his book. Its now on sale at amazon for 29% off.
Also, I mentioned that Curt Cotner has a blog. The address is: http://firstname.lastname@example.org
I've also added a link to the right for your future reference.
Thanks to those who gave me comments to correct these ommissions.
IBM Launched a whole series of Express editions of products to fit the needs of small to medium-sized businesses. Attend the webcast on Oct 12 to learn more:
Webcast: IBM Express Portfolio Announcements - Oct. 12
Designed, built and priced specifically to address the on demand business needs of mid-sized companies, the IBM Express Portfoliofeatures: relevant, scalable technologies that work with existing IT infrastructure; selected configurations that are easier to acquire, install and manage than traditional offerings; competitive pricing and enhanced availability; 100 solutions for mid-sized businesses, ranging from hardware and software to services, and; low-rate financing and simple, affordable leasing options. Register today for this live Web broadcast.
We also specially created the following book to support the express edition:
DB2 Express : Easy Development and Administration by Paul Yip, Kit Man Cheung, Jason Gartner, Clara Liu, Stephen O'Connell
Buy it directly from IBM Press to get a 30% discount:
What is in the book?
IBM DB2 UDB Express Edition Version 8.2 delivers everything small to medium-sized businesses need to accelerate time-to-value and dramatically reduce TCO in their database applications. Now, IBM's own experts show exactly how to get started with DB2 Express, and use it to develop, deploy, and manage superior applications from start to finish.
Like DB2 Express itself, this book cuts out the complexity--helping you achieve the full business benefits of today's most advanced database platform simply and quickly. You'll find step-by-step guidance and expert tips for every facet of DB2 Express development and administration, including: application design; development with both Visual Basic .NET and Java; security; deployment; performance tuning; day-to-day administration; and more.
IBM's own DB2 specialists demonstrate how to use DB2 Express' graphical tools to manage DB2 more easily than any other full-function relational database. Along the way, they help you make the most of DB2 Express' powerful "autonomic" features for self-administration, self-tuning, and self-healing to drive down costs throughout the entire application lifecycle.
This book will help you:
* Understand DB2 Express architecture and its implications for development and administration
* Install DB2 Express, create databases, and master essential DB2 Express tools
* Work with database objects: schemas, data types, tables, relationships, views, and indexes
* Develop VB.NET applications with ADO.NET and the DB2 .NET Data Provider
* Develop Java applications with JDBC and SQLJ
* Leverage DB2's concurrency model to design efficient transactions and improve user experience
* Introduce database functions, stored procedures, and triggers to improve application design
* Generate and manipulate data efficiently: LOAD, IMPORT, exporting to Microsoft Excel, reporting, and more
* Tune performance: optimize your configuration, analyze SQL with Visual Explain, and optimize SQL with Design Advisor
* Secure your applications: authentication, authorization, group privileges, and more
* Deploy to production, and master silent DB2 installations
* Define a solid database maintenance plan that fully leverages DB2 Express autonomic features
* Troubleshoot DB2 Express and avoid common pitfalls
Whether you're a developer, administrator, IT manager, or end-user, this definitive single-source guide will help you achieve results fast... and maximize DB2 Express' business value, every step of the way.
About the Authors
Paul Yip is a database consultant at IBM Canada. As a member of IBM's Channel and Partner Enablement Team, he works closely with partners, ISVs, and integrators to develop and tune third-party products for DB2. He coauthored DB2 SQL Procedure Language for Linux, UNIX and Windows (Prentice Hall, 2003) with Clara Liu.
Kit Man Cheung, member of IBM's DB2 Tools Development Team, has deep technical insight into DB2 Version 8.2's new GUI tools.
Jason Gartner, member of IBM's DB2 Tools Development Team, has deep technical insight into DB2 Version 8.2's new GUI tools. He is Development Manager for DB2 administration tools.
Clara Liu is a database consultant at IBM Canada. As a member of IBM's Channel and Partner Enablement Team, she works closely with partners, ISVs, and integrators to develop and tune third-party products for DB2. She coauthored DB2 SQL Procedure Language for Linux, UNIX and Windows (Prentice Hall, 2003) with Paul Yip.
Stephen O'Connell, member of IBM's DB2 User-Centered Design Team, has worked on the DB2 Web client and many other IBM-wide DB2 initiatives.