Following are terms used in the transfer process discussion.
This refers to the DBMS in the transfer statement. For DB2 access services, this is a DB2 UDB database.
This database is another DBMS that is defined in the connection string within the transfer statement. The secondary database can be a database that is targeted by another DB2 access service. Always specify the secondary database in transfer statements.
The source is the database the data is coming from.
This database is where the data is being sent. Either the primary or secondary database can be the source or target, depending on whether you use the transfer from or transfer to command.
Figure 8-1 shows the DB2 access service configured to access a particular DB2 UDB database, which is the primary database. The secondary database is an Adaptive Server database located on the LAN. The client application can transfer data from DB2 UDB to ASE, or from ASE to DB2 UDB.
Figure 8-1: DB2 access service data transfer between databases
During a transfer:
Data flows from a table in the source database, through the DB2 access service, to the target database. Although the client application initiates the transfer, the data does not flow through it.
The DB2 access service becomes a client to the secondary database.