I am unable to figure out how to add multiple catalogs for a DB2 linked server. I have an initial Linked server setup and working properly, but I am struggling to figure out how to add multiple databases from the DB2 instance(version 11.1) using Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64) Jun 17 2016 19:14:09 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor) . Any help would be greatly appreciated.
-
It's not clear why are you struggling with it. You will add a separate linked server for each database you want to connect to. Catalog (schema) is something that's inside a database. – mustaccio Aug 15 '19 at 14:59
-
My APP team is restricting me to only one linked server (for automation) per server. Hence my attempt to create additional catalogs – Jett_DBA Aug 15 '19 at 15:02
From my experience there can be just 1 catalog per 1 linked server
You will need to create separate linked servers for each database on remote server (DB2) that you want to be available for querying on your "local" server (SQL Server)
