DB2 Universal Database™ for iSeries™ (DB2® UDB for iSeries) shares characteristics with many other DB2 implementations. But if you have just migrated to the System i™ product, you might wonder how DB2 UDB for iSeries works differently on the system and what advantages the system brings to database development.
The System i product as a database platform has various strengths. This topic collection describes how to assess which data access methods make most sense for your organization and how to build a rough framework for developing and maintaining your database implementation.
You can also explore other database information using the main navigation tree.
By using the code examples, you agree to the terms of the Code license and disclaimer information.
- What's new for V5R4
This topic highlights changes to the IBM® iSeries Navigator database functions for V5R4.
- Printable PDF
Use this to view and print a PDF of this information.
- DB2 Universal Database for iSeries
DB2 Universal Database for iSeries is the relational database manager that is fully integrated on your System i product. Because it is integrated on the system, DB2 UDB for iSeries is easy to use and manage.
- Terminology: SQL versus traditional file access
DB2 UDB for iSeries provides two access methods for manipulating database tables and data: SQL and system file access methods. These access methods use different words to describe some similar concepts.
- Getting started with iSeries Navigator
iSeries Navigator is a graphical interface that you can use to perform many of your common administrative database operations. Most of the iSeries Navigator operations are based on SQL, but you do not need to fully understand SQL to perform them.
- iSeries Navigator database tasks
You can perform many database tasks with iSeries Navigator, including creating, modifying, and deleting various database objects.
- Getting started with SQL
SQL is a standardized language for defining and manipulating data in a relational database. You can create and work with schemas, tables, and views by using SQL statements in interactive SQL directly.