Transferring files to IBM z/OS for geodatabase setup

To create a geodatabase on DB2 version 9.1 for the z/OS system, you must transfer a dataset—esriobj.XMIT—to the target z/OS system. The esriobj.XMIT file can be found in the DB2zOS folder inside the DatabaseSupport folder of your ArcGIS client. The file contains images of programs that must be link-edited into load libraries on z/OS. The following steps are required to accomplish this setup:

Steps:
  1. Log in to a SYSADM user account ID on the z/OS system.
  2. Upload the dataset to the z/OS system using ftp.

    The data is in Time Sharing Option/Extension (TSO/E) Transmit/Receive format and must be uploaded to the z/OS using a BINARY transfer. You can find the dataset in the DatabaseSupport\DB2zOS folder in your ArcGIS installation directory on Windows.

  3. Assuming ftp is used for the transfer, the dataset must eventually be defined on z/OS with these characteristics:

    RECFM=FB,LRECL=80,BLKSIZE=3120

    Typically, ftp systems are set up such that for any data that is received and results in a new dataset, the resultant new dataset is not in the required format. However, that can be changed by using ftp commands. The command to ftp from Windows is

    quote site recfm=fb lrecl=80 blksize=3120
    

    If you are logged on to the z/OS and pull the files using ftp, the command is

    locsite recfm=fm lrecl=80 blksize=3120
    

    NoteNote:

    Be sure the ftp is in binary mode and type the command appropriate to your operating system.

  4. The dataset must be TSO/E RECEIVED by a user account on the z/OS system. Log on to a SYSADM user account ID on the z/OS system and open option 6 (the command panel) of Interactive System Productivity Facility (ISPF).
  5. The dataset that you uploaded is named esriobj.XMIT; therefore, issue the following TSO/E command to receive the dataset:

    RECEIVE INDA('SYSADM.ESRIOBJ.XMIT')
    

    A prompt for specification of dataset creation overrides is returned for this command. If you do not provide any overrides, the dataset will be created under the high-level qualifier (HLQ) of the user ID with which you logged in.

    You should now have a dataset in SCR03: <user>.ESRI.OBJLIB.

  6. Review the name of the dataset. If it is correct, it is to be referenced in the ESRI UDF installation job that must now be uploaded to z/OS, edited, and run on z/OS. See Creating databases in DB2 on z/OS for instructions.
11/6/2014