Skip to main content


developerWorks  >  Information Management  >

Porting to DB2 for Linux, UNIX, and Windows

Technical resources and roadmap

developerWorks
OverviewPorting stepsResources
 Step 1. Assessment
 Step 2. Planning the project
 Step 3. Education and training
 Step 4. Development environment
 Step 5. Users, groups, and permissions
 Step 6. Porting the database structure
 Step 7. Porting the database objects
 Step 8. Additional database components and products
 Step 9. Application modifications
 Step 10. Interface modifications
 Step 11. Data migration
 Step 12. Performance tuning
 Step 13. Maintenance strategy
 Step 14. Acceptance testing
 Step 15. Documentation
 Step 16. Packaging
 Step 17. Support
 

Step 13. Maintenance strategy

Checklist for database maintenance
  • Examine needs for maintaining performance
  • Establish and implement a REORG strategy
  • Establish and implement a RUNSTATS strategy
  • Establish and implement a REBIND strategy (if necessary)
  • Establish and implement a Backup/Recovery strategy
  • Establish and implement a High Availability-Disaster Recovery strategy
  • Test and refine all strategies as your application changes

The key to keeping a system performing well is to keep data fragmentation to a minimum and keep database statistics up-to-date. Based on lessons learned from the development and performance tuning steps, recommendations should be made on how to keep the database performing well. It is important that these details be documented.




Back to top


 logo

Document options

Document options requiring JavaScript are not displayed


More resources
Information for IBM customers
Information for IBM business partners
DB2 Migrate Now!
Software Migration Project Office
IBM Migration Toolkit
Porting to DB2 for i5/OS
IBM Information Management Community

Special offers
Optimize database apps and services with pureQuery
Webcast: IBM solidDB
Webcast: Replication and change data

More offers