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 below:

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) .

  • My APP team is restricting me to only one linked server (for automation) per server. Hence my attempt to create additional catalogs
    – Jett_DBA
    Commented Aug 15, 2019 at 15:02

1 Answer 1


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 and acknowledge you have read our privacy policy.

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