---
title: "How to Connect CICS to DB2 Top Ideas"
description: "Connect CICS to DB2 top ideas you need"
url: https://srinimf.com/2014/11/11/connecting-cics-region-to-multiple-db2-subsystems/
date: 2014-11-11
modified: 2020-01-05
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2014/11/cics-to-db2.jpg?fit=1200%2C600&ssl=1
categories: ["CICS"]
tags: ["CICS regions", "CICS tips and Tricks"]
type: post
lang: en
---

# How to Connect CICS to DB2 Top Ideas

When you are defining the connection between CICS® and DB2®, you can choose to have CICS connect to a specific DB2 subsystem. You can specify the name of this DB2 subsystem using the DB2ID attribute of the DB2CONN definition.

However, if you have multiple DB2 subsystems that are using DB2 Version 7 or later, you might want to use DB2’s group attach facility to make it possible for CICS to connect to any of your subsystems, rather than just one named subsystem.

(Group attach for [CICS i](http://cics)s not available in releases of DB2 earlier than Version 7.) For full details of the CICS DB2 configuration needed to use the DB2 group attach facility, see Migrating to a different release of DB2.

Group attach is a DB2 facility that allows CICS to connect to any one member of a data-sharing group of [DB2 subsystems](https://srinimf.com/2014/10/23/db2-subsystem-and-instance/), rather than to a specific DB2 subsystem. The group attach facility chooses any one member of the group that is active on the local MVS™ image for the connection to CICS (members that are active on other MVS images are not eligible for selection).

If you use the DB2GROUPID attribute of the DB2CONN definition to specify the ID for the group of DB2 subsystems, instead of using the DB2ID attribute to specify the ID of an individual DB2 subsystem, you will activate the group attach facility.

This means that you can use a common DB2CONN definition, specifying a group ID, across multiple cloned AORs, and CICS will connect to any active member of that data-sharing group. See the CICS Resource Definition Guide for information on how to define and install a DB2CONN definition.

If you are using group attach and the connection between CICS and DB2 is broken, CICS might not reconnect to the same DB2 subsystem–it might choose a different member of the data-sharing group of DB2 subsystems.

This means that if indoubt UOWs are being held by the first DB2 subsystem to which CICS connected, they cannot be resolved. The RESYNCMEMBER attribute of the DB2CONN definition can be used to solve this problem. SeeResolving indoubt units of work (UOWs) for information on the RESYNCMEMBER attribute and how to set it.

[**Read more from IBM**](http://www-01.ibm.com/support/knowledgecenter/SSGMGV_3.1.0/com.ibm.cics.ts31.doc/dfhtk/dfhtk6g.htm%23dfhtk6g)

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2014%2F11%2F11%2Fconnecting-cics-region-to-multiple-db2-subsystems%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2014%2F11%2Fcics-to-db2.jpg%3Ffit%3D1200%252C600%26ssl%3D1&description=How%20to%20Connect%20CICS%20to%20DB2%20Top%20Ideas)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2014/11/11/connecting-cics-region-to-multiple-db2-subsystems/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2014/11/11/connecting-cics-region-to-multiple-db2-subsystems/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2014/11/11/connecting-cics-region-to-multiple-db2-subsystems/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2014/11/11/connecting-cics-region-to-multiple-db2-subsystems/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20to%20Connect%20CICS%20to%20DB2%20Top%20Ideas&body=https%3A%2F%2Fsrinimf.com%2F2014%2F11%2F11%2Fconnecting-cics-region-to-multiple-db2-subsystems%2F&share=email)
-

### Like this:

Like Loading…