Db2 version 9 to Db2 version 11 Database conversion

[saikrishna7978]

We are trying to migrate from the databases in Hopex Db2 version 9 to Db2 version 11. (Hopex V1R3)
Unfortunately this conversion to a DB2 V11 database in Hopex was not all smooth sailing.  

Once the change to V11 was completed, We then noted that all SQL Blocks had been deleted within that
database - this for all Datagroups, Indexes and Tables. This will obviously be quite a big problem for us
when we update our models to DB2 V11(We observed that the sql blocks are still related to V9.).

Is there a simple process or any procedure available to do this.

[jhorber · Accepted solution]

Hello saikrishna7978

I assume that you

• Use the product MEGA Database
• Have specified databases at physical level (SQL Clause)
• Have switched Target DBMS from DB2 Version 9 to DB2 version 11

 When switching Target DBMS, a warning is displayed such as

'The admendment of the target DBMS can generate a incompatibility of physical parameters. We strongly advise that you run the regulation 'Database Physical Regulation' to indicate if your data are valid.

Changing Target DBMS when SQL Clause have been specified has impacts.

As each SQL Clause object has a SQL Clause type and each SQL Clause type  is related to a Target DBMS a reprocessing of data is required.  There is no standard feature to help this. You need to analyse the data and reprocess them manually.