Personal Edition
Quick Beginnings
IBM DB2 Connect
Version
Page
Personal Edition
Quick Beginnings
IBM DB2 Connect
Version
Page
Part 1. Introduction to DB2
Contents
and Installation
Connect
Part 5. Conguring DB2 Clients to
Part 6. Using DB2 Connect
Part 7. Appendixes
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
Part 1. Introduction to DB2 Connect
Copyright IBM Corp. 1993
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
OS/390 APPC TCP/IP*** MPTN
Chapter 1. About DB2 Connect
Connections via Communications Gateway
6 Quick Beginnings
ESCON
OS/390 APPC TCP/IP*** MPTN
v Middle-tier application server is employed
v Database products, such as Lotus Approach and Microsoft Access
DB2 Connect Enterprise Edition
OS/390 APPC TCP/IP*** MPTN
ESCON
Figure 3. DB2 Connect Enterprise Edition
ESCON
Figure 4. Using Transaction Monitors with DB2 Connect
OS/390 APPC TCP/IP*** MPTN
DB2 Connect Enterprise Edition
Figure 5. Java Server Support
OS/390 APPC TCP/IP*** MPTN
ESCON
12 Quick Beginnings
ESCON
OS/390 APPC TCP/IP*** MPTN
Figure 6. DB2 Connect working with Microsoft IIS
Accessing DB2 Data from the Web Using Java
14 Quick Beginnings
OS/390 APPC TCP/IP*** MPTN
Figure 7. Using Java Applets
ESCON
Accessing DB2 Data from the Web Using Net.Data
16 Quick Beginnings
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
Part 2. DB2 Connect Planning and Installation
Copyright IBM Corp. 1993
22 Quick Beginnings
DB2 Connect Requirements
Chapter 2. Planning for Installation
Memory Requirements
Disk Requirements
Software Requirements
Estimating Fixed Disk Requirements
Components
Product Requirements
Table 2. Software Requirements
Hardware/Software
Table 2. Software Requirements continued
Product
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
Chapter 4. Installing DB2 Connect on Windows 9x or Windows NT
Before You Begin
Performing the Installation
To manually invoke the setup program, perform the following steps
Step 4. The Welcome window opens
Software Registration
34 Quick Beginnings
Upgrading from a Try-and-Buy License
36 Quick Beginnings
Copyright IBM Corp. 1993
38 Quick Beginnings
Chapter 5. Conguring Host and AS/400 Databases for DB2 Connect
Preparing MVS/ESA or OS/390 for DB2 Connect
Summary of Steps
Conguring VTAM
NYM2DB2
Sample Network Element Names VTAM
Sample VTAM APPL Denition for OS/390
Chapter 5. Conguring Host and AS/400 Databases for DB2 Connect
Sample VTAM PU and LU Denitions for DB2 Connect
Sample VTAM Log Mode Denition for DB2
Figure 11. Sample VTAM Switched Major Node Denition for DB2 Connect
Conguring DB2 Universal Database for OS/390
Updating SYSIBM.LUNAMES
Conguring DB2 for MVS/ESA
Updating SYSIBM.IPNAMES
Updating SYSIBM.SYSLUMODES
Updating SYSIBM.SYSUSERNAMES
Updating SYSIBM.SYSLUNAMES
INSERT INTO SYSIBM.SYSLUMODES VALUES NYX1
Conguring TCP/IP for DB2 Universal Database for OS/390
Prerequisite OS/390 Software for TCP/IP Support
Collecting Information
Example Worksheet
1. To obtain the hosts IP address „TCP-9…, enter at the host
Conguring the TCP/IP Connection
Update the DB2 Universal Database for OS/390 Host At your OS/390 host
2. Verify the port number or the service name
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
Example
Preparing DB2 for VSE & VM
Parameter
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
Adding a Database Using Discovery
60 Quick Beginnings
a. Click on the Add System push button
Adding a Database Manually
62 Quick Beginnings
VM or VSE
OS/390 or MVS
AS/400
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
Table 5. Worksheet for Planning Host and AS/400 Server Connections
targetdbname
localdcsname
or DB2DRDA
Step 2. Update the APPC Proles on the DB2 Connect Workstation
Conguring IBM eNetwork Communications Server for Windows NT
a. Click on the Start push button, then select Settings-Control Panel
window
a. In the Conguration options eld, select Congure devices
a. In the Conguration options eld, select Congure connections
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
Conguring Microsoft SNA Client
88 Quick Beginnings
The rest of this section assumes
OS/390 APPC TCP/IP*** MPTN
ESCON
DB2 Connect Enterprise Edition with SNA Gateway client software
Step 3. Install DB2 Connect for Windows
Step 1. Obtain Required Information
Step 3. Catalog the APPC or APPN Node
Step 5. Catalog the Database
catalog dcs db localdcsname as targetdbname terminate
localdcsname of the remote
Table 6. Worksheet Parameter Values for Cataloging Databases
databasename
databasealias
Step 6. Bind Utilities and Applications to the Database Server
Step 7. Test the Host or AS/400 Connection
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
Testing the Multisite Update Feature
Enabling Multisite Updates Using the Control Center
Starting the Multisite Update Smartguide
Smartguide Steps
102 Quick Beginnings
Part 5. Conguring DB2 Clients to Use DB2 Connect
Copyright IBM Corp. 1993
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
Adding a Database Using Discovery
108 Quick Beginnings
Step 5. Register this database as an ODBC data source
Adding a Database Manually
110 Quick Beginnings
AS/400
OS/390 or MVS
VM or VSE
Creating and Using Proles
Server Proles
Client Proles
Step 3. Select the Export server prole option
v Database connection information including CLI or ODBC settings
Step 6. Click on OK. The Export Client Prole window opens
116 Quick Beginnings
Part 6. Using DB2 Connect
Copyright IBM Corp. 1993
118 Quick Beginnings
Chapter 10. Running Your Own Applications
Binding Database Utilities
Binding to Host Databases
Binding to DB2 Universal Databases
Running CLI/ODBC Programs
Reference
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
CATALOG user system ODBC DATA SOURCE
124 Quick Beginnings
OS/2 Client Access to DB2 using CLI/ODBC
3 Select the Register this database for ODBC check box
Detailed Conguration Information
126 Quick Beginnings
Running Java Programs
Silicon Graphics IRIX
Conguring the Environment
HP-UX
Solaris
On Windows and OS/2 platforms
Java Applications
On UNIX platforms
On UNIX platforms
Java Applets
Part 7. Appendixes
Copyright IBM Corp. 1993
132 Quick Beginnings
Starting the Client Conguration Assistant
Appendix A. Basic Task Knowledge
Starting the Software Registration Tool
OS/2 Click on OS/2 Warp and select DB2 for OS/2±Registration
On OS/2
Entering Commands Using the Command Center
Starting the Control Center
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
Windows-Command Line Processor
Interactive Input Mode
OS/2 Click on OS/2 Warp, and select DB2 for OS/2±Command
Windows 9x or Windows NT
Working with the System Administrative Group
OS/2
Page
Using the Control Center
Preparing DB2 for OS/390 Servers for the Control Center
v DB2 Universal Database UDB for Windows NT Version 5 all editions
142 Quick Beginnings
Appendix D. How the DB2 Library Is Structured
Completing Tasks with SmartGuides
Create-Table using SmartGuide
Accessing Online Help
How to Access
Create-Table space using
Type of Help
Contents
How to Access
Appendix D. How the DB2 Library Is Structured
Platform-specic books
DB2 Information ± Hardcopy and Online
Cross-platform books
Cross-platform sample programs in HTML
Administration Guide
Form Number
Name
Description
HTML
Form Number HTML
Name
Description
Directory
SC09-2851 db2q0 db2q0x60
Form Number HTML
Name
Description
Directory
See Application Building Guide for more
152 Quick Beginnings
Viewing Online Information
Tasks
Accessing Information with the Information Center
Troubleshooting
Reference
Setting Up a Document Server
Searching Online Information
Printing the PostScript Books
Ordering the Printed Books
158 Quick Beginnings
Appendix E. National Language Support NLS
Code Page and Language Support
Conversion of Character Data
Table 8. Languages and Code Pages continued
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
A maximum of 14 characters
Password Rules
DB2SYSTEM Naming Rules
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
Table 10. DRDA Bind Files and Packages continued
Appendix G. List Files, Bind Files, and Packages
172 Quick Beginnings
Appendix H. Notices
Trademarks
Trademarks of Other Companies
Appendix H. Notices
176 Quick Beginnings
Index
Page
Page
180 Quick Beginnings
Telephone
Contacting IBM
Anonymous FTP Sites
CompuServe
Page
IBMR
Part Number CT6D9NA