The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.

Keep on Learning

From archive: September 2012

DB2Night Show – September 2012

svisser1 Tags: webinar db2night db2 ‎ 8,347 Views

The DB2Night Show is back for it’s 4th season and what a great start to the season! Join hosts Scott Hayes and Martin Hubel along with their special guests. Scott and Martin are both IBM Champions (aka IBM’s Best Friends).

First off is two shows featuring Steve Rees who will share the ANSWERS to many Frequently Asked DB2 LUW Performance Questions. Steve is a Performance Specialist and is often a speaker at IDUG.

Season #4 Kickoff!

Date: 7 SEP 2012
Time: 11am ET
Topic: Top DB2 LUW Performance FAQs

Speaker: Steve Rees, Performance Specialist, IBM Toronto Lab

Date: 21 SEP 2012
Time: 11am ET
Topic: Top DB2 LUW Performance FAQs, Part 2

Speaker: Steve Rees, Performance Specialist, IBM Toronto Lab

Host Martin Hubel, an IBM Information Champion, will be joined by Willie Favero, a Senior Certified Consulting IT Software Specialist working for the IBM Silicon Valley Lab (SVL).

Date: 28 SEP 2012
Time: 11am ET
Topic: Willie's Favorite DB2 for z/OS Topic...

Speaker: Willie Favero, IBM

Three speakers are scheduled for October already as well. See The DB2Night Show website for details.

If you are new to this series of webinars, you’ll be happy to note that all shows are recorded and the replays can be watched at your leisure.

Thanks Scott and Martin for helping educated the masses on DB2!

Susan

IDUG DB2 Tech Conference in Sydney, Australia 2012

svisser1 Tags: conference db2 idugap sydney idug ‎ 9,700 Views

Another great IDUG conference is about to begin. This one takes place in Sydney, Australia, 12-14 September, 2012.

There is still time to register and many reasons why you should attend.

Take advantage of 46 hours of technical presentations.

Attend either full day or half day Education Seminars featuring some of the leading speakers in the DB2 community. Featuring: Susan Lawson, John Campbell, Phil Grainger, Scott Hayes, Tony Winch, and George Baklarz.

Get your free signed copy of the DB2 10 for Linux, UNIX, Windows New Features Flashbook.

Meet authors Paul Zikopoulos, George Baklarz and Matthias Nicola. Wednesday September 12 at noon.

Attend a free Database Administration Certification Seminar on Tuesday September 11. Seminars are available for DB2 LUW with Robert Clow and DB2 for z/OS with Susan Lawson.

Take one Certification Exam for free on Thursday, September 13.

Stay in touch with social media while at the conference. Scott Hayes has set up a twitter aggregator: bit.ly/idugap12 tracks #IDUGAP conversations!

This is a can't-miss event! Register today!

Sessions available for you to choose from:

John Campbell - DB2 for z/OS - Trends and Directions
Les King - A Modern [Scientific] Approach to Smarter Planet

John Campbell - Enterprise Application Development with DB2 for z/OS
George Baklarz - NoSQL - Is this the end of SQL?
Frank Rhodes - An XML Document,s Life - Dr. Node!!!
Matthias Nicola - Temporal Data Management with DB2 10 - A Deep Dive

John Campbell - Enterprise Application Development with DB2 for z/OS
Scott Hayes - Customer Success Story: How a Top Retailer achieves 250,000 SQL/Sec on Black Friday
John Tobler - Looking Behind the Curtain of DB2 for z/OS 10 Performance and Scalability: Stored Procedure Analysis
Matthias Nicola - Temporal Data Management with DB2 10 - A Deep Dive

Saghi Amirsoleymani - The Truth about Data Studio 3.1
Scott Hayes - Celebrating 20 Years of DB2 for LUW: DB2's Greatest Hits, Tips, and Best Practices
Steen Rasmussen - Eliminating the DBA nightmare of U-D-C-L (Unload-Drop-Create-Load)
George Baklarz - DB2 10 Performance Enhancements

Neale Armstrong - Bringing Analytics to the Data - Data Warehousing and Business Analytics on System z
Nathan Jolly - Linux to AIX Migration: Big and Little endians
Steen Rasmussen - The DB2 V10 catalog - a revolution
YunCheol Ha - DB2 pureScale implementation experience and lessons learned from a Korea Credit

John Tobler - Leveraging the Instrumentation Facility on DB2 for z/OS: Tracing and Monitoring Fundamentals
Matthias Nicola - How to Design a Hybrid XML/Relational Database Schema
Frank Rhodes - INLINE LOBS - Dare We Go There?
Paul Zikopoulos - Big Data Introduction - Part 1
Saghi Amirsoleymani - Data Studio Hands-on lab

Phil Grainger - ALTER in DB2 10 - Things got easier didn't they?
Matthias Nicola - Understanding and Tuning Page Cleaning in DB2
John Campbell/Terry Purcell - DB2 for z/OS Migration - Query Performance Considerations
Paul Zikopoulos - Big Data Introduction - Part 1 Con't

Nenad Vasiljevic - In the land of traces
Robert Mala - Going Barefoot with UNIX for the DB2 DBA
Paul Murray - Went to tune an application and ended up tuning the subsystem, space and stored procedures
Kingo Saito - Various Tips from Japanese DBA
Phil Downey - Analytics Accelerator, DW strategies and more

Scott Hayes - DBI Software Presentation
Ian Chudleigh - CA CHORUS by CA Technologies
Vinicius (Vinnie) Cardoso - Vendor Software Presentation from IBM
Paul Casson - Test Data Privacy Manager in Eclipse

Terry Purcell - Runstats Challenges for Optimal Query Performance
Kelly Schlamb - Multi-Temperature Data Management in DB2 10.1
John Tobler - DB2 for z/OS V9 and V10 enhancements for system programmers
Paul Casson - Test Data : The End to End story
Phil Grainger - Virtualise Production in DB2 z/OS with Profiles

Terry Purcell - Do these DB2 10 Optimizer Enhancements Apply to Me?
Kelly Schlamb - IBM DB2 HADR 2012 state of the union
Susan Lawson - DB2 10 for z/OS Data Sharing: New Features and Member Consolidation Considerations
Les King - Advanced security features

Terry Purcell - Optimizing DB2 Applications Using Extended Explain Tables
John Campbell - Getting the most of DB2 V10 to reduce performance cost
Les King - PureSystems

I hope you can attend!

Susan

DB2 10 Redbook, "Unleashing DB2 10 for Linux, UNIX, and Windows”

svisser1 Tags: db2 redbook ‎ 8,946 Views

Just released: "Unleashing DB2 10 for Linux, UNIX, and Windows", and available for downloading in either PDF format or EPUB format for use on ebook readers.

Authors:

Abstract:

This IBM® Redbooks® publication provides a broad understanding of the key features in IBM DB2® 10 and how to use these features to get more value from business applications. It includes information about the following features:

Time Travel Query, which you use to store and retrieve time-based data by using capability built into DB2 10, without needing to build your own solution
Adaptive compression, an enhanced compression technology that adapts to changing data patterns, yielding extremely high compression ratios
Multi-temperature storage, which you may use to optimize storage costs by identifying and managing data based on its “temperature” or access requirements
Row and column access control, which offers security access enforcement on your data, at the row or column level, or both
Availability enhancements, which provide different DB2 availability features for different enterprise needs; high availability disaster recovery (HADR) multiple-standby databases provide availability and data recovery in one technology, and the IBM DB2 pureScale® Feature provides continuous availability and scalability that is transparent to applications
Oracle compatibility, which allows many applications written for Oracle to run on DB2, virtually unchanged
Ingest utility, a feature-rich data movement utility that allows queries to run concurrently with minimal impact on data availability

This book is for database administrators and application developers who are considering DB2 10 for a new installation, an upgrade from a previous version of DB2, or a migration from a vendor product. It explains key features and illustrates concepts with real-world examples to provide a clear idea of how powerful these features are.

Together, these features provide functionality that lower operational costs, ease development, and provide greater reliability.
As one of the authors of the Redbook, I would appreciate any assistance in spreading the word about the new book to interested people in the larger DB2 community. The book has examples of how to use the various features, along with sample output, and detailed explanations of the major new features such as Time Travel Query, Multi-temperature storage, and RCAC, along with several other features.

Table of Contents

Chapter 1. Introduction to DB2 10
Chapter 2. Time Travel Query
Chapter 3. Adaptive compression
Chapter 4. Multi-temperature storage
Chapter 5. Row and column access control
Chapter 6. Availability enhancements
Chapter 7. Oracle compatibility
Chapter 8. Ingest utility
Appendix A. Ingest utility script

Susan

Get Certified at the IBM Information on Demand Conference

svisser1 Tags: certification db2 iod12 ‎ 10,545 Views

Help justify your attendance at the IBM Information on Demand Conference this year by saving $170 per exam for any IM, BA or ECM exam. Each of these exams are available for you to take for $30 each. That is 85% off the regular price of $200 per exam.

So, if you take 3 of the latest DB2 10 exams, you’ll save $510. You can take each exam twice while at the conference, so if it takes you two tries per exam, you’ll save $1020.

Other IBM Certification exams are available for you to take as well, with a 50% discounted price of $100 per exam.

What exams should you take?

Take an exam that relates to the job role you’re currently in, or for a job role you’d like to be in. Then choose a platform and release. For example, if you are working with DB2, here’s what’s available for Version 10:

Pass exam 000-610 - DB2 10.1 Fundamentals to earn this certification: IBM Certified Database Associate - DB2 10.1 Fundamentals. Note that this exam is a prerequisite exam for most others.
Pass exam 000-611 - DB2 10.1 DBA for Linux, UNIX, and Windows to earn this certification: IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows
Pass exam 000-612 - DB2 10 DBA for z/OS to earn this certification: IBM Certified Database Administrator - DB2 10 for z/OS
Pass exam 000-617 - DB2 10 System Administrator for z/OS to earn this certification: IBM Certified System Administrator - DB2 10 for z/OS

There are too many choices available for me to list them all here, so take a look at the certification website to find which exam best fits your needs. I suggest you pay particular attention to the exam objectives as these directly relate to the questions you’ll find on the exam.

How do you sign up for an exam at the conference?

I like to call it “Exams on Demand” because you show up when you’re ready to take the exam and in most cases, a computer will be available for you to take the exam of your choice. Remember to give yourself about 90 minutes for most exams. Bring your conference badge, photo ID and your credit card to pay the exam fee.

The certification testing will be located at Surf DEF and will be available during the following hours:

Sunday 10:00 a.m. - 4:00 p.m.*
Monday 10:00 a.m. - 4:00 p.m.*
Tuesday 8:00 a.m. - 5:00 p.m.*
Wednesday 10:00 a.m. - 6:00 p.m.*
Thursday 7:00 a.m. - 4:00 p.m.*

* Please note: The closing times listed above are for the last exam seating available on that day.

How should you prepare for the exam?

It is possible to pass most exams with strong experience, but why take the chance? Read a study guide, take a course, and take an assessment exam to be sure that you are prepared to pass. Ensure your success on exam day with the help of our preparation resources.

Assessment exams are regularly $30 per take, but for those who register for the conference, the exams will be free during the month of October. An email will be sent to all those who register with the code you need to make the practice exam free.

We have one DB2 Version 10 certification guide published and more to come, but not in time for the conference.

DB2 10 for z/OS Database Administration: Certification Study Guide by Susan Lawson and Daniel Luksetich

I’ll have more information about the books you can use to study in an upcoming blog entry. Stay tuned.

Last year, I created a podcast with Susan Weaver, the program manager for the IBM Information Management Certification Exams and I discussed the exams and the procedure to take them for free at the IBM Information on Demand Conference. Listen now: Conversation with Susan Weaver.

For additional 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

Susan