 |
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.
|
 |
-
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.
-
Login as cisdba user and run edm.sh
from $EDS_HOME/bin directory. For additional information,
see Using CES Database Manager.
-
From the EDM main window, select a database
that is to be exported.
-
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.
|
-
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.
-
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.
|