|
Moving your database
Moving your database to HP-UX involves the following steps:
- Install the DBEXPORT utility on HP3000
- Export the database
- Create and import the database on Eloquence
Install the DBEXPORT utility on the HP3000
Eloquence comes with the dbexport and dbimport utilities which
can be used to unload a database to one or multiple text files or
respectively load a text file into the database.
The export files are text files which follow a simple syntax.
An equivalent DBEXPORT utility is available for the HP3000 and
can be used to unload your database. It can be downloaded from
the Eloquence ftp server at the URL below:
The following files are available:
- LICENSE - license for the migration utilities (BSD like)
- hp3ksrc.tar - source code
- hp3kbin.tar.Z - compiled version, tar format (MPE 6.5 or newer)
- EQ3KBTAZ - compiled version, tar format (same as above)
- EQ3KBIN - compiled version, STORE format
Note:
You may also download the source code and compile it yourself.
Please note that compiling on MPE 6.0 fails with HP C since
the long long (64 bit integer) data type is not supported.
Note:
Please make sure you download the files in binary format.
You may either need to provide an alternative file name which is
MPE compliant or prepend the file name on MPE with a ./ (dot slash)
to make sure it is accepted as a POSIX file name, such as shown below:
get hp3kbin.tar.Z ./hp3kbin.tar.Z
Note:
When downloading the STORE format file you need to specify
additional ftp parameters, such as the file type.
If in doubt, please use the tar archive.
To install the tar archive on your system, please enter the POSIX
shell and follow the procedure below:
$ tar -xzvf hp3kbin.tar.Z
Tar may issue a warning about being unable to restore the user
and group which can be safely ignored.
To install the STORE archive, please follow the procedure
below:
: FILE EQBIN=./EQ3KBIN;DEV=DISC
: restore *EQBIN;;LOCAL;SHOW
This restores the archive contents in the current directory.
After installation of the archive the DBINFO and DBEXPORT
utilities are available.
The DBEXPORT utility
DBEXPORT is used to export the database contents to one or multiple
text files. It provides a convenient means to move your database
contents to the Eloquence database.
The current version should be used with Eloquence A.07.00
and supports all item types.
Usage: DBEXPORT [-p password] database [set [...]]
Specify the -help command line option to get information on usage.
Options:
-
The -p passwd option specifies the database password used
to open the database.
-
The -s file option specifies that a single file should be used
which contains all data sets.
-
The -v (verbose) option displays the progress
Any data set name or number specified after the database name
indicates that only the specified data sets should be exported.
Documentation:
http://eloquence.marxmeier.com/doc/html/manuals/dbms/dbms-57.html
http://eloquence.marxmeier.com/support/misc/export.html
The DBINFO utility
DBINFO lists the data sets for the specified database
including data set name, type, number of entries and capacity.
Usage: DBINFO [-p password] database [set [...]]
Specify the -help command line option to get information on usage.
Options:
-
The -p passwd option specifies the database password used
to open the database.
-
database is the name of the database.
Optionally, one or more data set names or numbers can be specified
after the database name (separated by spaces). In this case only
information on the specified data sets is returned. By default
all accessible data sets are displayed.
:dbinfo testdb
Processing database : testdb
SET NAME RECLEN CAPACITY ENTRIES
---------------- -- - ------ -------- --------
TEST 01 D 111 100 1
Export the database
The DBEXPORT utility is used to unload the database contents
to a text file. Run the DBEXPORT utility as below:
DBEXPORT [-p passwd] [-v] [-s file] database
Options:
-
The -p passwd option specifies the database password used
to open the database.
-
If the -v option is present then the progress is displayed
-
The -s file specifies that all data sets should be exported to a
single file. If not specified a separate export file is created
for each data set, named database.#.exp (where # is the
number of the data set).
-
database is the name of the database.
Optionally, one or more data set names or numbers can be specified
after the database name (separated by spaces). In this case only
the specified data sets are processed. By default all accessible
data sets are exported.
When running the DBEXPORT utility from the POSIX shell the arguments
are separated by a space.
$ DBEXPORT -p SECRET -v SAMPLEDB
When running from the MPE shell (CI) you need to enclose the
arguments in quotes.
: DBEXPORT "-p SECRET -v SAMPLEDB"
Create and import the database on Eloquence
Transfer your schema files and the export files to the
Eloquence system.
-
Please use the ftp text mode to
transfer your schema files (as an alternative you may
convert them to byte files and then use binary mode).
-
When using ftp please make sure to use
binary mode to transfer the export files.
On Eloquence, run the schema and dbcreate utility as described
above and then use dbimport to fill the database.
$ dbimport database {set [...]]
Options:
-
The -v (verbose) option displays the progress
-
The -s file specifies that all data are contained in a single file.
-
database is the name of the database and may in addition specify
the server system and database instance.
A list of data set names or numbers can be can be specified
after the database name. In this case only the specified data
sets are processed. By default all accessible data sets are imported.
For example:
$ dbimport -v sampledb
$ dbimport -v -s sampledb.exp localhost:8208/sampledb
On the Windows and Linux platform you should use the
-z roman8 commandline option of dbimport to make
sure any national charaters ("Umlaute") are converted properly.
Please note:
Unless you import a trivial volume of data you may want to consider
to set the SyncMode = 0
in your eloqdb6.cfg configuration file during the dbimport.
|
