Skip to Content
Information

This site will undergo maintenance on Friday, 26 September at 2:00 AM CDT / 12:30 PM IST and may experience a short period of instability during that time.

CDB2CON view

This topic describes the CDB2CON view.

To display information about the status and activity of the installed IBM CICS-Db2 connection for the CICS regions within the current context, perform one of the following actions:

  • Hyperlink from the DB2 Attachment field of the EZCFSSI Easy menu.
  • Hyperlink from the DB2 Information field of the EZCSREGN Easy menu.
  • Hyperlink from the DB2CONN field of the EZCSRES Easy menu.
  • Hyperlink from the DB2 Sys field of the TASKMQ view.
  • Issue the following command:
    CDB2CON

Related topic

Database-views

CMRDTN-view

The following figure is displayed:

ddmmmyyyy  hh:mm:ss ------ BMC AMI Ops WINDOW INTERFACE (Vv.r.mm) --------------
COMMAND  ===>                                                      SCROLL ===> PAGE
CURR WIN ===> 1        ALT WIN ===>                                                  
>W1 =CDB2CON==========(CCSALL===*=======)ddmmmyyyy==hh:mm:ss====MVCICS===D====5===============================================================
CMD DB2CONN   Target  Connection   DB2  Grp  DB2  OTL SIGNON   TCB  Curr HWM  Curr Free HWM  Curr HWM  Pool
--- Name              Status       Sys  ID   REL  Sup   ID     Lim  TCB  TCB  Conn Conn Conn RdyQ RdyQ Call
    DB211    BCVCF730 CONNECTING   DEJA               BCVCF730  250    0    0    0    0    0    0    0    0
    DB211    BCVCF740 CONNECTING   DEJA               BCVCF740  250    0    0    0    0    0    0    0    0
    DB211    BCVCF750 CONNECTING   DEJA               BCVCF750  100    0    0    0    0    0    0    0    0
    DB211    BCVCF760 CONNECTING   DEJA           NO  BCVCF760  100    0    0    0    0    0    0    0    0

Usage notes

  • The view displays only regions that have a CICS-to-Db2 connection set up.
  • Scroll to the right to see additional fields.
  • For additional information about DB2 usage, you can hyperlink from the DB2 Rel field on the CDB2CON view to the STDB2D view in the BMC AMI Ops Monitor for Db2 product.

Actions

The CDB2CON view supports the following line command actions:

 

Line command

Description

SET

Changes the value in a modifiable field to a new user-entered value; the following DB2CONN attributes are modifiable:

  • Pool Thread Accounting Requirement
  • Pool Thread Authid
  • Pool Thread Authtype
  • Command Thread Authid
  • Command Thread Authtype
  • Command Thread Limit
  • Connection Error and Connection Status
  • DB2 Group ID and DB2 System ID
  • MSGQUEUE1, MSGQUEUE2, and MSGQUEUE3
  • Non-Terminal Release
  • Pool Plan Name
  • Pool Dynamic Plan Exit
  • Pool Thread Priority
  • Purge Cycle Minutes and Purge Cycle Seconds
  • RESYNCMEMBER
  • REUSELIMIT
  • Signon Auth Id
  • STANDBYMODE
  • STATSQUEUE
  • TCBLIMIT
  • Pool Thread Limit, Pool Thread Wait
Warning

Note

Be sure the field contains exactly the value that you want before pressing Enter to issue the SET command. You must clear the field of any other data to prevent it from being passed as part of the new value.

STA

Starts the CICS Db2 connection

STO

Stops the CICS Db2 connection

This action uses the default BUSY(WAIT) option.

When you use this command, the connection to Db2 is quiesced. Any existing transactions will complete before the connection is stopped. Control is returned to the application before the connection is stopped.

SEC

Issues the SET DB2CONN SECURITY(REBUILD) command to force all existing threads to sign on again at the next thread reuse

You should use this command only when you need to refresh changes made in security profiles.

Related views

The following views provide additional CICS-DB2 connection information.

 

View

Description

CDB2CONZ

To display a summary view that summarizes all CICS-to-Db2 connections based on the Connection Status field, enter CDB2CONZ or the SUM command from the CDB2CON view.

CDB2CONQ

To display the Quick Menu for Db2 connection information, hyperlink from the DB2CONN Name field of the CDB2CON view.

CDB2COND

To display detailed information about the statistics for a CICS-Db2 connection for a specific CICS region, hyperlink from the Connection Status field of the CDB2CON view.

CDB2CON2

To display detailed information about the attributes of a CICS-Db2 connection for a specific CICS region, hyperlink from the DB2 Sys field of the CDB2CON view..

CDB2CONR

To display the CICS-Db2 connection signature data, hyperlink from the Resource Signature field of the CDB2CONQ Quick Menu.

CDB2CONT 

Warning

Important

This view is available only if you have are licensed for the BMC AMI Ops for CICS solution. 

To display Dynamic Tuning information, hyperlink from the Dynamic Tuning field of the CDB2CONQ Quick Menu. 

For more Dynamic Tuning information about the Db2 Connection TCBLIMIT and THREADLIMIT attribute values, see Implementing-Dynamic-Tuning-for-IBM-CICS-resource-attributes. 

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for CICS 7.5