IBM
Page
 IBM
Page
 Contents
 Part 5. Conguring DB2 Clients to
Part 6. Using DB2 Connect 117
Part 7. Appendixes 131
Use DB2 Connect 103
 Appendix G. List Files, Bind Files,
 Vi Quick Beginnings
 Welcome to DB2 Connect
How This Book is Structured
 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
 DB2 Connect Requirements
Planning for Installation
Memory Requirements
Disk Requirements
 Estimating Fixed Disk Requirements
Software Requirements
 Product Requirements
Software 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
 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 PU and LU Denitions for DB2 Connect
 Sample Vtam Log Mode Denition for DB2
 Conguring DB2 Universal Database for OS/390
TYPE=0
 Conguring DB2 for MVS/ESA
Updating SYSIBM.LUNAMES
 Updating SYSIBM.SYSUSERNAMES
 Conguring TCP/IP for DB2 Universal Database for OS/390
Prerequisite OS/390 Software for TCP/IP Support
 Collecting Information
 Example Worksheet
Description Sample Value Your Value User Information
 Conguring the TCP/IP Connection
 Update the DB2 Connect Directories
 Preparing DB2 Universal Database for AS/400 for DB2 Connect
Dspneta
 Preparing DB2 for VSE & VM
Parameter Example Your value
 Quick Beginnings
 Copyright IBM Corp
 Quick Beginnings
 Copyright IBM Corp
 Conguration Steps
 Adding a Database Using a Prole
Register this database as an Odbc data source
 Adding a Database Using Discovery
Page
 Adding a Database Manually
 OS/390 or MVS
AS/400
VM or VSE
 Quick Beginnings
Page
 Quick Beginnings
 Conguring Appc Communications on the DB2 Connect Workstation
Identify and Record Parameter Values
 VM/VSE
 Localdcsname
 Update the Appc Proles on the DB2 Connect Workstation
Conguring IBM eNetwork Communications Server for Windows NT
 Conguring Appc Communications on the DB2 Connect Workstation
 Quick Beginnings
 Conguration options eld, select Congure devices
Conguration options eld, select Congure connections
 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
 Catalog the Database
Program
 Catalog the database by entering the following commands
 Bind Utilities and Applications to the Database Server
Test the Host or AS/400 Connection
 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
 Testing the Multisite Update Feature
Enabling Multisite Updates Using the Control Center
Starting the Multisite Update Smartguide
Smartguide Steps
 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
 Creating and Using Proles
Server Proles
 Client Proles
Select the Export server prole option
 Quick Beginnings
 Register this database as an Odbc data source
 Quick Beginnings
 Part 6. Using DB2 Connect
 Quick Beginnings
 Running Your Own Applications
Binding Database Utilities
 Binding to Host Databases
Binding to DB2 Universal Databases
 Running CLI/ODBC Programs
Reference
 Quick Beginnings
 Platform Specic Details for CLI/ODBC Access
Select the Register this database for Odbc check box
 Catalog user system Odbc Data Source
 OS/2 Client Access to DB2 using CLI/ODBC
 Detailed Conguration Information
 Running Java Programs
 Solaris
Conguring the Environment
Silicon Graphics Irix
Windows 32-bit operating systems
 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 OS/2
Entering Commands Using the Command Center
Starting the Control Center
On Windows 9x or Windows NT
 Connect to sample list tables for system
 Command Line Mode
Entering Commands Using the Command Line Processor
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
 Working with the System Administrative Group
OS/2
 139
 Using the Control Center
Preparing DB2 for OS/390 Servers for the Control Center
 141
 Quick Beginnings
 Appendix D. How the DB2 Library Is Structured
Completing Tasks with SmartGuides
 Accessing Online Help
Create-Table using SmartGuide
 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
 Searching Online Information
Printing the PostScript Books
 Ordering the Printed Books
 Quick Beginnings
 Appendix E. National Language Support NLS
Code Page and Language Support
 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
 OS/2 Maximum of 14 characters
Password Rules
DB2SYSTEM Naming Rules
Maximum of 8 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
 Appendix H. Notices
Canada
 Trademarks
Trademarks of Other Companies
 Appendix H. Notices
 Quick Beginnings
 Index
Appc
 Location Name MVS, OS/390
 SQL/DS
 Quick Beginnings
 Contacting IBM
Telephone
Anonymous FTP Sites
 CompuServe
Page
 Ibmr