It all started with the connections from Goldengate to DB2 not working anymore:<\/p>\n\n\n
\n2023-09-11 15:31:27 WARNING OGG-00552 Database operation failed: Couldn't connect to DB2_DB1. ODBC error: SQLSTATE 08001 native database error -30073. [IBM][CLI Driver] SQL30073N "0x0000" Parameter value "0x0000" is not supported. SQLSTATE=58017.\nFailed to open data source DB2_DB1for user GG01.\n<\/pre><\/div>\n\n\nThe DB2 administrators say “We changed nothing. Maybe you changed something? And the DB2 documentation says nothing for this error.<\/p>\n\n\n\n
Next email from DB2 admins “well, we did activated the option TCPALVER=SERVER_ENCRYPT and maybe that is the problem”<\/p>\n\n\n\n
Indeed, that was the problem. With that option on the server side, then:<\/p>\n\n\n\n
\nSERVER_ENCRYPT (recommended)<\/strong><\/p>\n\n\n\n
A user ID and password are required for connection requests. Kerberos tickets are also accepted. Also, one of the following conditions must be true:<\/p>\n\n\n\n
The user ID and password is AES (Advanced Encryption Standard)-encrypted.<\/p>\n\n\n\n
…<\/p>\n\n\n\n
Non-encrypted security credentials are not accepted unless the connection is secured by the TCP\/IP network. DES-based (Data Encryption Standard) encryption is also considered insecure.<\/p>\n<\/blockquote>\n\n\n\n
Ok, I needed to activate on my client side the AES encrytion for username and password. Not so difficult:<\/p>\n\n\n
\ndb2cli writecfg add -dsn DB2_DB1 -parameter "Authentication=SERVER_ENCRYPT_AES"\n<\/pre><\/div>\n\n\nAnd voil\u00e0, the connection to DB2 works again, and it is secured.<\/p>\n","protected":false},"excerpt":{"rendered":"
It all started with the connections from Goldengate to DB2 not working anymore: The DB2 administrators say “We changed nothing. Maybe you changed something? And the DB2 documentation says nothing for this error. Next email from DB2 admins “well, we did activated the option TCPALVER=SERVER_ENCRYPT and maybe that is the problem” Indeed, that was the […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,5],"tags":[],"class_list":{"0":"post-860","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-db2-zos","7":"category-goldengate","8":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=860"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/860\/revisions"}],"predecessor-version":[{"id":861,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/860\/revisions\/861"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}