Version
Quick Beginnings
IBM DB2 Connect
Personal Edition
Page
Version
Quick Beginnings
IBM DB2 Connect
Personal Edition
Page
Connect
Contents
and Installation
Part 1. Introduction to DB2
Use DB2 Connect
Part 6. Using DB2 Connect
Part 7. Appendixes
Part 5. Conguring DB2 Clients to
Appendix G. List Files, Bind Files, and
vi Quick Beginnings
DB2 Universal Database
Welcome to DB2 Connect
How This Book is Structured
Conventions
v If you do not follow the documented installation method with the
x Quick Beginnings
Copyright IBM Corp. 1993
Part 1. Introduction to DB2 Connect
2 Quick Beginnings
DB2 Connect Personal Edition
Chapter 1. About DB2 Connect
DB2 Connect Enterprise Edition
4 Quick Beginnings
Accessing Host or AS/400 DB2 Data Using DB2 Connect Personal Edition
Working with DB2 Data
Chapter 1. About DB2 Connect
OS/390 APPC TCP/IP*** MPTN
6 Quick Beginnings
Connections via Communications Gateway
OS/390 APPC TCP/IP*** MPTN
ESCON
v Middle-tier application server is employed
v Database products, such as Lotus Approach and Microsoft Access
Figure 3. DB2 Connect Enterprise Edition
OS/390 APPC TCP/IP*** MPTN
ESCON
DB2 Connect Enterprise Edition
DB2 Connect Enterprise Edition
Figure 4. Using Transaction Monitors with DB2 Connect
OS/390 APPC TCP/IP*** MPTN
ESCON
12 Quick Beginnings
OS/390 APPC TCP/IP*** MPTN
ESCON
Figure 5. Java Server Support
Figure 6. DB2 Connect working with Microsoft IIS
OS/390 APPC TCP/IP*** MPTN
ESCON
14 Quick Beginnings
Accessing DB2 Data from the Web Using Java
ESCON
Figure 7. Using Java Applets
OS/390 APPC TCP/IP*** MPTN
16 Quick Beginnings
Accessing DB2 Data from the Web Using Net.Data
Figure 8. Net.Data with DB2 Connect
OS/390 APPC TCP/IP*** MPTN
ESCON
Developing Applications Using the DB2 Software Developers Kit
Running Your Own Applications
v Net.Data macros containing HTML and SQL
Copyright IBM Corp. 1993
Part 2. DB2 Connect Planning and Installation
22 Quick Beginnings
Disk Requirements
Chapter 2. Planning for Installation
Memory Requirements
DB2 Connect Requirements
Components
Estimating Fixed Disk Requirements
Software Requirements
Table 2. Software Requirements
Product Requirements
Communications
Table 2. Software Requirements continued
Product
Hardware/Software
Before You Begin
Chapter 3. Installing DB2 Connect on OS/2
Performing the Installation
28 Quick Beginnings
x\install
x\install /i language
Software Registration
Upgrading from a Try-and-Buy License
Before You Begin
Chapter 4. Installing DB2 Connect on Windows 9x or Windows NT
To manually invoke the setup program, perform the following steps
Performing the Installation
Step 4. The Welcome window opens
34 Quick Beginnings
Software Registration
Upgrading from a Try-and-Buy License
36 Quick Beginnings
Copyright IBM Corp. 1993
38 Quick Beginnings
Preparing MVS/ESA or OS/390 for DB2 Connect
Chapter 5. Conguring Host and AS/400 Databases for DB2 Connect
Conguring VTAM
Summary of Steps
Chapter 5. Conguring Host and AS/400 Databases for DB2 Connect
Sample Network Element Names VTAM
Sample VTAM APPL Denition for OS/390
NYM2DB2
Sample VTAM PU and LU Denitions for DB2 Connect
Figure 11. Sample VTAM Switched Major Node Denition for DB2 Connect
Sample VTAM Log Mode Denition for DB2
Conguring DB2 Universal Database for OS/390
Updating SYSIBM.IPNAMES
Conguring DB2 for MVS/ESA
Updating SYSIBM.LUNAMES
INSERT INTO SYSIBM.SYSLUMODES VALUES NYX1
Updating SYSIBM.SYSUSERNAMES
Updating SYSIBM.SYSLUNAMES
Updating SYSIBM.SYSLUMODES
Prerequisite OS/390 Software for TCP/IP Support
Conguring TCP/IP for DB2 Universal Database for OS/390
Collecting Information
1. To obtain the hosts IP address „TCP-9…, enter at the host
Example Worksheet
1. Verify the host address or the host name
Update the DB2 Universal Database for OS/390 Host At your OS/390 host
2. Verify the port number or the service name
Conguring the TCP/IP Connection
Update the DB2 Connect Directories
DSPNETA
Preparing DB2 Universal Database for AS/400 for DB2 Connect
DSPNETA
Your value
Preparing DB2 for VSE & VM
Parameter
Example
54 Quick Beginnings
Copyright IBM Corp. 1993
56 Quick Beginnings
With the CCA, you can
Conguration Steps
Adding a Database Using a Prole
60 Quick Beginnings
Adding a Database Using Discovery
a. Click on the Add System push button
62 Quick Beginnings
Adding a Database Manually
If you are not using Lightweight Directory Access Protocol LDAP, this tab will not be shown, skip this step and go to Step
OS/390 or MVS
AS/400
VM or VSE
64 Quick Beginnings
Step 4. Click on the Bind push button
66 Quick Beginnings
Step 1. Identify and Record Parameter Values
targetdbname
Table 5. Worksheet for Planning Host and AS/400 Server Connections
or DB2DRDA
localdcsname
Conguring IBM eNetwork Communications Server for Windows NT
Step 2. Update the APPC Proles on the DB2 Connect Workstation
a. Click on the Start push button, then select Settings-Control Panel
window
a. In the Conguration options eld, select Congure connections
a. In the Conguration options eld, select Congure devices
74 Quick Beginnings
Accept the defaults for the other elds f. Click on OK
to register Communications Server with the default conguration, or
b. Select Users-New User from the menu bar. The New User window opens
SNA Client Conguration window opens Step 3. Congure Global Data
Conguring Microsoft SNA Server for Windows NT
Step 2. Dene the control point name
Step 4. Dene the connection properties
b. Select DLC 802.2 Link Service c. Click on the Add push button
d. Click on the Finish push button
b. Enter a connection name „7… in the Name eld
i. Select the System Identication tab
window opens b. Enter the following information v The LU Alias „12…
c. Select the Limits tab
Step 7. Dene a mode
b. Enter the Mode Name „6… in the Mode Name eld
e. Accept the other defaults, and click on OK
d. Select the Partner Information tab
88 Quick Beginnings
Conguring Microsoft SNA Client
DB2 Connect Enterprise Edition with SNA Gateway client software
OS/390 APPC TCP/IP*** MPTN
ESCON
The rest of this section assumes
Step 1. Obtain Required Information
Step 3. Install DB2 Connect for Windows
Step 3. Catalog the APPC or APPN Node
catalog dcs db localdcsname as targetdbname terminate
Step 5. Catalog the Database
databasealias
Table 6. Worksheet Parameter Values for Cataloging Databases
databasename
localdcsname of the remote
Step 7. Test the Host or AS/400 Connection
Step 6. Bind Utilities and Applications to the Database Server
select tabname from syscat.tables
96 Quick Beginnings
Chapter 8. Enabling Multisite Updates Two-Phase Commit
v DB2 Common Server v DB2 Universal Database V5 and
Note *AIX
Host and AS/400 multisite update scenarios that require SPM
Chapter 8. Enabling Multisite Updates Two-Phase Commit
For more information about DUOW refer to the DB2 Connect Users Guide
Smartguide Steps
Enabling Multisite Updates Using the Control Center
Starting the Multisite Update Smartguide
Testing the Multisite Update Feature
102 Quick Beginnings
Copyright IBM Corp. 1993
Part 5. Conguring DB2 Clients to Use DB2 Connect
104 Quick Beginnings
If you are adding a host or AS/400 database, go to ªChapter
106 Quick Beginnings
Adding a Database Using a Prole
Conguration Steps
Page
108 Quick Beginnings
Adding a Database Using Discovery
Step 5. Register this database as an ODBC data source
110 Quick Beginnings
Adding a Database Manually
VM or VSE
OS/390 or MVS
AS/400
Server Proles
Creating and Using Proles
Step 3. Select the Export server prole option
Client Proles
v Database connection information including CLI or ODBC settings
Step 6. Click on OK. The Export Client Prole window opens
116 Quick Beginnings
Copyright IBM Corp. 1993
Part 6. Using DB2 Connect
118 Quick Beginnings
Binding Database Utilities
Chapter 10. Running Your Own Applications
Binding to DB2 Universal Databases
Binding to Host Databases
Reference
Running CLI/ODBC Programs
Step 3. To access the DB2 database from ODBC
c. Select the Register this database for ODBC check box
Platform Specic Details for CLI/ODBC Access
Windows 32-bit operating systems Client Access to DB2 using CLI/ODBC
124 Quick Beginnings
CATALOG user system ODBC DATA SOURCE
3 Select the Register this database for ODBC check box
OS/2 Client Access to DB2 using CLI/ODBC
126 Quick Beginnings
Detailed Conguration Information
Running Java Programs
Solaris
Conguring the Environment
HP-UX
Silicon Graphics IRIX
On UNIX platforms
Java Applications
On UNIX platforms
On Windows and OS/2 platforms
Java Applets
Copyright IBM Corp. 1993
Part 7. Appendixes
132 Quick Beginnings
OS/2 Click on OS/2 Warp and select DB2 for OS/2±Registration
Appendix A. Basic Task Knowledge
Starting the Software Registration Tool
Starting the Client Conguration Assistant
On Windows 9x or Windows NT
Entering Commands Using the Command Center
Starting the Control Center
On OS/2
On OS/2
Start the Command Center in one of the follows ways
On Windows 9x or Windows NT
Interactive Input Mode
Entering Commands Using the Command Line Processor
Command Line Mode
Command Line Mode
Windows 9x or Windows NT
Interactive Input Mode
OS/2 Click on OS/2 Warp, and select DB2 for OS/2±Command
Windows-Command Line Processor
OS/2
Working with the System Administrative Group
Page
Preparing DB2 for OS/390 Servers for the Control Center
Using the Control Center
v DB2 Universal Database UDB for Windows NT Version 5 all editions
142 Quick Beginnings
Completing Tasks with SmartGuides
Appendix D. How the DB2 Library Is Structured
Create-Table space using
Accessing Online Help
How to Access
Create-Table using SmartGuide
Appendix D. How the DB2 Library Is Structured
Contents
How to Access
Type of Help
Cross-platform sample programs in HTML
DB2 Information ± Hardcopy and Online
Cross-platform books
Platform-specic books
Administration Guide
HTML
Name
Description
Form Number
Directory
Name
Description
Form Number HTML
SC09-2851 db2q0 db2q0x60
Directory
Name
Description
Form Number HTML
152 Quick Beginnings
See Application Building Guide for more
Viewing Online Information
Reference
Accessing Information with the Information Center
Troubleshooting
Tasks
Setting Up a Document Server
Printing the PostScript Books
Searching Online Information
Ordering the Printed Books
158 Quick Beginnings
Code Page and Language Support
Appendix E. National Language Support NLS
Table 8. Languages and Code Pages continued
Conversion of Character Data
1. DB2 Connect sends an SQL statement and input data to OS/390 or MVS
Bidirectional CCSID Support
Bidirectional-specic CCSIDs
Where CDRA String Types are dened
Database, Database Alias, and Catalog Node Name Rules
Appendix F. Naming Rules
General Naming Rules
Object Name Rules
Windows 32-bit operating systems Use any case
Username, User ID, Group Name, and Instance Name Rules
Workstation Name nname Rules
UNIX
Password Rules
DB2SYSTEM Naming Rules
A maximum of 14 characters
Appendix G. List Files, Bind Files, and Packages
OS/400
List Files Associated with DRDA Servers
DRDA Server List File OS/390 and MVS
Appendix G. List Files, Bind Files, and Packages
Table 10. DRDA Bind Files and Packages continued
172 Quick Beginnings
Appendix H. Notices
Trademarks of Other Companies
Trademarks
Appendix H. Notices
176 Quick Beginnings
Index
Page
Page
180 Quick Beginnings
Anonymous FTP Sites
Contacting IBM
Telephone
CompuServe
Page
Part Number CT6D9NA
IBMR