If you are new to relational databases, please refer to the list of suggested reading. Learning the basics will save you a great deal of time in the long run, and your database applications will run faster and be much more robust.
When extensive changes have been made to an Access database, or you are converting an existing application to DB2, the following guidelines are strongly recommended.
Perform a repair database operation. This can eliminate some rather cryptic errors that can occur when analyzing the database. (Tools | Database Utilities | Repair Database)
Perform an analysis of the database (use the Access “Tools | Analyze | Performance” menu item). Analyze all tables and queries. DB2 Performance can be greatly improved by creating indexes and relationships suggested by the Performance Analyzer.
ODBC linked tables are not updatable unless they are assigned a unique index or primary key. Scriptoria will automatically identify and optionally create primary keys.
Use the Case Sensitivity Assistant (Tools | Migration Tools I Case Sensitivity Assistant) to identify and resolve upper and lower case matching issues (with criteria in Access queries) that may result from the case insensitive (Access) versus case sensitive (DB2) architecture of Access and DB2.
Use the Linked Query Optimization Wizard (Tools | Migration Tools I Linked Query Optimization) to identify and optionally generate Access indexes that will improve post-migration performance.
Use the High Overhead Queries report to identify queries that may exhibit post-migration performance degradation.