IBM
Page
IBM
Page
Contents
Part 6. Using DB2 Connect 117
Part 7. Appendixes 131
Part 5. Conguring DB2 Clients to
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
Planning for Installation
Memory Requirements
DB2 Connect 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
Enabling Multisite Updates Using the Control Center
Starting the Multisite Update Smartguide
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
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
Conguring the Environment
Silicon Graphics Irix
Solaris
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
Entering Commands Using the Command Center
Starting the Control Center
On OS/2
On Windows 9x or Windows NT
Connect to sample list tables for system
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
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
Password Rules
DB2SYSTEM Naming Rules
OS/2 Maximum of 14 characters
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