General DB2 resources

This section introduces links to the landing pages of important websites related to IBM DB2 data server products. These websites contain information about DB2 and in some cases search engines or related links to more product related information. Content from these sites can be found in other sections in this roadmap.

DB2 product overview

  • Product website This is the main IBM DB2 product website. It contains information about the latest release and new features and for information about value-added features. It describes the value added features that are available to extend the core features available with a DB2 edition.

  • DB2 trial download You will find many new and enhanced features to amplify performance gain, increase productivity, reduce storage needs, and optimize resource allocations in our latest release. Download DB2 for Linux, UNIX and Windows for a test drive.

DB2 documentation

  • DB2 data server product documentation This website contains links to the official online documentation for all of the currently supported versions of DB2 data server products.

  • DB2 for Linux, UNIX, and Windows developerWorks Domain This is the main DB2 product website in IBM developerWorks. The site contains articles and tutorials about DB2 written by IBM employees, consultants, customers, and other third parties. This is a great place to look for learning materials on highly specific subjects, that might not get coverage in the product documentation.

  • DB2 Best Practices Get practical guidance for the most common DB2 product configurations and use this knowledge to improve the value of your DB2 data servers.

  • IBM Information Management Books This is the main website for accessing books about IBM Information Management products. From this site you can find links to most of the available books and guides about DB2 published by IBM Press and other publishers.

  • IBM Redbooks: Information Management Domain IBM Redbooks are technical publications focus on subjects of interest to customers that are not readily addressed by product documentation. Subjects can include customer case studies, explanations of cross-product integration, and detailed examples of uses of features to solve business problems. This domain provides a view of the IBM Redbooks that pertain specifically to Information Management products.

DB2 community resources

  • DB2 IM forum This website lists the publicly available DB2 developerWorks forums. The forums are on-line discussion boards that are actively used by customers and IBM employees to post DB2 product-related questions and answers and to discuss DB2 product features. Use of the forums is free. The forums provide an alternative to official IBM support services that is appropriate for basic or straightforward questions.

  • IDUG: International DB2 User Group This is the main website for the International DB2 User Group (IDUG), an independent organization that is not directly affiliated with IBM that represents DB2 users and their interests and that hosts DB2 conferences internationally. This website has a repository of past conference presentations, proceedings, and other materials of technical interest to the DB2 user community that are unavailable from IBM websites.

Key DB2 features

This section contains information about key DB2 features, including the new technology to enhance your data management requirements. Information pertains to BLU, continuous availability, high availability, pureXML, workload management, analytics and more.

Grow with BLU

  • BLU highlights This developerWorks article discuses accelerated analytic processing, industry-leading compression, and reduced time-to-value that is DB2 Version 10.5.

  • DB2 with BLU Acceleration DB2 for Linux, UNIX and Windows Version 10.5 is now available. View product enhancements.

Continuous availability

  • Introduction to the IBM DB2 pureScale Feature In this topic and its related content provides an introduction to the design and benefits of the IBM DB2 pureScale Feature, why it is important and how it can help your business thrive.

High availability


Workload management

DB2 Warehouse

  • Introduction to the IBM DB2 Warehouse Feature This topic describes IBM DB2 Warehouse and what advanced analytics can do for your organization.

  • Data Warehousing and Analytics This website describes how DB2 warehouse can help you analyze data and explore information from different perspectives for a more extensive view of your business.

  • IBM DB2 + BLU: Three must-have capabilities for today's warehouse environment This white paper describes how IBM DB2 Warehouse with BLU Acceleration implements cost-effective ways for your business to handle rapidly growing volumes of data and extract more value in the form of action-oriented business insights.

  • SQL Warehousing tutorial This tutorial teaches the basics of SQL warehousing, including how to create a physical data model, data flows that transform your data, control flows that run your data flows, and how to deploy a data warehouse application.


This section contains links to information about downloading and installing DB2 products once you have selected which DB2 product and edition meets your needs.

  • System Prerequisites This topic provides links to information about the hardware and software requirements for software products, including DB2 data servers and clients and DB2 Connect.

  • IBM Software and Services for Purchase and Download From this website, you can purchase IBM software and services, including those related to DB2 products. To purchase and download an official and licensed version of DB2, click IBM Passport Advantage, and follow the instructions.

  • DB2 Express-C From this website, you can download DB2 Express-C, a no-charge version of DB2 Express Edition. DB2 Express-C offers the same core data features as DB2 Express Edition, including a solid base on which to build and deploy applications.


This section contains links to content pertaining to upgrading DB2 products to the latest release.

  • Upgrading to DB2 10.5 The upgrade documentation contains all of the details that you need to know to upgrade your DB2 environment to DB2 10.5 including information about upgrading DB2 data servers, clients, and applications. The details also include information that you must be aware to create your upgrade plan such as changes in behavior and new features that affect the upgrade.

  • DB2 10.1 Upgrading Roadmap This roadmap includes additional resources that you can use to plan the upgrade of your DB2 environment to DB2 10.1. The roadmap provides links to the DB2 Information Center topics as well as other articles and education resources. The troubleshooting section provides details about known problems and issues with the upgrade.

  • DB2 upgrade portal This portal provides link to all upgrade roadmaps available for DB2 database products, DB2 products, and products that access DB2 databases. You can find information to upgrade to earlier releases or complex environments that include DB2 databases


This section contains links to information about administering and maintaining a DB2 database server and client.


  • Database administration This topic introduces the section on database administration in the DB2 10.5 Information Center.

  • Database administration The database manager creates and maintains two sets of catalog views that are defined on top of the base system catalog tables. Applications should be written to these SYSCAT and SYSSTAT views.

Administrative interfaces

  • IBM Optim Integrated Data Management This website describes the features of IBM Optim, a graphical user interface (GUI) tool that supports developing SQL statements, developing database objects including stored procedures, running SQL statements, and administering databases

  • Administrative SQL routines and views This topic introduces the section on SQL routines and views in the DB2 Information Center. You can use the routines and views described here to access information about DB2 database environments, database manager configurations, database configurations, database objects, security settings, and other items that you can use to make administrative decisions about a system or to update database system settings.

  • Commands This topic introduces the section on commands in the DB2 Information Center. It begins with an introduction to the DB2 Command Line Processor interface from which DB2 commands and system commands can be issued to administer DB2 database managers and databases. The commands are then listed in alphabetical order.

  • Administrative APIs This topic introduces the section on administrative APIs in the DB2 Information Center and explains how the Administrative API documentation is organized. You can use the administrative APIs to administer DB2 data servers from within a program. Generally speaking, you can call the administrative APIs from C, C++, and Java applications. In some cases, you can call the APIs from COBOL applications.

Developing applications

This section contains links to content pertaining to the development of database applications and SQL statements.

Application development

  • Application development with DB2 10.5 This is the main product website about application development with DB2 10.5. This site has content about DB2 application development features and links to more detailed information about supported application programming interfaces and tools.

  • Application development with DB2 This article provides an overview of Java, .NET, and open source application development with DB2 products. It outlines the benefits of developing database applications that work with DB2 9.5 and describes some of the features that are available that facilitate programming applications for developers. This is a good article to read if you are considering using DB2 for database applications.

  • Application development This topic introduces the section on application development in the DB2 10.5 Information Center. This section contains information about supported elements in the application development environment as well as information on how to program database applications using each of the supported APIs.

Application development tools

  • Supported database application development tools This topic lists the supported integrated development environments and other development tools that facilitate DB2 database application development.

  • Download IBM Data Studio From this website you can download IBM Data Studio. Documentation about how to use IBM Data Studio is included with the tool. This website requires the use of an IBM user ID and password; you will be prompted to create them if you don't already have them.

Developing Java applications

Developing .NET applications

Developing RDF, PHP, Perl, Python and Ruby applications

  • RDF application development DB2 software now supports Resource Description Framework (RDF) to model information using URIs. Link and share structured and semi-structured data across different applications by using this simple model.

  • Perl application development This topic introduces the section on Perl application development in the DB2 Information Center.

  • PHP application development This topic introduces the section on PHP application development in the DB2 Information Center.

  • Python application development This topic introduces the section on Python application development in the DB2 Information Center.

  • Use DB2 native XML with PHP This article explains how to work with XML data in PHP applications. It contains several useful examples.

  • Developing PHP Applications for IBM Data Servers This IBM Redbooks article explains how to work with XML data in PHP applications. It provides an in-depth analysis of XML and PHP support that is presented with multiple examples.

Developing SQL and SQL PL statements

  • SQL statements This topic introduces the section on supported SQL statements in the DB2 Information Center.

  • Built-in functions This topic introduces the section on built-in functions in the DB2 Information Center.

  • Database objects This topic introduces the section on database objects in the DB2 Information Center. You can create, modify, and drop database objects using SQL statements. This section also contains information about the design, behavior, and use of database objects.

  • SQL routines This topic introduces the section on SQL routines in the DB2 Information Center. This section contains information about the SQL Procedural Language (SQL PL) and its use within SQL routines and other contexts.

  • DB2 SQL PL Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS, Second Edition From this website you can find a link to information about this book which is highly recommended for learning about and using SQL PL in SQL procedures, triggers, and applications. The structure of this book provides an excellent introduction to each of the language elements which are gradually incorporated into the accompanying set of examples.

Enabling applications to use DB2

This section contains links to information about moving to a DB2 data server from a competitor database vendor's product.

  • Migrate now to DB2 products! This website provides information about the available professional services that can be purchased to port a data server system to IBM products. The information is primarily intended for independent service vendors (ISVs) that embed DB2 within other solutions.


This section contains links to information about securing DB2 data server environments.

Troubleshooting and support

This section contains links to information about troubleshooting problems within a DB2 data server environment. It includes links related to accessing support and services from IBM and independent problem determination tools and techniques.

  • DB2 product support This is the main DB2 product support website on which you will find links to most support resources including to electronic problem reporting tools for opening a service request.

  • Troubleshooting tools and techniques To help you understand, isolate, and resolve problems with your DB2 software, the troubleshooting and support information contains instructions for using problem determination resources that are provided with DB2 products.

  • The db2pd tool This article introduces the db2pd tool for monitoring and administering DB2 databases and instances for the purpose of problem determination, troubleshooting problems, and tuning performance.


This section contains information about how prepare for industry recognized DB2 data server certification exams.

  • Information Management Training This is the main Information Management website for education and training.

  • Information Management Certification Roadmaps From this website, you can download a DB2 certification roadmap, which highlights DB2 user roles, certifications associated with these roles, the order in which you should pursue the certifications, and the prerequisites for each exam.

  • DB2 Certification Tutorials This website provides links to free tutorials that you can use when preparing for DB2 certification exams. The tutorials are divided into sections that cover the major concepts that you must understand to do the exams. These tutorials provide a solid base for preparing you for the exams; however, you should not rely on these tutorials alone.

  • DB2 Certification Study Guides This website provides links to the recommended certification guides that you can purchase to prepare for DB2 certification exams. The DB2 9 Certification Guides by Roger E. Sanders are strongly recommended. These certification guides provide a solid preparation for the exams and are unique in that they include a rich selection of questions and answers.

  • Assessment DB2 certification exams This website provides access to assessment exams that you can use when preparing for DB2 certification exams. The exams provide questions similar to those in the official certification exams.