Working with db2 data – IBM GC09-2830-00 User Manual

Page 16

Advertising
background image

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 configuration. 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
configuration, 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.

4

Quick Beginnings

Advertising