DB2CDEF Resource Table

A CICS® Definition that describes the connection properties of a DB2® connection.

The Primary key field for this resource class is  NAME .

The following actions are supported:

INSTALL
Install a DB2 connection definition.

The parameter data for the INSTALL action is described in Parameters for installing CICS Definitions.

Length
232
Usage
API or Batch Utility
API view
No
CMAS context
No
SCOPE applies
No
Only query CMASs in workload
No
Object type
CICS Definition
Copybook identifier
EYUt3817 or DB2CDEF
Valid API operations
GET CREATE UPDATE REMOVE and PERFORM
Parameters
GET
[RESGROUP] [CICSSYS]
CREATE
[RESGROUP]

API Actions

INSTALL
Install

PARM(' [NOTIFY(value)] USAGE(value) [FORCEINS(value)] [STATECHK(value)] [MODE(value)] [OVERTYPE(value)] [OVERRIDE(override)] TARGET(value) [RELATED(value)] .')

ADDTOGRP
Add to resource group

PARM(' [ERRQUEUE] RESGROUP(value) .')

Table 99. DB2CDEF FEEDBACK error codes
Code Description Code Description
DIFF_VERSION Different version INV_RESTYPE Invalid resource type
EARLY_NAMELIST_END Early name list end INV_RSCOPE Invalid related scope
INCONSISTENT_SET Inconsistent set condition INV_STATECHK Invalid state check
INV_ACTION Invalid action INV_STRNGTERM Invalid string terminator
INV_ATTRIBUTE Invalid attribute INV_TSCOPE Invalid target scope
INV_CONTEXT Context not found INV_USAGE Invalid usage
INV_DATA Attribute data invalid INV_VER Invalid resource version
INV_EMBEDTERM Invalid embedded terminator MISSING_RELSYSID Missing related system identifier
INV_FORCEINS Invalid force install MORE_THAN_1_RELSYS More than one related system
INV_LITERAL Invalid literal NODEFS_SELECTED No definitions selected
INV_MINNAME Invalid minor name NON_MP Maintenance point CMAS not available
INV_MODE Invalid mode NOTHING_INSTALLED Nothing installed
INV_NAME Invalid name NOTIFY Notify
INV_NAMELIST Invalid name list NO_RELATED No related systems
INV_NOTIFY Invalid notify NO_TARGETS No targets
INV_ORSTGNA Invalid override string PARTIAL_INSTALL Partial install
INV_ORSTRING Invalid override string REC_CHANGED Resource definition already changed
INV_OVERTYPE Invalid over type REC_EXISTS Resource already exists
INV_OVRBLOCK Invalid override block REC_NOT_FOUND Requested resource not found
INV_RECADDR Invalid record address SCOPE_CONFLICT Scope conflict
INV_RECLEN Invalid record length SCOPE_REQUIRED Scope required
INV_RESGROUP Resource group not found USAGE_CONFLICT Usage conflict
Table 100. DB2CDEF resource table attributes
Name Datatype Source Len Req Sum Description Default Value Range Attr ID
CHANGETIME DATETIME CPSM 8 Yes MAX Last time the definition was changed 1
 DEFVER-2  BINARY CPSM 1 Yes AVG Definition version 0 0-15 5
 NAME-1  CHAR CPSM 8 Yes DIF DB2 connection definition name 7
CONNECTERROR CVDAS CPSM 4 Yes LIKE Connection error processing option SQLCODE 9
CONNECTERROR Input/Output Valid Values ABEND SQLCODE
DB2ID CHAR CPSM 4 No DIF DB2 subsystem ID 10
MSGQUEUE1 CHAR CPSM 4 Yes DIF Unsolicited error message TDQ name 1 CDB2 11
MSGQUEUE2 CHAR CPSM 4 No DIF Unsolicited error message TDQ name 2 12
MSGQUEUE3 CHAR CPSM 4 No DIF Unsolicited error message TDQ name 3 13
NONTERMREL EYUDA CPSM 4 Yes LIKE Non-terminal transaction thread-release option YES 14
NONTERMREL Input/Output Valid Values YES NO
PURGECYCLEM CHAR CPSM 2 Yes DIF Protected thread purge cycle (minutes) 0 0-59 15
PURGECYCLES CHAR CPSM 2 Yes DIF Protected thread purge cycle (seconds) 30 0-59 16
SIGNID CHAR CPSM 8 No DIF Authorization ID used by CICS-DB2 attach 17
STANDBYMODE CVDAS CPSM 4 Yes LIKE Standby mode RECONNECT 18
STANDBYMODE Input/Output Valid Values RECONNECT NOCONNECT CONNECT
STATSQUEUE CHAR CPSM 4 Yes DIF Attachment statistics TDQ name CDB2 19
TCBLIMIT CHAR CPSM 4 Yes DIF Maximum number of subtask TCBs 12 4-2000 20
THREADERROR CVDAS CPSM 4 Yes LIKE Action following thread error N906D 21
THREADERROR Input/Output Valid Values ABEND N906D N906
ACCOUNTREC CVDAS CPSM 4 Yes LIKE Accounting record option NONE 22
ACCOUNTREC Input/Output Valid Values NONE UOW TASK TXID
AUTHID CHAR CPSM 8 No DIF Pool thread authorization ID 23
AUTHTYPE CVDAS CPSM 4 Yes LIKE Pool thread authorization type NOTAPPLIC 24
AUTHTYPE Input/Output Valid Values USERID GROUP TERM TX OPID SIGN NOTAPPLIC
DROLLBACK EYUDA CPSM 4 Yes LIKE Deadlock resoultion rollback option YES 25
DROLLBACK Input/Output Valid Values YES NO
PLAN CHAR CPSM 8 No DIF Name of plan used for pool 26
PLANEXITNAME CHAR CPSM 8 No DIF Name of dynamic plan exit used for pool threads DSNCUEXT 27
PRIORITY CVDAS CPSM 4 Yes LIKE Subtask priority HIGH 28
PRIORITY Input/Output Valid Values HIGH LOW EQUAL
THREADWAIT EYUDA CPSM 4 Yes LIKE Thread wait option YES 29
THREADWAIT Input/Output Valid Values YES NO
THREADLIMIT CHAR CPSM 4 Yes DIF Maximum number of pool threads 3 3-2000 30
COMTHREADLIM CHAR CPSM 4 Yes DIF Maximum number of command threads 3 0-2000 31
COMAUTHID CHAR CPSM 8 No DIF Command thread authorization ID 32
COMAUTHTYPE CVDAS CPSM 4 Yes LIKE Command thread authorization type NOTAPPLIC 33
COMAUTHTYPE Input/Output Valid Values USERID GROUP TERM TX OPID SIGN NOTAPPLIC
CREATETIME DATETIME CPSM 8 Yes MAX Definition create time 34
USERDATA1 CHAR CPSM 8 No DIF User data area 1 35
USERDATA2 CHAR CPSM 8 No DIF User data area 2 36
USERDATA3 CHAR CPSM 8 No DIF User data area 3 37
DESCRIPTION CHAR CPSM 58 No DIF Definition description 38
DB2GROUPID CHAR CPSM 4 No DIF DB2 data sharing group ID 40
RESYNCMEMBER EYUDA CPSM 4 Yes LIKE Resynchronization member YES 41
RESYNCMEMBER Input/Output Valid Values YES NO
[[ Contents Previous Page | Next Page Index ]]