Thanks to Data Warehouse experts Aruna De Silva and Enzo Cialini for putting together this latest Best Practice article. This paper is called "Active-Active Data Warehouse Topology using InfoSphere Warehouse" and explains how you can create an active-active environment for IBM InfoSphere Warehouse to meet the highest availability requirements using DB2 for Linux, UNIX, and Windows, WebSphere Edge Components, and Q Replication.
As data warehouses are now continually growing in supporting Tier 1 applications, you need fully integrated disaster recovery architecture. Traditional disaster recovery (DR) strategies involve a passive DR site that is not accessible for processing. However, companies are looking to leverage the additional hardware and software investments made in creating this DR site.
The purpose of this paper is to provide an active-active environment for IBM InfoSphere Warehouse by using IBM DB2 Version 9.7 for Linux, UNIX, and Windows database servers to meet the increasing availability and performance requirements demanded in today's business environment. An active-active warehouse architecture addresses two distinct problem domains: continuous availability and disaster recovery.
WebSphere Edge Components, part of IBM WebSphere Application Server Network Deployment (ND) offering, are typically used to control client access to Web servers. In this paper, we demonstrate how Edge Components can be used to load balance DB2 clients among multiple DB2 coordinators based on performance metrics or access control rules.
In addition, we describe how Q-replication is used to maintain two identical copies of DB2 V9.7 data servers in an active-active DB2 data warehouse topology. Finally, we examine some of the challenges associated with operating an active-active DB2 data warehouse and strategies to mitigate those issues.
About the Authors:
Aruna De Silva is on the QA-DB2 Data Warehouse and IM Solutions team with IBM
Enzo Cialini is Senior Technical Staff Member, IBM
If this is your area of concern or expertise, read the full Best Practice Paper: Active-Active Data Warehouse Topology using InfoSphere Warehouse.
See also my previous posts on Best Practices:
New DB2 WLM Best Practice Paper
Best Practices: IBM Smart Analytics Systems
How do I handle multi-temperature data in my warehouse?
Updated Best Practices Paper: Database Storage
Best Practice Resources for DB2 z/OS
DB2 Best Practices – New or Updated in 2011
Congratulations to the Best Practices team for putting out another excellent paper. This one is for Workload Manager: DB2 best practices: Implementing DB2 workload management in a data warehouse
What You’ll Learn:
- The best ways to implement a successful workload management solution using DB2 for Linux, UNIX, and Windows, Version 9.7.4 or higher.
- The information in the article reflects the latest experiences of IBM field personnel and customers within the data warehouse arena.
Using a staged approach, this article guides you through the steps needed to implement the best practices workload management configuration on IBM DB2 for Linux, UNIX, and Windows with sufficient controls to help ensure a stable, predictable system for most data warehouse environments. This initial configuration is intended to be a good base for implementing additional tuning and configuration changes as needed, in order for you to achieve your specific workload management objectives.
You’ll be presented with a set of definitions representing the different stages of maturity for a workload management configuration in a DB2 for Linux, UNIX, and Windows database. These stages range from stage 0 through to the advanced stage 3 configuration. A specific configuration template and process is provided as part of these best practices to enable customers to progress from a stage 0 configuration to a stage 2 configuration. General descriptions and advice are also given about common stage 3 scenarios.
The article assumes a novice beginner and describes the individual steps and mechanisms at each point. A more experienced user can condense many of the listed steps to move from stage 1 to stage 2, making the transition in days of elapsed time rather than weeks as the suggested timeline indicates in a later section.
The steps outlined are focused on the efficiency of the system as a whole, regardless of where the work itself comes from. It is important to note that achieving the goal of a stable system might not necessarily also result in the achievement of any individual application service-level agreement (SLA) or specific performance objectives for queries. These more granular objectives might require subsequent changes to the workload management configuration, such as outlined in the section on stage 3 scenarios, which is outside the main scope of this document.
This is not a tutorial on DB2 workload management capabilities and does not attempt to provide comprehensive guidance in addressing all possible scenarios where DB2 workload management might be employed. It also does not cover all features within the DB2 product that might be of use in controlling resource consumption. The scope of this article is focused on describing the system stabilization approach in some detail and provides some general guidance for common advanced scenarios.
Get the article now.
Paul Bird is a senior technical staff member (STSM) within the IBM Software Group development organization, sharing his time between the Optim and DB2 development organizations. Since 1991, he has worked on the inside of the DB2 for Linux, UNIX, and Windows product as a lead developer and architect with a focus on diverse areas such as workload management, monitoring, security, and general SQL processing. He recently became a member of the Optim development organization to expand his experiences. You can reach him at firstname.lastname@example.org.
Rimas Kalesnykas is a technical writer for DB2 for Linux, UNIX, and Windows. In the last 5 years, he was the documentation owner for a variety of DB2 subject areas, including the Command and API references, the Partitioning and Clustering Guide, Troubleshooting, and Workload Management. In 2008, he was a co-author of a best practices paper that describes how to improve data server utilization and management through virtualization. You can reach him at email@example.com.
Did you know?
- Best practices papers complement product documentation. and provide practical recommendations to help you implement IBM Information Management solutions
- Best practices are developed and tested by a wide ranging group of experts, including product architects, software developers and testers, information developers, field practitioners, and most importantly, real users.
- Best Practices webcasts allow users to watch presentations from technical experts without having to attend a live conference presentation.
- As new products and features are introduced, new best practices are published
- As more practical knowledge is gathered from real world environments, best practices are updated to reflect up-to-date information
See also my previous posts on Best Practices:
Best Practices: IBM Smart Analytics Systems
How do I handle multi-temperature data in my warehouse?
Updated Best Practices Paper: Database Storage
Best Practice Resources for DB2 z/OS
DB2 Best Practices – New or Updated in 2011
Next Thursday (November 10th, 12:30 PM - 2:00 PM Eastern), you can attend a free webinar that will teach you about the performance management and optimization solutions that are available from IBM. You’ll learn about:
- InfoSphere Optim Query Workload Tuner which helps DBAs tune poorly performing query workloads.
- InfoSphere Optim Performance Manager which helps manage application performance by identifying problems across multiple applications, DB2 instances, and the network in between.
Better yet, you’ll be learning from the experts!
- Holly Hayes, Product Manager – InfoSphere Optim Solutions
- Bob Harbus, DB2 Technical Specialist
- Danny Zilio, Software Analyst – Optim Query Tuner group
Don’t miss these experts as they discuss how the performance management solutions delivered by IBM helps you implement a best-practice methodology to identify, diagnose, solve and prevent performance related bottlenecks before they affect your production environment.
Register Now for this webinar on November 10th, 12:30 PM - 2:00 PM Eastern to take charge and manage performance of your data environment before it impacts your business.
This year at the IBM Information on Demand Conference (#IOD11), there is a crammer course for InfoSphere QualityStage 8.5 (Exam 422). If you use this product, you may want to earn an industry-recognized IBM Information Management certification by passing Exam 422. Passing this exam is a great way to validate your skills on the InfoSphere QualityStage 8.5 product. Remember, if you are a registered Information On Demand conference attendee, taking the exam is free. Normally it is $200 per take, so you are saving significantly.
To help you pass this exam, consider taking the Crammer course that is being offered for the first time at this event: (9Q061) InfoSphere QualityStage 8.5 Certification Crammer for Exam 422. This course is being offered the day BEFORE IOD begins: Sunday, October 23. You can register in advance or show up early morning to register at the event.
The instructor for this course is Dale Buckingham. Dale is a learning consultant and technical architect for InfoSphere.
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.
To gauge whether you need to take this course or not, consider taking the assessment exam. Normally these exams cost $10, but for conference attendees they are free and will show you how much more you need to know to pass the exam. Beyond this crammer courses, check out the other types of education that are available to learn the material to pass this exam. Of course, you may not have time to take any of this education before going to IOD, so the crammer course may be the best timing and value.
The test contains six sections totaling approximately 62 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Methodology (5%)
- Describe the steps in data quality methodology.
- Understand the impact of data integration preparing.
Section 2 - Design Considerations (18%)
- Identify the steps for standardization.
- Given a scenario, demonstrate knowledge how to optimize QualityStage jobs using parallel concepts.
- Given a scenario, describe how to handle data from multiple countries.
- Describe initial vs. delta vs. real-time design considerations. (may use scenarios)
Section 3 - Investigation (10%)
- Given a scenario, demonstrate knowledge of investigation types.
- Given a scenario, describe how word investigation results can be used.
Section 4 - Standardization/Addresses/Postal (11%)
- Describe the differences between address certification, verification, and standardization. (may use scenarios)
- Define what the standardization stage is and how to use it. (may use scenarios)
- Given a scenario, describe the purpose of standardization and what results are produced by the process.
Section 5 - Rule Sets (16%)
- Demonstrate knowledge of how to customize standardization rules. (may use scenarios)
- Demonstrate knowledge of the components of a rule and their functions.
- Demonstrate knowledge of managing standardization rules.
- Demonstrate knowledge of user defined standardization rules.
Section 6 - Matching (21%)
- Given a scenario, demonstrate knowledge of match concepts.
- Describe the match job components. (may use scenarios)
- Given a scenario, describe how to review and tune a match.
- Demonstrate knowledge of managing match specification (re-usability). (may use scenarios)
- Given a scenario, demonstrate knowledge of match job design to achieve optimal performance.
Section 7 - Survive (10%)
- Describe the purpose of survive.
- Demonstrate knowledge of the different rule types for surviving data and when to use them. (may use scenarios)
- Describe how to implement a survive stage.
Section 8 - Setup and Troubleshooting (10%)
- Identify how to troubleshoot a QualityStage job. (may use scenarios)
- Describe how to configure data quality environment functionality.
- Describe QualityStage deployment considerations. (may use scenarios)
- Demonstrate knowledge of NLS/non-NLS install and its impact on QualityStage stages. (may use scenarios)
Good luck on this an any other exam you may choose to take at the IOD conference this year.
I bet you know an IBM Champion or two! I know I do. I’ve blogged about this wonderful group in the past and lovingly call them “IBM’s BEST Friends”. In IBM’s definition, IBM Champions are thought leaders and advocates who share their opinions and years of experience with people like you.
These people are recognized by IBM for their extensive contributions to the community and IBM Champions help make IBM communities a vibrant, meaningful and useful resource. IBM Champions are sought after experts in their field, and as such, have become renowned speakers at IBM and user group events worldwide.
At this year’s Information on Demand Conference (iod11), we will have 59 IBM Champions in attendance & speaking. An impressive 80 of the planned sessions across all the Forums and a variety of tracks is being led by one or more of our IBM Champions. The full list of 80 sessions can be found in this IBM Champions for Business Analytics, Enterprise Content Management and Information Management PDF document.
I’ve been attending conferences for many years now and I’ve become friends with many of these IBM Champions. Take a look at some of the events where a friend of mine is involved:
Roger Sanders: Pre-Conference Certification Class on Sunday Oct 23, 2 book signings: Idea to Print & DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes.
Susan Lawson: Pre-Conference Certification Class on Sunday Oct 23, Up-coming book: DB2 10 for z/OS Database Administration: Certification Study Guide.
Judy Nall: Pre-Conference Certification Class on Sunday Oct 23, Book: DB2 9 System Administration for z/OS: Certification Study Guide: Exam 737.
Panel Discussion Speakers: Brian Green, Blue Cross Blue Shield of Tennessee, Manager, BI and Performance Management; John Boyer, The Nielsen Company, Enablement Team Lead; Kay Van De Vanter, The Boeing: co-authors of the book, "Business Intelligence Strategy", session BDS-1670B: How to Deliver BI Program Excellence, Tuesday, Oct 25, 3-4 pm.
Bernie O'Connor: IDUG Friend; Session IDB-3162A Anixter Uses IBM DB2 pureScale and Optim for Mission Critical Applications; 03:00 PM - 04:00 PM
Klaas Brant; Fellow judge on DB2’s Got Talent Competition & Host for DB2Night Show for DB2 for z/OS: Session IDB-2878A DB2 9.7: How to Create, Maintain and Monitor Huge Tables, Tuesday, Oct 25 04:30 PM - 05:45 PM
Cristian Molaro: Friend from DB2Night Show; Several sessions!
Cuneyt Goksu; Future Author; Session IDZ-1012A Practical Recipes for Daily Database Administration Activities Using IBM DB2 9 and 10 for IBM z/OS Monday, Oct 24 02:15 PM - 03:15 PM
Suresh Sane; IDUG Friend; Session IDZ-1179B DB2 10 Customer Experiences Part 1 What's New for the Developer? Monday, Oct 24 02:15 PM - 03:15 PM
Isaac Yassin; IDUG Friend; Session IDZ-1100A A Closer Look at IBM DB2 (z/OS) Member Cluster Tuesday, Oct 25 08:15 AM - 09:30 AM
Dave Beulke; Co-author of book: DB2 10 for z/OS - Cost Savings ..... Out of the Box; Session IDZ-1731A IBM DB2 Temporal Database Performance Designs Tuesday, Oct 25 10:00 AM - 11:00 AM
Sheryl M. Larsen; Session IDZ-3504A More Lessons Learned from SQL Performance Review Tuesday, Oct 25 10:00 AM - 11:00 AM
Bryan Paulsen; Session IDZ-3138A IBM DB2 10 for z/OS: John Deere's Beta Experience Tuesday, Oct 25 10:00 AM - 11:00 AM
Julian Stuhler; Co-author of book DB2 10 for z/OS - Cost Savings ..... Out of the Box; Session IDZ-1425A The Business Value of IBM DB2 10 Top Features - Real Customer Experiences Tuesday, Oct 25 11:15 AM - 12:15 PM
Daniel L Luksetich; Author of up-coming book: DB2 10 for z/OS Database Administration: Certification Study Guide; Session IDZ-1561A Explaining the IBM DB2 for z/OS Dynamic Statement Cache Tuesday, Oct 25 11:15 AM - 12:15 PM
Craig S Mullins; Author of many books including an up-coming book; Session IDZ-1380A IBM DB2 for z/OS Performance Tuning Roadmap, Tuesday, Oct 25 03:00 PM - 04:00 PM
Phil Grainger; IDUG Friend; Session IDZ-1011A Hash Access: The Hierarchical Direct Access Method (HDAM) IBM DB2 Table? Wednesday, Oct 26 02:00 PM - 03:00 PM
Bonnie Baker; IDUG Friend; Session IDZ-3510A DB2 Doctor: Symptoms, Diagnoses, and Cures for Poor Performance Wednesday, Oct 26 04:30 PM - 05:45 PM
David Birmingham; Author of book: Netezza Transformation: Taming the dragon without alchemy, sorcery or strange potions ; Blogger: “Netezza Underground” ; Several sessions, including Unleashing Netezza - Netezza Solution Best Practices Wednesday, Oct 26 08:15 AM - 09:30 AM.
For complete details of the sessions that all the IBM Champions are involved with, see this IBM Champions for Business Analytics, Enterprise Content Management and Information Management PDF document.
Looking forward to going to the conference to see my friends… and to make more friends.
PS… If you follow my blog, you’ll notice that two of my friends are missing from this list: Rebecca Bond and Scott Hayes. Rebecca won’t be attending for personal reasons and Scott doesn’t have any sessions that he’s running, but I hope he’ll be at the conference. If not, I’ll see him in Prague for IDUG.
A new exam was recently added to the large collection of Information Management Certification Exams. This one leads you to become an IBM Certified Specialist - IBM InfoSphere Optim for Distributed Systems - V7.3.1.
This intermediate level certification is intended for application developers, database administrators, and technical personnel who perform the installation, configuration and day-to-day tasks associated with ensuring the smooth and efficient operation of InfoSphere Optim environment.
- product installation and configuration
- configuration of security
- archive and extract maintenance
- archiving and Optim Connect
- creation and maintenance of test data
- privatizing data
- accessing extended data sources using Optim Connect and InfoSphere Federation Server
- implementing a test data management environment
- performance and tuning
The person performing these functions is generally self-sufficient and is able to perform most of the tasks involved in the role with limited assistance from peers, product documentation and vendor support services.
To earn this certification, you need to take one exam: Test 000-552 - IBM InfoSphere Optim for Distributed Systems - V7.3.1
There are four sections on the exam. See the full set of exam objectives.
Section 1 - Installation and Configuration (25%)
Section 2 - Optim Core Functionality (35%)
Section 3 - Advanced Topics (34%)
Section 4 - Performance and Troubleshooting (6%)
To prepare to pass, here are the recommended courses that you could take:
As always, you can keep up to date with the latest exams and education offering updates from this site: ibm.com/software/data/education/
Another book that is launching at the IBM Information on Demand Conference this year is by Sunil Soares, “Selling Information Governance to the Business: Best Practices by Industry and Job Function”. You may remember Sunil from last year when we launched his very popular Flashbook, “The IBM Data Governance Unified Process: Driving Business Value with IBM Software”. Based on the feedback and enormous success of last year’s book, Sunil was offered a book contract with MC Press for a new book.
The new book, Selling Information Governance to the Business: Best Practices by Industry and Job Function” is so amazing, I’m not sure where to start. First of all, the publisher and the copy editor were completely wowed with both Sunil and the content he created for the book. I haven’t read the book yet, but Sunil has just sent me a draft and from a simple browse I can completely understand why they are so excited.About the book:
One of the major challenges with any information governance program is explaining the value to the business. Most information governance programs deal with certain themes that are common across every enterprise including poor data quality, inconsistent business terms, fragmented data, high storage costs, regulatory compliance, and security and privacy issues. However, these themes present themselves differently across different industries and job functions. For example, poor data quality manifests itself in the form of duplicate customer records in a bank, which affects the ability of the credit risk group to establish the overall exposure to an individual customer across product lines. In retail, poor data quality results in duplicate mailings of multiple catalogs by the marketing department to the same household. I have spoken to hundreds of organizations across multiple industries and geographies about their information governance programs. The conversation quickly proceeds along the following lines: “I get the value of information governance. However, it is very hard for me to convince the business about the value of an information governance program. What best practices do you have to help me do this?” That is why I am writing this book; to help you apply best practices in your organization based on what I have learned, heard, and observed through my industry experience.
This book discusses the best practices to sell the value of information governance, and is divided into four parts:
- Best practices by industry that deal with the application of information governance principles within banking and financial markets, insurance, healthcare, manufacturing, retail, travel and transportation, government, oil and gas, telecommunications, and utilities.
- Best practices by job function that deal with the application of information governance principles within critical job functions such as sales and marketing, finance, information technology operations, information security and privacy, human resources, legal and compliance, operations, supply chain, and product management.
- Cross-industry best practices that deal with horizontal topics such as roles and responsibilities, metrics, metadata, maturity assessments, and business cases. These themes appear consistently within information governance programs across job functions, industries, and geographies.
- Information-centric applications and information governance software tools that cover the applications that benefit from information governance and the actual software tools that facilitate information governance.
The objective of the book is to provide a representative sample, rather than an exhaustive list, of best practices to sell the value of information governance within an organization. You should use these best practices as inspiration for what might work within your organization. It is important that you read chapters from industries and functions outside of your own because there are a number of case studies that you might find useful for your specific situation.
Another unique thing about this book is the number of case studies and forewords. There are more than 50 case studies and 16 forewords. I think what I’ll do is list the names of the people writing the forewords for the book. This might give you an idea of how well connected Sunil is and the depths that are covered in this book:
Partner and Global Leader
Business Analytics and Optimization – Information Management Foundation
IBM Global Business Services
Global Vice President
IBM Software Group
Business Analytics and Optimization
IBM North America
From a banking perspective: David W. Bailey
Director of Enterprise Product Management
From a telecommunications perspective: Komalin Chetty
Head – Data Governance Office
Telkom South Africa
From a financial markets perspective: Paul Ranaldo
Senior Vice President
Master Data Management/Data Governance
Brown Brothers Harriman
From an analyst perspective: Aaron Zornes
Chief Research Officer, The MDM Institute
& Conference Chairman, The “MDM & Data Governance Summit” Global Conferences Series
(London, Mumbai, NYC, San Francisco, Shanghai, Singapore, Sydney, Tokyo, & Toronto)
From a consumer packaged goods perspective: Jay Yusko, Ph.D.
VP Technology Research
From a European banking perspective: Banu Ekiz
Vice President – Business Intelligence
IBM Information Champion
Akbank Information Technologies
From a retail perspective: Michel Boudrias
Director of Enterprise Architecture
SAQ – Société des alcools du Québec
From a manufacturing perspective: Anthony Harris
Enterprise Information Architect
Air Products Gases and Chemicals Inc.
From a distribution perspective: Cengiz Barlas
Vice President & Global Head of Data Management
From an information services perspective: Gustavo Tadao Okida
Chief Enterprise Architect - LATAM
From an analyst perspective: Claudia Imhoff
President of Intelligent Solutions, Inc.
Founder of the Boulder BI Brain Trust
From an analyst perspective: Andy Hayler
The Information Difference
From a retail perspective: Charles Hunsinger
Chief Information Officer
Harry & David
About the Author:
Sunil Soares is the director of information governance within IBM Software Group. Sunil has worked with hundred of clients across multiple industries including banking, insurance, life sciences, retail, telecommunications, media and entertainment, energy and utilities, manufacturing, healthcare, and government. Sunil helps clients establish information governance programs that align IT and the business around common business objectives. Sunil’s first book The IBM Data Governance Unified Process detailed the 14 steps and almost 100 sub-steps to implement an information governance program. The book is already in its second print, and has been translated into Chinese.
I’ve just learned that Sunil is also blogging now! You can find his entries in the Mastering Data Management website. Some of his entries:
Congratulations Sunil for finishing your second book!
At this time there are 82 Web-Based Training (WBT) Courses available for you to take to sharpen your skills on IBM Information Management (IM) products and technologies. Eighty-two is a LOT of courses! More are being created and being updated, so if this is the way you like to learn, make sure you stay in touch with all the latest as they are released.
IBM’s Education is known for its high quality content and excellent instructors. Although with WBT courses you won’t be in a classroom environment, you’ll get the same quality of content that you expect. WBT courses allow you to learn at your own pace and on your schedule with training that is completely self-contained from your desktop. Most courses provide introductory and overview training that serves as the foundation for more technical and follow-on training. Courses include expert instruction but do not include hands-on labs.
How do you get there?
Access this site to see all course offering types: http://www.ibm.com/software/data/education/elearning.html. Under the Web Based section, click on "Browse the complete Information Management WBT portfolio". I’ve included the 82 courses that I know of right now and have put the newest ones at the top of the list. If you’re an IBM employee, contact me offline as there is a different procedure that must be used to take these classes.
Using IBM Optim Designer and Optim Manager - Web Based – New
Connect Information Server to SAP R/3 ECC (DataStage Pack for SAP) – New
DataStage Essentials - Web Based – Updated
IBM InfoSphere Information Server Metadata in Practice – New
InfoSphere BigInsights Essentials (Web) – New
InfoSphere MDM Server Workbench for MDM Server 9 - Web Based – Updated Programming for InfoSphere Streams V2 - Web Based - New
5 Ways to Apply Data Quality with Information Analyzer WBT
A Blueprint for Implementing MDM Server Using V8.5 - Web Based Training
Advanced DataStage - Web-Based
Advanced DB2 SAP for Administrators - Web-Based
Advanced Programming InfoSphere Streams - Web Based
Basic Programming for InfoSphere Streams - Web Based
Business Glossary Essentials - Web Based
Changing Business with Data Insight (Web Based)
Configure ODBC for IBM DataStage on UNIX - Web Based Training
DB2 9 for z/OS Database Administration Workshop Part 1 (Web Based)
DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 9.1 (Web-Based)
DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 (Web-Based)
DB2 9.7 for Linux, UNIX, and Windows New Features (Web-Based)
DB2 Everyplace V9 Tutorial – Online
DB2 Express V9 - Developer in a Day Workshop – Online
DB2 Family Fundamentals - Web-Based
DB2 for LUW 9.5 Fundamentals – Online
DB2 for LUW pureXML
DB2 LUW Advanced Topics – Online
Exploring IBM solidDB Universal Cache - Web-Based
Exploring Initiate Workbench V8.x - Web Based
Exploring Initiate Workbench V9.x - Web Based
FastTrack Essentials - Web Based
Federation Server Essentials - Web Based
How to Analyze Data (Using InfoSphere Information Analyzer) - Web Based Training
How to Install IBM DataStage on UNIX - Web Based Training
How to Install IBM QualityStage on UNIX - Web Based Training
How to Install Information Server 8.5 - Basic and Advanced Option
IBM Data Studio Basics - Web Based
IBM InfoSphere Change Data Capture Essentials V6.3 - Web Based
Implementing IBM InfoSphere MDM Server for PIM V9 (Web Based)
Information Analysis - Web Based
Informix 11 New Features (Web Based Training)
Informix Version 10 – Online
InfoSphere Information Server Administration - Web Based
InfoSphere Master Data Management Server Overview (MDM Server) - Web Based Training
InfoSphere MDM Server Architecture – WBT
InfoSphere MDM Server Domains for MDM Server 9 - Web Based
InfoSphere MDM Server User Interface Generator - Web Based
InfoSphere Warehouse 9 - Cubing Services - Web Based Training
InfoSphere Warehouse 9 - Data Mining and Unstructured Text Analysis – WBT
InfoSphere Warehouse 9 - SQL Warehousing Tool and Admin Console – WBT
InfoSphere Warehouse 9 Components - Web Based
Initiate Self-Paced Bundle V8.x - Web Based
Initiate Self-Paced Bundle V9.x - Web Based
Install, Configure, and Use DataStage SOA Edition (RTI) - Web Based Training
Installing and Configuring IBM Optim Data Privacy Solution - Web-Based
Introduction to IBM InfoSphere Information Analyzer - Web Based Training
Introduction to IBM Optim Data Privacy Solution - Web-Based
Introduction to IBM QualityStage - Web Based Training
Introduction to InfoSphere Change Data Capture How to Use CDC WBT
Introduction to InfoSphere DataStage Using Version 8 - Web Based Training
Introduction to InfoSphere QualityStage Using Version 8 - Web Based Training
Introduction to Initiate Master Data Service - Web Based
Introduction to New Features in Informix Version 11 – Online
Introduction to TSA in IBM Smart Analytics Systems - Web Based
Managing Workloads for DB2 LUW and InfoSphere Warehouse - Web Based
Metadata Workbench Essentials - Web Based
Overview of (IISD) InfoSphere Information Services Director - Web Based Training
Overview of IBM DataStage Enterprise Edition for ETL Developers - Web Based Training
Overview of IBM Information Server and DataStage QualityStage Version 8.0 - Web Based Training
Production Automation of IBM DataStage- Web Based Training
Programming for InfoSphere Streams - Web Based
Programming with IBM InfoSphere MDM Server for PIM V9 (Web Based)
QualityStage Advanced Concepts - Web Based
QualityStage V8 Essentials - Web Based
SQL Replication: Advanced Topics (Web Based)
Troubleshooting IBM InfoSphere Information Analyzer - Web Based Training
Using InfoSphere MDM Server for PIM V9 (Web Based)
Using Initiate Inspector V8.x - Web Based
Using Initiate Inspector V9.x - Web Based
Using Queue Replication - Web Based
Using SQL Replication (Web Based)
Validating Data with Rules in Information Analyzer 8.1.1 - Web Based Training
XML and DataStage: Convert Relational and XML Data - Web Based Training
I hope you’ve found one or two in this massive list that interest you! Take the course and let me know what you thought of it.
I got this information from a newsletter that I subscribe to and thought that you may be interested. IBM continues to invest in creating education that is timely, well-designed, and highly-rated, therefore you can continue to expand your skills so that you can perform at your optimal level.
Here are the IBM Information Management courses have recently been updated:
You can view all IM training classes from this link: View all Information Management training
The newsletter I subscribe to is: IBM Training News.
To subscribe to this newsletter and many others, click here: Subscribe. Once on this site, you can choose the product and technology areas that you are interested in seeing in your newsletter and the newsletter is custom-built to your requirements.
Keep your skills as sharp as they can be!
Last year at the IOD Conference, one of the more popular events was handing out printed copies of the IBM Redbooks for Cognos 10. There were a limited number of copies that we had to hand out, and we went through them very quickly. Many other people came and left empty-handed, unfortunately. I pointed out that the book was available for free online at the ibm.com/redbooks site. Clearly there are many people who still prefer to have printed copies!
This year at the IBM Information on Demand 2011 Conference, we’re announcing up front which IBM Redbooks we’ll be handing out, and when. Make sure that if you want one of these books that you come to the Conference Bookstore at the planned times to get your copy. If you miss it, you miss it… but can get the content online!
Get one of the limited copies… and meet the author team behind the book. Maybe you can even find out how you can become an author of an IBM Redbooks.
Monday October 24 from 10:45 – 12:30 p
IBM Production Imaging Edition and Datacap Taskmaster
Metadata Management with IBM InfoSphere Information Server
Tuesday October 25 from 3:00 – 4:00 p
IBM Redbooks DB2 10 for z/OS Performance Topics
Wednesday October 26 from 11:30 – 1:30 p
IBM InfoSphere Streams and the Streams Processing Language
IBM solidDB: Delivering Data with Extreme Speed
The Conference bookstore will be a busy place this year. Here are the other signings and giveaways that are taking place at the event:
Meet Author Sandy Carter at IOD2011 - Get Bold: Using Social Media Meet Netezza Expert & Author David Birmingham at IOD11 Meet Data Warehouse expert & author: Bob Laberge Meet author Tony Giordano, “Data Integration Blueprint and Modeling” Meet FileNet expert and author Bill Carpenter at IOD11 Meet author & decision management expert James Taylor at IBM’s Information on Demand Conference From Idea to Print by Roger Sanders Flashbook: Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data Meet author and DB2 expert Roger Sanders at IOD11 Meet Flashbook author Arvind Sathi - Customer Experience AnalyticsMeet DB2 authors and experts Lawson & Luksetich at IOD: DB2 10 for z/OS DBA Cert Guide
Keep this in mind as you build your schedule for the conference. Note, soon I’ll have session numbers for all of these events where you can add them to your SmartSite schedule.
Meet author Anthony David Giordano and have him sign a copy of his book at the IBM Information on Demand 2011 Conference. Come to the Conference bookstore Tuesday October 25 from 11:30 – 12:30 pm to meet Tony. Soon you’ll be able to add this signing and others to your Smart Site schedule.
Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture
About the book:
The book begins with an overview of the “patterns” of data integration, showing how to build blueprints that smoothly handle both operational and analytic data integration. Next, he walks through the entire project lifecycle, explaining each phase, activity, task, and deliverable through a complete case study. Finally, he shows how to integrate data integration with other information management disciplines, from data governance to metadata. The book’s appendices bring together key principles, detailed models, and a complete data integration glossary.
Today’s enterprises are investing massive resources in data integration. Many possess thousands of point-to-point data integration applications that are costly, undocumented, and difficult to maintain. Data integration now accounts for a major part of the expense and risk of typical data warehousing and business intelligence projects--and, as businesses increasingly rely on analytics, the need for a blueprint for data integration is increasing now more than ever.
This book presents the solution: a clear, consistent approach to defining, designing, and building data integration components to reduce cost, simplify management, enhance quality, and improve effectiveness. Leading IBM data management expert Tony Giordano brings together best practices for architecture, design, and methodology, and shows how to do the disciplined work of getting data integration right.
Implementing repeatable, efficient, and well-documented processes for integrating data
Lowering costs and improving quality by eliminating unnecessary or duplicative data integrations
Managing the high levels of complexity associated with integrating business and technical data
Using intuitive graphical design techniques for more effective process and data integration modeling
Building end-to-end data integration applications that bring together many complex data sources
About the Author:
Anthony Giordano is a partner in IBM’s Business Analytics and Optimization Consulting Practice and currently leads the Enterprise Information Management Service Line that focuses on data modeling, data integration, master data management, and data governance. He has more than 20 years of experience in the Information Technology field with a focus in the areas of business intelligence, data warehousing, and Information Management. In his spare time, he has taught classes in data warehousing and project management at the undergraduate and graduate levels at several local colleges and universities.
Tony is speaking at the following sessions:
Monday 10:15 am:
Implementing Information Governance Best Practices within an Organization
In this session, information governance experts describe what they have seen, and done, and take your questions about how to best implement the various information governance practices within an organization.
Tuesday 10 am:
Selling Information Governance to the Business: Best Practices by Industry and Job Function
This session discusses the best practices used to generate sponsorship for an information governance program. It also describes best practices by job function such as marketing, supply chain, risk management, finance, and legal. It will also discuss industry-specific aspects of information governance.
For IOD sessions related to this book, see the IM Information Governance.
Other blog entries about IOD Events:
As you’ve noticed, I’m promoting the upcoming IBM Information on Demand Conference via my blog. Many Europeans are unable to afford the time or money to go all the way to Las Vegas for a conference, so the good news is there is an amazing conference planned for Prague in November. I’m hoping that I can attend in order to set up a bookstore for attendees.
IDUG DB2 Tech Conference in Prague, Czech Republic, 13-18 November 2011, at the Clarion Congress Hotel Prague
- Register on or before 17 October 2011 and receive a discount of EUR 275.
- Multiple Delegate Discount: For every three individuals who register from the same organization, a fourth may attend at the discounted rate of EUR 730.
- Mentor Program: If you have attended three previous IDUG DB2 Conferences, you are eligible to bring a first-time colleague to Prague for an 80% discount off the full registration fee.
How you can hone your expert DB2 skills at IDUG EMEA
- Members of IDUG get 45% off IBM Press books. New books include Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture, The New Era of Enterprise Business Intelligence: Using Analytics to Achieve a Global Competitive Advantage, and The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight.
- On 13 November, receive FREE IBM certification training, DB2 migration workshops and sessions for CA customers.
- IBM Certified Database Administrator - DB2 10 DBA for z/OS certification Preparation Seminar - Susan Lawson
- DB2 UDB V9.7 for LUW Advanced Database Administration certification Preparation Seminar - Guy Przytula
- One-Day Educational Seminars - Friday, 18 November 2011
Registration for paid full conference delegates is EUR 450; the cost for just the one-day seminar is EUR 495. Select from the following session topics:
- DB2 10 for z/OS - In Depth, Phil Grainger, Cogito
- DB2 Intermediate and Advanced SQL, Daniel Luksetich, Yevich Lawson & Assoc Inc.
- I Didn't Know DB2 did THAT!, Bonnie Baker, Bonnie Baker Corporation
- Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace, John Campbell, IBM Corporation
- Rocket Science: DB2 for LUW Performance Analysis and Tuning Workshop, Scott Hayes, DBI
- Some of the top rated speakers:
For the complete agenda and speaker list, see this site: http://www.idug.org/p/cm/ld/fid=102
Author Robert Laberge is flying in from Ireland to meet people who are interested in having him sign copies of his book at the IBM Information on Demand 2011 Conference. Come to the Conference bookstore Tuesday October 25 from 10:30 – 11:30 am to meet Bob. Soon you’ll be able to add this signing and others to your Smart Site schedule.
by Robert Laberge
What’s in the Book?
In The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights, business intelligence and data warehousing expert Robert Laberge explains the components and different alternatives in building a data warehouse and describes pros and cons for choosing one path over another. Building a data warehouse is unique for each organization but can be guided by the author’s years of knowledge obtained from working on many differing data warehouse and business intelligence environments in organizations around the world.
The book covers practical and technical aspects of current data warehouse and business intelligence issues with views on realistic solutions within the management and technical arenas. Data warehousing topics are first presented from a high-level overview to ensure the terminology and context is understood, and are then covered in deeper detail to clarify the specifics. These topics all pertain to data warehousing, business intelligence, and performance management.
The Data Warehouse Mentor
- Explains the proper implementation of the many available technologies and practices
- Shares the author’s nearly 30 years of data warehouse and business intelligence experience in more than 20 countries worldwide
- Mentors you to success in determining and deploying the most effective data warehouse and business intelligence solutions for your business
- Helps you anticipate future data requirements and usage to ensure the design and build environment for your solution is flexible and open to change
Data Warehouse and Business Intelligence Overview; Data in the Organization; Reasons for Building; Business Intelligence and Data Warehouse Strategy - The Plan; Project Resources – Roles and Insights; Write it Up – Overview; Business Intelligence: Data Marts & Usage; Enterprise Data Models; Data Warehouse Architecture; ETL and Data Quality; Project Planning; Working Scenarios - Hands On; Data Governance; Post Project Review
About the Author
Robert Laberge is a lead principle consultant for the IBM Industry Models and Assets Lab in Dublin which focuses on data warehousing and business intelligence solutions. He has helped more than 50 large organizations in 20 countries by mentoring, training, and demonstrating data warehouse and business intelligence solutions, including Target, Qwest, ING, Mayo Clinic, Canadian Tire, Shoppers Drug Mart, BMW, Korea Telecom, Scotiabank, Capital One, Reliance Infocomm, and Tata Group. Robert has a Masters of Business Administration from the University of Durham (UK) and has nearly 30 years of experience in IT.
Proven strategies for implementing the right data warehouse and business intelligence solutions for current and future business needs: order the book now!
Other Warehouse events taking place at IOD:
The best way to find out the warehouse specific sessions that are available at IOD this year is to review the roadmaps that were put together to guide you. Here is the mega list!
Other blog entries about IOD Events:
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:
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.
Judy’s book was launched at IOD last year and is a must read if you are interested in System Administration. DB2 9 System Administration for z/OS: Certification Study Guide: Exam 737
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.
- (9Q060) InfoSphere DataStage 8.5 Certification Crammer for Exam 421
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.
- (9Q061) InfoSphere QualityStage 8.5 Certification Crammer for Exam 422
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.
- (9Q080) InfoSphere BigInsights Essentials Crammer ( Mastery Test M97)
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.
Last May a bunch of us were in Rome for the IBM IOD EMEA conference. This year there is a smaller conference that is more technical in content and is being held in France this July:
6 - 8 July 2011
Register now and learn how to reduce costs, manage risk, optimize customer insight, and increase operational efficiency. Learn the latest about information management, Enterprise Content Management , Business Analytics, Smart Analytics Systems, and network with your peers. Learn how to turn your Information, Content, Analytics into a strategic driver of innovation and business optimization.
Featured are all the new major versions of IBM products announced in 2010 & 2011, such as
- DB2 10 for z
- Informix 11.7
- Cognos 10
- InfoSphere Information Server 8.5
- FileNet P8 5.0
- IBM Case Manager 5.0
- Change Data Capture 6.5
- ... and more
What you can expect:
- Thought-provoking general sessions from leading industry commentators and IBM executives Technical & Business Leadership
- Compelling speakers, including business and technical luminaries, analysts and customers. See the Agenda for a complete list of the sessions and the confirmed speakers.
- Ability to meet one-to-one with IBM executives
- Opportunity to meet the experts, providing solution, industry and technical insight
- Expo Solution Center showcasing information management solutions
- World-class technical training, free certification testing and education Extensive networking opportunities
- Hands-on Labs and Usability Labs
This is the event for gaining unique insight into the value that information Management, Content, Business Analytics technologies are
delivering today. To cover your specific needs, this Technical Conference offers two tracks – Business Leadership and Technical.
Move between tracks and create a personalized agenda to ensure you get the most value from your Conference attendance.
The Business Leadership Track
- The Business Leadership Track includes industry sessions, line-of-business managers looking to become more competitive, reduce
costs, enhance customer satisfaction, manage risk and deliver value.
The Technical Track
- The Technical Track focuses on the implementation of Information Management, Content, Business Analytics solutions, the latest
technical developments, plus the most recent innovations from entire portfolio. Together with certification and education, there are technical
demos and opportunity to meet with product and software development experts.
- The Conference fee is 1450 € exclusive of local VAT. This fee provides access to all keynote and elective sessions, workshops, panel
discussions, conference proceedings, meals, refreshments and conference events mentioned in the conference agenda.
For more information and enrollment: ibm.com/training/conf/europe/IMSSTC
Some additional incentives to attend:
25% Discounts on Public Training*
- Take your skills to the next level. Attend a Business Analytics, Enterprise Content Management or Information Management public class and save 25% off the tuition. This offer is valid for the IMSSTC EMEA attendees from July, 15, 2011 until March 30, 2012.
- * This offer is only for European public scheduled courses and can not be used in combination with other discounts. Please contact Education representative for complete details
Free Web-based training
- Receive your card to have web-based training for free, offered to the EMEA attendees of the
Free Certification Testing at IMSSTC**
- Validate your skills with an IBM Professional Certification. Attendees can take some of the available tests at no charge.
- ** Visit the Conference website to know more about the available tests and conditions.
Free Education Planning
- Success begins with having a plan. Building a custom Training plan helps to ensure that you and your team have the skills to maximize the value of your IBM software. Meet with one of our training experts to build a training plan that includes role-specific training and certification recommendations as well as cost saving strategies to get the most out of your training budget.
PS… I haven’t been to France yet, but plan to go this summer. Wish I were going to this conference, but I’m not. For those of you who do go, have a fun “geeky” vacation.
There are only a few shows remaining in the rest of this season’s collection of DB2Night Show episodes. Mark your calendar for these up coming events and take a look at previous shows that you may have missed. The education opportunity to you is huge.
#53 - Don't flip out! How to stop your query access plans from flopping! (aka DB2 HINTS!)
John Hornibrook, IBM STSM, Manager Query Optimization
Friday May 20: 11am ET, 90 minutes
Did you know you can "force" the DB2 LUW optimizer to choose a specific access strategy of your choosing? The secret is out...
Special guest John Hornibrook from the IBM Toronto Lab presented in Episode #52 where he talked about best practices for query tuning. In this show he’ll teach you how to exploit DB2 LUW Optimizer "hints", or, maybe more properly, how to tell the DB2 optimizer how to execute your queries.
Note that this show is scheduled for 90 minutes so that John can share all of his incredible presentation with you and have time for questions.
#z04 - What's new from the optimizer in DB2 10 for z/OS?
Terry Purcell, IBM SVL, SQL & Optimization
Monday May 23: 11am ET, 60 minutes
DB2 10 for z/OS is no exception to the goal of delivering incremental query optimization enhancements to the world’s most respected cost based optimizer. With skip-release migration supported, it is expected that many more customers may adopt DB2 10 in the coming year - so understanding the performance enhancements can be critical for those customers. Terry Purcell will share the insight uncovered from beta customer and early adopters, and provide the motivation for each enhancement including:
- “Safe” query optimization
- Improvements to complex OR and IN list processing
- RUNSTATS management and performance improvements
- And more!
#54 - DB2 9 LUW Core Engine Data Movement Utilities Overview with Oracle database comparisons
Burt Vialpando, Executive IT Specialist, IBM
Friday June 3 - 11am ET, 60 minutes
Special guest Burt Vialpando from IBM presented in Episode #22 which was the 15th most downloaded show in 2010. He talked about Comparing DB2 LUW and Oracle, Architectures and Administration. In this episode, Burt will give you an overview of each of the DB2 core engine data movement utilities: Load, Import, Export (with db2look), db2move, ADMIN_COPY_SCHEMA, ADMIN_MOVE_TABLE, db2relocatedb, restore from backup and split mirror. These will be compared to each other so that you can get a good idea of when to use and not to use each of these. To help round out the discussion, a comparison to the Oracle database core engine data movement utilities will be made to these DB2 utilities.
#z05 - B2 V10 Migration Planning and Early User Experiences
John Campbell, IBM Distinguished Engineer
Monday June 6: 11am ET, 60 minutes
In this episode, host Klaas Brant and guest John Campbell will introduce and discuss early experiences and lessons to be learned with DB2 10 for z/OS. It will provide quick hints on preparing for and executing the migration, performance expectations and opportunities, virtual storage constraint relief, some instrumentation changes, use of 1MB real storage frame size, use of hash access, value of rebind, etc. Key topics covered will include:
- Lessons learned
- Surprises and pitfalls
- Provide hints and tips
- Address some myths
- Provide additional planning information
- Provide usage guidelines
- Provide positioning on new enhancements
#55 - DB2 LUW Multi-Temperature Data Management
Kate Kurtz and IBM Smart Analytics Best Practices Team members
Friday June 17: 11am EDT, 60 minutes
Did you know that data has temperatures? Can data run a fever? What happens if your data catches a cold? Or rather, turns cold from hot? What can and should you do? What techniques are available for optimizing performance in databases where some data is more popular (hot) than other data?
In this episode of The DB2Night Show, various IBM experts will help us answer these challenging questions! Kate Kurtz along with team members from the IBM Smart Analytics Systems Best Practices team will share with us their expertise!
#56 Season #2 Finale! - Data Warehouse Performance Tuning!
Kate Kurtz and IBM Smart Analytics Best Practices Team members
Friday June 24: 11am ET, 60 minutes
Kate Kurtz and her IBM Smart Analytics Systems Best Practices team return again to share with us IBM recommendations and suggested best practices for optimizing performance of Data Warehouse Databases. If you're trying to make DPF or multi-partition databases run queries as fast as possible, then you should sign up for this show!
Hard to believe another season is over already! Thanks Scott Hayes and Klaas Brant for Entertaining, Informing, and best of all, EDUCATING us! We look forward to see what amazing ideas you come up with next season.
PS Click here for the recorded shows & commentary.
Coming up fast is the 3-day Information Management Technical Conference (IMTC India 2011) that is taking place in Bangalore, India. The conference starts Wednesday May 4 and goes until Friday May 6. If you’re in the region, you should attend for many reasons.
- This is a 3-day deep dive technical conference, specializing on the Information Management area.
- Choose from 58 technical sessions & 8 hands on Labs.
- Free certification: one free IBM certification exam per participant on IM brand only.
- Networking opportunities with peers, product and industry specialists, and like-minded professionals.
- Get your technical questions answered by experts.
There are four tracks that you can follow:
- Data Management
- ECM Enterprise Content Management (FileNet + DB2 CM)
- IP and S (Information Platform and Solutions - Datastage, MDM - Infosphere)
- Business Analytics and Optimisation
You can keep up to date with all the latest news by following the Training team on Facebook or Twitter.
To register and for full conference details, see the IMTC India 2011 web page.
See a previous blog I wrote about the resources that you can find in India that are related to Information Management.
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.
GU201: InfoSphere Guardium 8 Technical Training - New
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
- Database Administrators
- Access Management
- STAP and GIM
- Self Monitoring
- Determining requirements
- Group Builder
- Vulnerability Assessment
- Query and Report builder
- Compliance Workflow Automation
- Data Discovery
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.
Other courses you may wish to consider:
- GU200: IBM InfoSphere Guardium Technical 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.
The ITSO has been busy creating technical publications to help you deep your knowledge and hands on skills with IBM’s Information Management products. Here is a list of the Redbooks and Redpapers that have published in first three months of 2011:
Advanced Case Management with IBM Case Manager
Published 22 March 2011, last updated 26 March 2011, Rating: (based on 1 review)
This publication introduces IT architects and IT specialists to the case management concept, its benefits, and how it is different from traditional business process management or content management. In addition, this book introduces the IBM Case Manager product, designing a case management solution, setting up the appropriate environment, and building and deploying the solution. In addition, it serves as a practical guide for IT professionals who are responsible for designing, building, and deploying case management solutions.
Data Studio and DB2 for z/OS Stored Procedures
Published 15 March 2011
This IBM® Redpaper™ publication is devoted to tools that can be used for accelerating the development and debugging process, in particular to the stored procedure support provided by the latest and fastest evolving IBM product: Data Studio.
Information Server: Installation and Configuration Guide
Published 8 March 2011, Rating: (based on 1 review)
In this IBM® Redpaper™ publication we provide suggestions, hints and tips, directions, installation steps, checklists of prerequisites, and configuration information collected from a number of Information Server experts. It is intended to minimize the time required to successfully install and configure IBM Information Server.
IBM Smart Analytics System
Published 23 February 2011
This IBM Redbooks® publication introduces the architecture and components of the IBM Smart Analytics System family. We describe the installation and configuration of the IBM Smart Analytics System and show how to manage the systems effectively to deliver an enterprise class service.
Embedding IBM Informix
Published 17 February 2011
In this IBM® Redbooks® publication, we discuss and describe the capabilities for embedding Informix® into applications and software. We introduce the technological architecture and describe several of the functions and features that support Informix as a robust and powerful embeddable DBMS. Many of these features are unique in the industry today, enabling clients to create a business advantage.
IBM Optim Performance Manager for DB2 for Linux, UNIX, and Windows
Published 13 February 2011, last updated 17 February 2011
This IBM Redbooks® publication describes the architecture and components of Optim Performance Manager Extended Edition. We provide information for planning the deployment of Optim Performance Manager and detail steps for successful installation, activation, and configuration of Optim Performance Manager and the Extended Insight client.
Extremely pureXML in DB2 10 for z/OS
Published 28 January 2011, Rating: (based on 2 reviews)
In this IBM® Redbooks® publication, we document the steps for the implementation of a simple but meaningful XML application scenario. We have chosen to provide samples in COBOL and Java™ language. The purpose is to provide an easy path to follow to integrate the XML data type for the traditional DB2 for z/OS® user.
IBM Enterprise Content Management and IBM Information Archive: Providing the Complete Solution
Published 19 January 2011
This IBM Redpaper™ publication focuses on the benefit and technical details of the integration of ECM products and offering with the Information Archive device. We explain the need and concept behind the IBM Smart Archive strategy, provide an overview of the Information Archive device and ECM products and offerings, and discuss how integrating them can benefit an organization. The technical details that we provide include integrating the Information Archive device with the following ECM products and offerings:
-- IBM FileNet® P8
-- IBM Content Manager
-- IBM Content Manager OnDemand
IBM Scale Out Network Attached Storage: Architecture, Planning, and Implementation Basics
Published 1 January 2011, Rating: (based on 2 reviews)
In this IBM Redbooks® publication, we give you details of the hardware and software architecture that make up the SONAS appliance, along with configuration, sizing, and performance considerations. We provide information about the integration of the SONAS appliance into an existing network. We demonstrate the administration of the SONAS appliance through the GUI and CLI, as well as showing backup and availability scenarios. Using a quick start scenario, we take you through common SONAS administration tasks to familiarize you with the SONAS system.
DB2 10 for z/OS Technical Overview
Published 30 December 2010, last updated 10 March 2011, Rating: (based on 3 reviews)
This IBM Redbooks® publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating or skip migrating to DB2 10.
The following eBooks about key IBM Products are available at a 50% discount for the next two weeks, ending April 17. For all the details, click here. Note that the discount is automatic on these selected eBooks:
Manage and administer your WebSphere application server to create a reliable, secure, and scalable environment for running your applications
Build SOA-based flexible, economical, and efficient applications
Engineer a clear-cut strategy for achieving best-in-class results
Upgrade your system and embrace the exciting new features of the Lotus Notes and Domino 8.5.1 platform
Build scalable, high-performance software with IBM's data grid
Design, implement, and monitor a successful Q replication and Event Publishing project