IBM GC09-2830-00 manual Working with DB2 Data, Quick Beginnings

Working with DB2 Data

As well as providing a relational database to store your data, DB2 lets you issue requests to administer, query, update, insert, or delete data using local or remote client applications.

Accessing Host or AS/400 DB2 Data Using DB2 Connect Personal Edition

Direct connection without intermediate servers is a very convenient and desirable con®guration. This is especially true for situations where the host or the AS/400 database server supports TCP/IP connectivity (for example, DB2 for OS/390 V5.1, or DB2 for AS/400 V4R2, or DB2 for VM 6.1). In such a con®guration, each DB2 Connect workstation establishes a direct TCP/IP connection to DB2 for OS/390 or, for platforms with integrated SNA Support, connects via APPC to DB2 for MVS and other host and AS/400 databases.

TCP/IP connectivity requires that the host or AS/400 database support TCP/IP. At this point, DB2 for OS/390 V5.1, DB2/400 V4R2, and DB2 for VM V6.1 support native TCP/IP connections. An alternative to native TCP/IP is MPTN connectivity. MPTN connections require that IBM AnyNet products be installed on the target database system, but do not require the host or AS/400 database to provide native TCP/IP support.

Figure 1 on page 5 shows workstations directly connected to a host or AS/400 database server. Each workstation has DB2 Connect Personal Edition installed.

4Quick Beginnings