How does DB2 for i compare to DB2 for Linux/Unix/Windows (LUW)?
All the DB2 family members (DB2 runs on over twenty platforms) share common attributes (like SQL Standard syntax support), but also differ in their optimization for the specific platform and operating environments, and differ in packaging and in some administrative areas. At any point in time, feature/function differences may exist as well, depending on delivery schedules and market requirements. SQL Syntax is very common across the DB2 products. To see more details about the common SQL supported by DB2, refer to resources page on the IBM Virtual Innovation Center for Hardware. Version/Release naming will differ because, as mentioned above, DB2 for i follows the IBM i version/release numbering scheme, and not the DB2 LUW version/release scheme (i.e., you cannot assume a comparison of version/release is a reflection on functional equivalency). For instance, in the above document detailing common SQL Syntax, V5R1 of DB2 for i is compared favorably to DB2 LUW V7, and V5R3 is mapped to DB2
