IBM
Page
IBM
Page
Contents
Use DB2 Connect 103
Part 6. Using DB2 Connect 117
Part 7. Appendixes 131
Part 5. Conguring DB2 Clients to
Appendix G. List Files, Bind Files,
Vi Quick Beginnings
How This Book is Structured
Welcome to DB2 Connect
Conventions
Welcome to DB2 Connect
Quick Beginnings
Part 1. Introduction to DB2 Connect
Quick Beginnings
About DB2 Connect
DB2 Connect Enterprise Edition
DB2 Connect Personal Edition
Working with DB2 Data
OS/390 Appc TCP/IP*** Mptn
Connections via Communications Gateway
Escon
Quick Beginnings
About DB2 Connect
DB2 Connect Enterprise Edition
Using Transaction Monitors with DB2 Connect
Java Server Support
DB2 Connect working with Microsoft IIS
Accessing DB2 Data from the Web Using Java
Using Java Applets
Accessing DB2 Data from the Web Using Net.Data
Net.Data with DB2 Connect
Quick Beginnings
Running Your Own Applications
Quick Beginnings
Part 2. DB2 Connect Planning and Installation
Quick Beginnings
Disk Requirements
Planning for Installation
Memory Requirements
DB2 Connect Requirements
Software Requirements
Estimating Fixed Disk Requirements
Software Requirements
Product Requirements
Software Requirements
Installing DB2 Connect on OS/2
Performing the Installation
Before You Begin
\install
Software Registration
Upgrading from a Try-and-Buy License
Installing DB2 Connect on Windows 9x or Windows NT
Performing the Installation
Installing DB2 Connect on Windows 9x or Windows NT
Software Registration
Upgrading from a Try-and-Buy License
Quick Beginnings
Copyright IBM Corp
Quick Beginnings
Preparing MVS/ESA or OS/390 for DB2 Connect
Conguring Host and AS/400 Databases for DB2 Connect
Conguring Vtam
Summary of Steps
Sample Network Element Names Vtam
Sample Vtam PU and LU Denitions for DB2 Connect
Sample Vtam Log Mode Denition for DB2
TYPE=0
Conguring DB2 Universal Database for OS/390
Updating SYSIBM.LUNAMES
Conguring DB2 for MVS/ESA
Updating SYSIBM.SYSUSERNAMES
Prerequisite OS/390 Software for TCP/IP Support
Conguring TCP/IP for DB2 Universal Database for OS/390
Collecting Information
Description Sample Value Your Value User Information
Example Worksheet
Conguring the TCP/IP Connection
Update the DB2 Connect Directories
Dspneta
Preparing DB2 Universal Database for AS/400 for DB2 Connect
Parameter Example Your value
Preparing DB2 for VSE & VM
Quick Beginnings
Copyright IBM Corp
Quick Beginnings
Copyright IBM Corp
Conguration Steps
Register this database as an Odbc data source
Adding a Database Using a Prole
Adding a Database Using Discovery
Page
Adding a Database Manually
OS/390 or MVS
AS/400
VM or VSE
Quick Beginnings
Page
Quick Beginnings
Identify and Record Parameter Values
Conguring Appc Communications on the DB2 Connect Workstation
VM/VSE
Localdcsname
Conguring IBM eNetwork Communications Server for Windows NT
Update the Appc Proles on the DB2 Connect Workstation
Conguring Appc Communications on the DB2 Connect Workstation
Quick Beginnings
Conguration options eld, select Congure connections
Conguration options eld, select Congure devices
Quick Beginnings
Conguring Appc Communications on the DB2 Connect Workstation
Csstart -a
Conguring Appc Communications on the DB2 Connect Workstation
SNA Client Conguration window opens Congure Global Data
Conguring Microsoft SNA Server for Windows NT
Quick Beginnings
Conguring Appc Communications on the DB2 Connect Workstation
Quick Beginnings
Select the System Identication tab
Click on OK
Conguring Appc Communications on the DB2 Connect Workstation
Quick Beginnings
Conguring Appc Communications on the DB2 Connect Workstation
Conguring Microsoft SNA Client
OS/390 Appc TCP/IP*** Mptn
Obtain Required Information
Catalog the Appc or Appn Node
Program
Catalog the Database
Catalog the database by entering the following commands
Test the Host or AS/400 Connection
Bind Utilities and Applications to the Database Server
Select tabname from syscat.tables
Quick Beginnings
Enabling Multisite Updates Two-Phase Commit
Host and AS/400 multisite update scenarios that require SPM
TCP/IP
DB2 Connect DB2 for Personal OS/390 Edition
Smartguide Steps
Enabling Multisite Updates Using the Control Center
Starting the Multisite Update Smartguide
Testing the Multisite Update Feature
Quick Beginnings
Part 5. Conguring DB2 Clients to Use DB2 Connect
Quick Beginnings
105
Conguration Steps
Register this database as an Odbc data source
Adding a Database Using Discovery
Register this database as an Odbc data source
Adding a Database Manually
OS/390 or MVS
Server Proles
Creating and Using Proles
Select the Export server prole option
Client Proles
Quick Beginnings
Register this database as an Odbc data source
Quick Beginnings
Part 6. Using DB2 Connect
Quick Beginnings
Binding Database Utilities
Running Your Own Applications
Binding to DB2 Universal Databases
Binding to Host Databases
Reference
Running CLI/ODBC Programs
Quick Beginnings
Select the Register this database for Odbc check box
Platform Specic Details for CLI/ODBC Access
Catalog user system Odbc Data Source
OS/2 Client Access to DB2 using CLI/ODBC
Detailed Conguration Information
Running Java Programs
Windows 32-bit operating systems
Conguring the Environment
Silicon Graphics Irix
Solaris
Java Applications
On Unix platforms
On Windows and OS/2 platforms
Java Applets
Part 7. Appendixes
Quick Beginnings
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
Connect to sample list tables for system
Interactive Input Mode
Entering Commands Using the Command Line Processor
Command Line Mode
Command Line Mode
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
139
Preparing DB2 for OS/390 Servers for the Control Center
Using the Control Center
141
Quick Beginnings
Completing Tasks with SmartGuides
Appendix D. How the DB2 Library Is Structured
Create-Table using SmartGuide
Accessing Online Help
Type of Help Contents How to Access
DB2 Information ± Hardcopy and Online
Appendix D. How the DB2 Library Is Structured
Html
GC09-2857 db2iy Db2iyx60
Platform-Specic Books
Connect Enterprise Edition Quick Beginnings
Html
Viewing Online Information
Accessing Information with the Information Center
Setting Up a Document Server
Printing the PostScript Books
Searching Online Information
Ordering the Printed Books
Quick Beginnings
Code Page and Language Support
Appendix E. National Language Support NLS
Conversion of Character Data
Host CCSIDs Code Countries
Bidirectional Ccsid Support
Bidirectional-specic CCSIDs
Where Cdra String Types are dened
Appendix F. Naming Rules
General Naming Rules
Database, Database Alias, and Catalog Node Name Rules
Object Name Rules
Username, User ID, Group Name, and Instance Name Rules
Workstation Name nname Rules
Windows 32-bit operating systems Use any case
Maximum of 8 characters
Password Rules
DB2SYSTEM Naming Rules
OS/2 Maximum of 14 characters
Appendix G. List Files, Bind Files, and Packages
List Files Associated with Drda Servers
Drda Server List File OS/390 and MVS
OS/400
Rexx
Quick Beginnings
Canada
Appendix H. Notices
Trademarks of Other Companies
Trademarks
Appendix H. Notices
Quick Beginnings
Appc
Index
Location Name MVS, OS/390
SQL/DS
Quick Beginnings
Contacting IBM
Telephone
Anonymous FTP Sites
CompuServe
Page
Ibmr