Share tables between operational and archive companies

Tools > Database Management > Database Definitions and Directories

You must share the tccom000, tttxt004, and tttxt005 tables between your operational companies and archive companies.

  1. To share the tccom000 table between the operational company and archive company, use the Logical Tables (ttaad4120m000) session. In this session, the operational company is the physical company and the archive company is the logical company.
  2. Share the Text Windows tttxt004 and Text Groups tttxt005 tables in the same way.
Note: 
  • The changes will only take effect after you convert to runtime and restart the LN application (bshell).
  • If additional tables must be linked, one or more reference fields in the operational and archive companies are cleared. Typically, when you start an archiving session, one of the initial steps is to copy the general data. In some archiving sessions, this step is optional, however, in several other archiving sessions, this step is mandatory. During this copying process, some of these general data tables are copied twice from the operational company to the archive company. In the first copy process, specific reference fields in the archive company are cleared. When you copy the table the second time, all data is copied from the operational company to the archive company. This special copying process is required to prevent reference errors during the copying process.

    This process can technically be read in the script tcmcsdll0008 where, for some tables, the following two functions are listed to perform the copy process:

    • tccom.dll0025.archive.table

    • tccom.dll0026.archive.table

      This function also calls function empty.ref.fields, which clears one or more reference fields for the specified table.

  • Tables tccom000, tttxt004, and tttxt005 must always be linked. For all related multicompany companies and archive companies, these tables must be linked to the same operational company.