TCP/IP Datastores act like a direct pipe between systems. They are high performance and simplify communication between heterogeneous platforms like z/OS and UNIX. They can be secured by using Virtual Private Networking (VPN) and are preferred over FTP. The only restriction is that unlike FTP, a process must be ready and waiting for data to come through the pipe. With Connect CDC SQData this is usually accomplished through the use of an Engine Controller SQDaemon on the target system, that can initiate the receiving process before data begins to flow through the pipe.
Example:
Defining a TCP/IP datastore to be used for cross platform operation between a host system and another system, SYSB. The source system contains a sequential flat file source datastore identified by DDName EMPIN that is defined by COBOL copybook (EMPLOYEE). The target datastore is a DB2 LUW (UDB) datastore that will be created using the DB2 Load utility. Use TCP/IP port number 1830 for the communication.
-- Define the input and output file layout --
DESCRIPTION COBOL DD:COBLIB(EMPLOYEE)
AS EMPLOYEE;
-- Define the Source Datastore --
DATASTORE DD:EMPIN
OF BINARY
AS EMPLOYEE_IN
DESCRIBED BY EMPLOYEE;
-- Define theTarget Datastore --
DATASTORE TCP://SYSB/1830
OF DB2LOAD
AS EMPLOYEE_OUT
DESCRIBED BY EMPLOYEE;