IBM DB2 Connect
Quick Beginnings
Personal Edition
Version
Page
IBM DB2 Connect
Quick Beginnings
Personal Edition
Version
Page
and Installation
Contents
Part 1. Introduction to DB2
Connect
Part 7. Appendixes
Part 6. Using DB2 Connect
Part 5. Conguring DB2 Clients to
Use DB2 Connect
Appendix G. List Files, Bind Files, and
vi Quick Beginnings
How This Book is Structured
Welcome to DB2 Connect
DB2 Universal Database
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 Enterprise Edition
Chapter 1. About DB2 Connect
DB2 Connect Personal Edition
Working with DB2 Data
Accessing Host or AS/400 DB2 Data Using DB2 Connect Personal Edition
4 Quick Beginnings
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
ESCON
OS/390 APPC TCP/IP*** MPTN
DB2 Connect Enterprise Edition
Figure 3. DB2 Connect Enterprise Edition
OS/390 APPC TCP/IP*** MPTN
Figure 4. Using Transaction Monitors with DB2 Connect
ESCON
DB2 Connect Enterprise Edition
ESCON
OS/390 APPC TCP/IP*** MPTN
Figure 5. Java Server Support
12 Quick Beginnings
ESCON
OS/390 APPC TCP/IP*** MPTN
Figure 6. DB2 Connect working with Microsoft IIS
14 Quick Beginnings
Accessing DB2 Data from the Web Using Java
OS/390 APPC TCP/IP*** MPTN
Figure 7. Using Java Applets
ESCON
16 Quick Beginnings
Accessing DB2 Data from the Web Using Net.Data
ESCON
OS/390 APPC TCP/IP*** MPTN
Figure 8. Net.Data with DB2 Connect
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
Memory Requirements
Chapter 2. Planning for Installation
DB2 Connect Requirements
Disk Requirements
Software Requirements
Estimating Fixed Disk Requirements
Components
Table 2. Software Requirements
Product Requirements
Product
Table 2. Software Requirements continued
Hardware/Software
Communications
Performing the Installation
Chapter 3. Installing DB2 Connect on OS/2
Before You Begin
x\install /i language
x\install
28 Quick Beginnings
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
Sample VTAM APPL Denition for OS/390
Sample Network Element Names VTAM
NYM2DB2
Chapter 5. Conguring Host and AS/400 Databases for DB2 Connect
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.LUNAMES
Conguring DB2 for MVS/ESA
Updating SYSIBM.IPNAMES
Updating SYSIBM.SYSLUNAMES
Updating SYSIBM.SYSUSERNAMES
Updating SYSIBM.SYSLUMODES
INSERT INTO SYSIBM.SYSLUMODES VALUES NYX1
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
2. Verify the port number or the service name
Update the DB2 Universal Database for OS/390 Host At your OS/390 host
Conguring the TCP/IP Connection
1. Verify the host address or the host name
Update the DB2 Connect Directories
DSPNETA
Preparing DB2 Universal Database for AS/400 for DB2 Connect
DSPNETA
Parameter
Preparing DB2 for VSE & VM
Example
Your value
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
AS/400
OS/390 or MVS
VM or VSE
If you are not using Lightweight Directory Access Protocol LDAP, this tab will not be shown, skip this step and go to Step
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
d. Click on the Finish push button
b. Select DLC 802.2 Link Service c. Click on the Add push button
Step 4. Dene the connection properties
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…
b. Enter the Mode Name „6… in the Mode Name eld
Step 7. Dene a mode
c. Select the Limits tab
e. Accept the other defaults, and click on OK
d. Select the Partner Information tab
88 Quick Beginnings
Conguring Microsoft SNA Client
ESCON
OS/390 APPC TCP/IP*** MPTN
The rest of this section assumes
DB2 Connect Enterprise Edition with SNA Gateway client software
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
databasename
Table 6. Worksheet Parameter Values for Cataloging Databases
localdcsname of the remote
databasealias
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
Chapter 8. Enabling Multisite Updates Two-Phase Commit
Host and AS/400 multisite update scenarios that require SPM
Note *AIX
For more information about DUOW refer to the DB2 Connect Users Guide
Starting the Multisite Update Smartguide
Enabling Multisite Updates Using the Control Center
Testing the Multisite Update Feature
Smartguide Steps
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
Conguration Steps
Adding a Database Using a Prole
106 Quick Beginnings
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
AS/400
OS/390 or MVS
VM or VSE
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
Windows 32-bit operating systems Client Access to DB2 using CLI/ODBC
Platform Specic Details for CLI/ODBC Access
c. Select the Register this database for ODBC check box
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
HP-UX
Conguring the Environment
Silicon Graphics IRIX
Solaris
On UNIX platforms
Java Applications
On Windows and OS/2 platforms
On UNIX platforms
Java Applets
Copyright IBM Corp. 1993
Part 7. Appendixes
132 Quick Beginnings
Starting the Software Registration Tool
Appendix A. Basic Task Knowledge
Starting the Client Conguration Assistant
OS/2 Click on OS/2 Warp and select DB2 for OS/2±Registration
Starting the Control Center
Entering Commands Using the Command Center
On OS/2
On Windows 9x or Windows NT
On Windows 9x or Windows NT
Start the Command Center in one of the follows ways
On OS/2
Command Line Mode
Entering Commands Using the Command Line Processor
Command Line Mode
Interactive Input Mode
OS/2 Click on OS/2 Warp, and select DB2 for OS/2±Command
Interactive Input Mode
Windows-Command Line Processor
Windows 9x or Windows NT
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
How to Access
Accessing Online Help
Create-Table using SmartGuide
Create-Table space using
How to Access
Contents
Type of Help
Appendix D. How the DB2 Library Is Structured
Cross-platform books
DB2 Information ± Hardcopy and Online
Platform-specic books
Cross-platform sample programs in HTML
Administration Guide
Description
Name
Form Number
HTML
Description
Name
Form Number HTML
Directory
SC09-2851 db2q0 db2q0x60
Description
Name
Form Number HTML
Directory
152 Quick Beginnings
See Application Building Guide for more
Viewing Online Information
Troubleshooting
Accessing Information with the Information Center
Tasks
Reference
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
General Naming Rules
Appendix F. Naming Rules
Database, Database Alias, and Catalog Node Name Rules
Object Name Rules
Workstation Name nname Rules
Username, User ID, Group Name, and Instance Name Rules
Windows 32-bit operating systems Use any case
DB2SYSTEM Naming Rules
Password Rules
A maximum of 14 characters
UNIX
Appendix G. List Files, Bind Files, and Packages
DRDA Server List File OS/390 and MVS
List Files Associated with DRDA Servers
OS/400
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
Telephone
Contacting IBM
Anonymous FTP Sites
CompuServe
Page
Part Number CT6D9NA
IBMR