Moving data from one system to another

 

A number of situations occur in enterprise operations that might require moving data from one i5/OS^® operating system to another.

Here is a situation that might require moving data from one system to another: a new dealership opens in a region, and some clients from one or two other dealerships might be transferred to the new dealership as determined by client addresses. Perhaps a dealership closed or no longer represents Spiffy Corporation sales and service. That dealer's inventories and required service information must be allocated to either the regional office or other area dealerships. Perhaps a dealership has grown to the extent that it needs to upgrade its system, and the entire database must be moved to the new system.

Here are some alternatives for moving data from one system to another:

• User-written application programs

• Interactive SQL (ISQL)

• DB2 Universal Database™ for iSeries™ Query Management functions

• Copy to and from tape devices

• Copy file commands with DDM

• The network file commands

• i5/OS save and restore commands

• Creating a user-written application program
  A program compiled with distributed unit of work (DUW) connection management can connect to a remote database and a local database and FETCH from one to INSERT into the other to move the data.

• Querying a database using interactive SQL
  Using the SQL SELECT statement and interactive SQL, you can query a database on another i5/OS operating system for the data that you need in order to create or update a table on the local system.

• Querying remote systems using DB2 UDB for iSeries query management function
  The DB2 Universal Database for iSeries query management function provides almost the same support as interactive SQL for querying a remote system and returning the results in an output file to the local system.

• Copying files to and from tape
  There are several different commands that you can use to copy files to and from tape.

• Moving data between systems using copy file commands
  Another way to move data from one i5/OS operating system to another is to copy the data using the copy file commands with DDM.

• Transferring data over network using network file commands
  Data can be transferred over networks protocols that support Systems Network Architecture (SNA) distribution services (SNADS). In addition to APPC and APPN protocols used with distributed relational database processing, SNADS can be used with binary synchronous equivalence link (BSCEL) and SNA Upline Facility (SNUF) protocols.

• Moving a table using object save and restore commands
  You can move a table from another system using the Save Object (SAVOBJ) and Restore Object (RSTOBJ) commands. The save commands save database files on tape or in a save file. The save file can be distributed to another system through communications.

 

Parent topic:

Loading data into tables in a distributed relational database