Description

The bdbreconfig tool converts database tables to match the physical tables in the database with the new metadata defined in the definition data dictionary file. It can also analyze the differences between two database definitions and report the changes that are required to bring the database into a new state. You can use this to predict the required conversion time, spot potential performance bottlenecks, and gain insight into changes introduced by an upgrade procedure. For details, see the description of the -A (analyze mode) option.

For each table that must be converted, the bdbreconfig tool expects that these two files exist:

• A data dictionary file of that table, for example, dtfgld106.
• A data dictionary file of that table with a .new extension, for example dtgld106.new.

The bdbreconfig tool compares the two data dictionary files to determine what changes must be made to the existing table. Based on this comparison, and based on the capabilities of the database, the bdbreconfig tool will try to find an optimum method to convert the table.

After successful completion, the table definition matches with that of the new version of the data dictionary file. Therefore, to complete the conversion, the existing data dictionary file must be replaced with the new version. The bdbreconfig tool will not perform this procedure. Therefore you must perform this procedure manually.

Depending on the type of changes, and depending on the capabilities of the database, bdbreconfig will use a specific method to convert a table.