0

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 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 at 15:02
0

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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.