DB2CONND - DB2 connection details

The DB2CONND view shows detailed information about a DB2 connection.

Availability

The DB2CONND view is available for CICS Transaction Server for OS/390, Version 1 Release 3 and later systems.

Access

Issue command:
DB2CONND [db2conn]

db2conn
is a specific target name.

Hyperlink from:
the Target Name field of the DB2CONN view.

Figure 14 is an example of the DB2CONND view.

Figure 14. 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 

Action commands

Table 33 shows the action commands you can issue from the DB2CONND view. The overtype fields are shown in Table 34.

Table 33. DB2CONND view action commands
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.

Table 34. DB2CONND view overtype fields
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

Hyperlinks

Table 32 shows the hyperlink field on the DB2CONND view.

Table 35. DB2CONND view hyperlink field
Hyperlink field View displayed Description
DB2 Conn Stats DB2CONN2 Detailed information about the statistics settings for the specific DB2 connection.
[[ Contents Previous Page | Next Page Index ]]