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
 DB2 Connect Personal Edition
About DB2 Connect
DB2 Connect Enterprise 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
 Before You Begin
Installing DB2 Connect on OS/2
Performing the Installation
 \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
 VM or VSE
OS/390 or MVS
AS/400
 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
 On Windows and OS/2 platforms
Java Applications
On Unix platforms
 Java Applets
 Part 7. Appendixes
 Quick Beginnings
 Starting the Client Conguration Assistant
Appendix A. Basic Task Knowledge
Starting the Software Registration Tool
 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
 Windows-Command Line Processor
Interactive Input Mode
OS/2 Click on OS/2 Warp, and select DB2 for OS/2±Command
 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
 Database, Database Alias, and Catalog Node Name Rules
Appendix F. Naming Rules
General Naming Rules
 Object Name Rules
 Windows 32-bit operating systems Use any case
Username, User ID, Group Name, and Instance Name Rules
Workstation Name nname Rules
 Maximum of 8 characters
Password Rules
DB2SYSTEM Naming Rules
OS/2 Maximum of 14 characters
 Appendix G. List Files, Bind Files, and Packages
 OS/400
List Files Associated with Drda Servers
Drda Server List File OS/390 and MVS
 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
 Anonymous FTP Sites
Contacting IBM
Telephone
 CompuServe
Page
 Ibmr