Subsystems in a CICS region - DB2SS

The DB2 subsystem in a CICS region (DB2SS) view displays information about attachments between an active CICS system and a DB2 subsystem.

Supplied views

To access from the main menu, click:

CICS operations views > DB2, DBCTL and WebSphere MQ operations views > Subsystems in a CICS region

Table 1. Views in the supplied DB2 subsystems in a CICS region (DB2SS) view set
View Notes
DB2 subsystems in a CICS region

EYUSTARTDB2SS.DETAILED

Detailed information about a selected DBCTL subsystem.
DB2 subsystems in a CICS region

EYUSTARTDB2SS.TABULAR

Tabular information about DBCTL subsystems.

Actions

None.

Fields

Table 2. Fields in DB2SS views
Field Attribute name Description
Number of current active tasks CURTHREAD The number of threads that are currently active between the CICS system and the DB2 subsystem.
First error destination ERRDEST1 The first CICS transient data destination to receive unsolicited messages.
Second error destination ERRDEST2 The second CICS transient data destination to receive unsolicited messages.
Third error destination ERRDEST3 The third CICS transient data destination to receive unsolicited messages.
MVS system ID LOCATION The system ID of the MVS system where this DB2 subsystem resides.
Maximum number of threads MAXTHREAD The maximum number of threads that could be created between the CICS system and the DB2 subsystem. This includes command threads, pool threads and entry threads.
DB2 ID NAME The name of the DB2 subsystem.
Plan allocation entry trace ID PLANENTRTRC Entry trace ID of the DB2 dynamic plan exit used for this subsystem
Plan allocation exit trace ID PLANEXITTRC Exit trace ID of the DB2 dynamic plan exit used for this DB2 subsystem
DB2 connection name RCTNAME The 8 character DB2 connection name.
DB2 subsystem release level RELEASE The release of the DB2 subsystem.
Snap dump output class SNAPCLASS The SYSOUT class of the snap dump
SQL trace ID SQLTRCID ID of the SQL trace
Transient data destination for CICS DB2 statistics STATSDEST The transient data destination used for the collection of CICS DB2 statistics
DB2 CICS attachment status STATUS The status of the DB2 subsystem, as one of the following:
  • ACTIVE - The subsystem is either processing or available for work.
  • INACTIVE - The subsystem is not available for work.
  • QUIESCING - The subsystem is being shutdown.
  • WAITING - The subsystem is not fully initialized.
  • CONNECTING - CICS is currently attempting to connect to the subsystem.
  • DISCONNING - CICS is currently disconnecting from the subsystem.
Wait for DB2 subsystem option WAIT Wait for the DB2 subsystem to become available.


eyua3s7.html | Timestamp icon Last updated: Sunday, 4 June 2017