Administration
DB2 for i is built into IBM i. Because of the tight integration between DB2 and i, and the unique architecture of 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 i5/OS called System i Navigator (formerly iSeries Navigator). With System 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. 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
IBM offers several self guided learning opportunities, including a comprehensive course, Piloting DB2 for i with System i Navigator (registration required).
Learn More
Centerfield Technology Toolset
Database administration tools from Centerfield complements System i Navigator function with additional features to manage, monitor, and tune DB2 for i workloads. Functions include:
- Information about completed queries can be collected and analyzed to determine trends across queries, heavy users, and frequently used tables and indexes
- Set resource usage policies at the system level and at the user level.
- Generate reports that assist in identifying trends in database usage such as which DB2 objects are being accessed, and which individuals or groups of users are the biggest contributors to the workload.
- Autonomic Database Assistant
|
