Procedure details

  1. Create target companies.

    Create the target companies through the Companies (ttaad1100m000) session.

    From the appropriate menu, select Convert to Runtime to make the changes active at runtime. Restart your bshell to load the new settings.

  2. Define logical tables for target companies.

    Take this step only if logical tables are defined for one or more source companies. To define logical tables for a target company, you must update the actual table sharing so that the target company is also shared correctly. You can perform this update action in two ways:

    1. Update the actual table sharing set

      Copy the actual table sharing set to a new version. Add the table relations for the table sets to relate the new target company to the physical company. Make the new version of the table sharing set actual.

      Note: 

      If no actual table sharing set exists, you must perform the update through the Import from logical tables step as described below. To check for the actual table sharing set, use the Table Sharing Sets (tltsm1115m009) session.

    2. Import from logical tables

      In the Table Sharing Sets (tltsm1115m009) session, run the Import from Logical Tables command. A new table sharing set is created that matches the settings defined in logical tables.

    After you have defined the logical tables for the target companies, you must convert the changes to the runtime data dictionary and restart your bshell to load the new settings.

    Note: 

    The tccom000 (Implemented Software Components) table and its reference tables such as tcmcs010 (Countries) and tccom130 (Addresses), contain data that must be shared by all companies, including the central DEM company, if DEM modeling is used, in the new multicompany structure. These tables must be stored physically in only one company in the new structure. The corresponding logical tables in the remaining companies in the new structure must therefore all be linked to the same physical company.

    For example, the new multicompany structure consists of companies 600, 601, 602 and 603. Tccom000 and its reference tables are physically stored in company 600. The corresponding logical tables in companies 601, 602, and 603 must therefore all be linked to physical company 600.

  3. Export data from source companies.

    Run the Create Sequential Dump of Table (ttaad4226m000) session to export the data of the source companies to sequential files.

    For each source company, the sequential files must be stored in a separate directory, for example directory /tmp/500 for company 500, directory /tmp/501 for company 501. Therefore you must export data from only one source company at a time and store the sequential files in the corresponding directory.

    You must export the data of all packages, except the Enterprise Modeling (tg) package. Therefore you must run the session twice for each source company: the first time to export data for packages in the range aa-tf; the second time to export data for the packages th-zz.

    To export data for a source company:

    • Run the Create Sequential Dump of Table (ttaad4226m000) session.

      Points of attention:

      • Select the source company (only one company) from which data must be exported.
      • Select the range of packages for which data must be exported: aa-tf
      • Select the full range of tables: <empty> - zzz999.
      • Clear the Drop Table after Dump check box.
      • Specify a field separator. This can be a pipe (|), or a caret followed by a single uppercase alphabetical character: ^A, ^B, and so on.
      • Enter the directory where the sequential files must be stored. It is recommended to enter the company number as (part of) the directory name. For example: use directory /tmp/500 to store the sequential files of company 500. Note: if the specified directory does not exist, you must create it first.
      • Specify the name of the error file to which all error messages and statistics information must be written.
    • Run the Create Sequential Dump of Table (ttaad4226m000) session again. Use exactly the same settings as were used during the first export, except:

      • Range of packages: th-zz
      • Enter a different name for the error file. If you use the same name, the first error file is overwritten by the second one.

    Repeat these two steps for each source company that must be copied.

  4. Correct company numbers.

    The exported company data contains various references to the source company numbers. For example: the records that are exported from the Implemented Software Components (tccom000) table contain a reference to the company number of the source company.

    Run the Copy Company Data (tccom0214m000) session to correct these references in the sequential files, so that they refer to the target companies into which the data will be imported.

    Points of attention:

    • You must run this session from each source company. For example, you copy data from source companies 500 and 501 to target companies 600 and 601 respectively. After exporting data from the source companies you must:
      • Switch to company 500 and run this session to correct the references in the files that were exported from company 500: all references to company 500 and 501 must be replaced with references to company 600 and 601 respectively.
      • Switch to company 501 and run this session to correct the references in the files that were exported from company 501: all references to company 500 and 501 must be replaced with references to company 600 and 601 respectively.
    • Specify the field separator that is used in the sequential files: this is the same separator as the one that was specified during the export in the Create Sequential Dump of Table (ttaad4226m000) session.
    • Enter the source company numbers, and the corresponding target company numbers by which they must be replaced, in the Companies to Copy field. Refer to the Help of this field for details.
    • Leave the Enterprise Units to Copy field blank, because you copy an existing multicompany structure, including the central DEM company. In this case, the target companies use the new, target central DEM company. The enterprise units used in the target companies will have the same codes as the enterprise units used in the source companies. You do not need to change the enterprise unit codes because they are unique in the new target central DEM company.
  5. Import data into target companies.

    Run the Create Table from Sequential Dump (ttaad4227m000) session to import the contents of the sequential files into the target companies.

    You can only load data into a single company at a time; therefore you must repeat this session for each target company.

    Points of attention:

    • Select the Create Tables for Different Company check box and specify the target company number.
    • The target company is a new company without any tables. Therefore you must clear the Append if Table Exists and Delete Existing Tables check boxes.
    • Select the Create Rows before Index and Ignore Referential Integrity Constraints check boxes.
    • Specify the field separator that is used in the sequential files: this is the same separator as the one that was specified during the export in the Create Sequential Dump of Table (ttaad4226m000) session.
    • Specify the directory where the sequential files are stored. This is the same directory as the one that was specified during the export in the Create Sequential Dump of Table (ttaad4226m000) session.
    • Enter * in the Pattern to Match Table Names field, to load all sequential files.
    • Specify the name of the error file to which all error messages and statistics information must be written.

    After each import the Reorganize Tables (ttaad4225m000) session is started automatically. Do not reorganize the tables at this stage. Click Close to exit this session. The tables will be reorganized in the last step of this procedure.

    Check the error file when the import process is completed.

  6. Create missing tables for target companies.

    Run the Create Tables (ttaad4230m000) session to create missing tables for the target companies.

    Note:  If you do not use the DEM Modeler, you can skip step 7.
  7. Define the central DEM company for each target company.

    For each target company, repeat these steps:

    • Switch to the new target company.
    • Run the Central Company to store Enterprise Modeler Data (tgbrg0100s000) session. In this session you must enter the company number of the central DEM company of the target multicompany structure.

    Example: A multicompany structure, consisting of companies 500 (central DEM company), 501, 502 and 503, is copied to a new multicompany structure, consisting of companies 600, 601, 602 and 603. You must run the above mentioned session from each of the target companies, including company 600, to define company 600 as the central DEM Company.

  8. Reorganize tables and repair reference counters for target companies.

    Run the Reorganize Tables (ttaad4225m000) session to reorganize the tables and to repair the reference counters for all target companies.

    Select these check boxes:

    • Data and Indices
    • Reference Integrity
    • Repair Reference Counter