ISAMReplicatorFileInfo

The ISAMReplicatorFileInfo utility is a DBL command-line application that produces the metadata required by the ISAM Agent. This metadata is then stored in the IsamFileMapping property within the master configuration file MasterConfig.json. On OpenVMS, it is temporarily stored in a file named <PROFILE>_FILES.JSON.

When you run the application, you'll see something like this:

When entering a file spec you must use the full file spec used by code to
access the file, and if either the origin or destination system is Linux"
then the entire file spec must be correctly cased.
You can also enter INPUT:\<file.to.read\> to process a list of files.

File spec: 

You can either enter the full file specification of a data file, like this:

DAT:employee.ism

or you can enter the file specification of an input file that contains a list of data files to be processed, like this:

INPUT:IsamAgentFiles.lis

In the latter case, the input file might look something like this:

# Files to be replicated by the ISAM Agent
DAT:department.ism  #Departments file
DAT:employee.ism    #Employee file

The input file may contain blank lines and comments preceded by #.

If you enter a single file spec, the name of the output file will be SIP_CONFIG:<FILENAME>_<FILEXTENSION>.JSON. For example, if the input file is DAT:EMPLOYEE.ISM, the output file will be SIP_CONFIG:EMPLOYEE_ISM.JSON.

If you enter an input file spec, the name of the output file will be SIP_CONFIG:FILES.JSON.

IMPORTANT: File specifications (including logical names) are case-sensitive on Linux. If either the origin or target systems are Linux, make sure all filenames are expressed appropriately. If the origin system is Linux, you must specify the file specifications correctly based on how the origin application will access them. If the target system is Linux but the origin system is not, define the file specifications as you want them to be on the target system.

Example Configuration

This is an example of the metadata that describes the EMPLOYEE.ISM file in the sample environment:

[
  {
    "Revision": 1,
    "Created": "20240901000000000000",
    "Enabled": true,
    "FileName": "EMPLOYEE.ISM",
    "FileSpec": "SIP_DAT:EMPLOYEE.ISM",
    "FileType": "ISAM",
    "RecordLength": 300,
    "FileAttributes": "FIXED,COMPRESS,DENSITY=50,PAGE=1024,TBYTE",
    "IsamKeys": [
      "START=1,LENGTH=8,NAME=EMP_ID,TYPE=DECIMAL,ORDER=A,DENSITY=50,NODUPS,NOMODIFY",
      "START=49,LENGTH=15,NAME=EMP_DEPT,ASCEND,DENSITY=50,DUPS,ATEND,MODIFY",
      "START=29,LENGTH=20,NAME=EMP_LAST_NAME,TYPE=NOCASE,ORDER=A,DENSITY=50,DUPS,ATEND,MODIFY",
      "START=218,LENGTH=2,NAME=STATE_CODE,TYPE=ALPHA,ORDER=A,DENSITY=50,DUPS,ATEND,MODIFY",
      "START=220,LENGTH=5,NAME=ZIP_CODE,TYPE=DECIMAL,ORDER=A,DENSITY=50,DUPS,ATEND,MODIFY"
    ],
    "IsamReplicationKeyNum": 0,
    "RequiresReplicationKey": false,
    "ReplicationKeyPosition": 0
  }
]