Full details of how to use the DEFINE FILE command to define files are given in the CICS® Resource Definition Guide. Only the parameters that relate to data tables are described in this section.
specify TABLE(USER) to define the file as a user-maintained data table
If you do not specify the TABLE parameter, or specify TABLE(NO), or TABLE(CF), the file is not defined as a CICS shared data table.
For a CICS-maintained data table, this name is used to refer to both the data table and the source data set, which are treated as a single entity by CICS.
For a user-maintained data table, this name is used to refer to only the data table.
Remember that the data table is loaded when the file is opened, so if you are using the user exit XDTRD, make sure that the user exit is activated before the file is opened (see Activating user exits for data tables).
RECORDFORMAT(V) is assumed by default. A user-maintained data table must have variable-length records.
For a user-maintained data table, only dynamic transaction backout is supported by CICS, so RECOVERY(BACKOUTONLY) and RECOVERY(ALL) have the same meaning.
For a CICS-maintained data table, the RECOVERY parameter applies to the source data set; it must be consistent with any other file definition for the same data set.
The recovery attributes of a user-maintained data table are totally independent of any recovery attributes that its source data set may have.
When you define a user-maintained data table, you specify its recovery attributes on the file definition by specifying either RECOVERY(NONE) if it is to be non-recoverable, or RECOVERY(BACKOUTONLY|ALL) if it is to be recoverable after a transaction failure.
The source data set for the user-maintained data table can be non-recoverable, recoverable for backout only (after both transaction and system failures), or forward recoverable, regardless of what you have specified for the user-maintained data table.
The source data set can acquire its recovery attributes in one of two ways:
The following example shows the definition of a CICS-maintained data table. Only the relevant parameters are shown.
File ==> APPLE Group ==> FRUIT DEscription ==> VSAM PARAMETERS DSNAme ==> CIC01.CICOWN.APPLES Password ==> PASSWORD NOT SPECIFIED RLSACCESS ==> NO YES|NO Lsrpoolid ==> 2 1-8 | None READINTEG ==> UNCOMMITTED UNCOMMITTED|CONSISTENT|REPEATABLE DSNSharing ==> Allreqs Allreqs | Modifyreqs STRings ==> 005 1 - 255 Nsrgroup ==> REMOTE ATTRIBUTES REMOTESystem ==> REMOTEName ==> REMOTE AND CFDATATABLE PARAMETERS RECORDSize ==> 00080 1-32767 Keylength ==> 006 1-255 (1-16 For CF Datatable) INITIAL STATUS STAtus ==> Enabled Enabled | Disabled | Unenabled Opentime ==> Startup Firstref | Startup DIsposition ==> Share Share | Old BUFFERS DAtabuffers ==> 00002 2 - 32767 Indexbuffers ==> 00001 1 - 32767 DATATABLE PARAMETERS TABLE ==> CICS No | Cics | User | CF Maxnumrecs ==> 1000000 Nolimit | 1-99999999 CFDATATABLE PARAMETERS Cfdtpool ==> TABLEName ==> UPDATEModel ==> Locking Contention | Locking LOad ==> No No | Yes DATA FORMAT RECORDFormat ==> F V | F OPERATIONS Add ==> Yes No | Yes BRowse ==> No No | Yes DELete ==> Yes No | Yes REAd ==> Yes Yes | No Update ==> Yes No | Yes AUTO JOURNALING JOurnal ==> No No | 1 - 99 JNLRead ==> None None | Updateonly | Readonly | All JNLSYNCRead ==> No No | Yes JNLUpdate ==> No No | Yes JNLAdd ==> None None | Before | AFter |ALl JNLSYNCWrite ==> Yes Yes | No RECOVERY PARAMETERS RECOVery ==> All None | Backoutonly | All Fwdrecovlog ==> 10 No | 1-99 BAckuptype ==> STAtic STAtic | DYNamic SECURITY RESsecnum : 00 0-24 | Public
The following example shows the definition of a user-maintained data table. Only the relevant parameters are shown.
File ==> COURGETT Group ==> VEGS DEscription ==> VSAM PARAMETERS DSNAme ==> CIC02.CICOWN.COURGETT Password ==> PASSWORD NOT SPECIFIED RLSACCESS ==> NO YES|NO Lsrpoolid ==> 5 1-8 | None READINTEG ==> UNCOMMITTED UNCOMMITTED|CONSISTENT|REPEATABLE DSNSharing ==> Allreqs Allreqs | Modifyreqs STRings ==> 005 1 - 255 Nsrgroup ==> REMOTE ATTRIBUTES REMOTESystem ==> REMOTEName ==> REMOTE AND CFDATATABLE PARAMETERS RECORDSize ==> 00080 1-32767 Keylength ==> 006 1-255 (1-16 For CF Datatable) INITIAL STATUS STAtus ==> Enabled Enabled | Disabled | Unenabled Opentime ==> Firstref Firstref | Startup DIsposition ==> Share Share | Old BUFFERS DAtabuffers ==> 00002 2 - 32767 Indexbuffers ==> 00001 1 - 32767 DATATABLE PARAMETERS TABLE ==> User No | CIcs | User | CF Maxnumrecs ==> 2000000 Nolimit | 1-99999999 CFDATATABLE PARAMETERS Cfdtpool ==> TABLEName ==> UPDATEModel ==> Locking Contention | Locking LOad ==> No No | Yes DATA FORMAT RECORDFormat ==> V V | F OPERATIONS Add ==> Yes No | Yes BRowse ==> Yes No | Yes DELete ==> No No | Yes REAd ==> Yes Yes | No Update ==> Yes No | Yes AUTO JOURNALING JOurnal ==> No No | 1 - 99 JNLRead ==> None None | Updateonly | Readonly | All JNLSYNCRead ==> No No | Yes JNLUpdate ==> No No | Yes JNLAdd ==> None None | Before | AFter |ALl JNLSYNCWrite ==> Yes Yes | No RECOVERY PARAMETERS RECOVery ==> Backoutonly None | Backoutonly | All Fwdrecovlog ==> No No | 1-99 BAckuptype ==> STAtic STAtic | DYNamic SECURITY RESsecnum : 00 0-24 | Public