DB2ENTRY Resource Table

A CICS® Resource that describes a Db2® entry in an active CICS system being managed by CICSPlex® SM.

The First key field for this resource is NAME.

The following actions are supported:
DISABLE
Disable the DB2® entry.
The parameter data for the DISABLE action is: 
   PARM('BUSY(cvda).')

     where:
     
     cvda = Valid CVDA values for the DB2 entry busy condition WAIT, NOWAIT or FORCE.
DISCARD
Discard the DB2 entry.
ENABLE
Enable the DB2 entry

External resource name(CMCI)
CICSDb2Entry
Object type
CICS Resource
Length
248
Usage
API, WUI, CICS Management Client Interface(CMCI), EVALDEF
API view
Yes
CMAS context
No
SCOPE applies
Yes
Only query CMASs in workload
No
Copybook identifier
EYUt0087
Security Class
OPERATE.DB2DBCTL
CICS Commands subject to CICS Security
EXTRACT STATISTICS
INQUIRE DB2ENTRY
Unsupported CICS Releases
None
Table 1. Valid CPSM operations
Operations Actions Parameters Required
GET   None N/A
SET   None N/A
PERFORM SET, PERFORM OBJECT DISABLE BUSY(WAIT, NOWAIT, FORCE) Yes
  DISCARD None N/A
  ENABLE None N/A
Table 2. DB2ENTRY resource table attributes
Name Datatype Source CICS Source CICS Field Len Sum Set Description Default Get Invalid Offset GraphQL Field
EYU_CICSNAME CHAR CPSM     8 DIFF No CICS System Name     0 regionName
EYU_CICSREL CHAR CPSM     4 DIFF No CICS Release     8 CICSRelease
EYU_RESERVED CHAR CPSM     4 N/A No Reserved     12  
 NAME-1  CHAR INQ DB2ENTRY DB2ENTRY 8 DIFF No DB2 entry name     16 name
ABORTS CNUMERIC STAT DFHD2RDS D2R_ABORTS 4 AVG No Number of aborts     104 aborts
ACCOUNTREC CVDAS INQ DB2ENTRY ACCOUNTREC 4 LIKE Yes Accounting record option     24 accountrec
ACCOUNTREC Input/output valid values
  • NONE
  • TASK
  • TXID
  • UOW
AUTHID CHAR INQ DB2ENTRY AUTHID 8 DIFF Yes Thread authorization ID     40 authid
AUTHTYPE CVDAS INQ DB2ENTRY AUTHTYPE 4 LIKE Yes Authorization type     48 authtype
AUTHTYPE Input/output valid values
  • GROUP
  • SIGN
  • TERM
  • TX
  • OPID
  • USERID
BASDEFINEVER BINARY CPSM   Calculated 1 AVG No BAS resource definition version 0   228 basdefinever
CALLS CNUMERIC STAT DFHD2RDS D2R_CALLS 4 AVG No Number of calls     92 calls
CHANGEAGENT CVDAS INQ DB2ENTRY CHANGEAGENT 4 LIKE No Last modification agent     168 changeAgent
CHANGEAGENT Input/output valid values
  • CSDAPI
  • CSDBATCH
  • DREPAPI
  • OVERRIDE
  • DREPBATCH
  • CREATESPI
  • NOTAPPLIC
  • N_A
CHANGEAGREL CHAR INQ DB2ENTRY CHANGEAGREL 4 DIFF No Last modification agent release     180 changeAgentRelease
CHANGETIME DATETIME INQ DB2ENTRY CHANGETIME 8 MAX No Last modification time     184 changeTime
CHANGEUSRID CHAR INQ DB2ENTRY CHANGEUSRID 8 DIFF No Last modification user ID     172 changeUserID
COMMITS CNUMERIC STAT DFHD2RDS D2R_COMMITS 4 AVG No Number of commits     100 commits
DEFINESOURCE CHAR INQ DB2ENTRY DEFINESOURCE 8 DIFF No Source of the resource definition     192 defineSource
DEFINETIME DATETIME INQ DB2ENTRY DEFINETIME 8 MAX No Creation time     200 defineTime
DISABLEDACT CVDAS INQ DB2ENTRY DISABLEDACT 4 LIKE Yes Disabled action     28 disabledact
DISABLEDACT Input/output valid values
  • ABEND
  • SQLCODE
  • POOL
DROLLBACK CVDAS INQ DB2ENTRY DROLLBACK 4 LIKE No Deadlock rollback option     52 drollback
DROLLBACK Output valid values
  • ROLLBACK
  • NOROLLBACK
ENABLESTATUS CVDAS INQ DB2ENTRY ENABLESTATUS 4 LIKE Yes Enabled status     56 status
ENABLESTATUS Input/output valid values
  • ENABLED
  • DISABLED
ENABLESTATUS Output valid values
  • DISABLING
INSTALLAGENT CVDAS INQ DB2ENTRY INSTALLAGENT 4 LIKE No Installation agent     224 installAgent
INSTALLAGENT Input/output valid values
  • CSDAPI
  • CREATESPI
  • GRPLIST
INSTALLTIME DATETIME INQ DB2ENTRY INSTALLTIME 8 MAX No Installation time     216 installTime
INSTALLUSRID CHAR INQ DB2ENTRY INSTALLUSRID 8 DIFF No Installation user ID     208 installUserID
PLAN CHAR INQ DB2ENTRY PLAN 8 DIFF Yes Plan name     60 plan
PLANEXITNAME CHAR INQ DB2ENTRY PLANEXITNAME 8 DIFF Yes Dynamic plan exit name     68 planexitname
PRIORITY CVDAS INQ DB2ENTRY PRIORITY 4 LIKE Yes TCB priority     76 priority
PRIORITY Input/output valid values
  • HIGH
  • EQUAL
  • LOW
PROTECTNUM CNUMERIC INQ DB2ENTRY PROTECTNUM 4 AVG Yes Maximum number of protected threads     88 protectnum
PSIGNONS BINARY STAT DFHD2RDS D2R_PARTIAL_SIGNONS 4 AVG No Number of partial signons     236 psignons
PTCURR CNUMERIC STAT DFHD2RDS D2R_PTHREAD_CURRENT 4 AVG No Current number of protected threads     140 ptcurr
PTHREADS CNUMERIC INQ DB2ENTRY PTHREADS 4 AVG No Number of protected threads     32 pthreads
PTHWM CNUMERIC STAT DFHD2RDS D2R_PTHREAD_HWM 4 AVG No Peak number of protected threads     144 pthwm
PTLIM CNUMERIC STAT DFHD2RDS D2R_PTHREAD_LIMIT 4 AVG No Maximum number of protected threads     136 ptlim
REUSELIMCT BINARY STAT DFHD2RDS D2R_REUSELIMIT_COUNT 4 AVG No Number of times a DB2ENTRY thread reached REUSELIMIT     232 reuselimct
RQCUR CNUMERIC STAT DFHD2RDS D2R_READYQ_CURRENT 4 AVG No Current number of tasks waiting for thread     160 rqcur
RQHWM CNUMERIC STAT DFHD2RDS D2R_READYQ_HWM 4 AVG No Peak number of tasks waiting for thread     164 rqhwm
SHARELOCKS CVDAS INQ DB2ENTRY SHARELOCKS 4 LIKE Yes Sharelocks option   E710-E730 244 shareLocks
SHARELOCKS Input/output valid values
  • SHARED
  • NOTSHARED
SIGNONS CNUMERIC STAT DFHD2RDS D2R_SIGNONS 4 AVG No Number of signons     96 signons
SPHASE CNUMERIC STAT DFHD2RDS D2R_SINGLE_PHASE 4 AVG No Number of UOWs with single phase commit     108 sphase
TCREATE BINARY STAT DFHD2RDS D2R_THREAD_CREATE 4 AVG No Number of times threads created     240 tcreate
TCURR CNUMERIC STAT DFHD2RDS D2R_THREAD_CURRENT 4 AVG No Current number of threads     128 tcurr
THREADLIMIT CNUMERIC INQ DB2ENTRY THREADLIMIT 4 AVG Yes Maximum number of active threads     84 maxThreads
THREADS CNUMERIC INQ DB2ENTRY THREADS 4 AVG No Number of active threads     36 activeThreads
THREADWAIT CVDAS INQ DB2ENTRY THREADWAIT 4 LIKE Yes Thread wait option     80 threadWait
THREADWAIT Input/output valid values
  • TWAIT
  • NOTWAIT
  • TPOOL
THWM CNUMERIC STAT DFHD2RDS D2R_THREAD_HWM 4 AVG No Peak number of active threads     132 thwm
TLIMIT CNUMERIC STAT DFHD2RDS D2R_THREAD_LIMIT 4 AVG No Maximum number of threads     124 tlimit
TREUSE CNUMERIC STAT DFHD2RDS D2R_THREAD_REUSE 4 AVG No Number of times threads reused     112 treuse
TTERM CNUMERIC STAT DFHD2RDS D2R_THREAD_TERM 4 AVG No Number of times threads terminated     116 tterm
TWORO CNUMERIC STAT DFHD2RDS D2R_THREAD_WAIT_OR_OVERFL 4 AVG No Number of thread waits or overflows     120 tworo
XCURR CNUMERIC STAT DFHD2RDS D2R_TASK_CURRENT 4 AVG No Current number of tasks     148 xcurr
XHWM CNUMERIC STAT DFHD2RDS D2R_TASK_HWM 4 AVG No Peak number of tasks     152 xhwm
XTOTAL CNUMERIC STAT DFHD2RDS D2R_TASK_TOTAL 4 AVG No Total number of tasks     156 xtotal