Question about database upgrade from 5.5 to 7.0

HCL Connections Connections Forum
,
1

Hello all ,

I've a customer that needs to update from 5.5 to 7.0.

Considering a lot of things are involved , included old operating system out of support , I'm doing a test environment where test the migration and now I'm having issue with database upgrade task.

I have followed the way to create new database 5.5 cr2 ( same level of the source ) and I have migrate the data from old to the new db2.

now I've noted the dbwizard is having a lot of issue.

It failed on FAILS because he tried to apply Grants, before run the script to create some tables

to be clear he runs

db2 -td@ -vf connections.sql/files/db2/appGrants.sql

and I've got error because 3 tables was not existing, but that tables will be created on the other script he had in plan to run after

db2 -td@ -vf connections.sql/files/db2/upgrade-60-60CR2.sql
db2 -td@ -vf connections.sql/files/db2/upgrade-60CR2-60CR4.sql
db2 -td@ -vf connections.sql/files/db2/upgrade-60CR4-60CR5.sql

Looking the logs i found this issue and I've re migrate the data, and run the scripts in the correct order.

Later I have relaunched the wizard, it was able to update some dbs and failed on homepage and wikis.

Here I noted the big thing because this was the plan of the wizard for my HomePage database:

Home page
1. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/upgrade-55CR2-60.sql
2. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/appGrants.sql
3. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/reorg.sql
4. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/updateStats.sql
5. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/upgrade-60-60CR1.sql
6. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/appGrants.sql
7. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/reorg.sql
8. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/updateStats.sql
9. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/upgrade-60CR1-60CR2.sql
10. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/upgrade-60CR2-60CR3.sql
11. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/upgrade-60CR3-60CR4.sql
12. /opt/IBM/db2/V11.1/bin/db2 -td@ -vf connections.sql/homepage/db2/upgrade-60-60CR1.sql

as you could read it's a total mess, he try again to apply some grants at point 2, in tables that will be created later (steps from 9 to 11) , than he will runs several times appGrants (step 2 and 6) , reorg (step 3 and 7) , he suppose to run 2 times also upgrade-60-60CR1.sql (step 5 and 12) and last but not less important he is not upgradin the db to cnx 7.0 because he is not launching

db2 -td@ -vf connections.sql/homepage/db2/upgrade-60CR4-70.sql

The question is: it's just me or it's totally unusable? There is out there a page with the scripts that needs to be launched in the correct orderd to upgrade db to 5.5 to 7.0 ?

Maybe I've a bugged wizard and there is another one fixed ?

Thanks for any info you could provide

2

Hi Matteo

Yes, I had issues with the wizard and homepage in several upgrades last year.
I save the tasks as a script (option in the wizard) and change the order before I run it.

In an 6.0 version it updates homepage and thennruns a script and changes the version schema back.

Chris

3

I didn’t bother with the Wizard. I found the sql script names pretty self explanatory and wrote my own bash scripts to migrate the databases including the actual transfer with the dbt tool. It was a bit of effort to create them, but I’ve done multiple migrations with them since.

4

thanks for the confirm guys, this was the first and last time I tried to use this wizard to do this task (5.5. -> 7).

Ok , I'll do the upgrade manually launching the scripts. Have a nice day