DB2TDEF Resource Table

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

The Primary key field for this resource class is NAME.

The Secondary key field for this resource class is DEFVER.

The Tertairy key field for this resource class is CSDGROUP.

The following actions are supported:
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
CICSDefinitionDb2Transaction
Length
152
Usage
API or Batch Utility or WUI or CICS Management Client Interface
API view
No
CMAS context
No
SCOPE applies
No
Only query CMASs in workload
No
Object type
CICS Definition
Copybook identifier
EYUt3819
Table 1. Valid CPSM operations
Operations Actions Parameters Required
GET   CICSSYS(value) No
    CSDGROUP(value) No
    RESGROUP(value) No
CREATE   CSD No
    RESGROUP(value) No
UPDATE   CSD No
REMOVE   CSD No
PERFORM SET 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
  ADDTOGRP RESGROUP(value) Yes
  CSDINSTALL None N/A
  CSDCOPY AS_RESOURCE(value) No
    DUPACTION(DUPERROR, DUPNOREPLACE, DUPREPLACE) No
    TO_CSDGROUP(value) No
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 Get Invalid Attr ID
CHANGEAGENT CVDAS CPSM 4 No LIKE Last modification agent     E640 E650 17
CHANGEAGENT Input/output valid values DREPAPI
CHANGEAGREL CHAR CPSM 4 No DIFF Last modification agent release     E640 E650 19
CHANGETIME DATETIME CPSM 8 Yes MAX Last modification time       1
CHANGEUSRID CHAR CPSM 8 No DIFF Last modification user ID     E640 E650 18
CREATETIME DATETIME CPSM 8 Yes MAX Time created       11
 CSDGROUP-3  CHAR CPSM 8 Yes DIFF CSD group     E640 E650 21
 DEFVER-2  BINARY CPSM 1 Yes AVG Version 0 0-15   5
DESCCODEPAGE BINARY CPSM 4 No DIFF Description code page 37 0-99999999   16
DESCRIPTION CHAR CPSM 58 No DIFF Description       15
ENTRY CHAR CPSM 8 Yes DIFF Name of associated DB2 entry       9
 NAME-1  CHAR CPSM 8 Yes DIFF Name       7
TRANSID CHAR CPSM 4 No DIFF Transaction ID associated with DB2 entry       10
USERDATA1 CHAR CPSM 8 No DIFF User data area 1       12
USERDATA2 CHAR CPSM 8 No DIFF User data area 2       13
USERDATA3 CHAR CPSM 8 No DIFF User data area 3       14