How to change the DB2 Version from ESE to WSE

If you need to change DB2 version , you have to either a)uninstall the old version or b) upgrade it to the new version. In these notes, I am uninstalling the old version. In this example, I am changing DB2 versions from DB2 10.1 ESE to DB2 10.1 WSE Step 1: Contact application owners to shutdown application connections to the DB2 instances stopped. You can check for any live connections with: db2 list applications Step 2: Backup, export or db2move. This decision depends on the circumstances # mkdir /backups # cd /backups # db2look -d DBNAME -e -o DBNAME.DDL #... Read more →