DB2 family

The IBM DB2® family provides the foundation of information on demand. It's designed to meet your business needs whether large or small.

Online DB2 for z/OS migration

Get hints and tips to make your online migration successful. Discover how the DB2 migration process has been designed specifically to allow the business application set to continue to run while you migrate. More >

Featured content

16 May 2013 — Show descriptions | Hide descriptions

Optim Query Tuner: Capture and tune DB2 z/OS SQL statements using a user-defined SQL repository
Create query workloads directly from your own SQL repository, without the overhead of archiving or staging your workload data. Leverage the Query Tuner user interface to define dynamic and static SQL statement filters, and tune the saved workload without implementing your own client.
DB2 10: Run Oracle applications on DB2 10 for Linux, UNIX, and Windows
Get the latest DB2 10.5 capabilities in this article update, including a high-level overview of what Oracle compatibility means in DB2, and whether to switch your custom application to DB2 or extend your DBMS vendor support to DB2.
Restrict database connections using the CONNECT_PROC database configuration parameter in DB2
Protect data access using this simple technique that allows end users in DB2 for Linux, UNIX, and Windows to connect to the database only from a specific set of hosts or IP addresses. This article gives a practical example.
Get the most out of DB2 optimizer: Leveraging statistical views to improve query execution performance
Leverage statistical views to provide DB2 optimizer with information to accurately model complex relationships to choose an optimal query access plan. Use examples to identify complex relationships and create statistical views to compute more accurate cardinality estimates.
Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 2: Modifying an existing data model
In Part 2 of this article series, use InfoSphere Data Architect 8.5 to modify an existing data model to incorporate changes in requirements for the created global temorary table.
What's new in DB2 10.5 for Linux, UNIX, and Windows
Get the key features and enhancements in IBM DB2 10.5 for Linux, UNIX, and Windows releasing in June. The new features address business needs like cost reduction, application performance, productivity, and reliability.
Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 1: Getting Started
Leverage InfoSphere Data Architect to create a physical data model with CGTT (created global temporary tables) and then generate a DDL with CGTT-specific syntax that you can run on a database server.
DB2 pureScale Feature: Workload balancing, automatic client reroute, and client affinities concepts and administration
Keep your distributed database system available 24/7, reduce the risk and cost related to business growth, and scale the database solution with DB2 pureScale Feature clustering technology.
Updated: Verify DB2 Net Search Extender indexes using the NSE Index Verification tool
Get the latest, updated information on how to use the newest version of the NSE Index Verification tool to ensure the validity of indexes being use for text searches in DB2 for Linux, UNIX, and Windows.