Invoking Extension Technology

The Data Express for Distributed Systems Tutorials demonstrates the default method for executing Extension Technology on a Windows platform using default mode.

This section walks you through configuration settings necessary for the execution of Extension Technology.

To invoke the Extension Technology:

  1. Copy the files generated by the Distributed Exporter from the output directory you specified, and paste them in the config subdirectory of the appropriate default data directory on Windows.
    Note: For a list of default directories, refer back to the section Data of the chapter Extension Technology Directories.
  2. Ensure that your data store environment is configured appropriately. If you are working with ODBC data stores, an ODBC Data Source Names (DSN) should be configured as required for your source and target data stores. If you will be executing the ODBC Extension from a UNIX environment, the ODBC driver manager and driver environment should be configured. Typically, this includes:
    • The ODBCINI environment variable should point to the ODBC configuration file.
    • The setting of the LIBPATH (AIX), SHLIB_PATH (HP/UX), or LD_LIBRARY_PATH (all other flavors of UNIX) environment variable should include the lib folder under your ODBC Driver Manager installation.
    • Implement other settings as defined by your ODBC/ODBC Driver Manager documentation.
      Note: If you will be executing the ODBC Extension from a UNIX environment, make sure that the UNIX ODBC DSN matches the ODBC DSN specified when you did the export on Windows. If you are making use of C or COBOL masking routines, verify that you have a development environment for building masking routines and a run-time environment for executing masking routines.
  3. Verify the Run-time Knowledge Base has been created and is configured with the appropriate privileges. For more information, see the sections Run-time Knowledge Base Requirements and User Credential Requirements of your Readme.
  4. Navigate to the executables directory, which contains the Extension Technology (ODBC Extension or Oracle Extension).
  5. Execute the appropriate command to invoke the Extension Technology:
    Mode Windows UNIX

    Default

    dxestart ./dxestart

    Parallel

    dxestart -d DirectoryName ./dxestart -d DirectoryName

    Unload

    dxeunload ./dxeunload
    Tip: dxeunload has the same syntax and format as dxestart. See The dxestart Utility for more information on using dxestart.

    The Extension Technology processes all the tables previously specified within Data Express, and reports a status for each data store, for example:

     Data Express Distributed Server 4.0.0
    c) Micro Focus (IP) Limited 2003-2009 
    Table xdb.SRC.CUSTOMER: 21 rows [##########] Reduced to 6 rows. 
    Table xdb.SRC.ORDERS: 5 rows [##########] Reduced to 3 rows. 
    Table xdb.SRC.ITEMS: 8 rows [##########] Reduced to 5 rows. 
    Data Express processing completed OK. 
  6. Use the Distributed Statistics Loader to populate run-time statistics into Data Subset Extraction. For more information, see section Distributed Statistics Loader of chapter Extension Technology Utilities.