I just realized that I haven't blogged about our certification program in some time. I dusted off a blog entry I did last year, updated it, and voila, here it is:
DB2 has six current certification exams that each lead to a different certification role. The most common certification is IBM Certified Database Administrator. Here are the exams that cover DB2 9 content:
* Exam 730 - DB2 9 Fundamentals * Exam 731 - DB2 9 DBA for Linux, Unix, and Windows* Exam 732 - DB2 9 DBA for z/OS* Exam 733 - DB2 9 Application Developer * Exam 734 - DB2 9 Advanced DBA for Linux UNIX and Windows* Exam 736 - DB2 9 Database Administrator for Linux UNIX and Windows Upgrade
Each exam has a time limit of 90 minutes, except the upgrade exam which has a time limit of 60 minutes. The number of questions and the cutscore for each exam varies. For example, exam 730 has 64 questions and you must score 59 percent or higher to pass it.
To become certified as a Database Administrator, you must pass both exams 730 and 731. Exam 730 covers basic DB2 concepts like SQL, installation, packaging, security, and concurrency. Exam 731 is much more detailed and focuses on the job tasks that a database administrator does in his or her daily job.
Certification Tips Common questions about certification go something like this: Do I have to get certified?, Is it worth anything?, and How do I get it? I've put together answers to these questions along with some other advice that I hope you find useful.
Do I need a DBA Certification to get a job as a DBA?
Not always as it depends on a number of factors. If you've worked as a DBA before or have a degree in an IT related field, and have experience using DB2, you may not need to get certified. I'd recommend it anyway, as regardless of what you already know, you'll learn something new during the process of earning a certification that may be tremendously valuable to you or your company If you have an older certification, upgrading to the most current level is an easy way to ensure that you stay on the top of your game.
If your employer requires you to be certified, or a job you are trying to get lists certification as a requirement, then for sure you'll need to earn the required certifications.
If you have little experience using DB2 or if you have a degree in a non-IT field and you're trying to break into the database arena, it's generally a good idea to get a few DB2 Certifications so employers take you a little more seriously. For self-study, also check out the free tutorials that IBM provides for most of the exams. The tutorials are broken into hour long segments of information based on the exam objectives. If have a great deal of experience, this may be all you need to prepare for the exam. To see the full set of exam prep tutorials that are available, see ibm.com/software/data/education/selfstudy.html.
Classroom education is an excellent way to learn, but may be difficult to justify for some people due to costs. If you find that you learn most effectively through classroom education, encourage your employer to pay for them. Don't forget to look into ILO training as this type of training gives you all the benefits of classroom education, but eliminates the travel costs. The best place to start to determine the classroom education that best fits your needs is with the training roadmaps: ibm.com/software/data/education/roadmaps.html.
Is there an easier way to get certified, that doesn't include studying?
Not many things of value don't require an effort. There are sites on the web that claim to have the actual certification exam for you to buy and memorize in order to pass the exam. These are created by a previous applicant who shares knowledge of the questions on a certification exam with a third party. There is no noble purpose of this information sharing. It is cheating, pure and simple. IBM has a non-disclosure agreement that they make every exam applicant agree to before they allow you to take the test. Any person who creates or gives out questions or answers from a certification exam is in violation of the NDA and if you get caught "dumping", you're likely to have your certs revoked, at a minimum! And, if you get caught using someone else's dump, you'll get your certs revoked and will never be able to get certified through IBM again.
Further more, there's the credibility issue of this information. Most dumps are littered with errors, spelling and otherwise. There are a lot of companies out there that sell brain dumps, but just because you pay for their version of sims / exams, doesn't make it legal. Be very careful of cheap exam sims because they tend to be brain dumps. If you have any questions about the validity of a company's product, ask other people in the DB2 Forums or go to IBM directly. As mentioned earlier, DB2 exams are experience based, so lots of practice using the product in as many areas as possible, may allow you to pass the exam without studying.
If I take the assessment exams repeatedly, will I eventually see all the questions on the certification exam?In the past, IBM offered free assessment exams to all candidates. It seems that several people were taking these exams multiple times in a possible attempt to memorize all of the questions. The bad news for these people is that the set of questions on the assessment exams is different than the set on the certification exams. Also, memorizing the questions and answers will not help you learn the material at all! I suggest that you take at least one assessment test to see how ready you are, but only AFTER you have read the exam objectives and had either experience or training. By the way, the assessment exams now cost $10 per take, so that will help you limit the number of assessment exams you decide to take. Here is the site that will get you to the assessment exams: ibm.com/software/data/education/cert/assessment.html.
Can I gain experience by reading DB2 Forums and Blogs?
Absolutely! There are several DBAs who firmly believe helping out on the various forums have helped us gain a deeper understanding of subjects that were on the exams. So, contribute to those forums. You're not only helping other people, you're helping yourself as well! Most likely you'll find members of the DB2 development team actively taking part in the forums as well.
Here are the sites that I recommend, at the least:Planet DB2 - a blog aggregator that combines DB2 blogs from around the world.IBM developerWorks - DB2 PortalIDUG – International DB2 User’s Group
Is it true that the DB2 Fundamentals Exam (700 or 730) caters to an LUW audience?
Not at all. The DB2 Fundamentals Exam contains only questions that are true for each and every platform! In fact, I've noticed that people whose primary area of experience is with DB2 for z/OS find this exam pretty easy.
Recommended Learning Path for Certification:
Here is the recommended path I suggest you take to prepare for a DB2 exam:
1) Choose the exam you want to take based on your job role. The DBA and AppDev certifications first require that you are certified as a Database Associate. To help you decide where to start, see the certification roadmaps: ibm.com/software/data/education/cert-roadmaps.html
2) Read through the exam objectives. Every question on the exam relates directly to one or more of the exam objectives. For a breakdown of the exam objectives and the recommended study materials, see ibm.com/software/data/education/certprep.html
3) If you are experienced with DB2 and feel that you are prepared to pass based on what you saw in the exam objectives, take an assessment exam. You'll get a report after taking the assessment exam that can help you pinpoint your weaknesses.
4) If you are NOT experienced with DB2, download a free version of DB2 Express-C and give it a try!
5) Decide on how you best want to increase your skills, and test your level of skill achieved by taking an assessment exam: ibm.com/software/data/education/cert/assessment.html.
a) Consider buying one of the Certification Study Guides to refresh and deepen your skills: ibm.com/software/data/education/bookstore/
b) Take a free tutorial: ibm.com/software/data/education/selfstudy.html.
c) Take an education class from IBM or one of its partners.
6) Feel ready? Book your test! Testing centers are located around the world. Find a location closest to your office or home: www.prometric.com/ibm. If this is your first time taking a certification exam, review the steps on this site: ibm.com/certify/process/t_proc.shtml
Which book is best?
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) by George Baklarz and Paul ZikopoulosWhat 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.
For exam prep, the best books are these:DB2 9 Fundamentals Certification Study Guide by Roger SandersDB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 by Roger Sanders. You can find these books for sale at online book retails across the world.DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 by Susan Lawson and Dan Luksetich
You can find these books for sale at online book retails across the world.
PS: Check out Kate's blog entry with details about the upgrade exam: www.ibm.com/developerworks/blogs/page/katedawson[Read More]
Keep on Learning
The Information Management Technical Conference (IMTC) is taking place this week in Bangalore, India. Two of my colleagues, Susan Dykman and Bonnie-Lynn Murphy, are providing free certification testing for attendees. I've arranged for Shroff Publishers and Distributors Private Limited to set up a bookstore on site so we can showcase the large number of Information Management books that we have available to the Indian population.
Vineet Mishra, one of the attendees... has told me that the conference is quite useful and that he was amazed at the number of books that are available. One thing that I should make clear... these books are not just available to conference attendees, but we have them available in India... all the time. Just a URL away.
You may buy IBM Press books directly from Pearson Education India. Here you'll find primarily DB2 V8 editions of books, but soon the DB2 9 books will be available as well.
If you want printed IBM Redbooks at a very good price, see Shroff Publishing - Printed IBM Redbooks. Shroff Publishers is also selling the complete set of DB2 9 Certification Study Guides.
Please pass this information onto anyone who thinks that there is a lack of retail books to support DB2.... I'm trying to get every possible resource made available throughout the world!
PS.... See Kate's Blog: www.ibm.com/developerworks/blogs/page/katedawson[Read More]
Available now... an electronic version of the very popular flashbook by Carlton Doe: IBM Informix Dynamic Server: The Next Generation OLTP Data Server Technology.
Up until today... the only way to get this book and the excellent content inside was if you were attending an event where the book was being handed out. Now you can access and read the content at your convenience with this e-version of the same book.
What is a flashbook? A flashbook is a professionally published book that is roughly 100 pages in length and it introduces you to the latest release, in terms of the business value that the product will bring you and your company.
What is in this book: IBM Informix Dynamic Server: The Next Generation OLTP Data Server Technology? The major features and functions of the 11th version of Informix Dynamic Server (IDS 11), IBM’s lead data server for high-volume database applications in nonmainframe environments, are explored and explained in this handy guidebook. Security technologies offered by IDS 11—such as Label-Based Access Control and nonpreemptable connect and disconnect routines—are addressed, as are its newly enhanced Enterprise Replication and High Availability Data Replication capabilities. Oriented for both small business users and large corporate IT departments alike, this is the ultimate reference to one of the most stable, speedy, and adaptable data servers available.
About the AuthorCarlton Doe is one of the five founders of the International Informix Users Group (IIUG) and has served as the IIUG president. He is the author of Administering Informix Dynamic Server on Windows NT and Informix: OnLine Dynamic Server Handbook.
Table of Contents1 - Introduction to Informix Dynamic Server2 - Security and Regulatory Compliance3 - Relieving the Load on the IDS Administrator4 - Better Business Continuity Using IDS5 - Easing Application Development
Pearson Education, publisher of IBM Press books, has provided a free eBook and author podcasts along with a 35% discount on selected books. * FREE 200-page eBook available for download. Check out important content from our new and classic DB2 and Information Management titles. Topics covered include: PureXML Storage Engine, Database Security, SQL PL Language Elements, and Data Mining to Improve Innovation. Download this FREE eBook to read about these important topics and more. * New Author Podcasts. We currently have 3 new author podcasts available on DB2’s Self-Tuning Memory Manager, Unlocking the Business Value in Unstructured Information, and Understanding DB2. Through March we’ll be adding more podcasts and articles on ITIL, Trusted Computing, Using DeepCompression to Supercharge your DB2 9.5 Database, and more. * 35% discount on 10 new and best-selling DB2 and Information Management books. Plus free ground shipping in the US. Visit the IBM Press Books site to download the eBook, hear the podcasts, and view the books on discount.
See also Kate's Blog: www.ibm.com/developerworks/blogs/page/katedawson[Read More]
Last week I blogged about a promotion by Pearson Education, publisher of IBM Press books, who has provided a free eBook and author podcasts along with a 35% discount on selected books. Today I want to mention a few other podcasts that you might be interested in:
1) IBM DB2 9: Is certification worth it?Listen to Roger Sanders and Kathryn Marquis discuss the value that earning a DB2 certification may bring to your career. As you may know, Roger is author of 4 certification guides and was also a member of the exam development team. You can find links to his books and more from our IM Bookstore site: ibm.com/software/data/education/bookstore/certify.html. Amazon.com has many reader reviews for Roger's book that you may find helpful in making a decision on which book to buy:
* DB2 9 Fundamentals Certification Study Guide - 8 five star reviews* DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide - 1 five star review* DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade: Certification Study Guide - no reviews yet... * DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide by Roger E. Sanders and Dwaine R Snow (Publishes - Jul 1, 2008)- no reviews yet... but after you read the book, come back and give your opinion
2) Listen to Heather Ramsey and Rav Ahuja discuss the DB2 9 Certification Program in the DB2 9 Certification Podcast.
3) Find links to the ILO and IBM Optimum podcasts from ibm.com/software/data/education
4) Join Kate and I on ChannelDB2 where you will find a number of interesting videos, podcasts and photos. Join as a member and get involved in the community.
5) Find related videos on YouTube.
6) If you're on Facebook, join the group IBM DB2 to connect with others who are sharing blog entries and videos.
7) I'm pretty new to SecondLife, but others have been active and you'll be able to find IBM and DB2 related information on this site.
See my blog and others on PlanetDB2.
I'm pleased with all the multimedia options that are available today to find out about new products and as training resources. I'm sure we'll see more of this in the future!
svisser1 2700018UK9 3,451 Views
For a limited time... possible till the end of March only... save 37% on the purchase of DB2 9 for Developers by Philip K. Gunning. From this site, download chapter 4 The Path to DB2 9 XML Capabilities to check out Phil's writing style and the content on XML.
See also the amazon site for this book to see the six 5-star reader reviews for this book.
For details on all of the books that are available for DB2 9.5, see ibm.com/software/data/education/bookstore/.
Every thing is becoming green these day! Lucky me... I was born with green eyes... so I'm already in style!
In my role as Program Manager for IM Publishing... you can imagine that I love books. My office and cabinets are filled with them... and so is my house. Although you may not consider my habits green, in reality, I have reduced most other paper from my life. I read many magazines online. I rarely print an email or anything else for that matter. I recycle all paper I do end up with... like newspapers and junk mail.
I don't really like to read an entire book online, but when possible, I read what I can electronically before I make a decision to buy a printed book. For example, I will extensively research a book via the reader comments on amazon or other online site. For example, you can see that there are eight 5-star reviews for Roger Sanders book DB2 9 Fundamentals Certification Study Guide. Not that there is a comparable book to purchase, but if you read these comments, you may choose to buy the book.
Instead of buying the printed copy, however, you may want to read or browse the electronic version of the book. All retails books about IBM software is in electronic format. You can buy PDF versions of some books directly from the publisher... for example, Understanding DB2®: Learning Visually with Examples, Adobe Reader, 2nd Edition. If you have a subscription to Books 24x7 or Safari, you can also read entire books electronically or search through a library of books for a specific topic. If you work for IBM, you likely already know that IBM has a company-wide license for Books 24x7... if you need information, let me know. These sites quite often have trial periods, so you can see what the electronic books are like before you sign up for a subscription.
Amazon Kindle and other reading devices are becoming much more accessible and affordable. If you don't know what Kindle is... read the reader reviews on amazon and you'll learn all that you need to know. The thing that you should know about IBM books... is that they are ALL Kindle ready. I'm looking forward to the day when kids in school have their books on a device such as this so that they aren't forced to carry heavy knapsacks around any longer!
If you consider IBM Manuals and IBM Redbooks... you can easily make a case that IBM was on the "green" bandwagon long before it became cool. On top of all that great information, you can also find e-books, articles, and tutorials for nearly every topic that exists!
Even IBM Training classes are becoming "green". I've mentioned ILO several times... but what could be greener than taking a class while staying at home. No need to travel anywhere!
I'm sure many more examples can be mentioned. I'm pleased with the progress being made but only wish I could afford a kindle!
Maybe it's a bit sad that in the book world, a book that was published in 2004 is considered a classic! But with the number of new books being published on a daily basis... such is life!
Developing Quality Technical Information: A Handbook for Writers and Editors (2nd Edition) by Gretchen Hargis, Michelle Carey, Ann Kilty Hernandez, Polly Hughes, Deirdre Longo, Shannon Rouiller, and Elizabeth Wilde.
I have this book on my desk and think fondly of the team of people who wrote the book. Seven talented women from IBM wrote the book using their collective years of skill that they built working in Information Development. Sadly, Gretchen is no longer with us and several of the other authors have since retired from IBM. But, we can still benefit from their learned experience.
The book was so well-written that amazon displays 20 reader comments... most of them four or five star reviews! I recently went back to the author team to ask whether an update was needed. The answer came back... NO. The content is still very relevant and useful to anyone who is writing or reviewing technical content.
Who is writing technical content these days? I would have to say... just about everyone! Yes, the talented people working on the Information Development team are the leading contributors as they write the product docs, online help, and more. But... I write a blog, friends of mine write articles, tutorials, white papers, and IBM Redbooks. I work with many technical people and ask them to write books.... or chapters of books. Not many of these people took actual training to write about technical subjects, so this is very much a skill that people build over a number of attempts via trial and error, repeated writing, and learning from reviews.
I also ask many people to review chapters of books before they are published. Developers working on IBM are constantly asked to review documents to ensure that they are technically accurate. For that matter, developers are required to write technical specs before they design and code.
So, really the answer is just about everyone is required to write or review as part of their technical career. Do you feel qualified? Help yourself... and increase the quality of your work, with the help of this book. It is one of the books that I'll forever be proud to be part of... in the small way that I was.
Read the customer comments on amazon regarding this book, and take advantage of the 35% discount you can get when buying this book directly from the publisher.
Developing Quality Technical Information: A Handbook for Writers and Editors, 2nd Edition
* List Price: $49.99 * Your Price: $32.49 (Save 35%)
Another classic IBM Press title is An Introduction to IMS by Dean Meltz, Rick Long, Mark Harrington, Robert Hain, and Geoff Nicholls
I love this quote that Dean Meltz has as his signature line in his emails:
Do you bank? Do you use ATMs? Do you use the internet? Then you've used IMS. Nothing has ever compared to the reliability and speed of IMS.
This book was published in 2005 and provides the insights and skills you need to succeed--as an application designer, developer, or administrator. I've been told that there are still quite a few older installations of IMS. This book is critical for the people working with the older version and can help you understand why an upgrade is desirable and will help you to understand the latest features.
This book is one of the featured titles that Pearson Education is offering to you at a 35% discount:
Introduction to IMS™, An: Your Complete Guide to IBM's Information Management System
* List Price: $69.99 * Your Price: $45.49 (Save 35%)
Complete IDUG's Data Professionals Survey and Enter to Win $200
Complete the IDUG survey Evolving Skills and Roles of Data Professionals and earn a chance to win a $200 American Express Gift Certificate.
In addition to being entered in the prize drawing, those who complete the survey will also receive the Final Report of the "Evolving Skills and Roles of Data Professionals" survey results free by email when the study is completed.
The sweepstakes period ends on April 11, so please complete the survey today. The survey requires approximately 5-7 minutes to complete, and all responses are anonymous. All email addresses supplied will be used only for the purposes of communicating results of the prize drawing and distribution of the Final Report.
All correspondence related to this survey is confidential and will be emailed directly by IDUG. Unisphere Research, publishers of Database Trends and Applications magazine (to subscribe click here), will gather the information and prepare the report as a service to IDUG. A complete listing of sweepstakes rules can be found at the link above.
Can you believe it? March ends next Monday. Is it just me or was this the fastest moving first quarter ever!
Don't miss out on these special book prices that are offered by publishers MC Press and Pearson Education (IBM Press titles). The prices for the books at MC Press end March 31. I can't find details for when the IBM Press sale ends, but vaguely remember a March date as well. I'll confirm. But in the meantime, here are the details:
Save 37% on the purchase of DB2 9 for Developers by Philip K. Gunning. See also my blog entry about this book and sale.or go directly to the publisher's page.
While looking at the entry for Phil's book, I came across MC Press's Scratch and Dent Sale. Although there aren't any DB2 books listed in this sale, the prices are very good for Java, WebSphere, Elipse, and Rational titles.
See my blog entry about the Pearson Education sale of 35% off selected titles or go directly to the offer.
Books that are part of the IBM Press offer include:
* DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th Edition* Understanding DB2®: Learning Visually with Examples, 2nd Edition* Understanding DB2 9 Security* DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows™, i5/OS™, and z/OS®, 2nd Edition* Introduction to IMS™, An: Your Complete Guide to IBM's Information Management System* Mining the Talk: Unlocking the Business Value in Unstructured Information* Implementing ITIL Configuration Management* Practical Guide to Trusted Computing, A* Mainframe Basics for Security Professionals: Getting Started with RACF* Developing Quality Technical Information: A Handbook for Writers and Editors, 2nd Edition
What motivates you to take a training course?a) Training promotionb) Professional developmentc) Product upgraded) Job requirement
Log your response on the IDUG Instapol which has recently been updated with this new question.
Early results suggest that professional development drives the most people to training (based on 23 total votes). Help us get a very clear picture by ensuring that you log your vote.
Here are the results for the instapol that was focused on ILO:
Would you be interested in taking instructor-led online training?Yes, definitely. -- 62.09% (95 votes)No, I prefer classroom training. -- 16.34% (25 votes)Maybe, I’m thinking about it. -- 18.3% (28 votes)I’ve never heard of it. -- 3.27% (5 votes)
As always... thanks for your feedback... we listen to your needs.
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 3,502 Views
Have you seen the web banners for the new Certify and Save Promotion? The banner shows a cute piggy bank... which to me stands out because it is unlike most other web banners... on IBM sites at least.
What is Certify and Save?
From April 1, 2008 to June 30, 2008 you will receive a $75 discount on select DB2 9 certification exams when you purchase a qualifying DB2 9 Certification Study Guide. Simply purchase a qualifying guide from any US Bookstore between April 1, 2008 and June 30, 2008, and you are eligible to receive a Professional Certification voucher valid for 50% off the cost of an eligible exam at Thompson Prometric Testing Centers.
What are the qualifying books?
Only my most favourite books... the MC Press series of study guides that were written by Roger Sanders, Susan Lawson, and Dan Luksetich:
* DB2 9 Fundamentals Certification Study Guide by Roger Sanders* DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide by Roger Sanders* DB2 9 for z/OS Database Administration: Certification Study Guide by Susan Lawson and Dan Luksetich
All three books were written by well-respected DB2 experts / authors / speakers / exam developers. These books are focused on helping you learn what you need to know for the exams, so there is no better resource available for prepping for the exams. Each book contains sample questions that are directly related to the objectives of the exams. No where else can you find these questions along with the answers, and reasons for the answers.
Back to the promo... if you purchase the Fundamentals book by Roger Sanders, you'll qualify for a discount voucher for Exam 730; purchase the DBA book by Roger Sanders and you'll qualify for a discount voucher for Exam 731; and finally, purchase the DBA book by Susan Lawson & Dan Luksetich and you'll qualify for a discount voucher for Exam 732.
If you're interested in this offer... I'm sure you have plenty of questions. Here is a PDF with all the details for the Certify and Save Promotion. Kate and Emily also recorded a podcast to deliver all the details.
Again... follow the pig... and you'll find the savings.
PS... for those of you attending the IDUG conference during the offering period, you'll be happy to hear that I plan to be there handing out discount vouchers to those who buy the qualifying books.
It seems to me that every newsletter I get these days has at least one article about security / data protection. Here are a few of the headlines that I've noticed:
* Don't Tolerate Liberal Data Permissions* What Is All This Integrity Business?* How to get employees passionate about disaster recovery * Backups: Understanding How Performance Matters* Top 10 Security Trends for 2008* Learn Best Practices for Database Auditing
Yesterday I was sent this information regarding data security problems that I'd like to share with you:
* Is your DB2 audit reporting strategy lacking institutional controls, or perhaps even nonexistent? * Are you using "live" production data for unit testing, with no masking of sensitive data values? * Are you wasting resources storing large amounts of unreferenced and inactive data on your operational databases? * Is sensitive data potentially being exposed to theft while at rest or in transit between you and your business partners?
The DB2 and IMS solution can help minimize the liability risk associated with Data Governance.
Data Server Security BlueprintThis blueprint provides a threat-focused security framework for users of IBM Data Servers (whether DB2 for LUW, DB2 for z/OS or IDS) and our related data governance Tools that help them understand how our products work together to solve their data security problems. It is comprehensive enough to cover all the major threats, yet simple enough for a new DBA to pick up and use immediately. From this site, download the white paper and the blueprint.
On April 1, there was a Chat with the Lab regarding this blueprint. From this site you can download the charts and at some point in the near future, you'll be able to listen to a replay of the chat.
And last but not least, we have several books that are current and cover these topics to some degree. In particular Understanding DB2 9 Security by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, 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.
DBA Central on developerWorks has a list of the most recent articles, and you'll find several related to the security topic that may be useful to you as well.
I'm busily preparing for the IDUG 2008– North America Conference taking place in Dallas in approximately 6 weeks, May 18-22, 2008 at the Hyatt Regency Dallas.
The early-bird discount expires on April 16, so register now to save $200. See the online conference schedule to see what the conference has to offer you. Here are a few of the highlights:
1) Once again... free certification exams. This provides you a savings of $150 per take... pass or fail. If you are looking to upgrade to V9 certifications, you have 6 exams to choose from: 730, 731, 732, 733, 734, and 736. Even if you took only five exams, that would be a savings of $750! Could this be the justification that you need to go to the conference?
2) Prepare for the exams now... and/or take one of the Pre-conference Crammer classes by exam developer / authors: Roger Sanders or Susan Lawson.
3) Discounted books: I'm putting together a list of books to suggest to the bookseller, Breakpoint books. In creating this list, I'm trying to ensure that you have the latest books with the highest ratings. If there is a book that you'd like to suggest that I add to my list, let me know. I believe the normal 10% discount will apply at the conference.
4) Skills Hub: I will be located at the bookstore for the week, or right next to it, at the Skills Hub. This is a new area for an IDUG conference and is based loosely on what we did at IDUG Athens last November. We encourage people to come and ask questions, browse the books, talk to us about your particular needs, and if possible, pick up a freebie or two.
5) Authors who will be speaking at the conference. I don't know if I have a complete list yet, but here's what I was able to pull together from the Advance Program:
* Roger Sanders* Susan Lawson* Daniel Luksetich* George Baklarz* Leon Katsnelson* Dwaine Snow* Chris Eaton* Craig Mullins* Phil Gunning
6) Presentations / Education - there are at least 150 hours of education provided by experts and users.
7) Exhibit Hall: eight hours available for you to meet related vendors who can help with your specific needs for products or services.
8) Keynote speakers: Arvind Krishna, Curt Cotner and Chad Fowler.
9) IBM Panel discussions.
10) Special Interest Groups
and last, but not least.... networking opportunities!
Looking forward to seeing you!
Thanks to Bob Bernard for providing this comprehensive list of Data Studio websites that I can pass on to you.
First of all, what is Data Studio?
Data Studio provides a comprehensive suite of integrated tools for development database administrators and application developers. The tooling for each of these roles is essentially divided between two main views in the Data Perspective: the Data Project Explorer, and the Database Explorer. There are also features to help team members share resources.
The IBM Data Studio Information Center introduces IBM Data Studio and the underlying workbench technology, and explains how to use its integrated development environment to achieve your database development goals. For information about related products, visit the related product information links within the Information Center.
The Data Studio forum is ideal to engage in discussions related to the use of IBM Data Studio. The latest release is V1.1.2. This forum also contain discussions on previous releases, V1.1.1 and V1.1(also known as DB2 Developer Workbench 9.5 during its open beta), and DB2 Developer Workbench 9.1.
Articles and Papers
* DB2 Viper II and the IBM Data Studio Developer Workbench by Paul Zikopoulos, October 19, 2007
* IBM Beefs Up Data Studio by P. J. Connolly, January 15, 2008
* Data Web Services: Build Web services the new way to access IBM database servers by Vijay Bommireddipalli, December 6, 2007
* The Easy Way to Quick Data Access by Rafael A. Coss, Stephen A. Brodsky, and Vijay BommireddipalliIBM takes the drudgery out of JDBC programming with pureQuery, an integrated language that queries relational databases as well as Java collections and database caches. pureQuery and Data Web Services are components of the new IBM Data Studio, a new common database application development and administration platform.
* Web service development and deployment with Informix Dynamic Server and IBM Data Studio by Shweta Sinha, Prasanna Alur Mathada, and Amitava ChakrabortyIBM Data Studio brings Informix Dynamic Server (IDS) developers the latest in Web services technology. Learn how this new set of tools makes it easy to design, develop, deploy, and manage your IDS applications. Get started with Web services development using the latest methodology, and also learn how you can simulate a Web service response by converting it to presentable HTML format.
* Introduction to IBM Data Studio, Part 1: Get started with IBM Data Studio, Version 1.1.0 and Eclipse by Debra R. Eaton
* Understanding pureQuery, Part 2: Assist class modelers with data modeling by Azadeh AhadianLearn how the features of pureQuery can assist you as an object-oriented developer to define a set of database relational artifacts using traditional class modeling.
You can download the warranted or unwarranted version of IBM Data Studio and take part in the Data Studio Community on developerWorks.
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 for pre-orders.
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.
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.
Thanks to Hassan (Al) Shazly for providing me with this comprehensive list of IBM Redbooks that are useful to anyone interested in the Content Management area... especially in terms of the solutions that IBM provides. There are retail books available, but none of them talk specifically about IBM technologies/solutions for supporting content.
Here are a variety of IBM Redbooks that are available that do provide IBM content:
Content Manager OnDemand Guide, SG24-6915-02This IBM Redbooks publication covers a variety of topics relating to the practical application of Content Manager OnDemand (simply referred to as "OnDemand") for Multiplatforms Version 8.3 (also known as Version 18.104.22.168), z/OS Version 7.1, and IBM eServer iSeries Common Server Version 5.3 of the OnDemand product. Where necessary, separate sections are included to cover variations between the different platforms.
Implementing Content Manager OnDemand Solutions with Case Studies, SG24-7511-00 This IBM Redbooks publication will help you implement an IBM Content Manager OnDemand solution from the beginning to the end. We discuss the various stages of the Content Manager OnDemand solution implementation, including planning, software installation and configuration, design, application setup and verification, functional testing, performance testing, training, and finally deployment into production.
Content Manager Backup/Recovery and High Availability: Strategies, Options, and Procedures, SG24-7063-00 The purpose of this IBM Redbook is to introduce the concepts of backup/recovery, high availability, and disaster recovery for Content Manager systems, and provide strategies, options and implementation steps to protect your Content Manager systems. We also explore, through various case studies, how to apply your newly gained knowledge to real-world Content Manager system implementation and practices. This Redbook will also help IT architects, specialists, project managers, and decision makers identify the best high availability and disaster recovery strategies and integrate them into the Content Manager solution design process.
Content Manager OnDemand Backup, Recovery, and High Availability, SG24-6444-00This IBM Redbook helps you understand backup, recovery, high availability, business continuity strategies, and options available for IBM DB2 Content Manager OnDemand. We begin with an introduction of the basic concepts of backup and recovery, high availability, disaster recovery, and business continuity. We also provide an overview of IBM DB2 Content Manager OnDemand.
Overview of the Best Practices for Content Manager System Performance, TIPS0636 The Content Manager best practices performance methodology and checklists are based on some of the most common applicable performance tuning recommendations from the Content Manager Performance Team at the Silicon Valley Lab and services practitioners in the field. Although not all the platforms and databases are covered here, many of the principals and methodologies are applicable across platforms and databases.
Performance Tuning for Content Manager, SG24-6949-01 This IBM Redbook deals with performance tuning for IBM DB2 Content Manager Version 8 for Multiplatforms. It is aimed at architects, designers, and system administrators of Content Manager systems.
Content Manager Implementation and Migration Cookbook, SG24-7051-01 This IBM Redbook deals with IBM DB2 Content Manager implementation and migration. It is aimed at architects, designers, developers, and system administrators of Content Manager systems. It covers the basic concepts needed to design and implement a Content Manager solution. This includes topics on data modeling, workflow, text indexing and search, application development, query language, security, and Tivoli Storage Manager (TSM) overview. In addition, we cover the solution implementation process from planning and designing, to deployment. To put concepts into real practice, we provide practical case studies to demonstrate how to implement a Content Manager solution for real-world scenarios.
IBM DB2 Document Manager with IBM Records Manager Solution Guide, SG24-7180-00 IBM DB2 Document Manager Version 8.3 is one of the newest members of the IBM Enterprise Content Management portfolio. Document Manager provides a secure and robust platform to manage the complete life cycle of business documents. It helps ensure accurate and up-to-date documents are available on demand. When configured with IBM DB2 Records Manager Version 4.1.2, the Document Manager solution also provide records management capability.
E-mail Archiving and Records Management Integrated Solution Guide Using IBM DB2 CommonStore and DB2 Records Manager, SG24-6795-00 As more companies need to manage their e-mail to support regulatory compliance, litigation, and corporate policy and to improve system performance and productivity, the e-mail archiving and records management solution presented in this IBM Redbook is here to rescue.
IBM Tivoli Storage Management Concepts, SG24-4877-04 This IBM Redbook describes the features and functions of IBM Tivoli Storage Manager. It introduces Tivoli Storage Management concepts for those new to storage management, in general, and to IBM Tivoli Storage Manager, in particular.
If you are interested in Content Management... make sure you consider going to the IOD EMEA conference in The Hague... as there will be quite a few sessions specific to this area.
svisser1 2700018UK9 3,636 Views
We don't yet have a Certification Study Guide for any of the IDS certification exams, but we do have one in the works. So, how should you prepare for the exams in the meantime?
1) Review the exam objectives.
* Exam 915: System Administration for IBM Informix Dynamic Server V 9 * Exam 917: System Administration for IBM Informix Dynamic Server V 10 * Exam 918: System Administration for IBM Informix Dynamic Server 11
2) Read through the free tutorials.
This series of eight tutorials has been developed to help you prepare for the IBM Informix Dynamic Server 11 System Administration Certification Exam (918). These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. After a quick registration, you can begin a tutorial. Currently parts 1 and 2 are available in this series of eight. Each tutorial should take less than two hours to complete. You can take the tutorials online, or download a PDF.
3) Take an online assessment exam.
For a limited time, all IIUG members, can take a free online assessment testing to gauge their readiness for the certification exam. Assessment tests for Exams 915, 917 and 918 will be available free of charge for two weeks prior to and during the conference, April 15 through April 30, 2008. Normally these tests are offered for a fee of $10 each.
4) Take the real exam at the IIUG Informix Conference April 27-30, 2008 if you are planning to attend.
See also Kate's blog for more information on certification and training programs.
Good luck on all your exams!
Another commercial for you to view: Killer App. This one was from last year.... and the closing remark: "I don't know how to do that." I think MDM is "how you can do that" and is the answer to connecting everything to everything... the power is amazing.
Learn how: preorder Enterprise MDM - An SOA Approach to Managing Core Information.
This is valuable reading for everyone who wants to understand MDM.
- - -
Product Description: The Only Complete Technical Primer for Every MDM Planner and Implementer
Companies moving toward flexible SOA architectures often face difficult information management and integration challenges. The “lifeblood” master data they rely on is often stored and managed in ways that are redundant, inconsistent, inaccessible, non-standardized, and poorly governed. Using Master Data Management (MDM), organizations can regain control of their master data and maximize its value in SOA environments.
Now, for the first time, there’s an authoritative, vendor-independent MDM technical reference for every practitioner: architects, technical analysts, consultants, solution designers, and senior IT decision-makers. Authored by the IBM data management innovators who are pioneering MDM, this book systematically introduces MDM’s key concepts and technical themes, explains its business case, and illuminates how it interrelates with and enables SOA.
Drawing on their experience with cutting-edge projects, the authors introduce MDM patterns, blueprints, solutions, and best practices published nowhere else--everything you need to establish a consistent, manageable set of master data, and use it for competitive advantage.
• How MDM and SOA complement each other• Using the MDM Reference Architecture to position and design MDM solutions within an enterprise• Assessing the value and risks to master data, and applying the right security controls• Utilizing PIM-MDM and CDI-MDM Solution Blueprints to address industry-specific information management challenges• Incorporating MDM solutions into existing IT landscapes via MDM Integration Blueprints• Leveraging master data as an enterprise asset—bringing people, process, and technology together with MDM and data governance• Identifying user roles, responsibilities. and skill descriptions for MDM project participants• Case studies in MDM deployment, including data warehouse and SAP integration
About the Authors: * Allen Dreibelbis, Executive Architect in the IBM Software Group Worldwide Information Platform and Solutions Architecture Team, led the development of the MDM Reference Architecture.
* Eberhard Hechler, Technical Enablement Architect for IBM Information Platform & Solutions, works with system integrators throughout Europe.
* Ivan Milman, Senior Technical Staff Member at the IBM Software Group and IBM Master Inventor, focuses on security and governance in information management.
* Martin Oberhofer, Technical Consultant at the IBM Böblingen Lab, is a member of the Worldwide IBM Software Group Master Data Management Center of Excellence.
* Paul van Run, IBM Senior Technical Staff Member, is responsible for architecting the MDM Server and WebSphere Product Center.
* Dan Wolfson is an IBM Distinguished Engineer and Chief Architect/CTO for the Information Platform and Solutions segment of the IBM Information Management Division of the IBM Software Group.
If you are attending the IBM Information On Demand EMEA Conference 2008 meet all six authors in person and have a copy of your book signed.
Here is another IBM commercial. This one is called "The Grail" and is about security. Have you seen this IBM Press book that published earlier this year? It's about security as well....
Mainframe Basics for Security Professionals: Getting Started with RACF
Leverage Your Security Expertise in IBM® System z™ Mainframe Environments
For over 40 years, the IBM mainframe has been the backbone of the world’s largest enterprises. If you’re coming to the IBM System z mainframe platform from UNIX®, Linux®, or Windows®, you need practical guidance on leveraging its unique security capabilities. Now, IBM experts have written the first authoritative book on mainframe security specifically designed to build on your experience in other environments.
Even if you’ve never logged onto a mainframe before, this book will teach you how to run today’s z/OS® operating system command line and ISPF toolset and use them to efficiently perform every significant security administration task. Don’t have a mainframe available for practice? The book contains step-by-step videos walking you through dozens of key techniques. Simply log in and register your book at www.ibmpressbooks.com/register to gain access to these videos.
The authors illuminate the mainframe’s security model and call special attention to z/OS security techniques that differ from UNIX, Linux, and Windows. They thoroughly introduce IBM’s powerful Resource Access Control Facility (RACF) security subsystem and demonstrate how mainframe security integrates into your enterprise-wide IT security infrastructure. If you’re an experienced system administrator or security professional, there’s no faster way to extend your expertise into “big iron” environments.
* Mainframe basics: logging on, allocating and editing data sets, running JCL jobs, using UNIX System Services, and accessing documentation* Creating, modifying, and deleting users and groups* Protecting data sets, UNIX file system files, databases, transactions, and other resources* Manipulating profiles and managing permissions* Configuring the mainframe to log security events, filter them appropriately, and create usable reports* Using auditing tools to capture static configuration data and dynamic events, identify weaknesses, and remedy them* Creating limited-authority administrators: how, when, and why
About the Authors:
Ori Pomerantz has been securing computer networks--and teaching other people to do so--since 1995. Since joining IBM in 2003, he has written classes on several Tivoli® security products, including IBM Tivoli zSecure.
Barbara Vander Weele, a software engineer at IBM, has developed and presented education material on provisioning, security, storage, and business technologies for IBM Worldwide Education.
Mark Nelson, Senior Software Engineer at IBM, is a twenty-year veteran of the RACF design team and a frequent speaker on RACF and z/OS security-related topics.
Tim Hahn, IBM Distinguished Engineer, has been with IBM for seventeen years. He is Chief Architect for Secure Systems and Networks within the IBM Software Group Tivoli organization.
Security doesn't exist in a vacuum; it’s a part of the business process and it permeates all aspects of information technology. The bad news is that as applications run on a combination of multiple platforms, each of the platforms needs to be examined, understood, and protected. The good news is that good security techniques transcend platforms; the key is understanding how to take the knowledge that you already know and apply it across these platforms.
That's the reason for this book. Experienced UNIX or Windows security professionals can extend their existing security knowledge to the world of z/OS![Read More]
I recently invested in good headphones... and I'm glad I did. I've already used them for an ILO course, listened to the many podcasts, watched the new IBM commercials on YouTube, watched the videos on ChannelDB2, and will likely find many more purposes.
IBM's list of ILO courses is growing steadily. My recommendation... Make sure that you fully test your headphones and mic BEFORE the session. You'll have a much more productive ILO session if you do.
Kate blogged about the many podcasts that are available right now, and today the IBM Press newsletter featured many more. Podcasts are available from the following people: Danny Arnold, Dwaine Snow, Sandy Carter, Larry Klosterboer, Sara J. Moulton Reger, Raul F. Chong, Paul Zikopoulos, John Arthur Ricketts, Mike Moran, Tara Woodman, Ellice Uffer, and Scott Spangler.
I've been trying to mention as many of the IBM commercials as I can... here is the latest... . this one is called "When it Rains".
IDUG also has a growing list of courses and podcasts that you may find helpful.
ChannelDB2 contains a broad spectrum of resources including videocasts, podcasts, and more. If you would like to contribute your unique view on the DB2 products, film or record yourself and add the result to ChannelDB2.
In the past month I've been to two conferences and am about to go to one next week. Coincidentally, I was having system problems and was unable to make blog entries! Many times over the past month I've encountered items that I wanted to share with you, but since I didn't write them down, I need to rely on my taxed memory!
The first conference was actually a symposium for the IM Education and Consulting team. This is the team that I belong to and we are widely spread out in terms of location and mandate. The symposium was a chance for us to meet many of our teammates and of course to further our education. I attended sessions led by Belal Tassi (Data Governance), Chris Gruber (Info 2.0 Mashups), Melanie Stopfer (Pass it Forward), Matthias Nicola (XML), Mark Meredith (Are you Listening), and Kevin McNulty (Basics of Project Management). I enjoyed each of the sessions and intend to blog about some of what I learned in future entries.
The next conference was last week in Dallas: IDUG NA. My role at the conference was to lead the Publications and Certification sessions in the Skills Hub. The Skills Hub was our way of showing attendees that there are a variety of resources available to keep skills current. Angela Moore and Nancy Miller were my most constant team mates in this venture, but we also had help from Melanie Stopfer, Dave Romack, and Fred Whitlark. We collected 110 surveys during the time the Skills Hub was open and each person was required to listen to us briefly describe the resources that are available. To our complete shock... we discovered that nearly 90% of the people who we spoke to were unaware of developerWorks! I gave away all of my business cards in a hope that many of the people who didn't know about dworks would at least check out my blog and then wander off and explore the amazing and current content that is available in dworks... all the time! Welcome to those who are new! I hope you enjoy what you find on this site.
We were pleased to learn that most people are aware of the retail books and the growing supply of them, our certification program, our certify and save promotion (follow the pig), and of course... IBM Redbooks. We appreciate your support of these resources and hope that you find a few new ones via my blog or elsewhere. Stay tuned for future blog entries that will go into detail for each of the skills resources that we have available.
The highlight of my week was meeting Merrikay Lee, publisher of MC Press books, in person. We've been working together for several years now and have never had the opportunity to meet in person. I was able to introduce Merrikay to many of the authors she has worked with over the years, as well as reviewers and future authors.
Congratulations to Julian Stuhler, the new president of IDUG. The Skills Hub was located right next to the IDUG Information Booth, so I was lucky to spend time with many of these dedicated people!
Next week I'm at the IOD EMEA conference in Holland. I'll be working at the bookstore for the week, so if you are there, please say hi to me! We're launching the new Enterprise Master Data Management: An SOA Approach to Managing Core Information book which I'm quite proud of, but will have many valuable books for sale that will please the attendees. My parents were raised in Holland and Belgium, so I'm looking forward to finally visiting my countries of origin!
All the best!
PS... to catch up on some of the items that my team wants you to know about.... see Kate's blog... thanks Kate!
Do you ever wish that you could get practical guidance regarding the BEST way to use DB2 9 to improve the value of your DB2 data servers? For the past 6 months, the development teams have been creating Best Practice papers to help you discover the best practices for the most common DB2 9 product configurations with IBM® DB2® for Linux®, UNIX®, and Windows®.
These Best Practice papers present advice on the most optimal ways you can use DB2 to satisfy key business data processing needs. These papers are authored by leading experts in IBM's development and consulting teams, and have been extensively tested.
Each Best Practice paper is designed to provide practical guidance for the most common DB2 9 product configurations. By applying these recommendations, you may improve the value of your DB2 data servers and align yourself with IBM's technical direction for DB2.
Currently available are:
Database storage, (May 2008)Discover best practices for database storage including guidelines and recommendations for spindles and logical unit numbers (LUNs), stripe and striping, transaction logs and data, file systems versus raw devices, Redundant Array of Independent Disks (RAID) devices, registry variable and configuration parameter settings, and automatic storage.
Physical database design, (May 2008)Learn about all of the design features that relate to the physical structure of the database such as datatype selection, table normalization and denormalization, indexes, materialized views, data clustering, multidimensional data clustering, table (range) partitioning, and database (hash) partitioning.
Data life cycle management, (May 2008)See the best practices to design and implement scalable solutions that facilitate the continuous feed or roll-in and roll-out of data, with minimal interruption of data access.
Minimizing planned outages, (May 2008)View the best practices for minimizing, or even potentially eliminating, planned database outages. Planned outages can include activities such as routine database maintenance activities or upgrades to your database environment.
IBM data server security, (May 2008)This Best Practices roadmap details how to protect data servers against the common data security threats, some uncommon threats, and useful countermeasures for these threats.
Deploying IBM DB2 products, (May 2008)Discover best practices for deploying the DB2 9.5 family of products on Linux, UNIX, and Windows platforms across multiple computers quickly, easily, and consistently.
Writing and tuning queries for optimal performance, (May 2008)Learn best practices for minimizing the impact of SQL statements on DB2 database performance. This paper focuses on good fundamental writing and tuning practices that can be widely applied to help improve DB2 database performance.
Tuning and monitoring database system performance, (May 2008)See best practices for the performance evolution of a Data Server. From important principles of initial hardware and software configuration to monitoring techniques that help you understand system performance under both operational and troubleshooting conditions. For troubleshooting performance problems, this paper provide a step-wise, methodical method for determining the problem.
Managing XML data, (May 2008)Get principles and guidelines for using DB2 pureXML™ to solve business problems effectively and to achieve high performance when managing XML data in enterprise applications - illustrated with a real-world example easily adapted to other types of XML applications. See Downloads for the files associated with this paper.
Improving data server utilization and management through virtualization, (May 2008)Discover best practices for deploying DB2 9 with the IBM System p™ virtualization technology. Select the right blend of virtualization features and their configurations to achieve desired business goals, while improving the utilization of IT resources.
Frequently asked questions from problem management reports, (May 2008)Get answers to the most common questions that DB2 customers have about the DB2 data server.
Additional Best Practice papers are in development, and will be published on developerWorks as they become available.
Congratulations and THANKS to all the authors for their very valuable contribution to these papers!
PS... see also Kate's blog...[Read More]
I'm packed and ready for the IOD EMEA conference that is taking place next week in my homeland: Holland! After the conference I will stay a couple of extra weeks to explore the places where my parents grew up... before moving to Canada.
At the conference I'll be working at the bookstore, recommending books to the attendees. If you are planning to be there... come and say hi to me! I've worked closely with many of the authors who have published DB2 and related titles over the past 10 years.... so I may be able to help you choose the best book for your needs.
The bookstore is located at the main entrance of the World Forum Convention Center during the following hours:
Monday, 2 June 3 pm - 8 pmTuesday, 3 June 10 am – 6 pmWednesday, 4 June 8 am – 6 pmThursday, 5 June 8 am – 6 pm
I mentioned in a previous entry that we will be launching the new Enterprise Master Data Management: An SOA Approach to Managing Core Information book by Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul Van Run, and Dan Wolfson. We've arranged to have a special author signing session that will be held outside the World Forum Theater immediately following the Information Platform & Solutions featured keynote on Wednesday, 4 June at 12.20
Another newly published book that will be available for purchase at the bookstore is Executing SOA: A Practical Guide for the Service-Oriented Architect by Norbert Bieberstein, Robert G. Laird, Keith Jones, and Tilak Mitra.
Pick up your free copy of Carlton Doe's IBM Informix Dynamic Server 11, the Next Generation in OLTP Data Server Technology outside World Forum Theater immediately following the Data Management featured keynote on Tuesday, 3 June at 12.20.
Pick up your free copy of DB2 VIPER Strikes Again, New Features in DB2 9.5 outside World Forum Theater immediately following the Data Management featured keynote on Tuesday 3 June at 12.20.
The booksellers I’ll be working with have the following website where books may be purchased following the conference: www.vanstockum.nl
I’m not sure how connected I’ll be at the conference, so I am not sure how many posts I’ll be able to make, but I’ll try.
While I’m away, make sure that you keep an eye on Kate’s blog!
svisser1 2700018UK9 3,265 Views
You have until Monday, June 30th to register for a certification voucher that entitles you to a 50% off the price of an exam fee... if you've purchased one of the cert guides. For details see: http://www.ibm.com/developerworks/blogs/page/SusanVisser?entry=follow_the_pig
Follow the pig!
The promotion has been hugely successful! If you were one of the many people who has already received a voucher, good luck on your exam! You'll be happy to know that the book you bought is proven to help people prepare for the exams... not only because of the content, but because of the sample questions and answers that are in the books.
One of the things that I'm trying to find out this year is where do people normally buy their books... and why. It seems that most people go to amazon.com. I go to amazon.com, but only to see the prices, selection, and reader comments. I typically buy at one of the local online bookstores such as amazon.ca or chapters.indigo.ca.
During my travels in the past month, I've found out that many people in Europe choose to buy directly from amazon.com rather than their local sites. Why? I think primarily because of the very favourable currency exchange... and also the price, selection and reader comments!
If you look at the bookstore site that my team maintains, we also point to amazon for the books that we mention. Not really to say that you should buy it there, but for you to see the price and the reader comments.
Since I work directly with several publishers, I also work directly with them on various book promotions. If there is a special discount promotion available for a book... I make sure that the details are mentioned on our bookstore site. For instance, next week you'll see the following information posted:
Enterprise Master Data Management: An SOA Approach to Managing Core Information
Save 35% on the new MDM book published in June that is sure to be the only complete technical primer for every MDM planner and implementer! Written by a team of 6 authors, this book systematically introduces MDM’s key concepts and technical themes, explains its business case, and illuminates how it interrelates with and enables SOA.
Save 35% with the following code at checkout:Coupon Code: IBM6250Active until 12/31/08
We've also arranged for people to buy IBM Press books direct from the publisher in Europe and Canada as well. Here are the sites:Pearson Canada - for a 35% discount on all featured books.Pearson EMEA - provides free shipping and duty for EMEA residents.Employees in Canada - contact me directly :)
For all other places in the world, international information is placed on this page: International sites
We now have many books available through MC Press as well. In the US, the recommended site is: MC Press Online. MC Press has published all of the DB2 V9 Certification Study Guides and have the long awaited Advanced DBA Study Guide coming in September. When MC Press has preorder information, it will be posted on our bookstore site.
In India, Shroff Publishers & Distributors Pvt. Ltd or Computer Bookshop. I see some IBM Press books on the Computer Bookshop site as well. Check it out and let me know if the prices are good!
I've mentioned Kindle before... If you have amazon's electronic reader, then you will be happy to note that all IBM books are kindle-ready! What a better way to have all the reference materials in a single place?
IBMers are encouraged to use Books 24x7 for electronic access to most retail books. All IBMers, worldwide, have access to Books 24x7. If you need info, let me know. If you don't work for IBM, you can pay for a subscription to either Books 24x7 or Safari for electronic books. You can read entire books electronically... or search a library of books for just the right topic.
I know I wasn't able to cover all the countries in the world. I'm still doing research! If you can help me by enlightening me on how you buy your books, please send me a comment! I'd love to hear from you!
As always, check out other bloggers via Planet DB2