CEMT INQUIRE FILE

Retrieve information about VSAM, BDAM, and remote files, and files that refer to data tables.

In the CICS Explorer, the Files operations view provides a functional equivalent to this command.

Description

The values that are returned to you can vary depending on when the command is issued. For example, if the file is closed when you issue the command, much of the information you receive is about the state of the file when it is next opened. If the file has never been opened, you receive default or null values for some options, which might change when the file is opened.

The resource signature

You can use this command to display the resource signature fields. You can use these fields to manage resources by capturing details of when the resource was defined, installed, and last changed. For more information, see Auditing resources. The resource signature fields are CHANGEAGENT, CHANGEAGREL, CHANGETIME, CHANGEUSRID, DEFINESOURCE, DEFINETIME, INSTALLAGENT, INSTALLTIME, and INSTALLUSRID. See Summary of the resource signature field values for detailed information about the content of the resource signature fields.

Input

Press the Clear key to clear the screen. You can start this transaction in two ways:

Type CEMT INQUIRE FILE (or suitable abbreviations for the keywords). The resulting display lists the current status of all files installed.
Type CEMT INQUIRE FILE (or suitable abbreviations for the keywords), followed by the attributes that are necessary to limit the range of information that you require. For example, if you enter cemt i fi v op en up, the resulting display shows the details of only those files that are VSAM, open, enabled, and can be updated.

You can tab to the highlighted or blank fields and overtype them with the required values.

(value): Specifies one or more names (1 - 8 characters) of files defined to CICS®.
ALL: The default. Information about all files is given, unless you specify a selection of files to be queried.

Sample screen

Figure 1. CEMT INQUIRE FILE screen

  IN FILE
  STATUS:  RESULTS - OVERTYPE TO MODIFY
   Fil(DFHCMACD) Vsa Ope Ena Rea                     Sha
          Dsn( CICSTS52.CICS.DFHCMACD                             )
   Fil(DFHCSD  ) Vsa Clo Une Rea Upd Add Bro Del     Sha
          Dsn( CICSTS52.CICS.CICSH.DFHCSD                         )
   Fil(DFHDBFK ) Vsa Clo Ena Rea Upd Add Bro Del     Sha
   Fil(DFHLRQ  ) Vsa Ope Ena Rea Upd Add Bro Del     Sha
          Dsn( CICSTS52.CICS.CICSH.DFHLRQ                         )
   Fil(FILEA   ) Vsa Clo Ena Rea Upd Add Bro Del     Sha
          Dsn( CICSTS52.CICS.CICSH.FILEA                          ) Cft Loa

Note: When a value does not apply, or is negative (the value begins with No), the fields on the screen are blank. To modify these fields, locate them by tabbing (they appear in the same sequence as in the expanded format), and overtype with input valid for that field. You might find it more convenient to use the expanded format when setting one of these values.

If you place the cursor against a specific entry in the list and press ENTER, CICS displays an expanded format, as shown in Figure 2.

Figure 2. The expanded display of an individual entry

  INQ FILE
  RESULT - OVERTYPE TO MODIFY
    File(DFHCSD)
    Accessmethod(Vsam)
    Openstatus( Closed )
    Enablestatus( Unenabled )
    Readstatus( Read )
    Updatestatus( Update )
    Addstatus( Addable )
    Browsestatus( Browse )
    Deletestatus( Delete )
    Exclstatus(              )
    Disposition( Share )
    Rlsaccess( Notrls )
    Emptystatus( Noemptyreq )
    Dsname( CICSTS52.CICS.CICSH.DFHCSD )
    Table( Nottable )
    Loadtype( Noload )
    Cfdtpool(          )
 +  Tablename(          )
    Updatemodel(         )
    Maxnumrecs( 00000000 )
    Keylength( 000 )
    Recordsize( 00000 )
    Rbatype( Notapplic )

CEMT INQUIRE FILE

Displayed fields

ACCESSMETHOD

Displays the access method of the file.

VSAM: Virtual storage access method (VSAM).
BDAM: Basic direct access method (BDAM).
REMOTE: The file is defined as remote.

ADDSTATUS

Displays whether new records can be added to the file. The values are as follows:

ADDABLE: New records can be added to the file.
NOADDABLE: New records cannot be added to the file.

BROWSESTATUS

Displays whether you can browse the file.

BROWSE: You can browse records in the file.
NOBROWSE: You cannot browse records in the file.

CFDTPOOL (name)

Displays, for a file that refers to a coupling facility data table, the 8-character name of the coupling facility data table pool in which the CFDT resides.

If the pool name is not defined, the name is displayed as eight blanks. If the pool name is specified, it is always displayed even if the file definition does not refer to a coupling facility data table.

CHANGEAGENT(value)

Displays a value that identifies the agent that made the last change to the resource definition. You cannot use CEMT to filter on some of these values because they are duplicated. The possible values are as follows:

CREATESPI: The resource definition was last changed by an EXEC CICS CREATE command.
CSDAPI: The resource definition was last changed by a CEDA transaction or the programmable interface to DFHEDAP.
CSDBATCH: The resource definition was last changed by a DFHCSDUP job.
DREPAPI: The resource definition was last changed by a CICSPlex SM BAS API command.
FCT: The resource definition was last changed by a File Control table definition.
SYSTEM: The resource definition was last changed by the CICS or CICSPlex system.

CHANGEAGREL(value)

Displays the 4-digit number of the CICS release that was running when the resource definition was last changed.

CHANGETIME(date time)

Displays the date and time when the resource definition was last changed. The format of the date depends on the value that you selected for the DATFORM system initialization parameter for your CICS region. The format of the time is hh:mm:ss.

CHANGEUSRID(value)

Displays the 8-character user ID that ran the change agent.

DEFINESOURCE(value)

Displays the source of the resource definition. The DEFINESOURCE value depends on the CHANGEAGENT option. For details, see Summary of the resource signature field values.

DEFINETIME(date time)

Displays the date and time when the resource was created. The format of the date depends on the value that you selected for the DATFORM system initialization parameter for your CICS region. The format of the time is hh:mm:ss.

DELETESTATUS

Displays whether you can delete records from the file.

DELETE: You can delete records from the file.
NODELETE: You cannot delete records from the file.

DISPOSITION

Displays the disposition of this file.

OLD: The disposition of the data set associated with the file is defined as unshared for dynamic allocation.
SHARE: The disposition of the data set associated with the file is defined as shared for dynamic allocation.

DSNAME (value)

Displays the name (1- 44 characters) of the VSAM or BDAM data set with which this file is associated.

For a coupling facility data table, CICS displays the name of the source data set if the file specifies that the table is initially loaded from a data set; otherwise, CICS displays blanks.

CICS also displays blanks for files that have their DSNAME specified on a DD statement in the CICS JCL if the file has not been opened since the last cold or initial start.

EMPTYSTATUS (VSAM only)

Displays whether the data set is emptied when a file that references it is next opened. This field is valid only for data sets that are defined as reusable and are accessed in non-RLS mode. The values are as follows:

EMPTYREQ: Applies only to a VSAM file that is defined to VSAM as a cluster with the REUSE parameter. It indicates that when a file is next opened, its data is erased.
NOEMPTYREQ: Applies only to VSAM files. It indicates that when a file is next opened, its data is not erased.

ENABLESTATUS

Displays whether transactions can access the file.

ENABLED

The file is available for use by transactions and, if closed, it is opened on the first request.

UNENABLED

The file is not available for use by transactions except for those that are currently using it. If there are any such users, BEING CLOSED is also displayed.

This status is the same as DISABLED except that it occurs implicitly when a SET FILE CLOSE is requested. The file is enabled implicitly by a SET FILE OPEN command.

DISABLED

The file is not available for use by transactions except for those that are currently using it. If there are any such users, BEING DISABLED is also displayed.

The file can be reenabled by a SET FILE ENABLED command. See also UNENABLED.

You cannot disable a remote file.

EXCLSTATUS (BDAM only)

Displays whether records on this file are placed under exclusive control when a read for update is issued.

EXCLUSIVE: Records on the file are protected from simultaneous update.
NOEXCLUSIVE: Records on the file are not protected from simultaneous update.

FILE (value)

Indicates that this panel relates to a file inquiry and displays an 8-character file name.

INSTALLAGENT(value)

Displays a value that identifies the agent that installed the resource. You cannot use CEMT to filter on some of these values because they are duplicated. The possible values are as follows:

BUNDLE: The resource was installed by a bundle deployment.
CREATESPI: The resource was installed by an EXEC CICS CREATE command.
CSDAPI: The resource was installed by a CEDA transaction or the programmable interface to DFHEDAP.
FCT: The resource was installed by using a File Control table definition.
GRPLIST: The resource was installed by GRPLIST INSTALL.
SYSTEM: The resource was installed by the CICS or CICSPlex SM system.

INSTALLTIME(date time)

Displays the date and time when the resource was installed. The format of the date depends on the value that you selected for the DATFORM system initialization parameter for your CICS region. The format of the time is hh:mm:ss.

INSTALLUSRID(value)

Displays the 8-character user ID that installed the resource.

KEYLENGTH (value)

Displays the length of the record key for a file associated with a VSAM KSDS or a file associated with a coupling facility data table. If the file is associated with a BDAM data set, the value is the length of the logical key used for deblocking. The KEYLENGTH attribute is valid only for remote files and coupling facility data tables. CICS returns zero for local files which are closed.

Note:

If the file is closed and the key length is not defined in the file definition, CICS displays a zero value.
If the file is closed and a key length is defined on the file definition, CICS displays the value from the file definition.
Generally, if a file is open, CICS obtains the key length from the associated data set, in which case CICS displays the value from the data set. However, files that refer to coupling facility data tables defined with LOAD(NO) must get their key length from the file definition, in which case CICS returns the defined value when the file is open. This value must also match that of the coupling facility data table if it has already been created.

LOADTYPE

Displays the load type for a coupling facility data table.

LOAD: The coupling facility data table is, or will be, preloaded from a source data set.
NOLOAD: The coupling facility data table is not preloaded from a source data set.

MAXNUMRECS (value)

Displays the maximum number of records that the data table for this file can hold.

Note:

If the file resource definition specifies a MAXNUMRECS numeric value, even though the object is not a table (NOTTABLE is displayed on the TABLE option), CICS displays the specified value. The value can be in the range 1 - 99999999.
If the file resource definition is specified with MAXNUMRECS(NOLIMIT), meaning the number of records is unlimited, CICS displays a value of zero. (Internally, CICS holds NOLIMIT as the maximum positive fullword value (+2147483647 or X'7FFFFFFF').
If the file is remote, CICS displays a value of minus 1 (-1).
If the object is a coupling facility data table, note these points:
- The maximum number of records can be altered by a coupling facility data table server command, leaving the file definition MAXNUMRECS value unchanged. CICS displays the value in the file definition until the file is opened, after which CICS displays the MAXNUMRECS value defined to the server.
- If the value is changed again by a coupling facility data table server command, CICS obtains and displays the new value only after a file control operation on the table. Until then, CICS continues to display the old value.
- You can use the server DISPLAY TABLE console command to obtain the current value for a coupling facility data table.

Note: You can reset this value by overtyping it with a different value. The new value takes effect only when a new data table is created (which happens on each file open for a CICS-maintained or user-maintained data table, but only when the table does not already exist for a CF data table).

OPENSTATUS

Displays the open status of the file.

OPEN

The file is open. If the file is OPEN ENABLED, it is available for data accesses by CICS transactions. If it is OPEN DISABLED, it must first be enabled before it is available.

CLOSED

The file is closed; the access method does not allow accesses to the data until the file is opened. The file can be opened either explicitly by the user or, if the file has the ENABLED attribute, implicitly by CICS on the next reference to the file.

A file with the DISABLED attribute can be enabled only by a SET FILE ENABLED command. A file with the UNENABLED attribute can be enabled by a SET FILE ENABLED command or SET FILE OPEN command.

The CLOSED status might be a temporary status for a file that has just come out of LOADMODE status.

You can reset this value by overtyping it with one of the above OPENSTATUS values, or with:

FORCECLOSE: Specifies that the file is to be closed, and the tasks of any existing users of the file are to be stopped.

RBATYPE(value)

Displays whether, for VSAM files, the data set uses extended addressing.

EXTENDED

This VSAM data set uses extended relative byte addressing and therefore can hold more than 4 gigabytes of data.

NOTAPPLIC

One of the following is true:

The data set is BDAM.
The file is remote.
The file is not open.

NOTEXTENDED

This VSAM data set does not use extended relative byte addressing and therefore cannot hold more than 4 gigabytes of data.

You cannot modify the contents of this field.

READSTATUS

Displays whether you can read records from the file.

READ: You can read records in the file.
NOREAD: You cannot read records in the file.

RECORDSIZE (value)

Displays the actual size of fixed-length records, or the maximum size of variable-length records.

If the file is not open, CICS displays the value specified in the installed file definition. If the file definition does not specify a record size, CICS displays a zero value.

Generally, if a file is open, CICS obtains the record size from the associated data set, in which case CICS displays the value from the data set. However, files that refer to coupling facility data tables defined with LOAD(NO) must get their record size from the file definition, in which case CICS returns the defined value when the file is open. This value must also match that of the coupling facility data table if it has already been created.

RLSACCESS (VSAM only)

Displays whether the file is defined to be accessed in RLS mode.

RLS: The file is defined to be accessed in RLS mode.
NOTRLS: The file is defined to be accessed in a non-RLS mode (LSR or NSR)

TABLE

Displays whether the file name specified on the FILE parameter represents a data table.

NOTTABLE: The file name does not represent a data table.
CFTABLE: The file name represents a coupling facility data table.
CICSTABLE: The file name represents a CICS-maintained data table.
USERTABLE: The file name represents a user-maintained data table.

TABLENAME (value)

Displays the table name specified for the coupling facility data table on the file resource definition, if one is specified, or displays the file name if no table name was specified on the file resource definition.

CICS displays blanks if the file does not refer to a coupling facility data table

UPDATEMODEL (CFDT ONLY)

Displays the update model specified for the coupling facility data table in the installed file definition.

CONTENTION: The coupling facility data table is updated using the contention model.
LOCKING: The coupling facility data table is updated using the locking model.

UPDATESTATUS

Displays whether the file is updatable.

UPDATE: You can update records in the file.
NOUPDATE: You cannot update records in the file.