Quick Beginnings For DB2 Clients
IBM DB2 Universal Database Quick Beginnings for DB2 ClientsVersion 8GC09-4832-00
IBM DB2 Universal Database Quick Beginnings for DB2 ClientsVersion 8GC09-4832-00
Before using this information and the product it supports, be sure to read the general information under Notices.This document contains proprietary information of IBM. It is provided under a license agreement and is protected bycopyright law. The information contained in this publication does not include any product warranties, and anystatements provided in this manual should not be interpreted as such.You can order IBM publications online or through your local IBM representative.v To order publications online, go to the IBM Publications Center at www.ibm.com/shop/publications/orderv To find your local IBM representative, go to the IBM Directory of Worldwide Contacts atwww.ibm.com/planetwideTo order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-4YOU(426-4968).When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in anyway it believes appropriate without incurring any obligation to you. Copyright International Business Machines Corporation 1993 - 2002. All rights reserved.US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contractwith IBM Corp.
ContentsPart 1. Installing DB2 clients. . . . 1Chapter 1. DB2 clients overview . . . . . 3DB2 clients . . . . . . . . . . . . . 3DB2 Run-Time Client . . . . . . . . . 3DB2 Administration Client . . . . . . . 4DB2 Application Development Client . . . . 4Chapter 2. DB2 client requirements . . . . 7Memory requirements for DB2 clients . . . . 7Disk requirements for DB2 clients . . . . . 7Installation requirements for DB2 clients (AIX) 8Installation requirements for DB2 clients(HP-UX) . . . . . . . . . . . . . 9Installation requirements for DB2 clients(Linux) . . . . . . . . . . . . . . 11Installation requirements for DB2 clients(Solaris) . . . . . . . . . . . . . 12Installation requirements for DB2 clients(Windows) . . . . . . . . . . . . 14Chapter 3. Installing a DB2 clientInstalling a DB2 client on Windowssystems . . . . . . . . .Installing DB2 clients on UNIX. . . . . 17operating. . . . 17. . . . 19Part 2. Configuring client-to-servercommunications . . . . . . . . 21Chapter 4. Configuration scenarios .Supported and non-supported clientconfiguration scenarios . . . . . .Supported standard and gatewayconfiguration scenarios . . . . .Specific non-supported configurations. 23. 23. 23. 24Chapter 5. Configuring client-to-servercommunications using the ConfigurationAssistant . . . . . . . . . . . . 27Configuring a database connection usingDiscovery . . . . . . . . . . . . . 27Configuring a database connection using theConfiguration Assistant (CA) . . . . . . 28 Copyright IBM Corp. 1993 - 2002Client profiles . . . . . . . . . .Creating client profiles using the exportfunction of the Configuration Assistant (CA)Configuring client profiles using the importfunction of the Configuration Assistant (CA)Configuring a database connection using aprofile . . . . . . . . . . . . .LDAP Directory Support Considerations . 29. 30. 31. 33. 34Chapter 6. Configuring client-to-servercommunications using the command lineprocessor . . . . . . . . . . . .Configuring a client to server connectionusing the command line processor . . . .Cataloging a database . . . . . . . . .Cataloging a database using the CLP. . .Parameter values worksheet for cataloginga database . . . . . . . . . . .Configuring TCP/IP . . . . . . . . .Configuring TCP/IP on the client usingthe CLP . . . . . . . . . . . .TCP/IP parameter values worksheet forconfiguring a client to server connection .Resolving a server host address toconfigure a client to server connection . .Updating the services file on the client . .Cataloging the TCP/IP node on the clientConfiguring NetBIOS . . . . . . . . .Configuring NetBIOS on the client usingthe CLP . . . . . . . . . . . .Determining the logical adapter number ofthe client for the NetBIOS connection . .NetBIOS parameter values worksheet . .Cataloging the NetBIOS node on the DB2client . . . . . . . . . . . . .Updating the database managerconfiguration file for a NetBIOS connectionConfiguring Named Pipes . . . . . . .Configuring Named Pipes on the clientusing the CLP . . . . . . . . . .Named Pipes parameter values worksheetfor configuring Named Pipes on the client .Cataloging the Named Pipes node on theclient . . . . . . . . . . . . .Configuring APPC . . . . . . . . . .35353636383939404143434545464647484949505151iii
Configuring APPC communications on theDB2 client. . . . . . . . . . . .APPC parameter values worksheet for theDB2 client. . . . . . . . . . . .Updating APPC profiles on the DB2 clientConfiguring IBM eNetwork PersonalCommunications for Windows NT . . .Configuring IBM eNetworkCommunications Server for Windows NT .Configuring an SNA API Client for IBMeNetwork Communications Server forWindows . . . . . . . . . . . .Configuring Microsoft SNA Server . . .Configuring Microsoft SNA Client . . .Configuring IBM eNetworkCommunications Server for AIX . . . .Configuring Bull SNA for AIX . . . . .Configuring SNAPlus2 for HP-UX . . .Configure SNAP-IX for SPARC Solaris . .Cataloging the APPC node on the DB2client . . . . . . . . . . . . .Configuring IBM eNetwork PersonalCommunications for Windows . . . . .Configuring IBM eNetworkCommunications Server for Windows . .Testing a connection . . . . . . . . .Testing the client to server connectionusing the CLP . . . . . . . . . .Testing a database connection . . . . .515254555862646970757882858790959596Part 3. Thin clients . . . . . . . 99Chapter 7. Thin clients overview .Thin clients . . . . . . . . .Thin client environments . . . .Thin client considerations (Windows). . . 101. . . 101. . . 101. . . 104Chapter 8. Setting up thin clients . . .Setting up a thin-client environment . .Installing a DB2 Administration Client orDB2 Connect Personal Edition on the codeserver . . . . . . . . . . . . .Setting up cross-platform support on thecode server . . . . . . . . . . .Making the code directory available to allthin workstations . . . . . . . . .Creating a thin client response file . . .Mapping a network drive from the thinclient to the code server . . . . . . .ivQuick Beginnings for DB2 Clients. 107. 107Running the thnsetup command to enablethin clients . . . . . . . . . . . 114Part 4. Appendixes . . . . . . . 117Appendix A. DB2 Universal Databasetechnical information . . . . . . . .Overview of DB2 Universal Databasetechnical information. . . . . . . . .Categories of DB2 technical informationPrinting DB2 books from PDF files . . . .Ordering printed DB2 books . . . . . .Accessing online help . . . . . . . .Finding topics by accessing the DB2Information Center from a browser . . . .Finding product information by accessingthe DB2 Information Center from theadministration tools . . . . . . . . .Viewing technical documentation onlinedirectly from the DB2 HTML DocumentationCD. . . . . . . . . . . . . . .Updating the HTML documentation installedon your machine . . . . . . . . . .Copying files from the DB2 HTMLDocumentation CD to a Web Server. . . .Troubleshooting DB2 documentation searchwith Netscape 4.x . . . . . . . . . .Searching the DB2 documentation . . . .Online DB2 troubleshooting information . .Accessibility . . . . . . . . . . .Keyboard Input and Navigation . . . .Accessible Display . . . . . . . .Alternative Alert Cues . . . . . . .Compatibility with Assistive TechnologiesAccessible Documentation . . . . . .DB2 tutorials . . . . . . . . . . .DB2 Information Center for topics . . . 40140140140140141Appendix B. Notices . . . . . . . . 143Trademarks . . . . . . . . . . . . 146. 108Index. 108Contacting IBM . . . . . . . . . . 153Product information . . . . . . . . . 153. 110. 111. 113. 149
Part 1. Installing DB2 clients Copyright IBM Corp. 1993 - 20021
2Quick Beginnings for DB2 Clients
Chapter 1. DB2 clients overviewDB2 clientsThere are three types of DB2 clients:v Run-Time Clientv Administration Clientv Application Development ClientDB2 clients can connect to DB2 servers two releases later or one release earlierthan the client’s release level, as well as to servers at the same release level.This means that a DB2 Version 6 client can connect to DB2 servers at versions5, 6, 7, and 8.A database cannot be created on a DB2 client. You must access databases thatreside on a DB2 server.Related concepts:v “DB2 Run-Time Client” on page 3v “DB2 Administration Client” on page 4v “DB2 Application Development Client” on page 4Related tasks:v “Installing a DB2 client on Windows operating systems” on page 17v “Installing DB2 clients on UNIX” on page 18DB2 Run-Time ClientThe DB2 Run-Time Client is a light-weight client that provides thefunctionality required for an application to access DB2 Universal Database servers and DB2 Connect servers. Functionality includes communicationprotocol support and support for application interfaces such as JDBC, SQLj,ODBC, CLI, and OLE DB. As a result of the removal of most of the previousRun-Time Client GUI facilities, the Version 8 Run-Time Client now hasdiminished disk requirements.Notes:1. The Configuration Assistant is not packaged with the Windows Run-TimeClient. The only available GUI is the CLI/ODBC administration GUI. Copyright IBM Corp. 1993 - 20023
2. With the DB2 Run-Time Client, you must bind the CLI packages from amachine with the proper bind files before you can make use of it for CLIapplications.DB2 Run-Time Clients are available for the following platforms: AIX, HP-UX,Linux, the Solaris Operating Environment, and Windows operating systems.Related concepts:v “DB2 clients” on page 3v “DB2 Administration Client” on page 4v “DB2 Application Development Client” on page 4Related tasks:v “Installing a DB2 client on Windows operating systems” on page 17v “Installing DB2 clients on UNIX” on page 18DB2 Administration ClientA DB2 Administration Client provides the ability for workstations from avariety of platforms to access and administer DB2 databases. The DB2Administration Client has all the features of the DB2 Run-Time Client andalso includes all the DB2 administration tools and support for Thin Clients.DB2 Administration Clients are available for the following platforms: AIX,HP-UX, Linux, the Solaris Operating Environment, and Windows operatingsystems.Related concepts:v “DB2 clients” on page 3v “DB2 Run-Time Client” on page 3v “DB2 Application Development Client” on page 4Related tasks:v “Installing a DB2 client on Windows operating systems” on page 17v “Installing DB2 clients on UNIX” on page 18DB2 Application Development ClientThe DB2 Application Development Client is a collection of graphical andnon-graphical tools and components for developing character-based,multimedia, and object-oriented applications. Special features include theDevelopment Center and sample applications for all supported programming4Quick Beginnings for DB2 Clients
languages. The Application Development Client also includes the tools andcomponents provided as part of the DB2 Administration Client product.DB2 Application Development clients are available for the followingplatforms: AIX, HP-UX, Linux, the Solaris Operating Environment, andWindows operating systems.Related concepts:v “DB2 clients” on page 3v “DB2 Run-Time Client” on page 3v “DB2 Administration Client” on page 4Related tasks:v “Installing a DB2 client on Windows operating systems” on page 17v “Installing DB2 clients on UNIX” on page 18Chapter 1. DB2 clients overview5
6Quick Beginnings for DB2 Clients
Chapter 2. DB2 client requirementsMemory requirements for DB2 clientsThe following list outlines the recommended minimum memory requirementsfor the different types of DB2 clients:v The amount of memory required for the DB2 Run-Time client depends onthe operating system and the database applications that you are running. Inmost cases, it should be sufficient to use the minimum memoryrequirements of the operating system as the minimum requirement forrunning the DB2 Run-Time client.v To run graphical tools on an Administration or Application Developmentclient, you will require an additional amount of 64 MB of RAM. Forexample, to run graphical tools on an Administration Client machinerunning Windows 2000 Professional, you would need a minimum of 64 MBof RAM for the operating system plus an additional amount of 64 MB ofRAM for the tools.Note: Performance may be affected if less than the recommended minimummemory requirements are used.Related concepts:v “DB2 clients” on page 3Related tasks:v “Installing a DB2 client on Windows operating systems” on page 17v “Installing DB2 clients on UNIX” on page 18Disk requirements for DB2 clientsThe actual fixed disk requirements of your installation may vary dependingon your file system and the client components you install. Ensure that youhave included a disk space allowance for your application development toolsand communication products.The following tables provide minimum disk space requirements for DB2clients on Windows and UNIX–based operating systems. When you install aDB2 client using the DB2 Setup wizard, size estimates are dynamicallyprovided by the installation program based on installation type andcomponent selection. Copyright IBM Corp. 1993 - 20027
Table 1. DB2 Clients for Windows — recommended minimum disk spaceDB2 Clients for WindowsRecommended minimum disk space(MB)DB2 Run-Time Client20 to 30 MBDB2 Administration Client80 to 110 MBDB2 Application Development Client325 MB, including the JDKTable 2. DB2 Clients for UNIX — recommended minimum disk spaceDB2 Clients for UNIXRecommended minimum disk space(MB)DB2 Run-Time Client50 to 60 MBNote: An additional 20 MB may beneeded for the instance creation in the/home directory.DB2 Administration Client125 MB, not including the JRENote: An additional 20 MB may beneeded for the instance creation in the/home directory.DB2 Application Development Client130 to 160 MB, not including the JDKNote: An additional 20 MB may beneeded for the instance creation in the/home directory.Related concepts:v “DB2 clients” on page 3Related tasks:v “Installing a DB2 client on Windows operating systems” on page 17v “Installing DB2 clients on UNIX” on page 18Installation requirements for DB2 clients (AIX)The following list provides hardware requirements, operating systemrequirements, software requirements, and communication requirements foryour DB2 client on AIX.Hardware requirementsRISC System/6000Operating system requirementsAIX Version 4.3.3.78 or laterSoftware requirements8Quick Beginnings for DB2 Clients
v For LDAP (Lightweight Directory Access Protocol) support, yourequire an IBM SecureWay Directory Client V3.1.1 running on AIXV4.3.3.78 or later.v The Java Runtime Environment (JRE) Version 1.3.1 is required torun DB2 graphical tools, such as the Control Center. During theinstallation process, if the JRE is not already installed, it will beinstalled. The DB2 JAVA GUI tools are not provided with the DB2Version 8 Run-Time Client.v If you are installing the Application Development Client, you mayrequire the Java Developer’s Kit. During the installation process, ifthe JDK is not already installed, it will be installed.v If you are installing the Application Development Client, you musthave a C compiler to build SQL Stored Procedures.Communication requirementsv TCP/IP (The AIX base operating system provides TCP/IPconnectivity, if selected during install.)Note: In Version 8, DB2 only supports TCP/IP for remotelyadministering a database.Related concepts:vvvv“DB2 clients” on page 3“DB2 Run-Time Client” on page 3“DB2 Administration Client” on page 4“DB2 Application Development Client” on page 4Related tasks:v “Installing DB2 clients on UNIX” on page 18Related reference:v “Memory requirements for DB2 clients” on page 7v “Disk requirements for DB2 clients” on page 7Installation requirements for DB2 clients (HP-UX)The following list provides hardware requirements, operating systemrequirements, software requirements, and communication requirements foryour DB2 client on HP-UX.Restrictions:Chapter 2. DB2 client requirements9
A system reboot is required if the kernel configuration parameters have beenupdated. The kernel configuration parameters are set in /etc/system and ifthese parameters require modification to accommodate the DB2 client, areboot will be necessary to make the changes to /etc/system effective.Note: The parameters must be set in advance of the DB2 client install.Hardware requirementsHP 9000 Series 700 or 800 systemOperating system requirementsv HP-UX 11.0 32-bit with general release bundle PHSS-24303v HP-UX 11.0 64-bit with general release bundle PHSS-24303v HP-UX 11i 32-bit with June 2001 general release bundlev HP-UX 11i 64-bit with June 2001 general release bundleSoftware requirementsv The Java Runtime Environment (JRE) Version 1.3.1 is required torun DB2 graphical tools, such as the Control Center. During theinstallation process, if the JRE is not already installed, it will beinstalled. The DB2 JAVA GUI tools are not provided with the DB2Version 8 Run-Time Client.v If you are installing the Application Development Client, you mayrequire the Java Developer’s Kit. During the installation process, ifthe JDK is not already installed, it will be installed.v If you are installing the Application Development Client, you musthave a C compiler to build SQL Stored Procedures.Communication requirementsv TCP/IP (TCP/IP is provided with the HP-UX base operatingsystem.)Note: In Version 8, DB2 only supports TCP/IP for remotelyadministering a database.Related concepts:vvvv“DB2 clients” on page 3“DB2 Run-Time Client” on page 3“DB2 Administration Client” on page 4“DB2 Application Development Client” on page 4Related tasks:v “Modifying kernel parameters (HP-UX)” in the Quick Beginnings for DB2Servers10Quick Beginnings for DB2 Clients
v “Installing DB2 clients on UNIX” on page 18Related reference:v “Memory requirements for DB2 clients” on page 7v “Disk requirements for DB2 clients” on page 7Installation requirements for DB2 clients (Linux)The following list provides operating system requirements, softwarerequirements, and communication requirements for your DB2 client on Linux.Restrictions:A system reboot is required if the kernel configuration parameters have beenupdated. The kernel configuration parameters are set in /etc/system and ifthese parameters require modification to accommodate the DB2 client, areboot will be necessary to make the changes to /etc/system effective.Note: The parameters must be set in advance of the DB2 client install.Operating system requirementsFor Intel 32–bit architecture you require:v kernel level 2.4.9 or higherv glibc 2.2.4v RPM 3For Intel 64–bit architecture you require one of the following:v Red Hat Linux 7.2; ORv SuSE Linux SLES-7For z-Series architecture you require one of the following:v Red Hat Linux 7.2; ORv SuSE Linux SLES-7Software requirementsv The Java Runtime Environment (JRE) Version 1.3.1 is required torun DB2 graphical tools, such as the Control Center. The DB2 JAVAGUI tools are not provided with the DB2 Version 8 Run-TimeClient.v If you are installing the Application Development Client, you mayrequire the Java Developer’s Kit. During the installation process, ifChapter 2. DB2 client requirements11
the JDK is not already installed, it will be installed. The same isapplicable for JRE on all platforms, except for Linux where the JDKcannot be installed over the JRE.v If you are installing the Application Development Client, you musthave a C compiler to build SQL Stored Procedures.Communication requirementsv TCP/IP (The Linux base operating system provides TCP/IPconnectivity, if selected during installation).Note: In Version 8, DB2 only supports TCP/IP for remotelyadministering a database.Related concepts:v “DB2 clients” on page 3v “DB2 Run-Time Client” on page 3v “DB2 Administration Client” on page 4v “DB2 Application Development Client” on page 4Related tasks:v “Installing DB2 clients on UNIX” on page 18v “Modifying kernel parameters (Linux)” in the Quick Beginnings for DB2ServersRelated reference:v “Memory requirements for DB2 clients” on page 7v “Disk requirements for DB2 clients” on page 7Installation requirements for DB2 clients (Solaris)The following list provides hardware requirements, operating systemrequirements, software requirements, and communication requirements foryour DB2 client on the Solaris Operating Environment.Restrictions:A system reboot is required if the kernel configuration parameters have beenupdated. The kernel configuration parameters are set in /etc/system and ifthese parameters require modification to accommodate the DB2 client, areboot will be necessary to make the changes to /etc/system effective.Note: The parameters must be set in advance of the DB2 client install.12Quick Beginnings for DB2 Clients
Hardware requirementsSolaris SPARC-based computerOperating system requirementsv Solaris Version 2.7 or laterNote: Solaris Version 2.7 is required for 64-bit.v The following patches are required for the Solaris operatingenvironment Version 2-bit)(64-bit)(32-bit)(64-bit)patch 106327-8patch 106300-09patch 108434-01 108528-12patches 108435-01 108528-12Software requirementsv For 32-bit Solaris, the Java Runtime Environment (JRE) Version 1.3.1is required to run DB2 graphical tools, such as the Control Center.The DB2 JAVA GUI tools are not provided with the DB2 Version 8Run-Time Client.v For 64-bit Solaris, the Java Runtime Environment (JRE) Version 1.4.0is required to run DB2 graphical tools, such as the Control Center.The DB2 JAVA GUI tools will not be provided with the DB2 Version8 Run-Time Client.v If you are installing the Application Development Client, you mayrequire the Java Developer’s Kit. The JDK will be available with theelectronically downloaded version of DB2. For installation usingCDs, the JDK will be included on a separate CD. This is alsoapplicable for the JRE.v If you are installing the Application Development Client, you musthave a C compiler to build SQL Stored Procedures.Communication requirementsv TCP/IP (The Solaris base operating system provides TCP/IPconnectivity.)Note: In Version 8, DB2 only supports TCP/IP for remotelyadministering a database.Related concepts:v “DB2 clients” on page 3v “DB2 Run-Time Client” on page 3v “DB2 Administration Client” on page 4v “DB2 Application Development Client” on page 4Chapter 2. DB2 client requirements13
Related tasks:v “Modifying kernel parameters (Solaris)” in the Quick Beginnings for DB2Serversv “Installing DB2 clients on UNIX” on page 18Related reference:v “Memory requirements for DB2 clients” on page 7v “Disk requirements for DB2 clients” on page 7Installation requirements for DB2 clients (Windows)The following list provides operating system requirements, softwarerequirements, and communication requirements for your DB2 client onWindows.Operating system requirementsOne of the following:vvvvWindows 98Windows MEWindows NT Version 4.0 with Service Pack 6a or laterWindows NT Server 4.0, Terminal Server Edition (only supports theDB2 Run-Time Client) with Service Pack 6 or later for TerminalServerv Windows 2000v Windows XP (32-bit and 64-bit editions)v Windows .NET servers (32-bit and 64-bit editions)Software requirementsv The Java Runtime Environment (JRE) Version 1.3.1 is required torun DB2 graphical tools, such as the Control Center. If the JRE isnot already installed, it will be installed for use by DB2. The DB2JAVA GUI tools are not provided with the DB2 Version 8 Run-TimeClient.v If you plan to use LDAP (Lightweight Directory Access Protocol),you require either a Microsoft LDAP client or an IBM SecureWayLDAP client V3.1.1 or later. Microsoft LDAP client is included withthe operating system for Windows ME, Windows 2000, WindowsXP, and Windows .NET.v If you plan to use the Tivoli Storage Manager facilities for backupand restore of your databases, you require the Tivoli StorageManager Client Version 3 or later.14Quick Beginnings for DB2 Clients
v If you have the IBM Antivirus program installed on your operatingsystem, it must be disabled or uninstalled to complete a DB2installation.v If you are installing the Application Development Client, you musthave a C compiler to build SQL Stored Procedures.Communication requirementsv Named Pipes, NetBIOS, or TCP/IP.v The Windows base operating system provides Named Pipes,NetBIOS, and TCP/IP connectivity.Note: In Version 8, DB2 only supports TCP/IP for remotelyadministering a database.Related concepts:v “DB2 clients” on page 3v “DB2 Run-Time Client” on page 3v “DB2 Administration Client” on page 4v “DB2 Application Development Client” on page 4Related tasks:v “Installing a DB2 client on Windows operating systems” on page 17Related reference:v “Memory requirements for DB2 clients” on page 7v “Disk requirements for DB2 clients” on page 7Chapter 2. DB2 client requirements15
16Quick Beginnings for DB2 Clients
Chapter 3. Installing a DB2 clientInstalling a DB2 client on Windows operating systemsThis task describes how to install a DB2 client on a Windows operatingsystem.Prerequisites:Before you install your DB2 client:v Ensure that your system meets all of the memory, disk space, andinstallation requirements.v Ensure that you have a user account to perform the installation:Windows 98, Windows MEAny valid Windows 98 user account.Windows Terminal Server, Windows NT, Windows 2000, Windows XP,and Windows .NETA user account that belongs to a group with more authority thanthe Guests group, such as the Users group.Note: To perform an installation on Windows 2000 servers andWindows .NET as part of the Users group, the registrypermissions have to be modified to allow Users write accessto the HKEY LOCAL MACHINE\Software registry branch. In thedefault Windows 2000 and Windows .NET environment,members of the Users group only have read access to theHKEY LOCAL MACHINE\Software registry branch.Procedure:To install a DB2 client:1. Log on to the system with the user account that you want to use toperform the installation.2. Shut down any other programs so that the DB2 Setup wizard can updatefiles as required.3. Insert the appropriate CD-ROM into the drive. The auto-run featureautomatically starts the DB2 Setup wizard. The DB2 Setup wizard willdetermine the system language, and launch the setup program for that Copyright IBM Corp. 1993 - 200217
language. You can run the DB2 Setup wizard in a language other than thedefault system language by manually invoking the DB2 Setup wizard andspecifying a language code.4. Choose Install Products once the DB2 Launchpad opens.5. Proceed by following the DB2 Setup wizard’s prompts. Online help isavailable to guide you through the remaining steps.After installing your DB2 client, you should configure it to access a remoteDB2 server.Note: In Version 8, DB2 only supports TCP/IP for remotely administering adatabase.Related tasks:v “Configuring a client to server connection using the Configuration Assistant(CA)” in the Quick Beginnings for DB2 Serversv “Configuring remote access to a server database” in the Installation andConfiguration Supplementv “Starting the DB2 Setup wizard for a DB2 server installation (Windows)” inthe Quick Beginnings for DB2 ServersRelated reference:v “Language identifiers (for running the DB2 Setup wizard in anotherlanguage)” in the Quick Beginnings for DB2 ServersInstalling DB2 clients on UNIXThis task provides steps for installing a DB2 client on UNIX.Prerequisites:Before you begin installing a DB2 client on UNIX:v Ensure that your system meets all of the memory, hardware, and softwarerequirements to install your DB2 product.v Installing a DB2 client in the Solaris Operating Environment or on HP-UXrequires that you update your kernel configuration parameters and restartyour system.Procedure:After updating your kernel configuration parameters and rebooting yoursystem (required for Solaris and HP-UX), you can install your DB2 client.18Quick Beginnings for DB2 Clients
To1.2.3.4.5.6.7.install a DB2 client on UNIX:Log in as a user with root authority.Insert and mount the appropriate CD-ROM.Change to the directory where the CD-ROM is mounted by entering thecd /cdrom command where /cdrom is the CD-ROM mount point.Enter the ./db2setup command. At this point the DB2 Setup Wizard willstart.Choose Install Products once the DB2 Launchpad opens.Select the client you want to install.Proceed by following the DB2 setup Wizard’s prompts. Online help isavailable to guide you through the remaining steps.When installation is complete DB2 software will be installed in the DB2DIRdirectory,where DB2DIR /usr/opt/db2 08 01 on AIX /opt/IBM/db2/V8.1 on all other UNIX operatingsystems.After installing your DB2 client, you should configure it to access a remoteDB2 server.Note: In Version 8, DB2 only supports TCP/IP for remotely administering adatabase.Related tasks:v “Modifying kernel parameters (Solaris)” in the Quick Beginnings for DB2Serversv “Modifying kernel parameters (HP-UX)” in the Quick Beginnings for DB2Serversv “Configuring a client to server connection using the Configuration Assistant(CA)” in the Quick Beginnings for DB2 Serversv “Configuring remote access to a server database” in the Installation andConfiguration Supplementv “Modifying kernel parameters (Linux)” in the Quick Beginnings for DB2ServersChapter 3. Installing a DB2 client19
20Quick Beginnings for DB2 Clients
Part 2. Configuring client-to-server communications Copyright IBM Corp. 1993 - 200221
22Quick Beginnings for DB2 Clients
Chapter 4. Configuration scenariosSupported and non-supported client configuration scenariosThis section
also includes all the DB2 administration tools and support for Thin Clients. DB2 Administration Clients are available for the following platforms: AIX, HP-UX, Linux, the Solaris Operating Environment, and Windows operating systems. Related concepts: v “DB2 clients” on page 3 v “DB2 Run-Time Client” on page 3
For the first time ever, DB2 functionality which has previously been available on Linux, Unix, and Windows (LUW) is now available for Mac OS X. These DB2 products are available free of charge through the . DB2 Express-C program. The DB2 Express-C program gives you access to a DB2 data server (DB2 Express-C) and DB2 Client for Mac OS X.
DB2 Logs, but Were Afraid to Ask Paul Pendle, Rocket Software Session: 16906. Agenda DB2 Logs Introduction DB2 Logging Components Log Performance How to Leverage the DB2 Log DIY Log Analysis DB2 Log Analysis Tool. DB2 Log Introduction Central to every updating transaction
DB2 Command Line Editor -is an application you can use to run DB2 commands, operating system commands, or SQL statements. Development Center (V8) / DB2 Developer Workbench (V9) -is used to create business logic for databases (stored procedures and user defined functions). Visual Explain (DB2 LUW version included with client ) lets you view the
Basic instructions to drop a table in DB2. Examples Basic Drop Table Syntax db2 connect to {databaseName} db2 drop table {schema}.{table} db2 connect reset The schema is not necessary if it matches the current user name. The "db2" prefix is not necessary if you are already in a DB2 command prompt.
db2_install - Install DB2 database product.712 db2_local_ps - DB2 process status for Linux/UNIX 715 db2acsutil - Manage DB2 snapshot backup objects 717 db2addicons - Create main menu entries for DB2 tools .721 db2admin - DB2 administration server .722 db2adutl - Managing DB2 objects within TSM . . 724
Multisystem. . .52 Directed join with DB2 Multisystem.52 Repartitioned join with DB2 Multisystem.53 Broadcast join with DB2 Multisystem . . .54 Join optimization with DB2 Multisystem. . . .55 Partitioning keys over join fields with DB2 Multisystem.55 Implementation and optimization of grouping with DB2 Multisystem.55 One-step .
Bruksanvisning för bilstereo . Bruksanvisning for bilstereo . Instrukcja obsługi samochodowego odtwarzacza stereo . Operating Instructions for Car Stereo . 610-104 . SV . Bruksanvisning i original
Accounting and Reporting by Charities: Statement of Recommended Practice applicable to charities preparing their accounts in accordance with the Financial
