On Friday, 24 November 2017 20:34:26 UTC+13, Joachim Tuchel wrote:
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?
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).
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)