The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 for Linux, UNIX, and Windows

IBM DB2, IBM's relational database management system, provides the foundation of information on demand.

Snapshot monitoring administrative views on DB2 version 10.1 for Linux, UNIX, and Windows

Use Snapshot monitoring views to access snapshot data from SQL-based appliations, a DB2 command line, or a command script to access your data for all database partitions of a connected database. More >

Featured content

13 Jun 2013 — Show descriptions | Hide descriptions

Secure Sockets Layer (SSL) support in DB2 for Linux, UNIX, and Windows
Configure SSL protocol and use the test case verification program in this article to protect your data as it moves through a network.
DB2 10.x certification: Everything you need to know
Learn how the IBM DB2 certification process works, how tests are developed, and whether getting certified is right for you. Review the many resources included in this article to help you in every phase of the certification process.
Backup and restore procedures for the DB2 instance shared directory in a DB2 pureScale environment
Use the procedures described in this article to restore a pureScale instance shared directory in a case where some or all files in that directory have become unavailable or unusable.
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.
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.
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.