How to upgrade Cognos Analytics 11.0.5 with Content store in SSL enabled DB2 database to 11.0.11

Resolving The Problem

1) In 11.0.5 in Cognos Configuration File -> Export As - save as the file called before_upgrade_cogconfig.xml outside the installation folder, exit Cognos Configuration

2) Make a backup copy of the 11.0.5 installation folder

2)Install 11.0.11 into the same installation folder where 11.0.5 was installed

3) Navigate to the configuration folder, remove cogstartup.xml file, copy  before_upgrade_cogconfig.xml to the configuration folder, rename it to cogstartup.xml

4) Copy JDBC drivers from the drivers folder of the 11.0.5 backup into drivers folder of 11.0.11

5) Copy certs folder from configuration folder of 11.0.5 backup to configuration folder of 11.0.11

7) Follow the documentation at
 https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.sw… to use a SSL enabled DB2 as the content store,

8) Copy the list of providers from jre\lib\security\java.security in 11.0.5 backup

security.provider.1=com.ibm.jsse2.IBMJSSEProvider2
security.provider.2=com.ibm.crypto.fips.provider.IBMJCEFIPS
security.provider.3=com.ibm.crypto.provider.IBMJCE
security.provider.4=com.ibm.security.jgss.IBMJGSSProvider
security.provider.5=com.ibm.security.cert.IBMCertPath
security.provider.6=com.ibm.security.sasl.IBMSASL
security.provider.7=com.ibm.xml.crypto.IBMXMLCryptoProvider
security.provider.8=com.ibm.xml.enc.IBMXMLEncProvider
security.provider.9=com.ibm.security.jgss.mech.spnego.IBMSPNEGO
security.provider.10=sun.security.provider.Sun

and replace a similar list of 9 providers in 11.0.11 with the list from 11.0.5

9) Copy unrestricted files from 11.0.5 backup to 11.0.11 or download them from  https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=jcesdk

10) Run Cognos Configuration in 11.0.11 and save the configuration

11) Start the Cognos Analytics 11.0.11