If you're a DBA or database developer currently working with Oracle or another relational database management system, learn how easy it is to get trained and certified for IBM® DB2® for Linux®, UNIX®, and Windows®. Features introduced in DB2 9.7 make it very easy to reuse your PL/SQL knowledge since DB2 has out-of-the-box support for Oracle's SQL and PL/SQL dialects. DB2 9.7 makes it easy to move applications, reduces enablement costs, and brings a radically lower total cost of ownership.
Expand your skills portfolio, or extend your DBMS vendor support to include DB2. You'll find that you're already almost there.
(A downloadable version of this e-kit is available in the Downloads section.)
- IBM DB2 Workshop for Oracle Professionals (in-person version and self-paced version)
The IBM DB2 Workshop for Database Professionals is a no-charge technical, hands-on session designed to help you quickly and easily extend your existing skills to IBM DB2 for Linux, UNIX, and Windows. The workshop assumes you have experience with relational database systems and PL/SQL technology. It teaches the differences and advantages of IBM DB2, comparing DB2 to the technologies with which you are already familiar. This course is offered as an in-person learning workshop, which is the recommended way to complete the class so you can interact with others and also take advantage of free certification testing. A self-paced version of this workshop is also available to provide increased flexibility and an opportunity to learn on your own schedule. The lectures and labs are taken from the in-person workshop with recordings by the instructors. The self-paced version does not include certification testing. See the current in-person workshop schedule or access the self-paced version of the workshop.
- IBM DB2 Customer Video: DB2 Is Easy to
Hear from several different DB2 practitioners as to why they found DB2 easy to learn and use in this short video clip.
- DB2 10: Run Oracle applications on DB2 for Linux, UNIX, and
Get a high-level overview of what Oracle compatibility means in DB2. Whether you want to switch your custom application to DB2 or extend your DBMS vendor support to DB2, now is your time.
- What's new in DB2 10 for LUW
Find out what's new in DB2 10 for Linux, UNIX, and Windows, including additional SQL compatibility enhancements, adaptive compression, multi-temperature data management, continuous data ingest, and much more.
Download PDF (199KB)
- Optimize storage with deep compression in DB2 10
Use deep compression to minimize storage space and improve database performance.
Download PDF (684KB)
- Managing time in DB2 with temporal consistency
Enforce time-based referential integrity.
Download PDF (557KB)
- DB2 Data Movement Tool
Get an introduction to a very simple and powerful tool that enables applications from Oracle to be run on DB2 10 for Linux, UNIX, and Windows. You can also use the tool to move data from various other database management systems to DB2 for Linux, UNIX, and Windows and DB2 for z/OS.
Download PDF (499KB)
- Created global temporary tables
Understand the capabilities of created global temporary tables (CGTTs). Learn about the definition, syntax, specifics, advantages, and limitations of created global temporary tables, and how they are different from declared global temporary tables (available in previous versions of DB2).
Download PDF (37KB)
- Using PL/SQL anonymous blocks in DB2 9.7
Understand PL/SQL anonymous blocks, a feature that enables PL/SQL application developers to test, troubleshoot, and prototype new procedural code, simulate application runs, and dynamically build complex ad-hoc queries and reports.
Download PDF (33KB)
- Autonomous transactions
Get an overview of autonomous transactions, and follow an example that illustrates what an autonomous transaction is and how to create one.
Download PDF (29KB)
- Online schema change
Learn about the new enhancements to DB2 9.7 that enable you to make online changes to the database schema so that you can keep objects fully accessible to the database users during the modification.
Download PDF (305KB)
- Best practices for DB2 for Linux, UNIX, and
Discover the best practices for DB2 for Linux, UNIX, and Windows. With these papers, get practical guidance for the most common DB2 9 product configurations, and use this knowledge to improve the value of your DB2 data servers.
- Distributed DBA: Creating and using partitioned tables (IBM
Data Management Magazine)
Get an overview of why, where, when, and how to partition tables in DB2 for Linux, UNIX, and Windows.
Download PDF (42KB)
- CLPPLUS: IBM DB2's new command line processor (Database
Learn about the options available in DB2's new CLPPLUS command line processor that you can use to connect to databases and to define, edit, and run statements, scripts, and commands.
- Generate formatted reports for IBM data servers using CLP
See how easy it is to generate reports from the new command line tool introduced in DB2 9.7—CLPPLUS. Follow examples to get started with the available report formatting options.
Download PDF (123KB)
- What is DB2 pureScale? (IBM Data Management
Primarily aimed at online transaction processing (OLTP) clusters, IBM DB2 pureScale is a new feature that provides scaleout active-active services for IBM DB2 running on AIX on Power Systems servers (and now SUSE Linux on IBM System x). In this article, understand the basics of the DB2 pureScale technology.
Download PDF (47KB)
- Native PL/SQL Support
This demo showcases native support for PL/SQL in DB2 9.7, which makes it easy to enable Oracle applications, procedures, packages, and more to DB2.
This demo shows the new Command Line Processor, CLP Plus, in DB2 9.7. CLP Plus makes it easy to edit and execute SQL statements, scripts, reports, procedures, functions, and more. It also supports scripts written for Oracle SQL*Plus.
- DB2 pureScale: Scalability
This video highlights how easily and instantly you can scale your workloads by simply adding a member to the DB2 pureScale cluster. It also shows how quickly DB2 pureScale recovers in case of a member failure.
- IBM DB2 Fundamentals for Oracle Professionals Knowledge
Follow this knowledge path step-by-step to quickly learn and use DB2 and to understand PL/SQL and other compatibility features. The primary audience is Oracle professionals who want to extend existing skills to DB2.
- Oracle to
DB2 conversion guide: Compatibility made easy
Understand new DB2 Oracle Database compatibility features, best practices for moving to DB2, and how to handle some common scenarios.
- MySQL to
DB2 conversion guide
Learn how to convert your database system from MySQL to DB2 on Linux, and see the steps that are involved in enabling the applications to use DB2 instead of MySQL.
Availability and Disaster Recovery Options for DB2 on Linux, UNIX,
This publication describes DB2's high availability functions and features, focusing on High Availability Disaster Recovery (HADR) in the OLTP environment. (PDF, 8.6MB)
Data Management Magazine
The content of this magazine focuses on the range of IBM data management products. The monthly publication is available online for your convenience, and contains the latest news, trends, tips, and other information.
- Getting Started with DB2 Application Development (IBM, October
This free eBook shows you how easy it is to get started on DB2 application development, and includes topics such as using DB2 Express-C, writing SQL statements, working with open source tools and more.
- Oracle and DB2 - An Architectural Comparison (MyMeetings Conferencing): Many database professionals and DBAs often ask how DB2 and Oracle compare architecturally, that is, how they are different and similar at their core. They also ask what are the equivalent concepts, names, and commands in the other database system. This free webinar will answer those questions. (31 Mar 2011)
- Enabling applications from Oracle to DB2 the easy way (channelDB2): Join experts from the DB2 labs to learn more about what Oracle compatibility means in DB2. Hear their firsthand Oracle to DB2 9.7 porting/enablement experiences.
- International DB2 Users Group: An independent, user-run organization that supports and strengthens the information services community by providing education and services designed to promote the effective use of the DB2 family of products.
- DB2 Database Professionals community: Join the DB2 discussion community on My developerWorks and see what your peers with multi-vendor database experience have to say about IBM DB2.
- Information Management community: Get involved in the Information Management community by participating in the developerWorks blogs, forums, and wikis.
- Getting started with DB2 LUW: Compiled for those less experienced with IBM DB2, this page is designed to help you get started and takes about two hours to complete.
- DB2 Tech Talk Series: Provides a wealth of information on a variety of DB2 and related tools and topics using skill-building sessions with presenters, often from the DB2 labs.
- Information Management tools with open source: Learn how to use PHP and other open source tools with DB2 and other IBM products.
- IBM Information Management products and XML page: Find information about how DB2 and other IBM products support XML technology.
- New to XML: Intended as a quick learning tool, this page contains ten questions and answers about the XML technology.
Once you have completed the above material designed to help you leverage existing database skills and PL/SQL knowledge, the following articles can help you learn more and get "hands-on" with IBM DB2.
- Deploy IBM DB2 pureScale feature on IBM Power Systems
This article describes different deployment methods of the DB2 pureScale feature on IBM Power Systems and how the hardware pieces come together to create a pureScale cluster.
- Unleashing the value of solid-state drives for DB2 workloads
(IBM Data Management Magazine)
Learn how to leverage IBM DB2 software to make the most of low-latency solid state drives.
Download PDF (95KB)
- Six tips for optimizing a native XML database
Native XML databases are becoming an increasingly important part of search applications and services, with the requirement for efficient search through a large volume of semi-structured data. See how XQuery can help improve response times and help cut development time.
Download PDF (55KB)
- Introduction to XML Querying with DB2 pureXML
Learn how to run queries that retrieve XML data from DB2 using the pureXML capabilities in IBM Optim Development Studio.
- Writing XQuery and SQL/XML queries for DB2 pureXML
This article provides syntax references and examples for common types of queries for XML data in DB2.
Download PDF (207KB)
- Get off to a fast start with DB2 9 pureXML
Leverage this series of articles to learn about pureXML for DB2.
- IBM DB2 Express-C (no charge): Download the free IBM DB2 Express-C community edition, which can be used as part of a production system, embedded and distributed in applications, or simply used for development purposes.
- Trial: DB2 for Linux, UNIX, and Windows: Download this trial software to see for yourself how to simplify administration, lower storage costs, improve performance, and more.
- IBM Data Studio (no charge): Download this integrated, modular environment for productive administration of DB2 for Linux, UNIX, and Windows that also provides collaborative database development tools for Informix, Oracle, and Sybase databases.