Download Quick Beginnings for DB2 Connect Personal Edition PDF

TitleQuick Beginnings for DB2 Connect Personal Edition
LanguageEnglish
File Size865.5 KB
Total Pages91
Table of Contents
                            Contents
Part 1. Introduction to DB2 Connect
Chapter 1. About DB2 Connect
	DB2 Connect product offerings
Chapter 2. DB2 Connect scenarios
	Accessing host or iSeries DB2 data using DB2 Connect Personal Edition
	Managing connections to databases using the Configuration Assistant (Linux and Windows)
	DB2 Client support for database application development
Chapter 3. Typical steps required to install and configure DB2 Connect Personal Edition
Part 2. Installing DB2 Connect
Chapter 4. Installation requirements
	Disk and memory requirements
	Installation requirements for DB2 Connect Personal Edition (Windows)
	Required user accounts for installation of DB2 Connect Personal Edition (Windows)
	Installation requirements for DB2 Connect Personal Edition (Linux)
Chapter 5. Preparing Windows for LDAP
	Extending the directory schema (Windows)
Chapter 6. Installation tasks
	Installing DB2 Connect Personal Edition (Windows)
		Installing DB2 Connect Personal Edition (Windows)
		Non-Administrator installation of DB2 Connect (Windows)
	Installing DB2 Connect Personal Edition (Linux)
Chapter 7. ID management
	Adding your user ID to the DB2ADMNS and DB2USERS user groups (Windows)
Part 3. Preparing host and iSeries databases for DB2 Connect communications
Chapter 8. Preparing DB2 for OS/390 and z/OS databases for DB2 Connect communications
	Preparing DB2 Universal Database for OS/390 and z/OS for connections from DB2 Connect
	Configuring TCP/IP for DB2 Universal Database for OS/390 and z/OS
	Configuring DB2 Universal Database for OS/390 and z/OS
Chapter 9. Preparing DB2 UDB for iSeries databases for DB2 Connect communications
	Preparing DB2 Universal Database for iSeries for connections from DB2 Connect
Chapter 10. Preparing DB2 for VM & VSE databases for DB2 Connect communications
	Preparing DB2 for VSE & VM for connections from DB2 Connect
Part 4. Configuring access to host and iSeries databases
Chapter 11. Using the Configuration Assistant
	Configuring a connection to host or iSeries database servers using the CA (Linux and Windows)
Chapter 12. Using the CLP
	Configuring a connection to host and iSeries database servers using the CLP
Part 5. Using DB2 Connect
Chapter 13. Running your own applications
Chapter 14. Binding database utilities on DB2 Connect
Chapter 15. Further reading
Part 6. Reference
Chapter 16. Uninstalling DB2 Connect
	Uninstalling your DB2 product (Windows)
	Uninstalling your DB2 product (Linux and UNIX)
Part 7. Appendixes
Appendix A. Configuring and testing database connections using the Configuration Assistant
	Configuring a database connection by searching the network using the Configuration Assistant
	Configuring a database connection manually using the Configuration Assistant
	Testing a database connection using the Configuration Assistant
Appendix B. Language Support
	Changing the DB2 interface language (Windows)
	Changing the DB2 interface language (Linux and UNIX)
	Supported DB2 interface languages
	Language identifiers for running the DB2 Setup wizard in another language
	Conversion of character data
Appendix C. DB2 Database technical information
	Overview of the DB2 technical information
		Documentation feedback
	DB2 technical library in hardcopy or PDF format
	Ordering printed DB2 books
	Displaying SQL state help from the command line processor
	Accessing different versions of the DB2 Information Center
	Displaying topics in your preferred language in the DB2 Information Center
	Updating the DB2 Information Center installed on your computer or intranet server
	DB2 tutorials
	DB2 troubleshooting information
	Terms and Conditions
Appendix D. Notices
	Trademarks
Index
Contacting IBM
                        
Document Text Contents
Page 1

DB2®

Quick Beginnings for DB2 Connect Personal Edition

DB2 Connect Version 9

GC10-4244-00





���

Page 45

Chapter 12. Using the CLP

Configuring a connection to host and iSeries database servers using
the CLP

You can manually configure your TCP/IP connection between a DB2 Connect
server and a host or iSeries database using the DB2 command line processor (CLP).

Prerequisites:

Before you manually configure a TCP/IP connection between DB2 Connect and a
host or iSeries database server, ensure that:
v TCP/IP is functional on the DB2 Connect server and host or iSeries system.
v You have identified the following parameter values:

– Hostname (hostname) or IP address (ip_address)
– Connection Service name (svcename) or Port number/Protocol

(port_number/tcp)
– Target database name (target_dbname)
– Local database name (local_dcsname)
– Node name (node_name)

Procedure:

To manually configure TCP/IP communications between your DB2 Connect server
and a host or iSeries database:
1. Configure TCP/IP on the DB2 Connect server.
2. Catalog the TCP/IP node.
3. Catalog the host or iSeries database as a Database Connection Service (DCS)

database.
4. Catalog the host or iSeries database.
5. Bind utilities and applications to the host or iSeries database server.
6. Test the host or iSeries connection.

Note: Due to the characteristics of the TCP/IP protocol, TCP/IP might not be
immediately notified of a partner’s failure on another host or iSeries. As a
result, a client application accessing a remote DB2 server using TCP/IP, or
the corresponding agent at the server, might sometimes appear to be hung.
The TCP/IP SO_KEEPALIVE socket option is used to detect when there has
been a failure and the TCP/IP connection has been broken.

Related tasks:

v Chapter 14, “Binding database utilities on DB2 Connect,” on page 45
v “Configuring a connection to host or iSeries database servers using the CA

(Linux and Windows)” on page 37
v “Configuring TCP/IP for DB2 Universal Database for OS/390 and z/OS” on

page 27

Related reference:



© Copyright IBM Corp. 1993, 2006 39

Page 46

v “CATALOG DATABASE command” in Command Reference
v “CATALOG DCS DATABASE command” in Command Reference
v “CATALOG TCPIP/TCPIP4/TCPIP6 NODE command” in Command Reference
v “CONNECT (Type 1) statement” in SQL Reference, Volume 2



40 DB2 Connect Personal Edition Quick Beginnings

Page 90

���

Part Number: CT3ZNNA



Printed in Ireland.




GC10-4244-00





(1
P)


P/

N:

CT

3Z
NN

A

Page 91

Sp
in

e
in

fo
rm

at
io

n:

IB
M

D
B

2
D

B2

Co

nn
ec

t V
er

si
on


9

D
B2


Co

nn
ec

t P
er

so
na

l E
di

tio
n

Q
ui

ck

Be

gi
nn

in
gs








Similer Documents