Copy general data using bdbpre and bdbpost tools

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.

To copy the general data from your operational company into the archive company, you can compose an ASCII file such as copy.erpln.data, in which all required tables are listed. With this file and the bdbpre command, you can dump the tables in a dump file. With the bdbpost command, you can create tables from the dump file.

Instruction (UNIX or Windows system level):

  1. List the names of the required tables in one or more ASCII files, such as copy.erpln.data.

    List the names of the required tables in one or more ASCII files, such as copy.erpln.data.

  2. Export the data from the operational company (bdbpre) and then import the data into the archive company (bdbpost), using this syntax:

    Export the data from the operational company (bdbpre) and then import the data into the archive company (bdbpost), using this syntax:

    UNIX

    At the command prompt, enter the following:

    • export BSE= path
    • export BSE_TMP=$BSE/tmp
    • set USER= user name of operational company
    • bdbpre6.2 –Icopy.erpln.data –Oerplndata001.dmp –C001
    • bdbpost6.2 –R –f –n –c901 –Ierplndata001.dmp

    This will copy the data of the provided tables from company 001 to company 901.

    Windows

    On the server, at the command prompt, enter the following:

    • In the $BSE\bin directory: fillenv
    • set user= user name of operational company bdbpre –Icopy.erpln.data –Oerplndata001.dmp –C001
    • bdbpost –R –f –n –c901 –Ierplndata001.dmp

    This will copy the data of the provided tables from company 001 to company 901

    copy.erpln.data The ASCII file that contains the list of table names to be exported.

    Part of the contents might look like this:

    • tcccp000
    • tccom999
    • tcibd000
    • tcmcs000
    001 The company number of the operational company.
    erplndata001.dmp The name of the dump file.
    901 The company number of the archive company.

  3. After you post the dump to the archive company, reorganize the tables using the Reorganize Tables (ttaad4225m000) session. In this session, select these boxes:

    • Reference Integrity
    • Repair Reference Counter

    This is required because the bdbpost option –n (Ignore referential integrity constraints) is used.

    For more information about the options for the bdbpre and bdbpost commands, see the Infor Enterprise Server Technical Manual.