dbexport/dbimport question

[maxster]

I checked to see if this has been asked before but here goes, can I use dbexport to backup four seperate databases on four seperate machines across a network to a common storage area?

Additionally could I then use dbimport if I need to restore one of the databases?

 

[olded]

Hi:

No, I don't think dbexport was designed to work across the network as you described. I tried using the -o option of dbexport.

You could perform a dbexport to disk, and then tar/cpio/compress that directory and move it to another network location.

In order to perform the dbimport, you'd have to retrieve the export.

You do know that performing dbexport places an exclusive lock on the database during the export? In fact, if dbexport can't exclusively the database it fails.

You might consider using the ontape command. That does support going across the network.

Regards,

Ed

 

[maxster]

Hi 'olded',

Is the ontape command a standard function or an add on?

Maxster

 

[olded]

Maxster:

ontape is an informix untility bundled with the engine. Here's the command line help:

ontape
usage:
{ -a |
-c |
-l |
-p |
-r [-D DBspace_list] |
-s [-L archive_level] [-A database_list] [-B database_list]
[-N database_list] [-U database_list] }

-a Automatic backup of logical logs
-c Continuous backup of logical logs
-l Logical restore
-p Physical restore for HDR
-r Full restore DBspaces/BLOBspaces as listed
-s Archive full system
-A set the following database(s) to ansi logging
-B set the following database(s) to buffered logging
-N set the following database(s) to no logging
-U set the following database(s) to unbuffered logging

You probably should consult the documentation.

Ed

 

[jasonylpang]

You should be able to export the databases to the common storage provided that the common storage area are connected to all the machines. If you using UNIX platform, then use the NFS (Network File System) protocal to share your common storage to all the machines.