FAQ - Frequently Asked Questions

Does BCV5|6 handle OBID translation?

Date added:
Wednesday, 08 April 2009
Hits:
671
Rating:
 
Vote for this:
Good  -  Bad

Answer

Yes. Each table has a unique ID, called the OBID. This ID uniquely identifies the table within the respective database. Each record of the internal DB2 data pages contains this OBID, to identify which table is related to which row. Because the OBID of source and target differ in most cases it is required to translate the OBIDs for every row from the source value to the target value. Otherwise the target DB2 would refuse to work with the copied tablespace. BCV5|6 implicitly translates the OBIDs from source to target. It automatically gathers the OBIDs of the source and target tables and uses this information during the copy process to change the respective fields within each row. 

 

Category