Skip to main content


developerWorks  >  Information Management  >  Products  >

IBM DB2 for i

developerWorks
IBM DB2 for i is an advanced, 64-bit relational database management system that supports a broad range of applications at a lower cost of ownership due to its unique autonomic computing (self-managing) features on System i.

Updated 06 Aug 2009

Using common connections with Data Studio Developer
Using common connections with Data Studio Developer
See how Data Studio Developer 2.1 gives you simple and efficient ways to manage database connections, so you can easily store and retrieve connection parameters for multiple databases.  More

Search technical library
All articles
All tutorials and online courses

For a comprehensive selection of troubleshooting documents, search the IBM technical support knowledge base.

Product information
DB2 for i home page
DB2 for i key benefits
 Related products:
IBM DB2 XML Extender
DB2 Connect Unlimited Edition for iSeries
IBM DB2 Web Query for System i
DB2 EveryPlace
DB2 DataPropagator
IBM DB2 Query Manager and SQL Development Kit
DB2 9 for Linux, UNIX, Windows
IBM System i Navigator
Downloads, CDs, DVDs
Select a download:
IBM Rational Data Architect
JTOpen Type-4 JDBC Driver
DB2 9 Developer Workbench
Journal Planning and Analysis Tools
IBM Migration Toolkit
DB2 for i5/OS and System i Fixes
Learning resources
Online DB2 for i Manuals
DB2 for i Redbooks
DB2 for i Porting Guides
DB2 for i Performance Workshop
DB2 for i Training
Role-Based Skills Roadmaps
System i Technical Conferences
Reference tables: Common SQL features for developers of portable DB2 apps
Support
DB2 for i Group PTF (fixpack)
Troubleshoot DB2 for i
DB2 for i Software Knowledge Base
Technical Support Database
System i APARs
ISV Resources
Community
DB2 Web Query for i wiki
DB2 Web Query for i community
DB2 for i developerWorks forum
COMMON User Group
iSociety Community
iSeries Community Forums
About dW  |  dW newsletter  |  Build custom feeds |  Submit content


 logo

Spotlight
Are you a Data Champion? IBM honors exceptional contributions to the Data Management community
DB2 for i SQL Performance Workshops
Announcing DB2 for i5/OS V6 R1

Latest content
Use SQL descriptors to extend DB2 for i database applications
Learn how to use SQL descriptors and their advantages, and compare SQLDA and SQL descriptor support using two simple ILE C programs.
IBM DB2 for i 6.1 -- Sophistication simplified
Discover the new, sophisticated technology of DB2 for i 6.1 that still maintains its easy-to-use nature, providing a great foundation to take your business solutions to new levels.
Managing DB2 for i5/OS schemas and journals
Many System i developers are starting to use SQL to create database objects instead of the proprietary non-SQL interfaces. This article shows you how to use a schema with DB2 for i5/OS to group related articles.
Simplify DB2 for i5/OS Index Advice
See how to use the new index advisor condensing feature. Discover how it can be accessed from the iSeries Navigator graphical interface or with a cusomer user query.
Use PHP scripts to access DB2 for iSeries data with Zend Core for i5/OS
Learn about PHP database application development on i5/OS using the Zend Core for i5/OS product. Install Zend Core, and deploy and run a PHP script to access data stored in a DB2 for iSeries database.
DB2 for iSeries cursor sensitivity enhancements
Learn what cursor sensitivity is and how it's programmatically controlled on DB2 for iSeries. In addition, the article covers the performance impacts of using different cursor sensitivity settings.
Score optimization goals with SQL performance on DB2 for i5/OS
Implement the new performance tuning enhancement in the SQL Call Level Interface. Leverage the iSeries Navigator's Performance Monitor feature to analyze any query's optimization goal.
DB2 UDB for iSeries Long and Short Identifiers
Customize your long and short identifiers to implement DB2 UDB. Get tips to help you integrate your application with existing iSeries commands, utilities, and applications.
More content

Editor's picks
Pinpointing problematic SQL with System i Navigator
Tuning DB2 Concurrency for Websphere Applications
The Ins and Outs of XML and DB2 for i5/OS
Indexing and Statistics Strategy for DB2 for i5/OS

Special offers
Rate and  Review Rational products
DB2 pureScale Unlimited capacity for your data
WebSphere Application Server Hypervisor trial

More offers