Check IBM Connections 5 DB Schema Versions with a script

My friend Christoph had some issues with IBM Connections DBs which weren’t updated to the correct schema version

I haven’t created a script since a while so the decision was made to accept the challenge.

Some hours later the work was done, look here: https://github.com/stoeps13/ibmcnxscripting/blob/master/DB2/check_schema_versions.sh

Thx to the work of Mark Myers (Stickfight) creating the scripts was rather easy because I could use the SQL code from his blog post on the topic.

The script will automatically detect your IBM Connections Version (5 Base, 5 CR1, 5 CR2) and will print all application DB versions.

Further it will check if all application versions are matching the installed IBM Connections Version or if they are issues with non updated DBs:

Hope you like it, enjoy.