How would you like to save 50% on an Information Management Certification
exam? With the Assess & Save offer, you must take and pass
an online assessment or "Practice test" to receive a voucher for 50% off the
corresponding exam. That's a savings of $100 USD!IBM Professional Certification
is the way for skilled IT professionals
to demonstrate their expertise to the world. Certification validates your skills
and demonstrates your proficiency in the latest IBM technology and solutions.
This offer will make it easier for you to become an IBM Certified Professional:
and Save, candidates who purchase ($10) and PASS an Information
Management Online Assessment Test during the offering period, will automatically
receive a 50% off certification voucher good for the corresponding exam.
That's a savings of $100 USD!
An online assessment test is available for each Information Management
Professional Certification Exam. These "practice tests" enable you to test your
readiness for a minimal fee, helping you to be successful on exam day.
You must take your assessment exam before the end
of May: March 1, 2012 - May 31, 2012
If you qualify, you’ll receive your voucher via an email within 10 days after
completing and passing the online assessment test. Vouchers must be redeemed
during the corresponding redemption period or they will expire.
March 1, 2012 - July 31, 2012 for vouchers
earned during the offering period.
For all the details see: Assess and Save
To help you pass the exams, I’ve written a series of blog entries that I hope
you’ll find helpful:
Good luck on your exams!
I’ve been reading IBM Data Management magazine
since it was launched 15 years ago. I’m sure you’ve read an issue or two as
well! The next generation is about to launch and it will capitalize on digital
The world looked very different when the IBM Data Management
magazine was first launched. Digital technology allows a whole new world
of opportunities and the new online format gives us more flexibility to cover
the latest information management developments and IBM advances as they happen.
IBM Data Management
magazine will deliver new kinds of interactive, highly dynamic content,
such as webinars and video. And it gives us a platform on which to create a
strong community of the world’s top information management professionals. This
inflection point also represents a unique opportunity for us to feature a
broader range of voices from across the industry. We're always looking for great
stories and now because we can update content almost immediately, it will be
easier for us to highlight important topics that are timed to a specific day and
Another benefit of going digital is it will make it much easier for you to
find previously published content. A little known fact is that we have 4 years
of articles available for you to search & read. I’m sure you’ll find a
treasure in this vast collection.
Bookmark the URL for the magazine and check back often to find out about the
latest hot topics!
PS: If you’d like to contribute to this magazine, reach out to me and I’ll
connect you with the editor. If you need help writing an article, I highly
recommend that you read Roger Sanders’ book: “From Idea to Print: How to Write a Technical Book
or Article and Get It Published”.
Apparently this is happening to many of our customers. They move from Oracle
to DB2 and achieve improved performance. Could this happen to you as well?
Here are some of the details of this particular case study:
JSC Rietumu Banka achieves faster database performance moving from
Oracle and Sun to IBM DB2 on Power Systems
With the worldwide recession placing pressure on banks to reduce costs, JSC
Rietumu Banka's CIO was concerned with total cost of hardware, software
and administration supporting the company’s online banking
applications. The bank’s web applications ran on Oracle Database and Sun servers
and it found that the annual fees were costly and administration time consuming.
With its migration to IBM DB2 on IBM Power Systems, it
reduced the total cost of ownership for its online banking
infrastructure and dramatically improved query performance and
data availability. On average, user queries are now executed up to 3 times
faster, with some queries completed up to 30 times faster (for
example, some queries that before took 30 seconds now take less than one
second). During the migration process, the bank reported an out-of-the-box
compatibility rate of more than 90 percent.
Thanks to the solution, JSC has:
• Reduced total cost of ownership by
• Achieved 3-30 times faster query performance
Improved data availability by 200 percent
"By migrating to IBM DB2 on IBM Power systems, and using IBM services, we
expect to decrease total cost of ownership for our mobile device banking
applications by 20-30 percent." - Sergey Golubev, Head of IT Maintenance
and Networking Department, JSC Rietumu Banka
To learn more about how JSC Rietumu Banka addressed its business challenges,
read the full case study.
I get the impression that this type of improvement is happening in many
shops. I base this impression on some of the comments that have been expressed
on the DB2Night Show. Has this happened to you as well? Do you want to share
Thanks to Dave Pittman and Paula Williams for providing me with the details
of this case. Watch for a few more that I’ll write about.
Here’s another book just published by Packt Publishers: IBM DB2 9.7 Advanced
Application Developer Cookbook by Sanjay Kumar and Mohankumar
About the book:
With lots of new features, DB2 9.7 delivers one the best relational database
systems in the market. DB2 pureXML optimizes Web 2.0 and SOA applications. DB2
LUW database software offers industry leading performance, scale, and
reliability on your choice of platform on various Linux distributions, leading
Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms.
This DB2 9.7 Advanced Application Developer Cookbook will provide an in-depth
quick reference during any application's design and development. This practical
cookbook focuses on advanced application development areas that include
performance tips and the most useful DB2 features that help in designing high
quality applications. This book dives deep into tips and tricks for optimized
With this book you will learn how to use various DB2 features in database
applications in an interactive way.
- Learn to design secured and robust database applications.
- Get to grips with all the important aspects of the DB2 application
development life cycle starting with design and planning, moving through the
development phase, and getting on to performance tips.
- Master various new DB2 features for high quality application design.
- Learn new features in DB2 9.7 such as Performance enhancements, pureXML
enhancements, high availability, backup, logging, resiliency, recovery
enhancements and so on for application development.
- Master different security aspects to design highly secured applications.
- Get step-by-step instructions to write advanced Java applications
- Work with DB2 routines and modules.
- Master the tips and tricks for optimized application performance.
- Learn to enable Oracle applications on DB2, migrating Oracle database
objects on to DB2 9.7, and more.
About the authors:
Sanjay Kumar started his career as a database developer and DB2 consultant in
IBM India Software Labs. He is currently working as Database Architect for Data
Warehouse Applications for an Investment banking firm. He has extensive
experience in DB2 application development and performance tuning. He is an IBM
certified application developer (DB2 9.7), IBM certified solution developer, and
IBM Certified Advanced Database Administrator.
Mohankumar Saraswatipura started his career in DB2 8.1, worked as database
application developer, performance consultant in IBM Software Labs, India. He is
currently working as Lead DB2 Database Administrator helping application
developers on Balanced Warehouse, Siebel and SAP implementations. He is
experienced in DB2 application performance tuning and design. He is an IBM
certified application developer, Infosphere Solution Designer, XML, Stored
Procedure along with Advanced Database administrator. He is an active member of
IDUG India and a IBM Information Champion.
DB2 9.7 Advanced Application Developer Cookbook with IBM
DB2 9.7 Advanced Administration Cookbook and get 50% off both the
Just add both the eBooks to your shopping cart and enter ibdb97ebk in
the 'Enter Promotion Code' field. Click 'Add Promotion Code' and the discount
will be applied.
Are you an expert who would like to share your knowledge with a world-wide
and large audience? If yes, I would suggest that you submit a proposal to speak
at the IBM Information On Demand 2012 Conference to be held
October 21-25, 2012 in Las Vegas, Nevada.
This conference provides in-depth technical education through an agenda that
includes Information Management, Business Analytics and Enterprise Content
Management. The Business Leadership program also addresses strategy issues and
the industry challenges facing today’s business leaders. The call for speakers
is open now http://ibm.co/IODspeaker until Friday, April 13,
2012 at 5:59 pm Eastern time.
Proposals are being accepted for the following programs:
We’re looking for best practices
and case studies to be featured in all of the above tracks. Details and
guidelines can be found on this page: http://ibm.co/IODspeaker
Why this conference?
- The conference attendees come from around the world and it’s expected
that more than 11,000 business and technology leaders will attend to experience
four days of in-depth education.
- The Business Leadership program addresses strategy issues and the industry
challenges facing today's business leaders.
- More than 700 sessions will be offered and we welcome your proposal that
highlights how IBM technologies and solutions help
leverage information to
gain insight and drive business results.
- Technical sessions will cover products, solutions, and implementations
including Hands On Labs. These sessions target IT professionals, DBAs,
architects, developers and programmers.
Why become a speaker?
- To share your expertise.
- To be seen as an an expert in your area.
- If you’re an author, to promote your book.
- To save on the conference fee to attend the conference.
- To network with like-minded professionals.
I’ve worked at every IOD conference that IBM has ever put on and I must say
that I love going to these conferences because of the energy, range of topics,
and the caliber of the speakers.
Today was the second show of the finals for the DB2’s Got Talent 2012
Competition. I wasn’t able to participate, so IBM Champion, Cristian
Molaro filled in for me. Like many of you, I’m listening to the replay a
few days after the live show.
If you didn’t participate live, I strongly encourage you to watch the replay. We had the
top 10 contestants from Round 1 present 4-minute technical presentations to us.
Once again, we ended up with very high quality presentations from very
experienced users of DB2 products.
The control is now in the hands of you, the audience. You
must vote for who you think should go on in the upcoming shows. Here’s what you
need to do. If you were in the audience, vote in the survey provided for who
you thought was the best. If you weren’t able to make it to the show today,
watch the replay, and then VOTE. The top 6 contestants based on your votes will
present again on March 30 and the judges will save one contestant from the
bottom 4 (again based on your votes). Don’t watch just to vote, watch to learn
great DB2 tips as well as examples of excellent presentation skills. Here’s a
summary of what happened:
Contestant 1 – Yonghang
DB2COS and Related Commands
Yonghang had a slide for “what is db2cos”, but I wasn’t able to figure out
from his presentation as to what this command is and what it is used for. Most
of his presentation centered around customizing the command to use it most
efficiently. Yonghang was nervous during his presentation, but the judges found
that the command was a little known command and the presentation was useful.
Contestant 2 – Rodolfo
Discovering DETAIL Option in DISPLAY Command
Rodolfo chose to present about the DB2 for z/OS command and its options. The
DETAIL option is only available on DB2 V10. This was a good topic with good
slides with pointers to additional information. Clear and to the point.
Examples were easy to follow. Cristian mentioned that there is also a Redpaper
about this topic. You can follow Rodolfo on twitter: https://twitter.com/#!/_rodc
Contestant 3 – Kingo
DB2 for z/OS Access Path Verification by REBIND command
Kingo, being from Japan, missed that North America is now on daylight savings
time. We’ll have to be sure to warn international contestants when times change
in the future. Very good presentation about how you can clone your system and
find the differences.
Contestant 4 – Richard
Unfortunately Richard has needed to leave the competition due to
Contestant 5 – Kohli
Command was clearly defined regarding its purpose and when to use it. I
liked that he showed how he uses the command and why. Very good presentation
with a summary and good examples. The format of the presentation was perfect
for this type of venue. Succinct and clear. Great job!
Contestant 6 – Elder
DB2top Collector, Auto-Performance Analysis, and Replay
Very clear definition of the command and why you’d want to use it. He
contained his presentation by discussing only 3 options that are available for
this command. He got caught up a bit in the introduction and ran out of time
for some of his examples, but otherwise it was a very good presentation.
Contestant 7 – Brian
Top 10 db2pd
Intro was excellent and humorous! The history of the command was also
interesting. Brian presented on the top ten options that he uses on a regular
basis. Interesting and dynamic slides with animation. Clearly presented with
the command, option, along with an example. Brian clearly has much experience
using this command and its options. Brian tweets at https://twitter.com/#!/fairchild_db2
and blogs at http://bit.ly/yGpae2 .
Contestant 8 – Ember
DB2caem: The Untold Story
Ember gave a clear introduction to the command and its benefits and then
wondered aloud what this command is doing to her databases. Her presentation
focused on this. She does a fine job investigating the command to find out how
it does what it does. She gives very clear conclusions regarding the
consequences of using the command, and give all sides of the story. As usual,
Ember did a very fine job with her slides, presentation, and was enthusiastic
and professional throughout. This is a relatively new command, so the topic was
very valuable to all. Ember tweets ember_crooks & blogs http://db2commerce.com/.
Contestant 9 – Jean
Dynamically Generating Scripts and Control Cards
Jean worked with her colleague Chuck to create this presentation, but she
presented on her own. Again this was a cross-platform topic. Clearly Jean and
Chuck have much experience using this command and its options. They clearly
defined the command and when it is used and how it helps. A lot of information
was given, very clearly, in only 4 minutes. Conclusion: If you are a DBA and
know your SQL, you can perform miracles. Some of the SQL showed new features
of the product.
Contestant 10 – Douglas
DB2 LUW 9.7 CLPplus Command Line Processor
The preamble to Doug’s presentation was very interesting. We know from
Doug’s previous appearances on this show that he is a DB2 & Oracle expert.
Doug’s screen saver is a photo of a motorcycle he received as a birthday gift
upon the return from an Oracle conference. He then gave us a couple of
interesting comments about the conference. I’ll let you listen to the replay to
hear what those comments are! The presentation focused on why you’d want to use
CLPplus versus CLP. Great slides, clearly presented topic, but he ran out of
The judges, Martin Hubel, Klaas Brant, and Cristian were
asked to save one of the bottom 3 presenters based on the voting from the past
two weeks. It was a tough decision, but the judges decided to save
While the judges were deliberating, Scott showed us some of the amazing
feedback people have been providing about the contestants, the show and of
course the learning opportunities. Keep giving feedback, we find it very
96% of the listening audience said they learned something new today. How
about you, listening to the replay? Did you learn something new?
Now the control is with you the listeners. After you watch the
replay, VOTE! I’m glad I don’t get to choose… there is such great
talent appearing on this show that it will be very difficult to choose.
March has one more show for the finals where those who have moved on will
present for the final time and the audience can choose the winner. Be sure to
join us March 30. If you get reminders for March 23, please ignore this
Thanks to host Scott Hayes for this opportunity for me as a judge and
for the contestants for helping them build technical presentation skills that
are so valuable.
For details on the prizes for this competition… and a summary of last year’s
event… see my blog entry: http://ibm.co/AnZxb4
See also: Session 1 of the
DB2’s Got Talent 2012 Competition
See also: Session 2 of the
DB2’s Got Talent 2012 Competition
See also: Session 3 of the
DB2’s Got Talent 2012 Competition
See also: Session 4 of the
DB2’s Got Talent 2012 Competition
See also: DB2’s Got Talent
Finals – Round 1
PS… If you are in the NY area, make sure you look into attending the DB2
Symposium that is taking place March 28-30 in this area. See
After a long delay, I can finally announce that this long awaited book has published.
DB2 10 for z/OS Database Administration: Certification Study
by IBM Champions Susan Lawson and Daniel Luksetich
I can also tell you that the covers for the certification series of books by
have been redesigned and will be launched on this title. I hope you like the
What’s in the book?
- Read this book to prepare to pass Exam 612 – DB2 10 for
z/OS Database Administration.
- All test objectives for this exam are covered in the same degree as they are
covered on the exam.
- Susan and Dan were members of the exam development team, so are fully aware
as to what questions are on the exam!
- Susan and Dan use DB2 every day and have 22 years experience.
DB2 10 for z/OS Database Administration: Certification Study Guide is
the definitive guide to preparing for IBM’s Certification Exam 612: DB2 10 for
z/OS Database Administration. This book provides a comprehensive review of all
the topics covered on the exam and introduces you to important new features
found in DB2 10 for z/OS.
Written by two industry experts who were members of the team that created the
612 exam, this book guides you through all the areas you need to know about to
pass the exam: Database Design and Implementation, Operation and Recovery,
Security and Auditing, Performance, and Installation and Migration/Upgrade.
At the end of each chapter, you’ll find practice questions with answers to
help you review that chapter’s material. The book concludes with a comprehensive
85-question practice exam (plus detailed answers) that lets you verify what
Beyond certification prep, the book covers new Version 10 features for
both database and application development. It also includes a wealth of
practical details about working with DB2 for z/OS, tips for best performance and
best practices, and loads of examples illustrating usage of DB2. It will serve
both as an essential tool for studying for exam 612 as well as a reference guide
that all DB2 for z/OS DBAs will want on their desktops.
With DB2 10 for z/OS Database Administration: Certification Study Guide,
- Learn how to effectively administer a DB2 10 for z/OS database
- Discover the changes to DB2 for z/OS in Version 10 that you’ll need to know
about to be successful when taking exam 612, and the pre-requisite Exam 730
- Receive an explanation of every objective on the test. . .from people
involved in the creation of the actual exam
- Find 85 practice questions based on the actual exam’s format and approach,
with detailed answers to help you gain understanding
While the book does cover all topics on the test, it also covers much more
than that. It covers the new features of DB2 10 for both database and
What do you need to know to pass the exam?
This is an outline of the Exam Objectives that this book covers:
Section 1 - Database Design and Implementation (30.5%)
Design tables and views
• Explain the different performance
• Design indexes
• Create and alter
• Perform table space and index partitioning
Normalize data and translate data model into physical model
Implement user-defined integrity rules
• Use the appropriate method
to create and alter DB2 objects
• Encoding schemes
Section 2 - Operation and Recovery (29%)
database-oriented commands for normal operational conditions
database-oriented commands and utility control statements for use in abnormal
• Identify and perform actions that are needed to protect
databases from planned and unplanned outages and ensure that timely image copies
are taken periodically
• Load and unload data into and from the
• Reorganize objects when necessary
Monitor the object by collecting statistics
• Monitor threads
• Identify and respond to advisory/restrictive statuses on objects
• Establish timely checkpoints
• Identify and perform
• Perform health checks
• Describe the special considerations for
availability in a data sharing environment
Section 3 - Security and Auditing (7%)
• Protect DB2
• Protect connection to DB2
Section 4 - Performance (29%)
• Plan for performance
monitoring by setting up and running monitoring procedures
• Analyze and respond to RUNSTATS statistics analysis
• Determine when and how to run the REORG utility
Understand and implement Real-Time Statistics & DSNACCOR(X)
• Evaluate and set appropriately the performance
parameters for different utilities
• Describe the performance
concerns for the distributed environment
• Describe DB2 interaction
• Interpret traces (statistics, accounting, performance)
and explain the performance impact of different DB2 traces
Identify and respond to critical performance thresholds
I/O wait times
• Identifying lock-latch waits and CPU waits
• Identifying and resolving deadlocks and timeouts
Review and tune SQL
• Dynamic SQL Performance
Section 5 - Installation and Migration/Upgrade(4.5%)
catalog health checks using queries and utilities
• Identify the
• Identify the migration/upgrade modes
• Identify and explain data sharing components and concepts
About the Authors:
Susan Lawson is an internationally recognized consultant and
lecturer with a background in system and database administration. She currently
works with several large clients to help develop, implement, and tune some of
the world’s largest and most complex DB2 databases and applications. Susan also
conducts performance and availability audits to help clients reduce costs
through proper performance tuning and ensure availability. She also writes
articles and white papers, presents at user group meetings, and teaches a
variety of DB2 courses. Susan is an IBM GOLD Consultant for DB2 and System z and
an IBM Champion.
Daniel Luksetich is a DB2 database professional with more than 26
years of experience in high-performance design and tuning of very large
databases and highly available, high-volume database applications. He also
teaches DB2 courses and has authored books, guides, whitepapers, and magazine
articles. Working as a DB2 application architect, Dan has been involved in
several very large DB2 application designs. An IBM Champion, Dan specializes in
DB2 for z/OS but has worked with DB2 on a variety of platforms. His specialties
include performance audits, SQL education, backup and recovery, stored
procedures, UDFs, triggers, application design, high-availability design, and
DB2 high performance.
PS, for all my z/OS friends, check out this new BLOG that focuses on
technical information that will interest you: DB2
for z/OS Exchange Forum
DB2 Developer's Guide is the best source for on-the-job
information on programming and administering DB2 on IBM z/OS mainframes. Now,
three-time (or is it 4 times now?) IBM Champion Craig S.
Mullins has thoroughly updated this classic for DB2 v9 and
v10. Craig fully covers new DB2 innovations including temporal database
support; hashing; universal tablespaces; pureXML; performance, security and
governance improvements; new data types, and much more.
Using current versions of DB2 for z/OS, readers will learn how to:
- Build better databases and applications for CICS, IMS, batch, CAF, and RRSAF
- Write proficient, code-optimized DB2 SQL
- Implement efficient dynamic and static SQL applications
- Use binding and rebinding to optimize applications
- Efficiently create, administer, and manage DB2 databases and applications
- Design, build, and populate efficient DB2 database structures for online,
batch, and data warehousing
- Improve the performance of DB2 subsystems, databases, utilities, programs,
and SQL stat
DB2 Developer's Guide, Sixth Edition builds on the unique approach
that has made previous editions so valuable. It combines:
- Condensed, easy-to-read coverage of all essential topics: information
otherwise scattered through dozens of documents
- Detailed discussions of crucial details within each topic
- Expert, field-tested implementation advice
- Sensible examples
About the Author
Craig S. Mullins is president and principal consultant of Mullins
Consulting, Inc., a leading data management consultancy. He is also a principal
with SoftwareOnZ, a mainframe software distributor that publishes The Database
Site. Mullins has been honored as an IBM Information Champion for his
exceptional contributions to the IBM Data Management community. He has 30+ years
of experience in all facets of database systems development in multiple
industries, and has worked with DB2 since Version 1. Mullins presents at events
including the International DB2 Users Group (IDUG) and IBM Information on
Demand, and has authored hundreds of technical articles on DB2 and databases.
You have several choices, so be sure to choose the one that best suits your
Direct from publisher: IBM Press
You can use the discount code – IBM6425 – to save
35% at the online checkout.
From Amazon.com: currently a 22% discount.
If you're in Europe, you can purchase this book
and many others in the IBM Press series at 35% off the retail price,
plus free shipping in the UK and discounted in other countries.
PS, for all my z/OS friends, check out this new BLOG that focuses on
technical information that will interest you: DB2
for z/OS Exchange Forum
Just published by McGraw Hill: IBM Cognos TM1: The Official Guide, by TM1 experts Karsten
Oehler, Jochen Gruenes, and Christopher Ilacqua.
What’s in the book:
Deliver timely, accurate, and actionable performance management solutions to
users across your enterprise. Filled with expert advice from a team of IBM
professionals, IBM Cognos TM1: The Official Guide shows you how to deploy
and maintain a dynamic planning, forecasting, and scenario analytic solution.
Learn the latest Cognos TM1 10.1 best practices on how to model Cognos TM1
cubes, develop highly agile performance management solutions, generate
feature-rich reports, and employ dashboards and scorecards. Securing, sizing,
and performance tuning are also covered in this IBM-authorized resource. This
book can also be used with former TM1 versions.
- Build Cognos TM1 models with cubes, dimensions, rules, and TurboIntegrator
- Load data and establish workflow using the TurboIntegrator
- Model and analyze multidimensional business processes
- Develop applications using Excel and Cognos TM1 Web
- Manage high user volumes with scaling and concurrency
- Assign and enforce roles, privileges, and permissions
- Deliver custom reports to end users through dashboards
- Use KPIs and balanced scorecards to monitor performance
About the Authors
Dr. Karsten Oehler is head of the performance management client
technical professionals (CTP) with IBM Deutschland GmbH, Frankfurt. He has
published four books and more than 130 articles on IT systems for financial
management. Dr. Oehler is a visiting lecturer at several universities in
Jochen Gruenes managed the German competence center for Cognos TM1
within the technical sales organization for IBM Deutschland GmbH and has led
several projects and workshops on the enhanced uses of TM1.
Dr. Christopher Ilacqua is an experienced Cognos TM1 practitioner with
over 20 years spent working with TM1 as a customer, OEM Manager, and Director of
Product Management & Marketing, helping customers globally seeking to
improve their planning, forecasting, and analysis solutions.
Get your copy now! At the time of writing this entry, amazon’s price for
this book is at a 39% discount!
IDUG is already filled with amazing learning opportunities, as mentioned in
my blog entry: IDUG Denver – May
, but here are more for you to consider. At the IDUG DB2 Tech Conference in
Denver, Colorado, USA
, taking place May 14-18, 2012 at the Colorado Convention
, you can take advantage of specialty Full-Day Seminars
for an in-depth look at a topic that is relevant to
Seminars are held on Monday, May 14 and provide a great start to
your IDUG week by giving you access to some of the top speakers in the DB2
industry. The additional fee includes breakfast, lunch and course materials for
the seminar you attend.
- Educational Seminar With Full Conference Registration: $425
- Educational Seminar Without Full Conference Registration: $475
Select from these 6 topics of interest:
DB2 10 for z/OS DBA Certification Crammer Course:
Susan Lawson, YL&A
This course is a 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. Participants are expected to have fundamental knowledge of
relational principles in addition to applied working knowledge of DB2 9 for z/OS
and basic knowledge of DB2 10 features. Susan’s latest book will also be
available, for sure before the conference and hopefully at the conference.
Recommended Best Practices from Customer DB2 Health Check
Studies: John Campbell, IBM DB2 for z/OS Development
one day seminar will introduce and discuss the major lessons to be learned from
customer DB2 Health Check Studies carried out by DB2 for z/OS Development and
provide recommended best practices in each area. The objectives are to:
introduce and discuss the most common issues, share the experience gained from
customer health check studies, share the experience from live customer
production incidents, provide proven recommended best practice, and to encourage
proactive behavior. The following topics will be covered: WLM Policy Setup,
Balanced Design across CICS and DB2 Disaster Recovery, use of Flashcopy,
Continuous Availability vs. Fast Failover, Preventative Software Maintenance,
Multiple Data Sharing Groups., Running Multiple DB2 Subsystems on same LPAR,
Normal DB2 Warm Restart vs. Restart Light, Storage Tuning. Download John’s
Flashbook for free: DB2 for z/OS Planning Your Upgrade: Reduce Costs. Improve
DB2 9.7 for Linux, UNIX and Windows DBA Certification
Crammer (Exam 541): Roger Sanders, EMC Corporation
training 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. After completion of this class, you will be familiar with
the concepts you will be expected to know and understand in order to take and
pass the DB2 9.7 for Linux, UNIX and Windows Database Administration
Certification Exam (Exam 541). Get Roger’s book about this exam: DB2 9.7 for
Linux, UNIX, and Windows Database Administration: Certification Study Notes
DB2 LUW Problem Determination and Trou bleshooting
Workshop: Pavel Sustr, IBM Toronto Lab
The popular DB2 LUW
troubleshooting seminar, updated with 9.7 techniques and LIVE DEMOS! Learn how
to identify and resolve problems such as database hangs, locking problems,
crashes and optimizer or performance problems. Get familiar with diagnostic
tools. Learn how and when to use these troubleshooting tools for a quick problem
resolution. Topics covered: Performance; Optimizer; FODC; Hangs;
Locking/Latching; and Crashes/Traps. Attendees will be able to characterize a
problem in order to expedite resolution, learn how and what data to collect
during intermittent hangs, slow-downs, and other frequent problems, and
understand DB2 Support’s methodology in troubleshooting DB2 and even non-DB2
hiccups. The seminar contains live demos, during which the audience will be
given an opportunity to perform an interactive investigation of selected
DB2 for LUW Performance Analysis and Tuning Workshop -
Everything You Need to Know: Scott Hayes, DBI
performance rules and best practices are changing as DB2 LUW advances.
Configuration parameters we used to have to care about are now AUTOMATIC, but
are the AUTOMATIC settings ideal? And what about Self Tuning Memory Manager best
practices? Most importantly, what ISN'T automatic and what DO you need to pay
attention to? What should you measure and how? What are the “new” and most
important configuration and design techniques that will deliver optimized
performance results for your organization? Participants will be encouraged to
run certain commands in advance and bring performance data to the class. We’ll
discuss your numbers, what they mean, and what to do next and all participants
should expect to “learn vicariously” through the seminar experience. Attendees
will receive over 36 SQL Snapshot commands that can be used against DB2 9.1, 9.5
and 9.7 databases.
I Didn't Know DB2 did THAT!: Bonnie Baker,
Bonnie Baker Corp.
Have you ever wondered what goes on inside DB2
when your SQL is being executed? This seminar is designed to answer exactly that
question and more by taking a look at DB2 Components and the Optimizer's
instructions for various SQL access paths. While simple paths will be reviewed,
this class will also focus on those difficult to understand access paths. Topics
include RIDPOOL failures, Hybrid Joins and a "Type C" Hybrid Join, coding both a
GROUP BY and an ORDER BY on the same columns to insure that my GROUPs are
returned in ORDER, using a 64-partition DPSI for SORT Avoidance, how does DB2
know if Index-Only data is "clean" or "dirty", result sets built at OPEN CURSOR,
DSNZPARMs affects on access path selection and operation and much, m uch more!
Platform: DB2 for z/OS
Take advantage of this additional conference option and register
Be an IDUG Mentor
IDUG is proud to offer an incomparable loyalty reward
program for those who have attended three or more IDUG conferences
- the opportunity to bring a first-time attendee for an unprecedented
80% discount! For IBM Champions, the number of years of
attending a conference and the restriction that the mentor must pay a full
conference registration, is being waived. If they are a speaker or volunteer,
using thier well-deserved speaker or volunteer discount no longer prevents them
from applying for the discount to mentor a first time attendee. To learn more,
visit the IDUG Web
The next DB2 TechTalk is scheduled for March 29. The topic is “Data Archiving: best practices to improve database performance and reduce costs” The speaker is Eric Naiburg, Program Director, Information Governance Solutions from IBM and he will present the full technical details on how to leverage the InfoSphere Optim solutions that help you control data growth.
When it comes to data, more isn’t always better. Users demand that applications perform at their best, yet system complexity and data volumes continue to grow. This causes application and database performance to slow.
Even with powerful systems like DB2 on Linux or z/OS platforms, SLA requirements are reaching their upper limits. This means that you must be extra diligent in managing your database operation to remain within SLA limits and that can mean significant time, resources and money—all of which can be better spent on adding new capabilities. That is why organizations around the world rely on the IBM® InfoSphere Optim Data Growth Solution to automatically control data growth, leveraging archiving to improve performance, reduce costs and ensure that data retention, disposition and compliance requirements are satisfied.
In this technical session, we will discuss ways to improve application and database performance and reduce costs by:
- Reducing the volume of data in your production databases
- Controlling data growth in transactional and warehouse systems
- Archiving and storing historical transactions securely and cost-effectively while still maintaining universal access
- Ensuring access to historical data for compliance, queries and reporting
- Ensuring compliance readiness
Date: Mar 29, 2012
Time: 12:30 PM - 2:00 PM (Eastern Time)
Hosted by: Serge Rielau (IBM)
Presented by: Eric Naiburg (IBM)
Register now: Data Archiving Webinar
Just published: IBM DB2 9.7 Advanced Administration Cookbook by Adrian Neagu and Robert Pelletier.
This book was published by Packt Publishing and is available in several formats. The book contains over 120 “recipes” focused on advanced administration tasks to build and configure powerful databases with IBM DB2 V9.7. Although there is a new release coming out soon, there are many people still at the 9.7 level.
The book allows you to:
- Master all the important aspects of administration from instances to IBM's High Availability technology pureScale
- Learn to implement key security features to harden your database's security against hackers and intruders
- Empower your databases by building efficient data configuration using MDC and clustered tables
DB2 for Linux, UNIX and Windows offers industry leading performance, scalability, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. With lots of new features, DB2 9.7 delivers one the best relational database systems in the market.
IBM DB2 9.7 Advanced Administration Cookbook covers all the latest features with instance creation, setup, and administration of multi-partitioned database.
This practical cookbook provides step-by-step instructions to build and configure powerful databases, with scalability, safety and reliability features, using industry standard best practices.
This book will walk you through all the important aspects of administration. You will learn to set up production capable environments with multi-partitioned databases and make the best use of hardware resources for maximum performance.
With this guide you can master the different ways to implement strong databases with a High Availability architecture.
What you will learn from this book
- Learn to make best use of scalability with multi-partitioned databases
- Get to grips with advanced technological breakthroughs with RBAC, and pureScale technology
- Sharpen your troubleshooting skills
- Design and implement the best backup strategy
- Master the new exciting features added to the DB2 9.7 version
- Get step-by-step instructions to tune and optimize DB2 to achieve best performance
- Understand the database objects and their integration
This cookbook has recipes written in a simple, easy to understand format, with lots of screenshots and insightful tips and hints.
Who this book is written for
If you are a DB2 Database Administrator who wants to understand and get hands on with the underlying aspects of database administration, then this book is for you.
This book assumes that you have a basic understanding of DB2 database concepts.
About the Authors
Adrian Neagu has over ten years experience as a database administrator, mainly with DB2 and Oracle databases. He started working with IBM DB2 in 2002.
He is an IBM DB2 Certified Administrator version 8.1.2 and 9, Oracle Database Administrator Certified Master 10g, Oracle Database Administrator Certified Professional 9i, 10g and Sun Certified System Administrator Solaris 10. He is an expert in many areas of database administration such as performance tuning, high availability solutions, replication, backup and recovery.
In his spare time he enjoys to cook, take photos and catch big pikes with huge jerkbaits and bulldawgs.
Robert Pelletier is a Senior DBA Certified Oracle 8i, 9i, 10g, and DB2. He has twelve years experience as a DBA, as production/development support, database installation and configuration, tuning and troubleshooting.
He has more than thirty years IT experience in many applications in development in central Environments, client-server, and UNIX. More recently he has added expertise in Oracle RAC 11gR2, 10gR2, 9i, DB2 UDB DBA, ORACLE 9iAS, Financials, PeopleSoft and also SAP R/2 and R/3.
His expertise has been recognized by many major organizations worldwide, and he has a solid consulting background in well-known firms.
Date: Mar 27, 2012
Time: 12:30 PM - 2:00 PM (Eastern Time)
Speaker: Paul Zikopoulos (IBM)
Topic: An Introduction to Big Data
Big Data can mean a lot of things to a lot of people; but one thing we're sure of, it's the hottest thing to hit the IT landscape. In this chat you'll start with an introduction to Big Data so we're all on common ground as to what it is, how to spot it, and what the opportunities are. (Hint, be prepared to get shocked on Volume and more). With a strong foundation on what Big Data is, you'll be introduced to the IBM Big Data platform, what it looks like and its key components. In the final part of the chat, we'll dive into IBM's non-forked, embraced and extended Hadoop distribution (called InfoSphere BigInsights) and streaming technology (InfoSphere Streams), a tour of the Big Data platform features as it relates to these pillar components, and a get introduced to the toughest Big Data use case there is: text analytics and how this is just one areas where IBM is brining the "WOW" factor to Big Data.
Of course along the way you'll get introduced to clients that are using the platform and implicit use cases and be all set to investigate and appreciate not only what Big Data can do you for company, but how a partnership with IBM can make it happen that much faster with that much more confidence.
Register now to join IBM speaker, Paul Zikopoulos on Tuesday March 27th, 2012 at 12:30 PM Eastern. Sign-up to attend this free webinar.
Here are a few other resources you may wish to tap into if you’re interested in this topic:
1) Dan Dubriwny from the Big Data Tiger Team, IBM USA, was the guest speaker on episode 62 of the DB2 Night Show, hosted by Klaas Brant. The topic was BIG DATA Overview - What is it? Who cares? Catch the replay.
2) Paul Zikopoulos and Robert Thomas were guests on Episode #63 of the DB2Night Show and gave a deep dive into IBM solutions around BIG DATA.
3) At the IBM Information on Demand Conference that took place last October, copies of the Flashbook “Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data” were handed out. If you didn’t get a copy, you can get the free e-version of this book on my bookstore page: ibm.com/software/data/education/bookstore.
4) Read Jeff Jonas’ Business Insider’s talks and his blog entries about Big Data:
5) Dive into the best wiki in the world! BigInsights Technical Enablement Wiki: ibm.com/developerworks/wiki/biginsights/
6) Read this technical intro to IBM BigInsights, IBM’s Big Data platform, by Cynthia Saracco: Understanding InfoSphere BigInsights: An introduction for software architects and technical leaders.
7) One of the 82 Web-based Training Courses available for IM is BigInsights Essentials.
8) Want to learn Hadoop, MapReduce, HBase or other Big Data topics? Join free BigDataUniversity.com. Already 15,000 students have registered.
9) Read the excellent article by Lisa Stapleton that published in a recent edition of the IBM Data Management Magazine BigData - Volume, Variety, and Velocity. How do you attack something *that* big?
10) Read the article Big Data Impacts Data Management: The Big Vs of Big Data by IBM Champion Dave Beulke.
11) Follow the blogs and tweets that are happening real-time via the Big Data Daily.
12) Read the article by IBM Champion Craig Mullins Big Data and 150 Trillion Calculations Per Second at Vestas
Read, attend and learn!
The IDUG DB2 Tech Conference 2012 is scheduled for May 14 - 18, 2012 in Denver, Colorado. Make your plans to attend now. The IDUG.org website has been updated with detailed information about the conference, including
- On-line schedule
- Education and training opportunities
- Technical certifications
- Discounts available for the conference
I’m sure you’ll find plenty of sessions that interest you. The online session schedule is now available for you to search through. The technical program includes over 120 sessions, addressing a range of topics such as DB2 for z/OS, DB2 for Linux, UNIX, Windows, DB2 Cross Platform, DB2 Application Development, and DB2 New Technology. I’ll try to find friends who can write guest blogs for me that outline their chosen sessions. If you’re going to the conference and have your sessions chosen, let me know and we can work on the guest blog.
Education and training opportunities
You’ll learn plenty from the keynotes that are planned this year. The topic is "Big Data, DB2 and the Future" and includes presenters Anjul Bhambhri, Curt Cotner, and Judy Huber from IBM. For more information and bios for the speakers, visit http://bit.ly/IDUG2012KeyNotes.
Spotlight sessions are always popular and this year, there are 3 sessions scheduled:
DB2 10 for z/OS Migration Planning Workshop: this FREE workshop is scheduled for Friday May 18th from 8.00am to 2:00pm. With IBM DB2 for z/OS Version 8 retiring support in April 2012, many clients are planning their migration strategy. Come and learn from experience how to deal with this normally time-consuming and expensive process. Register early as this workshop has limited places available.
Want to know what the labs are working on for the next release? IDUG in collaboration with IBM is featuring DB2 vNext by offering a dedicated track for DB2 vNext as well as offering in-depth knowledge on the coming releases.. These sessions are available for registered conference attendees free of charge.
I worked at many conferences running certification testing. I can tell you from experience that many people take advantage of the free exams that they can take while at the conference. Since you are saving $200 USD per test that you take, you may be able to justify your conference expenses by taking these exams! For information on which exams are being offered at the conference, see Certification @ IDUG. For tips on passing the exams, take a look at some of my previous blog entries:Cert 101 How to Prepare to Pass a DB2 Certification Exam? DB2 10 for z/OS Certification Roles, Exams and Study Materials Certification Study Guides for DB2 LUW Exams DB2 9.7 for Linux, UNIX and Windows: Certification Roles and Exams Certifications: Beyond DB2 Certification Tips on the DB2Night Show Web-based Training Courses to Consider Certification Promotions and Discounts
Discounts available for the conference
It might seem too early to plan for a May event, but it’s not. And, if you can book before April 6, you can save quite a bit. See this REGISTRATION site to register and to see how much you can save with the Early Bird Discount.
Another great way to save is by using the Multiple Attendee Discount. If your company is sending 3 or more individuals to IDUG you can get a 10% discount.
And finally, the IDUG Mentor Program gives IDUG members the opportunity to pass on the valuable skills they have learned over the years to fellow DB2 professionals. You become eligible to apply for a coupon worth up to 80% off the registration rate for a brand new IDUG conference attendee who accompanies you to IDUG DB2 Tech Conference in Denver. Visit www.IDUG.org/Mentor to learn more.
Follow my blog to get even more information about this fabulous conference. There are many things I haven’t been able to add in this entry including whether there will be a bookstore this year, or how many exams you can take, or what full-day sessions are being offered this year.
My TV is on its last legs, so what did I do? I searched several websites for
possible replacements and only considered those that had customer feedback and
multiple stars. I do this for books, movies, electronics, cars, just about
anything I consider buying. Do you do the same thing?
If the feedback from someone with actual experience is positive, I am more
likely to seriously consider buying the item myself.
If the feedback is
overwhelmingly positive from many people, my buying decision gets easier. If the
feedback is negative, it helps as well... but only if a clear description of the
problem is described and multiple people have experienced the same problem /
So... will you be willing to provide feedback to others regarding the
books that you've read? Let's face it, making a decision to buy a book isn't
only made based on the price of the book, but also on whether it is worth your
valuable time to read the book. We're all short on time, so we want to be sure
that we aren't wasting our time by reading a book that won't help
Where can you post your feedback? For books, amazon.com is likely the
most useful place. I'm in Canada, but still chose to read the feedback that is
posted on amazon.com rather than one of the Canadian sites. Why? Simply because
there tends to be much more feedback on amazon.com than anywhere else. But, you
can still provide feedback on any of the sites that take feedback. Even db2inbooks is a
good site to post feedback.
What should you avoid? It won't help anyone if your feedback is
negative, but you haven't actually read the book. Yes, it does happen. For
instance, my first book had a negative comment made by a reader because of the
title. I don't think the reader read a single word of the book, but decided to
trash it based on the title alone. Is this fair? Absolutely not. I'm sure most
people would disregard this type of feedback, but save yourself some time, if
you didn't actually read the book, don't bother posting comments... positive or
is of more use than just saying that you liked the book. For example, you could
say... "I read the certification guide and was able to learn everything that
I needed in order to pass the exam with an excellent score. I believe that my
success was based on how easy it was to read the information as well as the
sample questions that explained to me why my first answer was incorrect."
This is actual feedback that I've personally received from a reader who read one
of Roger Sander's books.
If you find errors in the book that aren't very serious but that should be
corrected.... I suggest that you contact the author directly if you can. It is
near impossible to produce an error-free book. Most of the authors who I work
with make it easy for you to reach them. Check in the front of the book... you
may find an email address. Also check on ChannelDB2.com as many of our
authors are members and would be happy to hear from you. If you'd rather not
contact the author directly... you can always go directly to the publisher... or
to me. I'll make sure your comments are sent to the author who can then make the
corrections for future iterations of the book.
If you really like reviewing books... and think that you are good at it....
did you know that you may qualify to get free books from the publisher? In some
cases we ask people to review the book before it publishes and ask reviewers to
provide a comment that may be included on the cover of the book. If this
interests you, let me know.
Share your opinion... everyone will appreciate it :)
Beyond books, your opinion about the presentations being
delivered at conferences or webinars is also extremely valuable. Right now on
the DB2Night Show, we are in the Final Rounds of the “DB2’s Got Talent
Competition”. During the finals, the power is in the hands of you the listener
to choose who will win a very lucrative prize as the overall champion. Don’t
miss your opportunity, see DB2’s
Got Talent Finals – Round 1 for further information.
I’d be remiss if I didn’t add that your feedback on blogs is
also important. You can show your “like” of a blog by following it, making
comments on the content, reshare it via twitter or other social media sites, or
add a “like” to the entry.