Copy general data using dump sessions

Tools > Database Management > Database Utilities

This topic is used to explain one of the alternative methods for archiving general data. The regular method is to archive the general data in a single step using the Archive General Data (tccom0250m000) session. See Archiving General Data.

Instruction (in operational or 0000 company):

Step 1. 

Export data from the operational company to a dump file using the Create Sequential Dump of Table (ttaad4226m000) session:

  1. Specify the (operational) company and a table or a range of tables for which you want to create a dump file.
  2. On the second tab of the session, specify the file name for the dump, and a file name for an error log. These two files will be written to your home directory or the directory specified in the Directory for Table Files field.

An extension will be automatically added to the file name of the dump; a dot followed by the company number.

Step 2. 

Import the data that you exported in the previous step into the archive company.

To load the previously created dump into the archive company, use the Create Table from Sequential Dump (ttaad4227m000) session:

  1. Select the Create Tables for Different Company check box and specify the company number of the new archive company.

    Select the Ignore Referential Integrity Constraints check box. If this check box is cleared, the result could be a 606 error when you create the table from the sequential dump. Therefore, the system may return the bdpost6.2 error message.

    In case of “Error in running bdbpost6.2”, the error file in the home directory shows the exact error message, which could look like the following:

    Default separator ('\0') taken

    Table M Idx RowCount Messages

    ----------- - --- -------- ----------------------

    tcmcs010999 R 1 1 write error 606

  2. Repeat the previous steps for all dumps of the mandatory tables that you created.

  3. Run the Reorganize Tables (ttaad4225m000) session with the Reference Integrity and Repair Reference Counter check boxes selected. The company number must be the company number of the archive company.