DB2TDEF Resource Table

A CICS® Definition that describes the relationship between a transaction and its related DB2® Entry.

The First key field for this resource is NAME.

The Second key field for this resource is DEFVER.

The Third key field for this resource is CSDGROUP.

The following actions are supported:
ADDTOGRP
Add to resource group
The parameter data for the ADDTOGRP action is: 
   PARM('RESGROUP(resgroup).')

     where:

     resgroup = The name of a RESGROUP definition.
CSDCOPY
Copy the CICS CSD resource definition in a CSD group into an different CSD group.
The parameter data for the CSDCOPY action is described in Managing CICS definitions in the CSD.
CSDINSTALL
Install the CICS CSD resource definition in a CSD group into an active system.
The parameter data for the CSDINSTALL action is described in Managing CICS definitions in the CSD.
INSTALL
Install a DB2 transaction definition.

The parameter data for the INSTALL action is described in Parameters for installing CICS definitions using BAS.

External resource name(CMCI)
CICSDefinitionDb2Transaction
Object type
CICS Definition
Length
152
Usage
API, Batch Utility, WUI, CICS Management Client Interface(CMCI)
API view
No
CMAS context
No
SCOPE applies
No
Only query CMASs in workload
No
Copybook identifier
EYUt3819
Security Class
OPERATE.DB2DBCTL
CICS Commands subject to CICS Security
INQUIRE DB2TRAN
Unsupported CICS Releases
None
Table 1. Valid CPSM operations
Operations Actions Parameters Required
CREATE   CSD No
    RESGROUP(value) No
GET   CICSGRP(value) No
    CICSSYS(value) No
    CSDGROUP(value) No
    RESGROUP(value) No
REMOVE   CSD No
UPDATE   CSD No
PERFORM SET, PERFORM OBJECT ADDTOGRP RESGROUP(value) Yes
  CSDCOPY AS_RESOURCE(value) No
    DUPACTION(DUPERROR, DUPNOREPLACE, DUPREPLACE) No
    TO_CSDGROUP(value) No
  CSDINSTALL None N/A
  INSTALL FORCEINS(YES, NO) No
    MODE(value) No
    NOTIFY(NO, INACTIVE, RELEASE, FULL) No
    OVERRIDE No
    OVERTYPE(TARGET, RELATED, BOTH, NONE) No
    RELATED(value) No
    STATECHK(YES, NO) No
    TARGET(value) Yes
    USAGE(LOCAL) Yes
Table 2. DB2TDEF FEEDBACK error codes
Value Code Description
1 DB2TDEF_INV_DATA Attribute data invalid
2 DB2TDEF_REC_NOT_FOUND Requested resource not found
4 DB2TDEF_REC_EXISTS Resource already exists
5 DB2TDEF_REC_CHANGED Resource definition already changed
6 DB2TDEF_INV_RESTYPE Invalid resource type
7 DB2TDEF_INV_VER Invalid resource version
11 DB2TDEF_NON_MP Maintenance point CMAS not available
12 DB2TDEF_INV_CONTEXT Context not found
13 DB2TDEF_INCONSISTENT_SET Inconsistent set condition
14 DB2TDEF_INV_RESGROUP Resource group not found
21 DB2TDEF_INV_ACTION Invalid action
22 DB2TDEF_INV_RECADDR Invalid record address
23 DB2TDEF_INV_RECLEN Invalid record length
24 DB2TDEF_DIFF_VERSION Different version
25 DB2TDEF_EARLY_NAMELIST_END Early name list end
26 DB2TDEF_INV_NAMELIST Invalid name list
27 DB2TDEF_INV_NAME Invalid name
28 DB2TDEF_INV_MINNAME Invalid minor name
29 DB2TDEF_NOTIFY Notify
30 DB2TDEF_PARTIAL_INSTALL Partial install
31 DB2TDEF_NOTHING_INSTALLED Nothing installed
32 DB2TDEF_NO_TARGETS No targets
33 DB2TDEF_NO_RELATED No related systems
34 DB2TDEF_INV_TSCOPE Invalid target scope
35 DB2TDEF_INV_RSCOPE Invalid related scope
36 DB2TDEF_INV_USAGE Invalid usage
37 DB2TDEF_INV_MODE Invalid mode
38 DB2TDEF_INV_STATECHK Invalid state check
39 DB2TDEF_INV_FORCEINS Invalid force install
40 DB2TDEF_INV_NOTIFY Invalid notify
41 DB2TDEF_INV_OVERTYPE Invalid over type
42 DB2TDEF_INV_OVRBLOCK Invalid override block
43 DB2TDEF_INV_ORSTRING Invalid override string
44 DB2TDEF_INV_STRNGTERM Invalid string terminator
45 DB2TDEF_INV_EMBEDTERM Invalid embedded terminator
46 DB2TDEF_INV_ATTRIBUTE Invalid attribute
47 DB2TDEF_INV_LITERAL Invalid literal
48 DB2TDEF_INV_ORSTGNA Invalid override string
49 DB2TDEF_SCOPE_REQUIRED Scope required
50 DB2TDEF_USAGE_CONFLICT Usage conflict
51 DB2TDEF_NODEFS_SELECTED No definitions selected
52 DB2TDEF_MORE_THAN_1_RELSYS More than one related system
53 DB2TDEF_MISSING_RELSYSID Missing related system identifier
54 DB2TDEF_SCOPE_CONFLICT Scope conflict
55 DB2TDEF_INV_CSDGROUP Invalid CSD group
56 DB2TDEF_REC_NOT_REMOVED Record not removed
57 DB2TDEF_INV_RESOURCE Invalid resource
58 DB2TDEF_INV_CICS_RESTYPE Invalid CICS restype
59 DB2TDEF_PARTIAL_ACTION Partial action
60 DB2TDEF_NOTHING_ACTIONED Nothing actioned
61 DB2TDEF_INV_BOTHTOAS TO_CSDGROUP and AS_RESOURCE are mutually exclusive
62 DB2TDEF_INV_NOTTOAS Either TO_CSDGROUP or AS_RESOURCE is required
63 DB2TDEF_CSD_ERROR CSD access error
Table 3. DB2TDEF resource table attributes
Name Datatype Source Len Req Sum Description Default Value Range GraphQL Field
 NAME-1  CHAR CPSM 8 Yes DIFF Name     name
 DEFVER-2  BINARY CPSM 1 Yes AVG Version 0 0-15 version
 CSDGROUP-3  CHAR CPSM 8 Yes DIFF CSD group     CSDGroup
CHANGEAGENT CVDAS CPSM 4 No LIKE Last modification agent     changeAgent
CHANGEAGENT Input/output valid values
  • CSDAPI
  • CSDBATCH
  • DREPAPI
  • N_A
CHANGEAGREL CHAR CPSM 4 No DIFF Last modification agent release     changeAgentRelease
CHANGETIME DATETIME CPSM 8 Yes MAX Last modification time     changeTime
CHANGEUSRID CHAR CPSM 8 No DIFF Last modification user ID     changeUserID
CREATETIME DATETIME CPSM 8 Yes MAX Time created     createTime
DESCCODEPAGE BINARY CPSM 4 No DIFF Description code page 37 0-99999999 desccodepage
DESCRIPTION CHAR CPSM 58 No DIFF Description     description
ENTRY CHAR CPSM 8 Yes DIFF Name of associated DB2 entry     DB2Entry
TRANSID CHAR CPSM 4 No DIFF Transaction ID associated with DB2 entry     transaction
USERDATA1 CHAR CPSM 8 No DIFF User data area 1     userdata1
USERDATA2 CHAR CPSM 8 No DIFF User data area 2     userdata2
USERDATA3 CHAR CPSM 8 No DIFF User data area 3     userdata3