Ibm GC09-2830-00 Manual do Utilizador

IBM DB2 ConnectPersonal EditionQuick BeginningsVe r s i o n 6GC09-2830-00IBM

connections. For DB2 Connect installation instructions, see “Part 2.DB2 Connect: Planning and Installation” on page 21.Step 5. After installation, you

Configuring Microsoft SNA ClientRead this section if you have a Windows NT workstation that has DB2Connect installed. This section provides step-by-ste

The rest of this section assumes:1. The Microsoft SNA Server has already been configured for APPCcommunications with the host, and is enabled for ODBC

2. Microsoft SNA Client Version 2.11 is not already installed on your DB2Connect workstation.To configure the Microsoft SNA client perform the followin

__ a. The Symbolic destination name (16) defined at the MicrosoftSNA Server for the Partner LU (2) of the target host orAS/400 database server.__ b

program name (17), the mode (15), and the security type. Enterthe following commands substituting your values from the worksheetin Table 5 on page

database name (database_name). The information in the database directory,along with the information in the node directory, is used on the DB2 Connectw

If you need to change values that were set with the catalog databasecommand, perform the following steps:Step a. Run the uncatalog database command:un

The userid and password values required are those defined at the host orAS/400 system, and must be provided to you by your DB2 Administrator. Formore i

96 Quick Beginnings

Chapter 8. Enabling Multisite Updates (Two-Phase Commit)This chapter provides an overview of the multisite update function as itapplies to scenarios t

This icon marks a fast path. A fast path guides you to informationspecific to your configuration where multiple options are available.This icon marks a

TP Monitor multisite update can coordinate a transaction that accesses bothDB2 and non-DB2 resource managers such as Oracle, Informix, SQLServer, etc.

Host and AS/400 multisite update scenarios that require SPM.Yes TCP/IP Yesv DB2 ConnectEnterpriseEditionv DB2UniversalDatabaseEnterpriseEditionv DB2Un

Host and AS/400 multisite update scenarios that require SPM.No TCP/IP Nov DB2 ConnectPersonalEditionv DB2 ConnectEnterpriseEditionv DB2UniversalDataba

1. Set your Web browser to the following URL:http://www.software.ibm.com/data/db2/library/2. Select ″DB2 Universal Database″.3. Search for ″Technotes″

Step 2. Select the databases you wish to test from the available databases inthe left sub-window. You can use the arrow buttons in the middle tomove s

Part 5. Configuring DB2 Clients to Use DB2 Connect© Copyright IBM Corp. 1993, 1999 103

104 Quick Beginnings

Chapter 9. Configuring Client-to-Server CommunicationsUsing the Client Configuration AssistantTo configure communications from a DB2 client to a server,

When you add a database using this configuration method, theClient Configuration Assistant will generate a default node name forthe server where the dat

Step 2. Click on the ... push button and select a profile.Step 3. Enter a local database alias name in the Database alias field and adda comment that de

x Quick Beginnings

Adding a Database Using DiscoveryThis option cannot return information about pre-Version 5 DB2systems or any systems where an Administration Server is

b. Enter the required communication protocol parameters for theremote Administration Server and click on OK. A new system isadded. For more informatio

Step 8. You are now able to use this database. To finish using the AddDatabase SmartGuide, click on the Close push button; you can thenadd more databas

OS/390 or MVSLocation nameAS/400RDB nameVM or VSEDBNAMEWhen a database is created on the remote server, if a database aliasis not specified during data

have incorrectly specified or click on the Help push button for moreinformation. For even more detailed information, refer to theTroubleshooting Guide.

have the discover_inst database manager configuration parameter anddatabases with the discover_db database configuration parameter set toENABLE. The dis

A Client Profile is generated from a client using the Export function of theCCA. The information contained in a Client Profile is determined during thee

Step 6. Click on OK. The Export Client Profile window opens.Step 7. Enter a path and file name for this Client Profile and click on OK.The DB2 Message wi

v If you would like all users on your system to have access tothis data source, select the As a system data source radiobutton.v If you would like onl

Part 6. Using DB2 Connect© Copyright IBM Corp. 1993, 1999 117

Part 1. Introduction to DB2 Connect© Copyright IBM Corp. 1993, 1999 1

118 Quick Beginnings

Chapter 10. Running Your Own ApplicationsVarious types of applications can access DB2 databases:v Applications developed using the DB2 Software Develo

The bind files are grouped together in different .lst files in the bnd directory,under the installation directory (typically sqllib\win on Windows 3.x s

"bind @db2ubind.lst messages bind.msg grant public""bind @db2cli.lst messages clibind.msg grant public"In this example, bind.msg a

The following general steps are required on the client system to give DB2 CLIand ODBC applications access to DB2 databases. These instructions assumet

Platform Specific Details for CLI/ODBC AccessThe platform specific details on how to give DB2 CLI and ODBCapplications access to DB2 are divided into th

d. On Windows 32-bit operating systems you can use the radiobuttons to add the data source as either a user or system datasource.v Using the Microsoft

OS/2 Client Access to DB2 using CLI/ODBCBefore DB2 CLI and ODBC applications can successfully access a DB2database from an OS/2 client, perform the fo

2) Click on the Add push button from the Data Sources window.The Add Data Source Window opens.3) Double-click on the IBM DB2 ODBC DRIVER in the list.4

Running Java ProgramsYou can develop Java programs to access DB2 databases with the appropriateJava Development Kit (JDK) on AIX, HP-UX, Linux, OS/2,

2 Quick Beginnings

Configuring the EnvironmentTo build and run DB2 Java programs, you need to install and configure theappropriate version of the Java Development Kit (JDK

You may want to pipe the output to a file for easier viewing. The JDK11_PATHfield appears near the beginning of the output. For more information on thes

java prog_namewhere prog_name is the name of the program.The DB2 JDBC driver handles the JDBC API calls from your application anduses the DB2 CAE to c

Part 7. Appendixes© Copyright IBM Corp. 1993, 1999 131

132 Quick Beginnings

Appendix A. Basic Task KnowledgeThis section describes the basic tasks that you will need to know to use thisproduct effectively.Go to the task that y

Starting the Control CenterStart the Control Center in one of the following ways:On OS/2v Enter the db2cc command at a command prompt.orv Click on the

v Display all the command scripts known to the system through the ScriptCenter, with summary information listed for each.Start the Command Center in o

To save commands as scripts, select Script->Save as from the menu bar. Formore information, click on the Help push button or press the F1 key.If yo

If the DB2 command contains characters that have special meaningon the operating system you are using, you will need to enter thecommand in quotation

Chapter 1. About DB2 ConnectDB2 Connect Enterprise EditionDB2 Connect Enterprise Edition is a connectivity server thatconcentrates and manages connect

db2 => select empno, function, firstname, lastname, birthdate, from \db2 (cont.) => employee where function='service' and \db2 (cont.)

Appendix B. Using the Control Center to Administer DB2for OS/390 and DB2 Connect Enterprise Edition serversDB2 Control Center is an easy to use applic

Preparing DB2 for OS/390 Servers for the Control CenterThe DB2 Control Center uses stored procedures to deliver many of itsmanagement functions. There

Appendix C. db2cpic.dll - Extended SNA Security Codes onWindows NT and Windows 95Extended SNA Security Codes were not implemented by some SNAsubsystem

142 Quick Beginnings

Appendix D. How the DB2 Library Is StructuredThe DB2 Universal Database library consists of SmartGuides, online help,books and sample programs in HTML

SmartGuide Helps You to... How to Access...Create Table Select basic data types, and create a primarykey for the table.From the Control Center, click

Type of Help Contents How to Access...Control Center HelpClient ConfigurationAssistant HelpEvent Analyzer HelpCommand Center HelpExplains the tasks you

DB2 Information – Hardcopy and OnlineThe table in this section lists the DB2 books. They are divided into twogroups:Cross-platform booksThese books co

Name Description Form NumberFile Name forOnline BookHTMLDirectoryCross-Platform BooksAdministration Guide Administration Guide, Design andImplementati

Working with DB2 DataAs well as providing a relational database to store your data, DB2 lets youissue requests to administer, query, update, insert, o

Name Description Form NumberFile Name forOnline BookHTMLDirectoryApplication DevelopmentGuideExplains how to develop applicationsthat access DB2 datab

Name Description Form NumberFile Name forOnline BookHTMLDirectoryInstallation andConfiguration SupplementGuides you through the planning,installation,

Name Description Form NumberFile Name forOnline BookHTMLDirectoryWhat’s New Describes the new features, functions,and enhancements in DB2 UniversalDat

Name Description Form NumberFile Name forOnline BookHTMLDirectoryDB2 Enterprise - ExtendedEdition for Windows NTQuick BeginningsProvides planning, ins

Name Description Form NumberFile Name forOnline BookHTMLDirectoryCross-Platform Sample Programs in HTMLSample programs inHTMLProvides the sample progr

Swedish sTrad. Chinese tTurkish m2. For late breaking information that could not be included in the DB2 books:v On UNIX-based platforms, see the Relea

If you have not installed the Information Center, you can open the pageby double-clicking on the DB2 Online Books icon. Depending on thesystem you are

Web. To access this information, you musthave a connection to the Web from yoursystem.When you select an item in one of the lists, the Information Cen

v List of booksv Tables of contents of frequently used booksv Frequently referenced articles, such as the ALTER TABLE topicv The Search formFor inform

book, simply run it as you would run any other executable program. Theresult from this step is a printable PostScript file with a file extension of.ps.3

In this environment, if you are using Windows 32-bit operating systems youcan use the DB2 Connect Personal Edition Integrated SNA Support to connectdi

Note: These form numbers only apply if you are ordering books that areprinted in the English language in North America.You can also order books indivi

Appendix E. National Language Support (NLS)This section contains information about configuring national language supportfor the DB2 Connect product, an

Table 8. Languages and Code Pages (continued)Country Code Languageen Englishes Spanishfi Finnishfr Frenchgr Greekhu Hungarianil Hebrewit Italianjp Japa

FOR BIT DATA clause) is not converted. Otherwise all input and outputcharacter data is converted if the two machines have different code pages orCCSID

Table 9. Workstation Code Page to Host CCSID Conversion (continued)Host CCSIDs Code Page Countries838 874 Thailand930, 939, 5026, 5035 932, 942, 943,

Since defaults on different platforms are not the same, problems appear whenDB2 data is sent from one platform to another. For example, Windowsplatfor

X'3F21' 856 11X'3F22' 862 11X'3F23' 916 11X'3F24' 1255 11Where CDRA String Types are defined:String - Text - Nu

Appendix F. Naming RulesGo to the section that describes the naming rules that you requireinformation on:v “General Naming Rules”v “Database, Database

Database alias names are synonyms given to remote databases. Database aliasesmust be unique within the System Database Directory in which all aliases

Using delimited identifiers, it is possible to create an object thatviolates these naming rules; however, subsequent use of the objectcould result in e

Connections via Communications GatewaySome organizations prefer to concentrate access to SNA networks throughdedicated SNA Gateways, such as IBM eNetw

v Can contain 1 to 8 charactersv Cannot include &, #, and @v Must be unique within the networkDB2SYSTEM Naming RulesDB2 uses the DB2SYSTEM name to

Appendix G. List Files, Bind Files, and PackagesThis appendix lists the bind files contained in different .lst files shipped withthe product. Although t

xMz Clients for MacintoshxGz Clients for Silicon GraphicsList Files Associated with DRDA ServersThe following table lists which bind files are included

Table 10. DRDA Bind Files and Packages (continued)Component Bind FileNamePackageNameMVS VM/VSE OS/400Isolation level NC db2clpnc.bnd sqlc6xyz no no ye

172 Quick Beginnings

Appendix H. NoticesAny reference to an IBM licensed program in this publication is not intendedto state or imply that only IBM’s licensed program may

TrademarksThe following terms are trademarks or registered trademarks of the IBMCorporation in the United States and/or other countries:ACF/VTAMADSTAR

Microsoft, Windows, Windows NT, Visual Basic, and the Windows logo aretrademarks or registered trademarks of Microsoft Corporation in the UnitedStates

176 Quick Beginnings

IndexAAccess Profilecreating 113using 112accessing datathrough DB2 Connect 8through Net.Data or JDBC 14accessing host serversconfiguring communicationsI

Although you can use DB2 Connect Personal Edition with SNA gateways, youmay find DB2 Connect Enterprise Edition a better choice if you want to usemany

DB2 Connect User’s Guide 148DB2 Data Links Manager for AIXQuick Beginnings 151DB2 Data Links Manager forWindows NT QuickBeginnings 151DB2 Enterprise -

partner node name 69passwordnaming rules 169planningDB2 configuration 23DB2 Connect configuration 23privilegesrequired 138productdescriptions 3overview

180 Quick Beginnings

Contacting IBMThis section lists ways you can get more information from IBM.If you have a technical problem, please take the time to review and carry

Log on as anonymous. In the directory /ps/products/db2, you can finddemos, fixes, information, and tools concerning DB2 and many relatedproducts.Interne

IBMRPart Number: CT6D9NAPrinted in the United States of Americaon recycled paper containing 10%recovered post-consumer fiber.GC09-2830-00CT6D9NA

same machine as IBM eNetwork Communications Server or Microsoft SNAServer, and in many cases it can provide a less expensive andbetter-performing solu

Java applets. In addition, you can use a wide range of off-the-shelf orcustom-developed database applications with DB2 Connect and its associatedtools

DB2 Run-Time Client DB2 Administration ClientDB2 forMVSDB2 forVSEDB2 forVMOS/390Communication SupportAPPC, Named Pipes, NetBIOS,IPX/SPX, TCP/IPAS/400S

TP Monitor ClientDB2 forMVSDB2 forVSEDB2 forVMOS/390TP Monitor(eg. CICS, ENCINA, MTS)Application Business LogicAS/400S/390, S/370Application 1Applicat

Web BrowserDB2 forMVSDB2 forVSEDB2 forVMOS/390WebSphereJava Servlets,JSP,Enterprise Java BeansAS/400S/390, S/370Application 1Application 2Application

Web BrowserDB2 forMVSDB2 forVSEDB2 forVMOS/390ASPs, COM ObjectsAS/400S/390, S/370Application 1Application 2Application nDB2 Connect Enterprise Edition

Accessing DB2 Data from the Web Using JavaJava Database Connectivity (JDBC) and Embedded SQL for Java (SQLJ) areprovided with DB2 to allow you to crea

JDBC and SQLJ applications can be run from any system that has a DB2 clientinstalled; a Web browser and a Web server are not required.Java-enabled Web

For more information on Java enablement, refer to the DB2 Java Enablementweb page at http://www.software.ibm.com/data/db2/java/. For moreinformation o

Web BrowserDB2 forMVSDB2 forVSEDB2 forVMOS/390Net.DataNet.DataTemplatesAS/400S/390, S/370Application 1Application 2Application nDB2 Connect Enterprise

IBM DB2 ConnectPersonal EditionQuick BeginningsVe r s i o n 6GC09-2830-00IBM

Managing Connections to Databases Using the Client Configuration AssistantThe Client Configuration Assistant (CCA) helps you manage your databaseconnect

Through a DB2 client, these applications can access all servers and, by usingthe DB2 Connect product (or the DB2 Connect functionality supplied withDB

v Net.Data macros containing HTML and SQL.The DB2 CLI/ODBC driver is an optional component during a DB2 clientinstall. It is required to run CLI, ODBC

Part 2. DB2 Connect: Planning and Installation© Copyright IBM Corp. 1993, 1999 21

22 Quick Beginnings

Chapter 2. Planning for InstallationIf you know that your system meets all the hardware and softwarerequirements, and you want to begin installing you

For information about space requirements for data, refer to the AdministrationGuide.Estimating Fixed Disk RequirementsTo estimate the disk requirement

v Whether you will be using a direct connection (see “Accessing Host orAS/400 DB2 Data Using DB2 Connect Personal Edition” on page 4), orconnections v

Table 2. Software Requirements (continued)Product Hardware/SoftwareRequirementsCommunicationsWindows 32-bit Operating Systemsv DB2 Connect PersonalEdi

Chapter 3. Installing DB2 Connect on OS/2This section describes how to install DB2 Connect Personal Edition on anOS/2 workstation. For information on

Before using this information and the product it supports, be sure to read the general information under“Appendix H. Notices” on page 173.This documen

Step 1. Log on to the system with the user ID that you created to performthe installation.Step 2. Insert the CD-ROM in the drive.Step 3. Open an OS/2

For information on errors encountered during installation, see thel1.log and l2.log files. These files store general information anderror messages resul

Upgrading from a Try-and-Buy LicenseTo upgrade from a Try-and-Buy license, perform the following steps:Step 1. Start the Control Center. For more info

Chapter 4. Installing DB2 Connect on Windows 9x orWindows NTThis section describes how to install DB2 Connect Personal Edition onWindows 32-bit operat

__ 3. For Windows NT, any user account that does not belong to the guestsgroup. This user account will be used to perform the installation.Performing

Step 4. The Welcome window opens.Step 5. Respond to the setup program’s prompts. Online help is available toguide you through the remaining steps. Inv

To set up connections to host or AS/400 database servers, go to one ofthe following sections:v “Chapter 6. Configuring DB2 Connect to Host or AS/400Com

Upgrading from a Try-and-Buy LicenseTo upgrade from a Try-and-Buy license, perform the following steps:Step 1. Start the Control Center. For more info

36 Quick Beginnings

Part 3. Preparing Host and AS/400 Databases for DB2Connect Communications© Copyright IBM Corp. 1993, 1999 37

ContentsWelcome to DB2 Connect! ... viiHow This Book is Structured...viiConventions ...viiiPart 1. Introduction to DB2Connect ...

38 Quick Beginnings

Chapter 5. Configuring Host and AS/400 Databases for DB2ConnectThis section describes the steps required to configure host and AS/400database servers to

Many details of these steps have changed with the introduction of DB2Universal Database for OS/390 Version 5.1. Most of these steps apply toSNA users,

Sample Network Element Names (VTAM)Figure 9 shows the sample VTAM definitions used to configure a hostdatabase server.Sample VTAM APPL Definition for OS/

Note: Continuations must begin in column 16, with continuation marks incolumn 72.Sample VTAM PU and LU Definitions for DB2 ConnectIf your security poli

Sample VTAM Log Mode Definition for DB2Figure 12 on page 44 shows the sample VTAM logon mode table definition forthe IBMRDB and SNASVCMG modes. Note tha

You must define the SNASVCMG logon mode when using APPC.Configuring DB2 Universal Database for OS/390Before you can use DB2 Connect, your DB2 Universal

The sections that follow contain examples of commands to update these tablesfor DB2 Universal Database for OS/390. Work with your DB2 Administratorto

The sections that follow contain examples of commands to update thesetables. Work with your DB2 Administrator to determine the options requiredfor you

where:v NYX1 represents the PU name of server involvedv IBMRDB represents the name of VTAM logon modev 150 represents the maximum number of conversati

Step 2. Update the APPC Profiles on theDB2 Connect Workstation ... 70Configuring IBM eNetworkCommunications Server for Windows NT 70Configuring IBM e

Collecting InformationBefore you can use DB2 Connect over a TCP/IP connection, you must collectinformation about both the host database server and the

Example Worksheet:Table 3. Example Worksheet for Planning TCP/IP Connections to DB2 UniversalDatabase for OS/390Ref. Description Sample Value Your Val

Configuring the TCP/IP ConnectionUse the manual steps in this section to complete the configuration and makethe connection.Complete the Worksheet: Compl

v 1ST_CONN, the first database that a connection is established to will beused as the Transaction Manager database for transactions. If this option isu

CONNECT and BIND: Finally, connect to the target host server and bind theutilities and applications to the server using commands similar to thefollowi

Display Relational Database Directory EntriesPosition to ...Type options, press Enter.5=Display details 6=Print detailsRelational RemoteOption Data

54 Quick Beginnings

Part 4. Configuring DB2 Connect to Communicate withHost and AS/400 Databases© Copyright IBM Corp. 1993, 1999 55

56 Quick Beginnings

Chapter 6. Configuring DB2 Connect to Host or AS/400Communications Using the CCAThis section describes how to use the Client Configuration Assistant (CC

Code Page and Language Support ...159Conversion of Character Data ...160Bidirectional CCSID Support ...162Bidirectional-specific CCSIDs...163Ap

v Change your server password.The CCA provides three methods to set up a database connection to a server:v Using a profile.v Searching the network for

Adding a Database Using a ProfileA profile contains information about instances and databases on a system, anddatabases within each instance. For inform

c. If you would like to create an ODBC data source file to sharedatabase access, select the Create a file data source check boxand enter the path and fil

The Client Configuration Assistant may be unable to detect a remotesystem if:v The Administration Server is not running on the remote system.v The Disc

Step 8. Register this database as an ODBC data source.If you are not planning to use ODBC, click on the Done push buttonand go to the next step.a. Ens

Step 1. Select the Manually configure a connection to a DB2 database radiobutton and click on the Next push button.If you are not using Lightweight Dir

v If you would like all users on your system to have access tothis data source, select the As a system data source radiobutton.v If you would like onl

Step 3. Select the database that you want to bind the utilities and packagesagainst.Step 4. Click on the Bind push button.Step 5. Select the type of b

66 Quick Beginnings

Chapter 7. Configuring APPC Communications on the DB2Connect WorkstationThis section describes how to configure a DB2 Connect workstation tocommunicate

vi Quick Beginnings

Note: The worksheet and configuration instructions supply suggested orsample values for required configuration parameters. For otherparameters, use the

Table 5. Worksheet for Planning Host and AS/400 Server Connections (continued)Ref.Name at the DB2ConnectWorkstationNetwork or VTAMName Sample Value Yo

4. For database name (5), determine the name of the host database. This isthe LOCATION NAME for OS/390 or MVS, the RDB_NAME for VM orVSE, or a relat

__ 1. It is Version 5.0 or higher if you are planning to update multipledatabases within the same transaction; if you are planning to use2-phase commi

window.To configure IBM eNetwork Personal Server for APPC communications,complete the perform the following steps:Step 1. Configure Nodea. In the Configu

f. Click on OK.Step 2. Configure Devicesa. In the Configuration options field, select Configure devices.b. Ensure that in the DLCs field, the appropriate D

c. In the Partner LU alias field, type in the partner LU name (2)from the worksheet (NYM2DB2).d. If you are configuring Communications Server for SNA

v To specify a service TP, in the TP name field, type in the nameof the service TP, for example 076DB, and ensure that there is acheck mark in the Serv

To automatically start Communications Server when the machine isbooted, you can register it as a Windows NT Service.To register Communications Server

To configure the Windows NT SNA API client for APPC communications,complete the following steps:Step 1. Create a user account for the SNA API client on

Welcome to DB2 Connect!The DB2 Connect Quick Beginningsbooks provide a focused introductionto the installation and configurationof DB2 Connect products

SNA Client Configuration window opens.Step 3. Configure Global Dataa. In the Configuration options box, select the Configure GlobalData option and click o

b. Type in the IP address of the server (for example,123.123.123.123).c. Click on OK.Step 5. Configure CPI-C Side Informationa. In the Configuration opt

similar to that of the Windows NT Explorer. The following illustration showsthe interface. There are two panes in the main window of the Server Manage

a. Right-click on the SNA Service icon and select the Insert->LinkService option. The Insert Link Service window opens.b. Select DLC 802.2 Link Ser

a. Right-click on SNA Service and select the Insert->Connection->802.2 option. The Connection Properties window opens.b. Enter a connection name

g. Select the Address tab.h. Fill in the Remote Network Address field (8). Accept thedefault numbers in the other fields.i. Select the System Identific

window opens.b. Enter the following information:v The LU Alias (12).v The NETID (9).v The LU Name (11).c. Select the Advanced tab.d. Select the

Step 7. Define a modea. Right-click on APPC Modes folder and select theInsert->APPC->Mode Definition option. The APPC ModeProperties window opens.

d. Enter appropriate numbers for the Parallel Session Limit andMinimum Contention Winner Limit fields. Your Host-Side orLAN administrator should be abl

d. Select the Partner Information tab.e. In Partner TP Name box, select the SNA Service TP (in hex)radio button and enter the Service TP name (17),