Today I want to tell
you about how to prepare to take and pass an exam.
How to Prepare
to Pass a DB2 Certification Exam
the exam objectives.The website ibm.com/certify lists the
objectives for every IBM certification exam.Read these carefully as each question on the exam links directly back to
one or more of these objectives!(That’s
a huge hint!)
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. How do I prepare to pass an exam? 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. 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 Here are the exams that cover the DB2 9 product:
* Exam 737 - DB2 9 System Administrator for z/OS 3)
If you are experienced with DB2 and feel that you are prepared to pass
the exam 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. Assessment exams cost $10 per take, so if you
really think you are ready, come and take the exam to see. 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 want to increase your skills:
a) Consider buying one
of the Certification Study Guides to refresh and deepen your skills: ibm.com/software/data/education/bookstore. For exam prep, the best books are these: DB2 9 Fundamentals Certification Study Guide by Roger Sanders DB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders DB2 9 Database Administration Certification Study Guide for Exam 732 by Susan Lawson and Daniel Luksetich DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 by Roger Sanders DB2 9 Advanced Database Administration Certification Study Guide for Exam 734 by Roger Sanders and Dwaine Snow. All
five of these certification prep guides were written by members of the
exam development team. That is, they created the questions for the
certification exam that you are about to take! Also, each chapter of
the book corresponds directly to a section on the exam. So, if you take
the assessment exam and find out that you are week on a single topic,
you simply need to read the chapter that corresponds to the topic where
you need improvement. Lastly, the authors created a set of sample
questions for the book that provides you with the correct answer to the
question as well as an explanation as to why the correct answer is
correct and the incorrect ones are not. For reference and guidance beyond the exam, I suggest the following: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) by George Baklarz and Paul Zikopoulos b)
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 you 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. c)
Take an education class from IBM or one of its partners. These classes
typically have a fee, even for employees, so check with management to
see if you can take one of these classes. Classroom education is an
excellent way to learn, but may be difficult to justify due to costs.
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. 6) If this is your first time taking a certification exam, review the steps on this site: ibm.com/certify/process/t_proc.shtml. Can I gain experience by reading DB2 Forums and Blogs?
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 Portal IDUG – International DB2 User’s Group My blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/SusanVisser/ Kate's blog: ibm.com/developerworks/blogs/page/katedawson
I hope you find this information useful! Good luck on your journey towards certification!
by Judith Hurwitz, Marcia Kauffman, and Adrian Bowles.
I've met Judith and Marcia many times and am always happy to promote their books. This one is about cognitive computing which is a technique that allows humans and computers to collaborate in order to gain insights and knowledge from data by uncovering patterns and anomalies.
As I read in the book "Zero to One" by Peter Thiel, big data is dumb data unless people are using computers as tools to gain the insights that can be found in data.
The book, "Cognitive Computing and Big Data Analytics" explains the underlying technologies such as artificial intelligence, machine learning, natural language processing, and big data analytics. It then demonstrates how you can use these technologies to transform your dumb data to smart data.
Detailed case histories from the financial, healthcare, and manufacturing industries, are presented with step-by-step examinations of the design and testing of cognitive systems. You'll benefit from the expert perspectives of of the authors and the clients they work with.
IBM Watson is perhaps the most popular cognitive computing platform, and you'll be happy to know that this book goes into detail about how IBM Watson has influenced the development of cognitive computing.
You can pick up this book at theIBM InterConnect Conference. Also, be sure to attend Judith's talk and have her sign your copy of the book. She'll be speaking at theExpo Cloud Theatre on Tuesday, February 24 from 6-6:30 pm(Vegas time).
Judith and Marcia: Congratulations on your latest book. If I'm able to attend the conference this year, I'll be first in line for your book!!
Once you register for IOD you’ll be sent a confirmation email that will tell you about the pre-conference education sessions that are available. Maybe you’ve heard of these before. They are full day classes that go deep in a particular topic. These classes have an additional cost.
Six of the classes are Certification Crammer Courses. These remain popular year after year and help you prepare to pass one of the free certification exams that are offered at the conference to attendees. These classes are taught by well-known experts who helped create the certification exam. Here are the six that are offered this year:
Instructor: Information Champion Susan Lawson - This is a high-level certification preparation course intended to help you take DB2 9 Family Fundamentals exam (730) and DB2 10 for z/OS Database Administration exam (612). Passing of these exams will result in certification as an IBM Certified Solutions Expert - DB2 10 z/OS Database Administration.
In addition to this Crammer Course, Susan’s latest Certification Guide will be launched at the conference. This book will focus on what you need to know to pass exam 612. The book isn’t listed on amazon.com yet, but as soon as it is, I’ll create an entry about the book. We’ve tentatively scheduled Susan Lawson and co-author Dan Luksetich for a book signing on Tuesday October 25 from 4pm – 5pm.
Instructor: Information Champion Judy Nall - This one-day crammer course guides students through the six testing sections that comprise the #617 Exam. Students attending this course will review tasks, methods and responsibilities of a DB2 10 for z/OS System Administrator as they relate to the #617 testing areas.
Instructor: Information Champion Roger Sanders - This one day course is designed to introduce you to the concepts a test candidate must know in order to take and pass the DB2 9.7 DBA for Linux, UNIX and Windows certification exam (Exam 541). The material for this course is aligned with the 541 exam objectives.
Roger’s books will fill an entire bookcase! This year we’re launching two more of his books. One is for Certification – exam 541, the other is about writing technical books and articles.Roger Sanders’ signings are tentatively scheduled for Monday October 24 3:00 – 4:00 pm and Tuesday October 25 from 2:00 pm – 3:00 pm.
instructor: Pavan Marpaka - In this one day course, students will review the 11 sections of knowledge candidates are expected to know for the InfoSphere DataStage V8.5 exam. The approach of this course is to review the 'core' knowledge for each section and the associated sub-topics for these sections.
Instructor: Dale Buckingham - This one day crammer course is designed to introduce you to the concepts a test candidate must know in order to take and pass the InfoSphere QualityStage 8.5 Certification exam 422. The material for this course is aligned with the 422 exam objectives.
Instructor: Glen Mules - This one-day training course is for system administrators and developers responsible for managing Apache Hadoop. This course will teach you everything you need to know about IBM BigInsights and will prepare you to take the BigInsights Technical mastery test.
There aren’t certification books for these last three topics… yet. If you think that these would be valuable, let me know.
IBM InfoSphere Guardium provides the simplest, most robust solution for assuring the privacy and integrity of trusted information in your data center (SAP, PeopleSoft, Cognos, Siebel, etc.) and reducing costs by automating the entire compliance auditing process in heterogeneous environments. You can find more information about this product on this website: IBM InfoSphere Guardium - Real-Time Database Activity Monitoring
Are you looking to build skills in Guardium? A new course for InfoSphere Guardium has just been released and is now available.
This three day course offers a balanced mix of lectures, hands-on lab work, case studies, and testing. You will learn how to create reports, audits, alerts, metrics, compliance oversight processes, and database access policies and controls. You will also learn about system administration, archiving, purging, and back-ups.
This intermediate course is for:
Information Security professionals
STAP and GIM
Query and Report builder
Compliance Workflow Automation
Guardium's training courses help you achieve results quickly and easily. For more information about training, to sign up for a training course, or to schedule a training session, go to: Guardium Training.
This three day course offers a balanced mix of lectures, hands-on lab work, case studies, and testing. Students will learn how to create reports, audits, alerts, metrics, compliance oversight processes, and database access policies and controls. Students will also learn about system administration, archiving, purging, and back-ups.
PS… thanks to Bill Fekrat for providing this information to me.
Are you looking for some good technical books to read in order to enhance your skills? For the month of February, you can purchase a number of amazing books and save money while doing it.
Let me start with the offers from IBM’s publishing partner, IBM Press:
1) If you are a member of IDUG, you can always get 45% off of books published by IBM Press. How? Go to IDUG’s home page and click on the icon on the bottom right corner. This will give you the instructions needed to get your discount. See a previous blog entry for more information on IDUG: IDUG = International DB2 User Group
By Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan
Next, MC Press,publisher of our ever popular DB2 Certification Series has a new online bookstore and are celebrating with FREE Shipping On Orders of $100 or More*; SAVE Up to 90%; BONUS $5 Savings On All “Scratch & Dent” Titles. Includes DB2 Cert Guides.
And finally, Packt.For the month of February, they are offering 4 eBooks for $75. Packt now has 17 IBM titles listed on site. Some suggestions:
Getting Started with IBM FileNet P8 Content Manager IBM Lotus Quickr 8.5 for Domino Administration IBM Rational Team Concert 2 Essentials IBM WebSphere Application Server v7.0 Security IBM Lotus Domino : Classic Web Application Development Techniques IBM Cognos 8 Report Studio Cookbook IBM Infosphere Replication Server & Data Event Publisher IBM Lotus Sametime 8 Essentials: A User's Guide WS-BPEL 2.0 for SOA Composite Applications with IBM WebSphere 7.0 IBM Lotus Notes 8.5 User Guide
doubt the biggest topic in tech these days is Big Data. Sunil uses
this guide to focus on Big Data plus one of the most important tech
topics: Governance. This
guide focuses on the convergence of two major trends in information
management—big data and information governance—by taking a strategic
approach oriented around business cases and industry imperatives. With
the advent of new technologies, enterprises are expanding and handling
very large volumes of data; this book, nontechnical in nature and geared
toward business audiences, encourages the practice of establishing
appropriate governance over big data initiatives and addresses how to
manage and govern big data, highlighting the relevant processes,
procedures, and policies. It teaches readers to understand how big data
fits within an overall information governance program; quantify the
business value of big data; apply information governance concepts such
as stewardship, metadata, and organization structures to big data;
appreciate the wide-ranging business benefits for various industries and
job functions; sell the value of big data governance to businesses; and
establish step-by-step processes to implement big data governance. Sunil
is a leading expert in the field and is the founder of Information
Asset LLC, a consulting firm focused on helping clients build
information governance programs, and a former director of information
governance at IBM. He is the author of two other high rated books:The IBM Governance Unified ProcessandSelling Information Governance to the Business.
IBM InfoSphere Optim High Performance Unload (HPU) for DB2 for Linux, UNIX, and Windows V4.2 is a high-speed tool for unloading, extracting, and repartitioning data in DB2 for Linux, UNIX, and Windows databases. HPU unloads large volumes of data quickly by reading directly from full, incremental, and delta backup images or table space containers rather than through the DB2 software layer.
The database is not affected by the HPU process and table spaces do not need to be placed in an offline state. HPU can therefore offer advantages over other recovery methods in data availability and processing speed. Incorporating HPU into your recovery strategy for scenarios involving data loss or corruption can help achieve service level objectives for data availability and data recovery.
Incorporate InfoSphere Optim HPU into your recovery strategy to provide:
Reduced recovery times through targeted data recovery Use the WHERE clause when selecting data from backup images to target only the data that was lost, compromised, or corrupted, reducing recovery time.
Increased data availability and reduced resource usage during recovery scenarios Unload data from a backup image and optionally process this data on a non-production system, maintaining availability of the query workload and reducing the effect on the production system.
Integration with DB2® and Tivoli® Storage Manager (TSM) software Query TSM to unload data from full, incremental, and delta backup images archived to TSM by the DB2 BACKUP command, reducing errors and facilitating outside recovery.
This article discusses how to incorporate HPU into a recovery strategy and when to use HPU to meet your recovery objectives. In addition the authors contrast the use of output files and named pipes, discuss introducing parallelism, review the HPU command and control file, and recommend best practices for creating control files. Finally, the article details how to install and configure HPU in an IBM Smart Analytics System.
This paper will be followed in the new year with a second paper on HPU that deals with data migration.
Thanks to the hard working team that includes: Garrett Fitzsimons, Konrad Emanowicz from the VLDB team who created and tested all the scenarios discussed in the paper and to Richard Lubell from the DB LUW ID team who steered the paper through to publication. Thanks also to Alice Ma, Austin Clifford, Bill Minor, Dale McInnis, Jaime Botella Ordinas, and Vincent Arrat whose contributions, feedback and experience were invaluable.
Thanks to Garrett and Serge for providing me with this information.
This year's IOD conference was amazing! Record crowds, lots of events, great people, and for the first time ever, our beloved product DB2 was front & center! DB2 with BLU Acceleration is clearly a winner and you had no trouble learning about it at IOD: the whole conference was painted BLU!
I've put together this rather large slideshare to show you what I mean. I presented these slides to the development team and the feedback was awesome. Throughout the slides, I've added links that will allow you to "take" part in the event after the fact. I link to free books that you can download, videos and blogs by our subject matter experts, and more. I hope you enjoy the photos and the twitter messages I've added throughout.
This book introduces cloud computing, workloads in cloud computing, analytics as a service, and its implementation using Cognos Software and provides guidance and considerations for your cloud solution, such as “Where should the data be located” and “How many images should I create?” Step-by-step instructions on how to install, configure, secure and test a Cognos Business Intelligence deployment in the IBM Cloud are provided to help you get to a point where you have a saved private instance to an image that you can then deploy in minutes on demand.
Learn how to graduate from single images to multiple images and more complicated topologies that are better suited for production workloads and how to secure your Cognos cloud solution.
More advanced topics include moving from a single image to multiple images, scalability and performance, and how to plan for scaling to ensure a high performing solution. Finally, tip are provided to ensure that your Cognos BI cloud solution is highly available and handles failover scenarios.