{"id":46175,"date":"2026-08-13T08:18:00","date_gmt":"2026-08-13T06:18:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=46175"},"modified":"2026-08-05T21:23:47","modified_gmt":"2026-08-05T19:23:47","slug":"db2-sql1598n-licensing-error-when-upgrading-goldengate","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/","title":{"rendered":"DB2 SQL1598N Licensing Error When Upgrading GoldenGate"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">While upgrading GoldenGate to 26ai for a DB2 z\/OS source, I had to update the <em><a href=\"https:\/\/www.ibm.com\/support\/pages\/db2-odbc-cli-driver-download-and-installation-information\" target=\"_blank\" rel=\"noreferrer noopener\">IBM Data Server Driver for ODBC and CLI<\/a><\/em> (<em><strong>CLI Driver<\/strong><\/em>, in short) alongside it. Since I realized that DB2 driver know-how was rare in companies, I figured it would be worth writing a blog about the topic.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this GoldenGate upgrade, the previous driver was version 11.1 and the target version was 12.1. After installing the new driver, <code>db2cli execsql<\/code> commands that previously worked started failing with the following error:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ndb2cli execsql -db &amp;lt;database_alias&amp;gt; -user &amp;lt;username&amp;gt; -passwd &amp;lt;password&amp;gt; \\\n  -inputsql \/home\/oracle\/input.sql\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Where <code>\/home\/oracle\/input.sql<\/code> just contains a trivial test query:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nselect 1 from sysibm.sysdummy1;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">The <code>sysibm.sysdummy1<\/code> table is DB2\u2019s equivalent of Oracle\u2019s <code>DUAL<\/code>, so this is about the simplest query you can run to check connectivity. It failed with the following error:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQLError: 1 = 0 (SQL_SUCCESS)\nSQLGetDiagRec: SQLState : 42968\nNativeError : -1598\nDiagMsg: &#x5B;IBM]&#x5B;CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968\n<\/pre><\/div>\n\n\n<h2 id=\"h-what-sql1598n-means\" class=\"wp-block-heading\">What SQL1598N means<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><code>SQL1598N<\/code> means the DB2 client does not have a valid license to connect to this database. The CLI driver loaded fine. But when it tried to establish an authenticated connection the server rejected it on licensing grounds.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is distinct from a connection failure or an authentication failure.<\/p>\n\n\n\n<h2 id=\"h-root-cause\" class=\"wp-block-heading\">Root cause<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">It might not be obvious for Oracle-accustomed DBAs, but the <strong>DB2 CLI Driver does not ship with a license file<\/strong> for connecting to DB2 for z\/OS. A separate license file named <code>db2consv_zs.lic<\/code> must be placed manually in the <code>clidriver\/license\/<\/code> directory of the driver installation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The critical point is that <strong>the license file is version-specific and cannot be reused across driver versions<\/strong>. The license file that worked with driver 11.1 is not valid for driver 12.1. After upgrading the driver, the new installation directory does not contain the license file in the <code>license\/<\/code> folder, and copying the old license file into it will not resolve the error.<\/p>\n\n\n\n<h2 id=\"h-observed-behavior\" class=\"wp-block-heading\">Observed behavior<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The error was reproducible every time the same command was run against the new driver. For reference, a successful run against a properly licensed driver returns:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nFetchAll: Columns: 1\n1\n1\nFetchAll: 1 rows fetched.\n<\/pre><\/div>\n\n\n<h2 id=\"h-license-file-location\" class=\"wp-block-heading\">License file location<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">It is important to keep in mind that the license file belongs in the <code>license\/<\/code> subdirectory of the CLI driver installation. With CLI driver 11.1, the path looked like:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\/opt\/ibm\/db2_odbc_cli_11_1\/clidriver\/license\/db2consv_zs.lic\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">After upgrading to 12.1, the <strong>new driver<\/strong> has its own separate installation directory with <strong>its own <code>license\/<\/code> subdirectory<\/strong>. Placing the old 11.1 license file there will not work &#8211; the file is tied to the driver version.<\/p>\n\n\n\n<h2 id=\"h-how-to-fix-the-issue\" class=\"wp-block-heading\">How to fix the issue ?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Since the old file is unusable, you must obtain a new license file matching the installed driver version from IBM. Essentially, you have two options here:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Contact your DB2 engineers<\/strong>: if someone on the team manages IBM software licenses, they should be able to provide the correct <code>db2consv_zs.lic<\/code> for the version you installed.<\/li>\n\n\n\n<li><strong>Open a case with IBM customer support<\/strong>: IBM will provide the appropriate license file for the new driver version.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have the correct file, place it in the <code>clidriver\/license\/<\/code> directory of the new driver installation and retry the same <code>db2cli execsql<\/code> command given above. No restart is required.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">DB2 CLI drivers are not that complicated to use and to debug. However, there are a few fundamentals that GoldenGate administrators should know before attempting a migration. Renewing the license file is one of them.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While upgrading GoldenGate to 26ai for a DB2 z\/OS source, I had to update the IBM Data Server Driver for ODBC and CLI (CLI Driver, in short) alongside it. Since I realized that DB2 driver know-how was rare in companies, I figured it would be worth writing a blog about the topic. In this GoldenGate [&hellip;]<\/p>\n","protected":false},"author":152,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[3787],"tags":[3827,3804,2324,3927,56,4185,1545,4180,328,57,377,3730,4181],"type_dbi":[3828,3823,3874,3928,3922,4186,2954,4183,3740,3929,4184,3881,4182],"class_list":["post-46175","post","type-post","status-publish","format-standard","hentry","category-goldengate","tag-3827","tag-26ai","tag-cli","tag-clidriver","tag-db2","tag-db2cli","tag-error","tag-execsql","tag-goldengate","tag-ibm","tag-licensing","tag-ogg","tag-sql1598n","type-3828","type-26ai","type-cli","type-clidriver","type-db2","type-db2cli","type-error","type-execsql","type-goldengate","type-ibm","type-licensing","type-ogg","type-sql1598n"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.2 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>DB2 SQL1598N Licensing Error When Upgrading GoldenGate - dbi Blog<\/title>\n<meta name=\"description\" content=\"Why upgrading GoldenGate for a DB2 z\/OS source can trigger a SQL1598N licensing error on the CLI driver, and how to fix it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DB2 SQL1598N Licensing Error When Upgrading GoldenGate\" \/>\n<meta property=\"og:description\" content=\"Why upgrading GoldenGate for a DB2 z\/OS source can trigger a SQL1598N licensing error on the CLI driver, and how to fix it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-13T06:18:00+00:00\" \/>\n<meta name=\"author\" content=\"Julien Delattre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julien Delattre\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/db2-sql1598n-licensing-error-when-upgrading-goldengate\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/db2-sql1598n-licensing-error-when-upgrading-goldengate\\\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"headline\":\"DB2 SQL1598N Licensing Error When Upgrading GoldenGate\",\"datePublished\":\"2026-08-13T06:18:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/db2-sql1598n-licensing-error-when-upgrading-goldengate\\\/\"},\"wordCount\":510,\"commentCount\":0,\"keywords\":[\"26\",\"26ai\",\"CLI\",\"clidriver\",\"DB2\",\"db2cli\",\"Error\",\"execsql\",\"GoldenGate\",\"IBM\",\"Licensing\",\"ogg\",\"sql1598n\"],\"articleSection\":[\"GoldenGate\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/db2-sql1598n-licensing-error-when-upgrading-goldengate\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/db2-sql1598n-licensing-error-when-upgrading-goldengate\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/db2-sql1598n-licensing-error-when-upgrading-goldengate\\\/\",\"name\":\"DB2 SQL1598N Licensing Error When Upgrading GoldenGate - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2026-08-13T06:18:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"description\":\"Why upgrading GoldenGate for a DB2 z\\\/OS source can trigger a SQL1598N licensing error on the CLI driver, and how to fix it.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/db2-sql1598n-licensing-error-when-upgrading-goldengate\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/db2-sql1598n-licensing-error-when-upgrading-goldengate\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/db2-sql1598n-licensing-error-when-upgrading-goldengate\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DB2 SQL1598N Licensing Error When Upgrading GoldenGate\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\",\"name\":\"Julien Delattre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"caption\":\"Julien Delattre\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/juliendelattre\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"DB2 SQL1598N Licensing Error When Upgrading GoldenGate - dbi Blog","description":"Why upgrading GoldenGate for a DB2 z\/OS source can trigger a SQL1598N licensing error on the CLI driver, and how to fix it.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/","og_locale":"en_US","og_type":"article","og_title":"DB2 SQL1598N Licensing Error When Upgrading GoldenGate","og_description":"Why upgrading GoldenGate for a DB2 z\/OS source can trigger a SQL1598N licensing error on the CLI driver, and how to fix it.","og_url":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/","og_site_name":"dbi Blog","article_published_time":"2026-08-13T06:18:00+00:00","author":"Julien Delattre","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julien Delattre","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"headline":"DB2 SQL1598N Licensing Error When Upgrading GoldenGate","datePublished":"2026-08-13T06:18:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/"},"wordCount":510,"commentCount":0,"keywords":["26","26ai","CLI","clidriver","DB2","db2cli","Error","execsql","GoldenGate","IBM","Licensing","ogg","sql1598n"],"articleSection":["GoldenGate"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/","url":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/","name":"DB2 SQL1598N Licensing Error When Upgrading GoldenGate - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-08-13T06:18:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"description":"Why upgrading GoldenGate for a DB2 z\/OS source can trigger a SQL1598N licensing error on the CLI driver, and how to fix it.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/db2-sql1598n-licensing-error-when-upgrading-goldengate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DB2 SQL1598N Licensing Error When Upgrading GoldenGate"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e","name":"Julien Delattre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","caption":"Julien Delattre"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/juliendelattre\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=46175"}],"version-history":[{"count":3,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46175\/revisions"}],"predecessor-version":[{"id":46267,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46175\/revisions\/46267"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=46175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=46175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=46175"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=46175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}