Can I access tables on SQL Server and DB2 from Mainframe Cobol Programs via BizTalk DRDA Services?Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerHow to concatenate text from multiple rows into a single text string in SQL server?How can I get column names from a table in SQL Server?Update a table using JOIN in SQL Server?How do I UPDATE from a SELECT in SQL Server?Find all tables containing column with specified name - MS SQL ServerHow to call a COBOL batch program from a COBOL stored procedure on DB2
What's this constructed number's starter?
How were the names on the memorial stones in Avengers: Endgame chosen, out-of-universe?
Resizing attribute form in QGIS 3
Is it possible to observe space debris with Binoculars?
Professor refuses to write a recommendation letter
What's the eccentricity of an orbit (trajectory) falling straight down towards the center?
Round away from zero
How can I oppose my advisor granting gift authorship to a collaborator?
Dissuading my girlfriend from a scam
What is the statistical difference between "choose either total" or "choose new total" when rerolling damage die?
Why is a pressure canner needed when canning?
Why don't they build airplanes from 3D printer plastic?
Was "The Hobbit" ever abridged?
Is it rude to ask my opponent to resign an online game when they have a lost endgame?
Never make public members virtual/abstract - really?
Draw the ☣ (Biohazard Symbol)
'This one' as a pronoun
Are language and thought the same?
If magnetic force can't do any work, then how can we define a potential?
Project Euler Problem 45
Comparing elements in a nested list to generate a new list
Is there any difference between these two sentences? (Adverbs)
In the DC universe, which characters assumed the identity of the Red Hood?
ASCII Maze Rendering 3000
Can I access tables on SQL Server and DB2 from Mainframe Cobol Programs via BizTalk DRDA Services?
Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerHow to concatenate text from multiple rows into a single text string in SQL server?How can I get column names from a table in SQL Server?Update a table using JOIN in SQL Server?How do I UPDATE from a SELECT in SQL Server?Find all tables containing column with specified name - MS SQL ServerHow to call a COBOL batch program from a COBOL stored procedure on DB2
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
We have Mainframe z/OS COBOL applications accessing set of DB2 tables (T1, T2) from few applications (App1, App2) in a SELECT query. Now, we are moving one of the application (App1) and its tables (T1) to SQL Server (Azure SQL in the future). How do we move this application without impacting the Mainframe COBOL applications?
Can we use BizTalk Host Integration Server DRDA services to expose the table T1 from SQL Server and Table T2 from DB2 and allow the Mainframe COBOL applications to continue to join the tables and run SELECT queries? In otherwords, Mainframe COBOL wouldn't even know the table T1 is not in DB2 but in SQL Server?
The following link from Microsoft says doable, but would like to understand the feasibility and Pros/Cons.
- IBM DRDA - https://en.wikipedia.org/wiki/DRDA, https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.admin.doc/ids_admin_0206.htm
- Configuring DB2 for z-OS - https://docs.microsoft.com/en-us/host-integration-server/core/configuring-db2-for-z-os
- DRDA services available in BizTalk - https://docs.microsoft.com/en-us/host-integration-server/core/service-for-drda
sql-server biztalk cobol mainframe db2-zos asked Mar 28 at 3:44
HumbleHumble
314 bronze badges
add a comment |
We have Mainframe z/OS COBOL applications accessing set of DB2 tables (T1, T2) from few applications (App1, App2) in a SELECT query. Now, we are moving one of the application (App1) and its tables (T1) to SQL Server (Azure SQL in the future). How do we move this application without impacting the Mainframe COBOL applications?
Can we use BizTalk Host Integration Server DRDA services to expose the table T1 from SQL Server and Table T2 from DB2 and allow the Mainframe COBOL applications to continue to join the tables and run SELECT queries? In otherwords, Mainframe COBOL wouldn't even know the table T1 is not in DB2 but in SQL Server?
The following link from Microsoft says doable, but would like to understand the feasibility and Pros/Cons.
- IBM DRDA - https://en.wikipedia.org/wiki/DRDA, https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.admin.doc/ids_admin_0206.htm
- Configuring DB2 for z-OS - https://docs.microsoft.com/en-us/host-integration-server/core/configuring-db2-for-z-os
- DRDA services available in BizTalk - https://docs.microsoft.com/en-us/host-integration-server/core/service-for-drda
sql-server biztalk cobol mainframe db2-zos asked Mar 28 at 3:44
HumbleHumble
314 bronze badges
Even if do-able, it might not be a good idea. You need to find out how and how often the table is used on the mainframe. Then talk to the DBA's. If the table is used 10000 times a day in a Cics transaction, it would be a very bad idea.
– Bruce Martin
Mar 29 at 11:28
The Table will be used few hundred thousand times per hour, mIllions per day. But it is not accessed through CICS. Mainframe COBOL programs access the table directly.
– Humble
Mar 30 at 5:52
I would be talking to the DBA's; I would guess you need to replicate the Table.
– Bruce Martin
Mar 30 at 7:03
add a comment |
We have Mainframe z/OS COBOL applications accessing set of DB2 tables (T1, T2) from few applications (App1, App2) in a SELECT query. Now, we are moving one of the application (App1) and its tables (T1) to SQL Server (Azure SQL in the future). How do we move this application without impacting the Mainframe COBOL applications?
Can we use BizTalk Host Integration Server DRDA services to expose the table T1 from SQL Server and Table T2 from DB2 and allow the Mainframe COBOL applications to continue to join the tables and run SELECT queries? In otherwords, Mainframe COBOL wouldn't even know the table T1 is not in DB2 but in SQL Server?
The following link from Microsoft says doable, but would like to understand the feasibility and Pros/Cons.
- IBM DRDA - https://en.wikipedia.org/wiki/DRDA, https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.admin.doc/ids_admin_0206.htm
- Configuring DB2 for z-OS - https://docs.microsoft.com/en-us/host-integration-server/core/configuring-db2-for-z-os
- DRDA services available in BizTalk - https://docs.microsoft.com/en-us/host-integration-server/core/service-for-drda
sql-server biztalk cobol mainframe db2-zos asked Mar 28 at 3:44
HumbleHumble
314 bronze badges
We have Mainframe z/OS COBOL applications accessing set of DB2 tables (T1, T2) from few applications (App1, App2) in a SELECT query. Now, we are moving one of the application (App1) and its tables (T1) to SQL Server (Azure SQL in the future). How do we move this application without impacting the Mainframe COBOL applications?
Can we use BizTalk Host Integration Server DRDA services to expose the table T1 from SQL Server and Table T2 from DB2 and allow the Mainframe COBOL applications to continue to join the tables and run SELECT queries? In otherwords, Mainframe COBOL wouldn't even know the table T1 is not in DB2 but in SQL Server?
The following link from Microsoft says doable, but would like to understand the feasibility and Pros/Cons.
- IBM DRDA - https://en.wikipedia.org/wiki/DRDA, https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.admin.doc/ids_admin_0206.htm
- Configuring DB2 for z-OS - https://docs.microsoft.com/en-us/host-integration-server/core/configuring-db2-for-z-os
- DRDA services available in BizTalk - https://docs.microsoft.com/en-us/host-integration-server/core/service-for-drda
sql-server biztalk cobol mainframe db2-zos sql-server biztalk cobol mainframe db2-zos asked Mar 28 at 3:44
HumbleHumble
314 bronze badges
asked Mar 28 at 3:44
HumbleHumble
314 bronze badges
asked Mar 28 at 3:44
HumbleHumble
314 bronze badges
asked Mar 28 at 3:44
HumbleHumble
314 bronze badges
asked Mar 28 at 3:44
HumbleHumble
314 bronze badges
314 bronze badges
Even if do-able, it might not be a good idea. You need to find out how and how often the table is used on the mainframe. Then talk to the DBA's. If the table is used 10000 times a day in a Cics transaction, it would be a very bad idea.
– Bruce Martin
Mar 29 at 11:28
The Table will be used few hundred thousand times per hour, mIllions per day. But it is not accessed through CICS. Mainframe COBOL programs access the table directly.
– Humble
Mar 30 at 5:52
I would be talking to the DBA's; I would guess you need to replicate the Table.
– Bruce Martin
Mar 30 at 7:03
add a comment |
Even if do-able, it might not be a good idea. You need to find out how and how often the table is used on the mainframe. Then talk to the DBA's. If the table is used 10000 times a day in a Cics transaction, it would be a very bad idea.
– Bruce Martin
Mar 29 at 11:28
The Table will be used few hundred thousand times per hour, mIllions per day. But it is not accessed through CICS. Mainframe COBOL programs access the table directly.
– Humble
Mar 30 at 5:52
I would be talking to the DBA's; I would guess you need to replicate the Table.
– Bruce Martin
Mar 30 at 7:03
Even if do-able, it might not be a good idea. You need to find out how and how often the table is used on the mainframe. Then talk to the DBA's. If the table is used 10000 times a day in a Cics transaction, it would be a very bad idea.
– Bruce Martin
Mar 29 at 11:28
Even if do-able, it might not be a good idea. You need to find out how and how often the table is used on the mainframe. Then talk to the DBA's. If the table is used 10000 times a day in a Cics transaction, it would be a very bad idea.
– Bruce Martin
Mar 29 at 11:28
The Table will be used few hundred thousand times per hour, mIllions per day. But it is not accessed through CICS. Mainframe COBOL programs access the table directly.
– Humble
Mar 30 at 5:52
The Table will be used few hundred thousand times per hour, mIllions per day. But it is not accessed through CICS. Mainframe COBOL programs access the table directly.
– Humble
Mar 30 at 5:52
I would be talking to the DBA's; I would guess you need to replicate the Table.
– Bruce Martin
Mar 30 at 7:03
I would be talking to the DBA's; I would guess you need to replicate the Table.
– Bruce Martin
Mar 30 at 7:03
add a comment |
2 Answers
2
active
oldest
votes
I'm going out on a limb here but I think the answer is NO. z/OS COBOL programs access DB2 using threads to a local DB2 subsystem via cross-memory services. Think of it like a socket but done using low-level zero copy inter-process-communication. To do what you require would need application changes and Java in the mix to integrate to BizTalk.
answered Mar 29 at 10:37
David CrayfordDavid Crayford
5311 gold badge3 silver badges10 bronze badges
add a comment |
You can define a DRDA link to an OCDB database link which should allow you to connect to almost any standard SQL database on another server. But you would probably not get it past your mainframe sysadmins's as it is non standard
and difficult to manage.
Replication would probably be your best bet -- there are several tools from both vendors: https://docs.microsoft.com/en-us/sql/relational-databases/replication/non-sql/ibm-db2-subscribers?view=sql-server-2017 describes the Microsoft offering.
answered Apr 1 at 17:32
James AndersonJames Anderson
24.9k6 gold badges41 silver badges71 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55389859%2fcan-i-access-tables-on-sql-server-and-db2-from-mainframe-cobol-programs-via-bizt%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I'm going out on a limb here but I think the answer is NO. z/OS COBOL programs access DB2 using threads to a local DB2 subsystem via cross-memory services. Think of it like a socket but done using low-level zero copy inter-process-communication. To do what you require would need application changes and Java in the mix to integrate to BizTalk.
answered Mar 29 at 10:37
David CrayfordDavid Crayford
5311 gold badge3 silver badges10 bronze badges
add a comment |
I'm going out on a limb here but I think the answer is NO. z/OS COBOL programs access DB2 using threads to a local DB2 subsystem via cross-memory services. Think of it like a socket but done using low-level zero copy inter-process-communication. To do what you require would need application changes and Java in the mix to integrate to BizTalk.
answered Mar 29 at 10:37
David CrayfordDavid Crayford
5311 gold badge3 silver badges10 bronze badges
add a comment |
I'm going out on a limb here but I think the answer is NO. z/OS COBOL programs access DB2 using threads to a local DB2 subsystem via cross-memory services. Think of it like a socket but done using low-level zero copy inter-process-communication. To do what you require would need application changes and Java in the mix to integrate to BizTalk.
answered Mar 29 at 10:37
David CrayfordDavid Crayford
5311 gold badge3 silver badges10 bronze badges
I'm going out on a limb here but I think the answer is NO. z/OS COBOL programs access DB2 using threads to a local DB2 subsystem via cross-memory services. Think of it like a socket but done using low-level zero copy inter-process-communication. To do what you require would need application changes and Java in the mix to integrate to BizTalk.
answered Mar 29 at 10:37
David CrayfordDavid Crayford
5311 gold badge3 silver badges10 bronze badges
answered Mar 29 at 10:37
David CrayfordDavid Crayford
5311 gold badge3 silver badges10 bronze badges
answered Mar 29 at 10:37
David CrayfordDavid Crayford
5311 gold badge3 silver badges10 bronze badges
answered Mar 29 at 10:37
David CrayfordDavid Crayford
5311 gold badge3 silver badges10 bronze badges
5311 gold badge3 silver badges10 bronze badges
add a comment |
add a comment |
You can define a DRDA link to an OCDB database link which should allow you to connect to almost any standard SQL database on another server. But you would probably not get it past your mainframe sysadmins's as it is non standard
and difficult to manage.
Replication would probably be your best bet -- there are several tools from both vendors: https://docs.microsoft.com/en-us/sql/relational-databases/replication/non-sql/ibm-db2-subscribers?view=sql-server-2017 describes the Microsoft offering.
answered Apr 1 at 17:32
James AndersonJames Anderson
24.9k6 gold badges41 silver badges71 bronze badges
add a comment |
You can define a DRDA link to an OCDB database link which should allow you to connect to almost any standard SQL database on another server. But you would probably not get it past your mainframe sysadmins's as it is non standard
and difficult to manage.
Replication would probably be your best bet -- there are several tools from both vendors: https://docs.microsoft.com/en-us/sql/relational-databases/replication/non-sql/ibm-db2-subscribers?view=sql-server-2017 describes the Microsoft offering.
answered Apr 1 at 17:32
James AndersonJames Anderson
24.9k6 gold badges41 silver badges71 bronze badges
add a comment |
You can define a DRDA link to an OCDB database link which should allow you to connect to almost any standard SQL database on another server. But you would probably not get it past your mainframe sysadmins's as it is non standard
and difficult to manage.
Replication would probably be your best bet -- there are several tools from both vendors: https://docs.microsoft.com/en-us/sql/relational-databases/replication/non-sql/ibm-db2-subscribers?view=sql-server-2017 describes the Microsoft offering.
answered Apr 1 at 17:32
James AndersonJames Anderson
24.9k6 gold badges41 silver badges71 bronze badges
You can define a DRDA link to an OCDB database link which should allow you to connect to almost any standard SQL database on another server. But you would probably not get it past your mainframe sysadmins's as it is non standard
and difficult to manage.
Replication would probably be your best bet -- there are several tools from both vendors: https://docs.microsoft.com/en-us/sql/relational-databases/replication/non-sql/ibm-db2-subscribers?view=sql-server-2017 describes the Microsoft offering.
answered Apr 1 at 17:32
James AndersonJames Anderson
24.9k6 gold badges41 silver badges71 bronze badges
answered Apr 1 at 17:32
James AndersonJames Anderson
24.9k6 gold badges41 silver badges71 bronze badges
answered Apr 1 at 17:32
James AndersonJames Anderson
24.9k6 gold badges41 silver badges71 bronze badges
answered Apr 1 at 17:32
James AndersonJames Anderson
24.9k6 gold badges41 silver badges71 bronze badges
24.9k6 gold badges41 silver badges71 bronze badges
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55389859%2fcan-i-access-tables-on-sql-server-and-db2-from-mainframe-cobol-programs-via-bizt%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Even if do-able, it might not be a good idea. You need to find out how and how often the table is used on the mainframe. Then talk to the DBA's. If the table is used 10000 times a day in a Cics transaction, it would be a very bad idea.
– Bruce Martin
Mar 29 at 11:28
The Table will be used few hundred thousand times per hour, mIllions per day. But it is not accessed through CICS. Mainframe COBOL programs access the table directly.
– Humble
Mar 30 at 5:52
I would be talking to the DBA's; I would guess you need to replicate the Table.
– Bruce Martin
Mar 30 at 7:03