Db2 Connector stage hangs after new server certificate

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
spdsquared2
Participant
Posts: 10
Joined: Mon Jun 01, 2015 3:39 pm
Location: Northern New Jersey

Db2 Connector stage hangs after new server certificate

Post by spdsquared2 »

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.
Thanks! Sean
Post Reply