Conventions
Conventions
Installing and Configuring DB2 Clients
Memory Requirements
Disk Requirements
DB2 Clients
Software Requirements
Client Product Requirements
Possible Client-to-Server Connectivity Scenarios
NetQuestion Search System
Your Next Step
DB2 Run-Time Client
DB2 Administration Client
DB2 Application Development Client
Distributed Installation
DB2 Thin Client
Before You Begin Installing
Installing Without Administrator Authority
Installation Steps
Before You Begin Installing
Installation Steps
Before You Begin
About the db2setup utility
Updating Kernel Configuration Parameters
HP-UX Kernel Configuration Parameters
NUMA-Q/PTX Kernel Configuration Parameters
Solaris Kernel Configuration Parameters
Installing Your DB2 Client
Your next step
LDAP Directory Support Considerations
Before You Begin
Configuration Steps
Adding a Database Using a Profile
Adding a Database Using Discovery
Adding a Database Manually
Creating and Using Profiles
Server Profiles
Client Profiles
Configuring Named Pipes on the Client
Step 1. Identify and Record Parameter Values
Step 2. Configure the Client
Step 3. Test the Client-to-Server Connection
Configuring TCP/IP on the Client
Step 1. Identify and Record Parameter Values
Step 2. Configure the Client
Step 3. Test the Client-to-Server Connection
Configuring NetBIOS on the Client
Step 1. Identify and Record Parameter Values
Step 2. Configure the Client
Step 3. Test the Client-to-Server Connection
Configuring IPX/SPX on the Client
Step 1. Identify and Record Parameter Values
Step 2. Configure the Client
Step 3. Test the Client-to-Server Connection
Configuring APPC on the Client
Step 1. Identify and Record Parameter Values
Step 2. Update the APPC Profiles
Step 3. Catalog the APPC or APPN Node
Step 4. Catalog the Database
Step 5. Test the Client-to-Server Connection
Troubleshooting the Client-to-Server Connection
Application versus Applet
Machine Configurations
Supported Java Virtual Machines for the Control Center
Setting Up and Working with the Control Center
Control Center Services Setup (Applet Mode only)
Working with the Control Center
Functional Considerations
Installation Tips for Control Center Help on UNIX Operating Systems
Configuring TCP/IP on OS/2
Enabling Local Loopback
Enabling Localhost
Verifying TCP/IP Configuration on OS/2
Troubleshooting Information
Administering DB2 for OS/390 and DB2 Connect Enterprise Edition servers with the Control Center
Preparing DB2 for OS/390 Servers for the Control Center
Working with the Control Center
Other Sources of Information
Configuring Stored Procedure Builder to run as an add-in with Microsoft Visual Basic
Configuring Stored Procedure Builder to run as an add-in with Microsoft Visual C++
Configuring Stored Procedure Builder on AIX and Solaris
Setting Up Server Communications
Before You Begin
About the Control Center and Communications Protocols
Configuring DB2 Communications for Local Instances
Configuring DB2 Communications for Remote Instances
Setting the DB2COMM Registry Parameter
Configuring Named Pipes on the Server
Configuring TCP/IP on the Server
1. Identify and Record Parameter Values
2. Configure the Server
Configuring NetBIOS on the Server
1. Identify and Record Parameter Values
2. Configure the Server
Autostarting DB2 with NetBIOS (for Windows NT only)
Configuring IPX/SPX on the Server
1. Identify and Record Parameter Values
2. Configure the Server
Configuring APPC on the Server
1. Identify and Record Parameter Values
2. Configure the Server
Binding Database Utilities
Running CLI/ODBC Programs
Platform Specific Details for CLI/ODBC Access
Detailed Configuration Information
Running Java Programs
Configuring the Environment
Java Applications
Java Applets
Configuration Keywords by Category
CLI/ODBC Settings General Configuration Keywords
Compatibility Configuration Keywords
Data Type Configuration Keywords
Enterprise Configuration Keywords
Environment Configuration Keywords
File DSN Configuration Keywords
Optimization Configuration Keywords
Service Configuration Keywords
Static SQL Configuration Keywords
Transaction Configuration Keywords
Configuration Keyword Descriptions
APPENDAPINAME
ASYNCENABLE
BITDATA
CLIPKG
CLISCHEMA
CONNECTNODE
CONNECTTYPE
CURRENTFUNCTIONPATH
CURRENTPACKAGESET
CURRENTREFRESHAGE
CURRENTSCHEMA
CURRENTSQLID
CURSORHOLD
DATABASE
DB2CONNECTVERSION
DB2DEGREE
DB2ESTIMATE
DB2EXPLAIN
DB2OPTIMIZATION
DBALIAS
DBNAME
DEFAULTPROCLIBRARY
DEFERREDPREPARE
DISABLEMULTITHREAD
EARLYCLOSE
GRANTEELIST
GRANTORLIST
GRAPHIC
HOSTNAME
IGNOREWARNINGS
IGNOREWARNLIST
KEEPCONNECT
KEEPSTATEMENT
LOBMAXCOLUMNSIZE
LONGDATACOMPAT
MAXCONN
MODE
MULTICONNECT
OPTIMIZEFORNROWS
OPTIMIZESQLCOLUMNS
PATCH1
PATCH2
POPUPMESSAGE
PROTOCOL
PWD
QUERYTIMEOUTINTERVAL
SCHEMALIST
SERVICENAME
SQLSTATEFILTER
STATICCAPFILE
STATICLOGFILE
STATICMODE
STATICPACKAGE
SYNCPOINT
SYSSCHEMA
TABLETYPE
TEMPDIR
TRACE
TRACECOMM
TRACEFILENAME
TRACEFLUSH
TRACEPATHNAME
TXNISOLATION
UID
UNDERSCORE
WARNINGLIST
Configuring DB2 Connect to Host or AS/400 Communications
1. Identify and Record Parameter Values
2. Configure the DB2 Connect Workstation
A. Resolve the Host's IP Address
B. Update the Services File
3. Catalog the TCP/IP Node
4. Catalog the Database as a Database Connection Service (DCS) Database
5. Catalog the Database
6. Bind Utilities and Applications to the Database Server
7. Test the Host or AS/400 Connection
Test the Host Connection
1. Identify and Record Parameter Values
2. Update the APPC Profiles on the DB2 Connect Workstation
Configuring IBM eNetwork Communications Server for OS/2
Configuring IBM Personal Communications for Windows
Configuring IBM eNetwork Communications Server for Windows
Configuring IBM eNetwork Communications Server for Windows NT SNA API Client
Configuring Microsoft SNA Server for Windows
Configuring Microsoft SNA Client
Configuring IBM eNetwork Communication Server for AIX
Configuring Bull SNA for AIX
Configuring SNAPlus2 for HP-UX
Configuring SNAP-IX Version 6.0.1 for SPARC Solaris
Configuring SunLink 9.1 for Solaris
3. Catalog the APPC or APPN Node
4. Catalog the Database as a Database Connection Service (DCS) Database
5. Catalog the Database
6. Bind Utilities and Applications to the Database Server
7. Test the Host or AS/400 Connection
Host and AS/400 Multisite Update Scenarios that Require SPM
Configuring DB2 UDB as a DRDA Application Server
Supported Clients
PTFs Required
Configuration Steps for DB2 Universal Database Server
Configuring DB2 Universal Database Servers for Host or AS/400 Client Access
Using the DB2 Universal Database Server from Host or AS/400 Clients
Authentication
Troubleshooting
DRDA Functions Supported
Security and Auditability
Configuration Considerations
Types of Distributed Installation
Response File
Available Sample Response Files
Important Response File Keywords
Response File Keywords for OS/2 and Windows 32-Bit Operating Systems
Response File Keywords for DB2 Satellite Edition
DB2 Control Server Response File Keywords for Windows NT and Windows 2000
Killing DB2 Processes During Interactive and Response File Installations
Response File Generator
Where Do You Go From Here?
Before You Begin
Make DB2 Files Available for Installation
Set up Shared Access
Create a Response File
Run Setup with the Response File from the Client Workstation
DB2 Product Installation Using SMS
SMS Requirements
Import the DB2 Install File into SMS on the SMS Server
Create the SMS Package on the SMS Server
Distribute the DB2 Installation Package from the SMS Server
Configuring Client Settings
Configuring Remote Access to a Server Database
Configuring db2cli.ini
Exporting and Importing a Profile
Before You Begin
Limitations on Response File Install
Step 1. Mount the CD-ROM
Step 2. Create a Response File
Step 3. Start an Unattended Installation with a Response File
Installing DB2 Products from a Hard Disk or CD-ROM
Before You Begin
Make DB2 Files Available for Installation
Create a Response File for Distributed Installation
Run the CMD File from the Remote Workstation
Thin Client and Thin Connect Architecture
The Benefits and Disadvantages in a Thin Environment
Performing the Installation of a DB2 Thin-Client or DB2 Thin-Connect Environment
Step 1. Install a DB2 Administration Client or DB2 Connect Personal Edition With The Code Server Component
Step 2. Setup Cross-Platform Support on the Code Server (Optional)
Step 3. Share the Code Server Directory where the DB2 Client or DB2 Connect Personal Edition Code is Installed
Step 4. Create a Response File for the Target Thin-Workstation.
Step 5. Make the Code Server Accessible to the Target Thin-Workstation.
Step 6. Create the Target Thin-Workstation
Your Next Step
Configuring a Federated Database System
Supported Data Sources
Enabling Federated Database Functionality
Adding DB2 Family Data Sources to a Federated System
Verifying Connections to DB2 Family Data Sources
Installing DB2 Relational Connect
Installing DB2 Relational Connect on Windows Systems
Installing DB2 Relational Connect on AIX Systems
Adding Oracle Data Sources to a Federated System
Oracle Code Page Options
Verifying Connections to Oracle Data Sources
Enabling Federated Database Functionality
Adding OLE DB data sources to a Federated System
Starting the Client Configuration Assistant
Starting the DB2 Control Center
Entering Commands Using the Command Center
Entering Commands Using the Command Line Processor
DB2 Command Window
Interactive Input Mode
Working with the System Administrative Group
Granting Advanced User Rights on Windows
Windows NT
Windows 2000
Working with the Business Intelligence Functions
Mounting CD-ROMs on UNIX Operating Systems
Mounting the CD-ROM on AIX
Mounting the CD-ROM on HP-UX
Mounting the CD-ROM on Linux
Mounting the CD-ROM on PTX
Mounting the CD-ROM on Solaris
Setting the Number of Licensed Processors
Upgrading DB2 from Try and Buy Mode
NetQuestion Overview
Searching the DB2 Online Information
Solving Search Problems
NetQuestion for Windows 32-bit Operating Systems
Diagnosing NetQuestion Install Errors
TCP/IP Configuration
Changing the Port Number for the Search Server
Ensuring NetQuestion Environment Variables are set on a LAN-Connected Drive
Locating the NetQuestion Installation Directory
Searching With Proxies Enabled in Netscape or Internet Explorer
Searching with a Laptop on Windows 9x
Uninstalling NetQuestion on Windows 32-bit Operating Systems
NetQuestion for OS/2 Operating Systems
Additional NetQuestion Prerequisites
Switching NetQuestion to use TCP/IP
Changing the Port Number for the Search Server (TCP/IP only)
Error Detected When Starting NetQuestion
Searching while Disconnected from the Network
Locating the NetQuestion Directory
Uninstalling NetQuestion on OS/2
NetQuestion for UNIX Operating Systems
Installing NetQuestion on UNIX Systems
NetQuestion Installation Workarounds on UNIX Platforms
Considerations for Using a Web Server
Working with the DB2 Universal Database Documentation Files in a Client/Server Environment
Typical Web Server Scenarios
Scenario 1: Lotus Domino Go! Web Server on OS/2
Scenario 2: Netscape Enterprise Web Server on Windows NT
Scenario 3: Microsoft Internet Information Server on Windows NT
Serving Documentation in Multiple Languages
Serving Documentation for Multiple Platforms
DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online
Language and Codeset Support for UNIX Operating Systems
Code Page and Language Support for OS/2 and Windows Operating Environments
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
DB2SYSTEM Naming Rules
Password Rules