Exporting Database

About Exporting Database

This option allows you to export DDL statements for CES database objects and table data of the CISDBA schema. The database objects exported include the complete list of CES database objects such as table, Indexes, Triggers and check constraints. This option has to be used along with EDM's Import a database option to duplicate an CES database.

This task explains the procedure to export a database:

  1. On your local machine, create an export directory of any name with file permissions set to 777 for the cisdba user to write export files.

  2. Login as cisdba user and run edm.sh from $EDS_HOME/bin directory. For additional information, see Using CES Database Manager.

  3. From the EDM main window, select a database that is to be exported.

  4. Select Administration > Export Database option. You are prompted for the cisdba password.

    Once you have specified the password, the Export Database window appears.

     

    Name Description

    Instance Name

    The name of the instance appears.

    Database Name

    The name of the database from which the data is to be exported appears.

    Export Directory

    The target directory in which the exported data is to be stored. The default path appears but you can click Browse and select a different directory/path.

    Export Log File

    The log file in which the export details will be stored. The default log file and path appears but you can click Browse and select a different file/path.

  1. Click Export to start the database export. The export operation may take some time depending on the size of the database. When the database export has been completed, two directories, dblook and dbmove, are created under the specified export directory. These directories and their files should not be disturbed as they are used by EDM's Import an CES Database option. These are included by the files generated by the Export option:

    Files created under dblook directory Files created under dbmove directory

    dblook.sql: Lists ddl statements for tables (Under dblook directory)

    EXPORT.out: The summarized result of the EXPORT action

     

    db2move.lst: The list of original table names and their corresponding IXF file names (tabnnn.ixf), and message file names (tabnnn.msg).

     

    tabnnn.ixf: The exported PC/IXF file of a specific table. Each exported IXF file is used as input to the CES Database Server's Import function.

     

    tabnnn.msg: The export message file of the corresponding table where nnn is the table number ranging from 001 to 999.

    After the export is completed, you can click Cancel to return to the EDM main window.

  2. Click Save Summary to save information regarding space management for the database you exported. This information can be found in the file tsAndBufPoolSum_<instance_name>_<DB_NAME>.rep under the $EDS_HOME/log directory and can be used later during the time of import.