IBM
Page
 IBM
Page
 Contents
 Part 7. Appendixes 131
Part 6. Using DB2 Connect 117
Part 5. Conguring DB2 Clients to
Use DB2 Connect 103
 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 Enterprise Edition
About DB2 Connect
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
 Memory Requirements
Planning for Installation
DB2 Connect Requirements
Disk Requirements
 Software Requirements
Estimating Fixed Disk Requirements
 Software Requirements
Product Requirements
 Software Requirements
 Performing the Installation
Installing DB2 Connect on OS/2
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
 AS/400
OS/390 or MVS
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
 Starting the Multisite Update Smartguide
Enabling Multisite Updates Using the Control Center
Testing the Multisite Update Feature
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
 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
 Silicon Graphics Irix
Conguring the Environment
Solaris
Windows 32-bit operating systems
 On Unix platforms
Java Applications
On Windows and OS/2 platforms
 Java Applets
 Part 7. Appendixes
 Quick Beginnings
 Starting the Software Registration Tool
Appendix A. Basic Task Knowledge
Starting the Client Conguration Assistant
 Starting the Control Center
Entering Commands Using the Command Center
On OS/2
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
 OS/2 Click on OS/2 Warp, and select DB2 for OS/2±Command
Interactive Input Mode
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
 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
 DB2SYSTEM Naming Rules
Password Rules
OS/2 Maximum of 14 characters
Maximum of 8 characters
 Appendix G. List Files, Bind Files, and Packages
 Drda Server List File OS/390 and MVS
List Files Associated with Drda Servers
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
 Telephone
Contacting IBM
Anonymous FTP Sites
 CompuServe
Page
 Ibmr