IBM DB2 for i

DB2 for i is built into IBM i. Because of the tight integration between DB2 and IBM i, and the unique architecture of IBM i, many of the traditional database-specific administration requirements found on other DBMS's either aren't necessary with DB2 for i, or administered through IBM i facilities.

System i Navigator 
Administration of DB2 for i can be achieved through a component shipped with IBM i called IBM i Navigator (formerly IBM i Navigator). With IBM i Navigator, you can graphically work with DB2, including:

• Create and Work with DB2 objects (tables, indexes, views, user defined functions, etc.)
• Define Referential Integrity and Check constraints
• Reverse engineer SQL DDL from tables created with SQL or DDS (heritage database interface)
• Create and debug SQL Stored Procedures, Triggers, and Functions
• Manage database logging (Journaling)
• Analyze SQL and query performance with the On Demand Performance Center. This toolset includes Visual Explain (AVI, 4.7MB). SQL Performance Monitors, and SQL Plan Cache
• Use Database Navigator to easily view and work with database objects and their related objects (for example, easily view indexes built over a table).

• See Database Navigator in action (EXE, 11.8MB)
• Get Windows® Media Player

IBM offers several self guided learning opportunities, including a comprehensive course, Piloting DB2 for i with IBM i Navigator (registration required).

• Learn more

IBM InfoSphere Optim Data Growth Solution provides proven archiving capabilities, allowing users to segregate historical from current data and store it securely and cost-effectively.

IBM InfoSphere Optim Test Data Management and Data Masking Solution delivers powerful data transformation capabilities to mask personal information, so that you can use it safely for application testing.