Db2 Connector stage hangs after new server certificate
Posted: Fri Jun 29, 2018 5:42 am
Posting in case others had similar issues.
Support installed a new certificate on our dev server (issued by known CA, replacing a self signed one). I followed instructions and did UpdateSignerCerts and accepted new cert on the client. I could login with datastage and change/run jobs, but when I tried to connect to db2 server from within Db2Connector stage my client hung (spinning circle).
After research/trying things I found that running command 'certmgr.msc' from the command line allowed me to access the certificate store; I deleted the old self signed cert from the 'Trusted Root CA' section and things started working again.
Just thought others may find this helpful.
Support installed a new certificate on our dev server (issued by known CA, replacing a self signed one). I followed instructions and did UpdateSignerCerts and accepted new cert on the client. I could login with datastage and change/run jobs, but when I tried to connect to db2 server from within Db2Connector stage my client hung (spinning circle).
After research/trying things I found that running command 'certmgr.msc' from the command line allowed me to access the certificate store; I deleted the old self signed cert from the 'Trusted Root CA' section and things started working again.
Just thought others may find this helpful.