planetDB2 logo

Planet DB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.


October 30, 2014

Adam Gartenberg

Recap: Insight 2014 Day 3 General Session

I found the Day 3 general session of Insight 2014 to be quite interesting for a number of reasons. Captain Richard Phillip's first-hand account of his ordeal and rescue was fascinating, and Kevin...

(Read more)

Robert Catterall

DB2 for z/OS: Thoughts on Table Space and Index Page Size Selection

The other day I got a note, from a DB2 for z/OS DBA, in which I was asked for my thoughts regarding the selection of page size for a table space. I typed out what I hoped would be a useful response, and found myself thinking, as I sometimes do, "Hey -- I could turn this into a blog entry." And so I have. I'll start here by offering some guidelines on page size selection for table spaces, and then I'll shift to the index perspective on the matter. Table spaces A table space (or index) gets its...

(Read more)

October 28, 2014

Adam Gartenberg

When it comes to analytics, are you a spectator or a front runner?

Last week IBM's Institute for Business Value released their latest analytics study. The important takeaway this time around: The need for speed. ...

(Read more)

Adam Gartenberg

Recap: Insight 2014 Day 2 General Session

There were some great demos in today's Insight general session (and this technology is always better in live demos than pre-recorded ones, isn't it? I've included the rough time stamps should you...

(Read more)

Adam Gartenberg

Recap: Insight 2014 Day 1 General Session

I'm following the Insight Conference from home this year, but am going to still keep up with recaps of the general sessions, as I have done in past years. If you want to do the same, head on over to...

(Read more)

Triton Consulting

Managing Mainframe Costs in the Financial Services Sector

Over the past 25 years of working with Mainframes, one aspect has proved to be a constant challenge – Mainframe pricing.  Mainframe software charges are usually based on peak usage.   Whatever an organisations’ peak workload in a given month is … Continue reading →

(Read more)

Ember Crooks

Options to Encrypt Data at Rest in DB2

I thought it would be relatively easy to investigate encryption for our environment. I was wrong, was just plain confusing. This was not because encryption is complicated per se, but that a DBA...


October 27, 2014


October 25, 2014

ChannelDB2 Videos

DB2 Tips n Tricks Part 48 - How to Connect to Database in Single User Only Mode


How to Connect to Database in Single User Only Mode Solution: db2 connect to dbname in exclusive mode user/using Happy Learning & Sharing

October 24, 2014

DB2Night Replays

The DB2Night Show z52: DB2 Thread Reuse and RELEASE(DEALLOCATE)

Presented by: John Campbell Distinguished Engineer, IBM DB2 Development "The DB2Night Show z52: DB2 Thread Reuse and RELEASE(DEALLOCATE)" Replays available in WMV and M4V formats! 98% of our studio audience learned something! John did a deep dive into thread reuse, Release(Deallocate), and when to use it to maximum advantage. Watch the replay...

(Read more)

DB2 Guys

Inside IBM Insight 2014: See How Clients Are Revolutionizing Their Business With DB2

By Cassandra Desens IBM Software Group, Information Management   This will be my second year at Insight and I must say, it is my favorite time of the work year. As frenzied and busy as the planning is, the return on intangible investments is worth it. Ask anyone – after just a few short days […]

Susan Visser

IBM Champions @ IBM Insight

The best part of my job is that I get to work with IBM’s partners.  IBM calls them IBM Champions, but I call them “IBM’s Best Friends”!  I’ve met some pretty awesome people over the years, so conferences feel like family reunions to me as I get to connect with my friends in person.  When we’re not together in person, we keep in touch through email, social media, and often on live webinars. 

As a thank you to each and every one of them, I’m creating this post to promote the sessions that are taking place at IBM Insight that feature an IBM Champion:  the conference would not be the same without you!

Mike Biere, Rocket Software, Senior Product Specialist
IDZ-4919A: Expert Exchange:Best Practices with QMF 11 and DataQuant 2.1 - Analytics for Big Data, Mobile, and TSO

Wed Oct 29 ( 3:00 p.m.  4:00 p.m. )


David Birmingham, Brightlight Consulting, Sr Principal Consultant

IWA-4124A: Performance Tuning Tips for the IBM PureData System for Analytics, Powered by Netezza

Tue Oct 28 ( 11:15 a.m.  12:15 p.m. )

IWS-7042A: Expert Exchange: PureData Tips from an Insider - David Birmingham offers tips for design, tuning & monitoring

Tue Oct 28 ( 4:30 p.m.  5:45 p.m. )


Dan Luksetich, DanL Database Consulting,

IDX-5043A: Auditing DB2 Tables across Platforms

Tue Oct 28 ( 1:45 p.m.  2:45 p.m. )

IDX-5100A: Fun with SQL

Wed Oct 29 ( 4:30 p.m.  5:45 p.m. )


Kurt Struyf, suadasoft, senior consultant
IDZ-4166A: IBM DB2 for z/OS Fundamentals: What Everybody Expects You to Know

Tue Oct 28 ( 3:00 p.m.  4:00 p.m. )

IDX-5100A: Fun with SQL

Wed Oct 29 ( 4:30 p.m.  5:45 p.m. )


Fred Sobotka, FRS Consulting, Inc., Data Management Consultant

IDX-6811A: DB2 Time Travel Query Patterns for Integration, Monitoring and Profit

Mon Oct 27 ( 3:30 p.m.  4:30 p.m. )


Dave Beulke, Dave Beulke and Associates, President

IDX-4211A: SQL Performance for a Big Data, 22 Billion-Row Data Warehouse

Tue Oct 28 ( 11:15 a.m.  12:15 p.m. )


Dennis Fallis, Intel Corporation, Strategic Relationship Manager
EXP-7188A: Ideas for Implementing Big Data on Intel Architecture

Mon Oct 27 ( 2:00 p.m.  2:30 p.m. )


EXP-7189A: Intel and IBM Software: A Long History

Tue Oct 28 ( 2:00 p.m.  2:30 p.m. )


Kay Vandevanter, Boeing, Business Intelligence and Analytics Architect;
LCB-6535A: An Introduction to ACE: The Analytics Center of Excellence

Mon Oct 27 ( 10:15 a.m.  11:15 a.m. )

LCB-6931A: Analytics Center of Excellence: Bringing Together Skills, People, and Processes

Tue Oct 28 ( 2:00 p.m.  3:30 p.m. )


Brian Green, BlueCross BlueShield of Tennessee, Mgr., Business Intelligence & Performance Management;

LCB-6844A: Analytics Center of Excellence: Build an Analytics Strategy and Demonstrate Its Value

Tue Oct 28 ( 10:00 a.m.  11:30 a.m. )

LCB-6931A: Analytics Center of Excellence: Bringing Together Skills, People, and Processes

Tue Oct 28 ( 2:00 p.m.  3:30 p.m. )


Bryan Smith, Rocket Software, Vice President R&D, CTO;
ISA-7086A: Data Virtualization on System z

Mon Oct 27 ( 2:00 p.m.  3:00 p.m. )

IDX-7087A: Extending the Value of IBM DB2 Analytics Accelerator with Database Tools

Tue Oct 28 ( 1:45 p.m.  2:45 p.m. )


Laurence Leong, SugarCRM, Senior Director, Strategic Alliance Marketing

BBS-7156A: Analytic Techniques for Customer Relationship Management

Wed Oct 29 ( 3:00 p.m.  4:00 p.m. )


Vladimir Bacvanski, SciSpike, Founder

DEV-7199A: Monday dev@Insight Ignite Talks

Mon Oct 27 ( 7:15 p.m.  7:45 p.m. )

LCI-4914A: Simplify Data Security and Compliance for Big Data Using InfoSphere Guardium

Tue Oct 28 ( 2:00 p.m.  5:00 p.m. )


ISA-5832A: Big Data and NoSQL: Polyglot Persistence

Thu Oct 30 ( 1:45 p.m.  2:45 p.m. )


Brenda Boshoff, University of Toronto, Senior Database Administrator
IWS-5338B: Why the University of Toronto Loves BLU: Faster, Smaller, and Simpler in Only a Few Hours

Tue Oct 28 ( 10:00 a.m.  11:00 a.m. )


Andrew Juarez, Coca-Cola Bottling Co. Consolidated, Lead SAP Basis / DBA / Unix;
IWS-5729A: IBM BLU Acceleration: Adoption Guidelines and Lessons Learned at Coca-Cola Bottling Company

Mon Oct 27 ( 3:30 p.m.  4:30 p.m. )


Ken Shaffer, Aerodata, Inc. , DB2 LUW consultant
IDB-5185A: IBM DB2 Linux, UNIX and Windows Online Version Upgrades

Thu Oct 30 ( 10:00 a.m.  11:00 a.m. )


Vijay Sitaram, Medtronic, SAP Basis - DB2 Team Lead, Global Infrastructure and Applications Services
IDB-4397A: Medtronic Running SAP Optimized on IBM DB2

Thu Oct 30 ( 11:15 a.m.  12:15 p.m. )


Ellen Reys, Visa, Chief Systems Architect, Data Platform and Information Products

IDB-7191A: DB2 10 Yesterday, Today and Tomorrow: A Recipe to a Successful Upgrade of a Petabyte Scale Data Warehouse

Wed Oct 29 ( 10:00 a.m.  11:00 a.m. )


Jean-Marc Blaise, DELTA DB, IT Solutions Architect;
IDB-5617B: IBM DB2 Tools: Tips from an IBM Champion

Thu Oct 30 ( 8:15 a.m.  9:30 a.m. )


William Shipley, The Vanguard Group, Inc., Database Administrator

IDZ-6114A: Vanguard's Implementation Experiences with IBM DB2 Analytics Accelerator

Wed Oct 29 ( 10:00 a.m.  11:00 a.m. )


Frank Fillmore, The Fillmore Group, Inc., President

IDZ-6691B: IBM DB2 Analytics Accelerator Use Cases

Tue Oct 28 ( 10:00 a.m.  11:00 a.m. )


Robert Goodman, Florida Hospital, Sr DBA

IDZ-4574A: Converting Everything to Universal Table Spaces in IBM DB2 11

Wed Oct 29 ( 4:30 p.m.  5:45 p.m. )


Paul Murray, Westpac NZ Ltd, DBA for z/OS;

IDZ-6718A: The Power of IBM DB2 Is More than Tables, Indexes and Views

Thu Oct 30 ( 10:00 a.m.  11:00 a.m. )


Paul Walters, Navy Federal Credit Union, DB2 DBA;

IDZ-6146A: How Navy Federal Credit Union Implemented IBM DB2 V11 for z/OS

Tue Oct 28 ( 3:00 p.m.  4:00 p.m. )


Scott Hayes and Frank Velasco

EXP-7142A: Magic Show by Frank Velasco - Experience the DB2 LUW Performance Magic of DBI and Get 10X ROI

Mon Oct 27 ( 5:30 p.m.  6:00 p.m. )


Craig Mullins
IDZ-4917A: The Top Ten Things You Need to Know for IBM DB2 for z/OS

Wed Oct 29 ( 3:00 p.m.  4:00 p.m. )

I know there are people missing from this list!  If you are one of them, let me know.  I also know that many of the IBM Champions will be at the conference, but are not speaking.  Watch for a blog entry after the conference that mentions others!



Susan Visser

Women in Technology @ IBM Insight

Living in Canada and working for IBM my entire career, I feel blessed that I am treated as a person.  I’ve often had trouble relating to the events geared towards women because I have always been treated equally and without bias.  I know that I’m often naïve about things … so I do attend them to learn.  Many women have not had it as well as I have.  Many struggle to be taken seriously.  One year while attending a “Women in Technology” (WIT) event, I heard horrific stories from some of the most amazing women I’ve ever met about how poorly they were treated in the 60s, 70s, and even 80s.    

We can’t forget the courage these women have had to make life much easier today.  I salute all of you… and encourage men and women everywhere to stay the course.  Women make up at least 50% of the population and are essential for the harmony of the world.

This year at IBM Impact, I hope you can join us for the annual WIT event: Take charge of your career at #WIT panel. Learn how executives manage careers. Networking reception follows.

Details about the event:

Executive host Inhi Cho Suh, IBM Vice President Big Data, Integration & Governance, and our distinguished panel of executives share their insights and experiences in pro-actively managing their careers to achieve their personal and professional goals.

Following the panel discussion, you are invited to join the Women In Technology Networking Reception held at 6 PM in Bayview court, North Convention center.  Expand your network while enjoying refreshments, appetizers and a great view of Las Vegas.

Thanks to my colleagues Lalitha Krishnamoorthy and Lena Woolf for arranging this event!

An aside: not many men choose to attend this event. Some do and I’m glad.  If you are a man and would like to join, please do! 



Susan Visser

Performing Information Governance: A Step-by-step Guide to Making Information Governance Work

Just published by IBM Press:

Performing Information Governance: A Step-by-step Guide to Making Information Governance Work

By Anthony David Giordano

Unfortunately Tony will not be at IBM Insights this year, so you won’t get a chance to get him to sign his latest book.  His book, however, will be at the conference, and it looks like Tony has another best seller on his hands!

About the book:

Most enterprises recognize the crucial importance of effective information governance. However, few are satisfied with the value of their efforts to date. Information governance is difficult because it is a pervasive function, touching multiple processes, systems, and stakeholders. Fortunately, there are best practices that work. Now, a leading expert in the field offers a complete, step-by-step guide to successfully governing information in your organization.

Using case studies and hands-on activities, Anthony Giordano fully illuminates the “who, what, how, and when” of information governance. He explains how core governance components link with other enterprise information management disciplines, and provides workable “job descriptions” for each project participant.

Tony helps you successfully integrate key data stewardship processes as you develop large-scale applications and Master Data Management (MDM) environments. Then, once you’ve deployed an information asset, he shows how to consistently get reliable regulatory and financial information from it.

Performing Information Governance will be indispensable to CIOs and Chief Data Officers…data quality, metadata, and MDM specialists…anyone responsible for making information governance work.

Coverage Includes

  • Recognizing the hidden development and operational implications of information governance—and why it needs to be integrated in the broader organization
  • Integrating information governance activities with transactional processing, BI, MDM, and other enterprise information management functions
  • Establishing the information governance organization: defining roles, launching projects, and integrating with ongoing operations
  • Performing information governance in transactional projects, including those using agile methods and COTS products
  • Bringing stronger information governance to MDM: strategy, architecture, development, and beyond
  • Governing information throughout your BI or Big Data project lifecycle
  • Effectively performing ongoing information governance and data stewardship operational processes
  • Auditing and enforcing data quality management in the context of enterprise information management
  • Maintaining and evolving metadata management for maximum business value

About the Author

Tony Giordano is an experienced executive with more than 25 years of global professional services experience in the information management field in the areas of business intelligence, data warehousing, customer relationship management and program management. He has significant work experience in the financial services, life sciences, and automotive sectors. Mr. Giordano has functioned in various roles, including positions such as IBM Japan BAO Service Line Leader, Financial Services Practice Partner, and other consulting roles.. Tony has been dedicated to implementing customer-focused business analytics and information management platform that deliver business outcomes.

Watch this video I recorded with Tony about his last book.


Henrik Loeser

Apply DB2 skills to Hadoop by using Big SQL on Bluemix

IBM Analytics for Hadoop One of the many services offered on the Platform-as-a-Service (PaaS) IBM Bluemix is "IBM Analytics for Hadoop", basically InfoSphere BigInsights as cloud service. Because it...

(Read more)

October 23, 2014

DB2 Guys

Inside IBM Insight 2014: What You Need To Know About The dev@Insight Program

By Steven Miller Data Maestro, Talent & Skills Ecosystem Something new and interesting is taking place at IBM conferences this year.  Maybe you’ve noticed the dev@ events?  If not, let me tell you about dev@Insight. IBM Insight is a meeting of minds for data and anaytics. Big data and analytics are necessary to help your team […]

DB2 Guys

20 Quick Tips for Making the Most of Your Time at IBM Insight

By Melanie Stopfer Consulting Learning Specialist, Information Management, IBM If you’ve been to as many conferences as I have, you’ll know that there are certain habits that you can follow with so much going on around you.  Here are my 20 tips to make life easier for you at IBM Insight 2014 taking place October 26 – […]

Craig Mullins

DB2 SQL and Application Performance Tools

So far in this series of blog posts on DB2 performance tools, we have looked at system and database performance solutions. But perhaps the most important solution area involves monitoring and tuning application SQL statements. Why do I say that? Well, the cause of most performance problems is usually due to bad SQL and application code. Not every problem, of course, but maybe as much as 70 to 80...

(Read more)

Dave Beulke

INSIGHT DB2 Family Schedule: Too Many Choices, Too Little Time

The first IBM INSIGHT conference is next week. It was formerly known as the Information on Demand conference which was formerly known as the DB2 Technical Conference way back when it all started. Over the years the IDUG conferences around the world and the IBM conferences by their various names...

(Read more)

Susan Visser

IBM SPSS Modeler Cookbook

Another great book that will be featured at the IBM Insight conference this year is:

IBM SPSS Modeler Cookbook

By Keith McCormick, Scott Mutchler, Dean Abbott, Meta Brown, and Tom Khabaza

At IBM Insight:

If you are attending the IBM Insights Conference, you can purchase this book and have Keith and Scott sign your copy.  They will be available for signing on Monday, October 27 from 12:00 – 1:00 pm. 

About the book:

IBM SPSS Modeler is a data mining workbench that enables you to explore data, identify important relationships that you can leverage, and build predictive models quickly allowing your organization to base its decisions on hard data not hunches or guesswork.

IBM SPSS Modeler Cookbook takes you beyond the basics and shares the tips, the timesavers, and the workarounds that experts use to increase productivity and extract maximum value from data. The authors of this book are among the very best of these exponents, gurus who, in their brilliant and imaginative use of the tool, have pushed back the boundaries of applied analytics. By reading this book, you are learning from practitioners who have helped define the state of the art.

Follow the industry standard data mining process, gaining new skills at each stage, from loading data to integrating results into everyday business practices. Get a handle on the most efficient ways of extracting data from your own sources, preparing it for exploration and modeling. Master the best methods for building models that will perform well in the workplace.

Go beyond the basics and get the full power of your data mining workbench with this practical guide.


What you will learn from this book:

  • Use and understand the industry standard CRISP_DM process for data mining.
  • Assemble data simply, quickly, and correctly using the full power of extraction, transformation, and loading (ETL) tools.
  • Control the amount of time you spend organizing and formatting your data.
  • Develop predictive models that stand up to the demands of real-life applications.
  • Take your modeling to the next level beyond default settings and learn the tips that the experts use.
  • Learn why the best model is not always the most accurate one.
  • Master deployment techniques that put your discoveries to work making the most of your business’ most critical resources.


About the Authors:

Keith McCormick is an independent data mining consultant, trainer, and author. He has a wealth of consulting experience in statistics, predictive analytics, and data mining. For many years, he has worked in the SPSS community, first as an External Trainer and Consultant for SPSS Inc., and then in a similar role with IBM. He possesses a BS in Computer Science and Psychology from Worcester Polytechnic Institute. He is an expert in IBM's SPSS software suite including IBM SPSS Statistics, IBM SPSS Modeler, AMOS, and Text Mining. He is active as a moderator and participant in statistics groups online including LinkedIn's Statistics and Analytics Consultants Groups. He also blogs and reviews related books at


Scott Mutchler is the Vice President of Advanced Analytics Services. Scott has a long track record of delivering enterprise class Advanced Analytics solutions that drive massive customer value. Scott is equally proficient at building high-performing teams, where ever team member focuses on their individual strengths. This approach has resulted in a team this is passionate about Advanced Analytics. That passion for Advanced Analytics is reflected in every client engagement.



For a full list of the book signing events at the conference, see



DB2 Guys

Mastering the DB2 10.1 Certification Exam – Part 2: Security

It’s hard to argue against the benefits of becoming a DB2 Certified Professional. Aside from gaining a better understanding of DB2, it helps keep you up to date with the latest versions of the product.  It also gives you professional credentials that you can put on your resume to show that you know what you […]

ChannelDB2 Videos

DB2 Tips n Tricks Part 47 - How Force Applications All will shutdown Database


How Force Applications All will shutdown Database Solution: Explicitly Activate Database db2 activate db dbanme Happy Learning & Sharing

October 21, 2014

DB2 Guys

Roger Sanders: Previewing the DB2 Sessions at IBM Insight 2014

By Roger E. Sanders Senior Consultant, Software Engineer As a DB2 professional, there are two major events I look forward to each year – the International DB2 User’s Group North America conference and the IBM Insight (formerly Information On Demand) conference. And this year, I’m really excited about the IBM Insight 2014 conference. Why? Well, […]

Susan Visser

Certification Exams at IBM Insight

All registered customers and IBM Business Partners are eligible to take IBM Professional Certification tests at a substantially discounted rate of $30.  You can choose from the Business Analytics, Enterprise Content Management and Information Management portfolios. All other IBM Software Certification tests will be available at a rate of $100 per test.

Don't miss this great opportunity to save while validating your skills and demonstrating your proficiency with IBM Software!

For more information on the exams that are available, see Take exams at a reduced price while at IBM Insights.

What exams are new this year?

Why get certified?

I encourage you to read the following for expert opinions on the value of certification:

Study Materials:


New this year is the DB2 10.1 Fundamentals Certification Study Guide by Roger Sanders.  Roger was one of the developers who created the exam questions for Exam 610.  He provides information that makes it very easy for you to learn the content that you need to pass the exam, including a sample test that provides answers with explanations as to why the answer is correct.  Roger’s book will be available for sale at the IBM Insight Conference bookstore.  You can meet Roger in person and ask for study tips.  For more information, see: DB2 10.1 Fundamentals: Certification Study Guide.

A new book for the DBA 10.5 exam is about to publish, but unfortunately, it will not be ready in time for the conference.  You can pre-order the book here:  DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration: Certification Study Guide.  Authors Mohankumar Saraswatipura and Robert Collins have taken up where Roger Sanders left off and have updated this book with Roger’s excellent style and methods. 

Although not specifically a study guide, you’ll do well by learning the content in this book: DB2 Essentials: Understanding DB2 in a Big Data World (3rd Edition) by Raul F. Chong and Clara Liu.


There are free resources that you can use as well.  There is a series of developerWorks tutorials that have already helped many people pass these exams.  Here is a blog post from Norberto who created the first tutorial in the series: DB2 10.1 Certification Exam tutorial - Part 1: Planning

New guide for DB2 certification exam 311

If you are seeking the IBM Certified Database Administrator - DB2 10.5 DBA for LUW Upgrade from DB2 10.1, the new Preparation Guide for DB2 10.5 DBA for Linux, UNIX, and Windows Exam 311 can help you study for the IBM® DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam. This guide provides information from the DB2 for Linux, UNIX, and Windows documentation to cover all the exam objectives. This guide is for database administrators and other DB2 database users with intermediate to advanced administration skills who want to prepare for the exam.

New guide for DB2 certification exam 614

If you are seeking the IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and Windows, the new Preparation Guide for DB2 10.1 DBA for Linux, UNIX, and Windows Exam 614 can help you study for the DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam. This guide provides information from the DB2 for Linux, UNIX, and Windows documentation to cover all the exam objectives. This guide is for database administrators and other DB2 database users with intermediate to advanced administration skills who want to prepare for the exam.


The exam room is located in Surf F, MBCC South, Level 2.  Testing hours can be found at this website: Hours of Certification Testing.


Good luck on your exam!


DB2 Guys

DB2Night Show Recap – An In-Depth Look at DB2 10.5 “Cancun Release”

Fans of the DB2Night show were treated to a great program on Friday as IBM Champions Scott Hayes and Iqbal Goralwalla talked in-depth about DB2 10.5 “Cancun Release”. Iqbal has been testing the release since it was available and shared a wealth of knowledge with the audience, including topics on combining transactional workloads with analytics, […]

DB2 Guys

Must See at IBM Insight 2014 – DB2 HADR with pureScale in SAP Systems

By Ali Mehedi SAP DB2 Integration and Support We’re less than a week away from IBM Insight 2014, and although I’m not going to Vegas, I’m still very excited about some of the session offerings being taught by a few of my colleagues from the IBM and SAP worldwide joint development team. As you probably […]

Ember Crooks

Looking Forward to IBM Insight

IBM’s Insight conference (the conference formerly known as IOD or Information On Demand) is next week in Las Vegas. It’s a large conference that covers more than just DB2, but it is still...


Subscribe by email



planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.