Quick Beginnings
IBM DB2 Connect
Personal Edition
Version
Page
Quick Beginnings
IBM DB2 Connect
Personal Edition
Version
Page
Contents
and Installation
Part 1. Introduction to DB2
Connect
Part 6. Using DB2 Connect
Part 7. Appendixes
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
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
OS/390 APPC TCP/IP*** MPTN
ESCON
DB2 Connect Enterprise Edition
Figure 3. DB2 Connect Enterprise Edition
Figure 4. Using Transaction Monitors with DB2 Connect
OS/390 APPC TCP/IP*** MPTN
ESCON
DB2 Connect Enterprise Edition
OS/390 APPC TCP/IP*** MPTN
ESCON
Figure 5. Java Server Support
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
Chapter 2. Planning for Installation
Memory Requirements
DB2 Connect Requirements
Disk Requirements
Software Requirements
Estimating Fixed Disk Requirements
Components
Product Requirements
Table 2. Software Requirements
Table 2. Software Requirements continued
Product
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
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
Sample Network Element Names VTAM
Sample VTAM APPL Denition for OS/390
NYM2DB2
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.SYSUSERNAMES
Updating SYSIBM.SYSLUNAMES
Updating SYSIBM.SYSLUMODES
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
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
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
Preparing DB2 for VSE & VM
Parameter
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
Adding a Database Using Discovery
60 Quick Beginnings
a. Click on the Add System push button
Adding a Database Manually
62 Quick Beginnings
OS/390 or MVS
AS/400
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
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
OS/390 APPC TCP/IP*** MPTN
ESCON
The rest of this section assumes
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
Table 6. Worksheet Parameter Values for Cataloging Databases
databasename
localdcsname of the remote
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
Enabling Multisite Updates Using the Control Center
Starting the Multisite Update Smartguide
Testing the Multisite Update Feature
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
Conguring the Environment
HP-UX
Silicon Graphics IRIX
Solaris
Java Applications
On UNIX platforms
On Windows and OS/2 platforms
On UNIX platforms
Java Applets
Part 7. Appendixes
Copyright IBM Corp. 1993
132 Quick Beginnings
Appendix A. Basic Task Knowledge
Starting the Software Registration Tool
Starting the Client Conguration Assistant
OS/2 Click on OS/2 Warp and select DB2 for OS/2±Registration
Entering Commands Using the Command Center
Starting the Control 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
Entering Commands Using the Command Line Processor
Command Line Mode
Command Line Mode
Interactive Input Mode
Interactive Input Mode
OS/2 Click on OS/2 Warp, and select DB2 for OS/2±Command
Windows-Command Line Processor
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
Accessing Online Help
How to Access
Create-Table using SmartGuide
Create-Table space using
Contents
How to Access
Type of Help
Appendix D. How the DB2 Library Is Structured
DB2 Information ± Hardcopy and Online
Cross-platform books
Platform-specic books
Cross-platform sample programs in HTML
Administration Guide
Name
Description
Form Number
HTML
Name
Description
Form Number HTML
Directory
SC09-2851 db2q0 db2q0x60
Name
Description
Form Number HTML
Directory
See Application Building Guide for more
152 Quick Beginnings
Viewing Online Information
Accessing Information with the Information Center
Troubleshooting
Tasks
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
Password Rules
DB2SYSTEM Naming 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
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