The DB2CONND view shows detailed information about a DB2 connection.
The DB2CONND view is available for CICS Transaction Server for OS/390, Version 1 Release 3 and later systems.
db2conn
is
a specific target name.
Figure 14 is an example of the DB2CONND view.
05SEP2001 17:09:36 ----------- INFORMATION DISPLAY --------------------------- COMMAND ===> SCROLL ===> PAGE CURR WIN ===> 1 ALT WIN ===> W1 =DB2CONN==DB2CONND=EYUPLX01===EYUPLX01==05SEP2001==17:01:32====CPSM=======1 Conname....... DJCDEF1 Authid...... Comauthid... CICS System... DJ13A0 Authtype.... USERID Comauthtype. CUSERID Connectst..... NOTCONNECTED Accountrec.. NONE Comthreads.. 0 Connecterror.. SQLCODE DRollback... ROLLBACK Comthreadlim 1 DB2id......... Planexitname DSNCUEXT DB2 Grp Id.... Plan........ DB2 Release... Priority.... HIGH Msgqueue1..... CDB2 Threads..... 0 Msgqueue2..... Threadwait.. TWAIT Msgqueue3..... Threadlimit. 3 Nontermrel.... RELEASE Purgecyclem... 0 Purgecycles... 30 Signid........ DJ13A0 Standbymode... RECONNECT Statsqueue.... CDB2 TCBs.......... 0 TCB Limit..... 12 Threaderror... N906D Resyncmember.. RESYNC DB2 Conn Stats
Table 33 shows the action commands you can issue from the DB2CONND view. The overtype fields are shown in Table 34.
Primary command | Line command | Description |
---|---|---|
NOTconnect
db2conn sysname |
NOT | Causes disconnection of the CICS/DB2 |
CONNect
db2conn sysname |
CONN | Causes a connection to be established between the CICS/DB2
attachment facility and the DB2 subsystem.
Note:
The shortened form
of this command, when issued from the Command line, is CONN, to avoid conflict
with the CICSPlex® SM CONtext command. |
REBuild | REB | Forces all existing threads to sign on again at the next thread reuse. |
Field name | Values |
---|---|
ACCOUNTREC | UOW | TASK | TXID | NONE |
AUTHID | Any valid alphanumeric character string |
AUTHTYPE | GROUP | SIGN | TERM | TX | OPID | USERID |
COMAUTHID | Any valid alphanumeric character string |
COMAUTHTYPE | CGROUP | CSIGN | CTERM | CTX | COPID | CUSERID |
COMTHREADLIM | 0 - 2000 |
CONNECTERROR | SQLCODE | ABEND |
CONNECTSTATUS | CONNECTED | NOTCONNECTED |
DB2ID | Any valid DB2 subsystem Identifier |
DB2GROUPID | DB2 data sharing group identifier |
DB2RELEASE | A valid DB2 version/release level |
DROLLBACK | ROLLBACK | NOROLLBACK |
MSGQUEUE1 | Any valid TD queue defined to the CICS system |
MSGQUEUE2 | Any valid TD queue defined to the CICS system |
MSGQUEUE3 | Any valid TD queue defined to the CICS system |
NONTERMREL | RELEASE | NORELEASE |
PLAN | Any valid DB2 plan name to be used for all pool threads |
PLANEXITNAME | Dynamic plan exit to be used for all pool threads |
PRIORITY | LOW | EQUAL | HIGH |
PURGECYCLEM | 0 - 59 |
PURGECYCLES | 1 - 59 |
RESYNCMEMBER | RESYNC | NORESYNC |
SIGNID | Authorization Id to be used for signing-on to DB2 |
STANDBYMODE | NOCONNECT | CONNECT | RECONNECT |
STATSQUEUE | Any valid TD queue defined to CICS for attachment statistics |
TCBLIMIT | 4 - 2000 |
THREADLIMIT | 3 - 2000 |
THREADWAIT | TWAIT | NOTWAIT | N906 for signing-on to DB2 |
Table 32 shows the hyperlink field on the DB2CONND view.
Hyperlink field | View displayed | Description |
---|---|---|
DB2 Conn Stats | DB2CONN2 | Detailed information about the statistics settings for the specific DB2 connection. |