FAQ - Frequently Asked Questions

Yes. DB2 version 9 introduced a new internal row format. Although DSN1COPY is not able to copy a tablespace that has a different row format in source and target, BCV5|6 is able to convert the row format on the fly during the copy process.

DB2 version 9 also introduced another “restriction” that is a pain for many users that use simple tablespaces, because DB2 V9 does not support simple tablespace any more. Each tablespace you create in V9 is either segmented, partitioned or universal, which is a combination of segmented and partitioned. This makes it very difficult to copy your old simple tablespaces from V8 to V9 in a fast way. Only UNLOAD/LOAD would handle such a situation. BCV5|6 also covers this restriction by converting all simple tablespaces from simple to segmented on the fly during the copy process. There is no manual effort for the user and no performance overhead like with UNLOAD/LOAD.