Upgrading from Express-C 10.5 to 11.1 not supported?

[Joachim Tuchel]

According to this page:

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.qb.upgrade.doc/doc/c0011933.html

it is not supported to upgrade from Express-C 10.5 to 11.1 Express-C

Is that correct?
What would be the recommended upgrade procedure?

[Jeremy Rickard]

Hi Joachim,

That's interesting but it may just be an oversight. Of course, technically *nothing* on Express-C is supported since its a free product that you cannot even buy support for :-)

If you do have a friendly IBM support guy to hand then you could ask them for an opinion.

Anyway, I happened to have an old DB2 10.5 Express-C instance on my laptop, so I have just tested a bare bones upgrade. Obviously if this matters to you, you would do extract steps to backup database and config first.

Short summary: The procedure worked, I can connect to the upgraded database in the upgraded instance, and nothing in db2diag or other output looked awry. So I would say the process should be fine by your mileage may vary of course.

Test output is below.

Regards, Jeremy


# --------------------------------------------------
# Show installed DB2 software and instance details

root@jeremy-HP-Pavilion-15-Notebook-PC:~# db2greg -dump
V,DB2GPRF,DB2_COMPATIBILITY_VECTOR,MYS,/opt/ibm/db2/V10.5,
S,RSCT,3.1.5.5,/usr/sbin/rsct,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,-,1481341225,0
S,DB2,10.5.0.7,/opt/ibm/db2/V10.5,,,7,0,,1481341261,0
V,DB2GPRF,DB2SYSTEM,jeremy-HP-Pavilion-15-Notebook-PC,/opt/ibm/db2/V10.5,
I,DB2,10.5.0.7,db2inst1,/home/db2inst1/sqllib,,1,0,/opt/ibm/db2/V10.5,,
V,DB2GPRF,DB2INSTDEF,db2inst1,/opt/ibm/db2/V10.5,
S,DB2,11.1.1.1,/db2/11.1,,,1,0,,1498356893,0
V,DB2GPRF,DB2SYSTEM,jeremy-HP-Pavilion-15-Notebook-PC,/db2/11.1,
V,DB2GPRF,DB2_COMPATIBILITY_VECTOR,MYS,/db2/11.1,
S,DB2,11.1.2.2,/db2/11.1.2.2,,,2,0,,1500716916,0
V,DB2GPRF,DB2SYSTEM,jeremy-HP-Pavilion-15-Notebook-PC,/db2/11.1.2.2,
V,DB2GPRF,DB2_COMPATIBILITY_VECTOR,MYS,/db2/11.1.2.2,
I,DB2,11.1.2.2,db2inst2,/home/db2inst2/sqllib,,1,0,/db2/11.1.2.2,,


# Show current instance level

root@jeremy-HP-Pavilion-15-Notebook-PC:/db2/11.1.2.2/instance# su - db2inst1

db2inst1@jeremy-HP-Pavilion-15-Notebook-PC:~$ db2level
DB21085I This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL10057" with level
identifier "0608010E".
Informational tokens are "DB2 v10.5.0.7", "s151221", "IP23956", and Fix Pack
"7".
Product is installed at "/opt/ibm/db2/V10.5".


# Run instance upgrade to 11.1 as root

root@jeremy-HP-Pavilion-15-Notebook-PC:/db2/11.1.2.2/instance# ./db2iupgrade db2inst1

DBI1446I The db2iupgrade command is running.

DB2 installation is being initialized.

Total number of tasks to be performed: 4
Total estimated time for all tasks to be performed: 309 second(s)

Task #1 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #1 end

Task #2 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #2 end

Task #3 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #3 end

Task #4 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #4 end

The execution completed successfully.

For more information see the DB2 installation log at
"/tmp/db2iupgrade.log.30769".
DBI1070I Program db2iupgrade completed successfully.


# Show updated instance level

root@jeremy-HP-Pavilion-15-Notebook-PC:/db2/11.1.2.2/instance# su - db2inst1

db2inst1@jeremy-HP-Pavilion-15-Notebook-PC:~$ db2level
DB21085I This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL11012" with level
identifier "0203010F".
Informational tokens are "DB2 v11.1.2.2", "s1706091900", "DYN1701310100AMD64",
and Fix Pack "2".
Product is installed at "/db2/11.1.2.2".


# List databases and levels

db2inst1@jeremy-HP-Pavilion-15-Notebook-PC:~$ db2 list db directory

System Database Directory

Number of entries in the directory = 2

Database 1 entry:

Database alias = TEST
Database name = TEST
Local database directory = /home/db2inst1
Database release level = 10.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = MERCURY
Database name = MERCURY
Local database directory = /home/db2inst1
Database release level = 10.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =


# Upgrade one of the databases

db2inst1@jeremy-HP-Pavilion-15-Notebook-PC:~$ db2start
SQL1063N DB2START processing was successful.

db2inst1@jeremy-HP-Pavilion-15-Notebook-PC:~$ db2 upgrade database TEST


# List databases and levels (note update to 14.00)

db2inst1@jeremy-HP-Pavilion-15-Notebook-PC:~$ db2 list db directory

System Database Directory

Number of entries in the directory = 2

Database 1 entry:

Database alias = TEST
Database name = TEST
Local database directory = /home/db2inst1
Database release level = 14.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = MERCURY
Database name = MERCURY
Local database directory = /home/db2inst1
Database release level = 10.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

# That's all (I then just connected and queried a table).

[Joachim Tuchel]

Jeremy,

thanks so much for sharing this. So it seems it's time to give it a test run ;-)

Joachim

[Joachim Tuchel]

install and db2ckupgrade on a test machine were a success. Now I have to wait until I can have the machine for myself alone ;-)