Importing reference data for the first time

After you install and configure your FTM SWIFT system, the reference information for bank, currency and country data are empty. If you want to use reference data, you must import initial reference data.

  1. Download one of the following full packages from SWIFT:
    • A BICDirectory full package, which has a name of the form: 
      BICDIR_BICDB_FULL_yyyymmdd_TXT.zip
    • A BankDirectoryPlus package, which has a name of the form: 
      BANKDIRECTORYPLUS_yyyymmdd.zip
    • A BIC Directory 2018 package, which has a name of the form:
      BICDIR2018_yyyymmdd_TXT.zip
  2. Log on as a reference data administrator.
  3. Ensure, that the user has access to the dniprofile.
  4. Run the dniprofile: 
    . /var/ftmswift_v300/run/dniprofile
    This sets up the RDU environment. For convenience, this profile can be included in the personal login profile of the reference data administrator.
  5. Import data in one of the following ways:
    Import all types of data (bank, currency, and country) from a package with a single command
    Issue the dnprdu command for the full package (see Reference Data Utility command), for example:
    • To import data from a BICDirectory full package: 
      dnprdu -file BICDIR_BICDB_FULL_20100804_TXT.zip
       -dir /u/download/SWIFT/
       -logpath /u/download/SWIFT/RDULogFiles/
    • To import data from a BankDirectoryPlus package: 
      dnprdu -file BANKDIRECTORYPLUS_20130304.zip
       -dir /u/download/SWIFT/ 
       -logpath /u/download/SWIFT/RDULogFiles/
    The Reference Data Utility automatically processes the files consecutively, and creates three log files, one for each data file type.

    If the import of one data file fails, RDU imports the others. Refer to Restarting a failed import for information about how to manage a failed import.

    Import each type of data (bank, currency, and country) from a separate text file by issuing commands for each type of data
    Take the following actions:
    1. Ensure you have access to the individual input files.
    2. Issue the dnprdu command (see Reference Data Utility command) for each text file that is to be imported, for example to import BICDirectory data:
      dnprdu -file FI_20100905.txt
       -dir /u/download/SWIFT/BICDIR_BICDB_FULL_20100905_TXT/
       -logpath /u/download/SWIFT/RDULogFiles/

dnprdu -file CU_20100905.txt 
       -dir /u/download/SWIFT/BICDIR_BICDB_FULL_20100905_TXT/ 
       -logpath /u/download/SWIFT/RDULogFiles/

dnprdu -file CT_20100905.txt 
       -dir /u/download/SWIFT/BICDIR_BICDB_FULL_20100905_TXT/ 
       -logpath /u/download/SWIFT/RDULogFiles/

      The RDU creates a new log file each time the dnprdu command is issued.

  6. After importing the SWIFT directory, it is recommended to run the Db2® runstats utility to update the catalog statistics for the reference data tables in the DNIBICI table space.
  7. To make the updated data usable by FTM SWIFT, please see Activating reference data updates for message validation and Making reference data updates visible in MER and RMA enterprise applications.