Manuals / IBM / Computer Equipment / Server

IBM GC09-2830-00 manual OS/390 APPC TCP/IP*** MPTN, Escon, DB2 Connect Enterprise Edition

Models: GC09-2830-00

1 196

Download 196 pages 29.94 Kb

Page 23

Figure 4. Using Transaction Monitors with DB2 Connect.

S/390, S/370

DB2 for
MVS
DB2 for	DB2 for
VSE	AS/400
DB2 for
VM	AS/400

OS/390 APPC TCP/IP*** MPTN

Coax* Ethernet Asynch Twinax**

SDLC Token-ring X.25

ESCON

DB2 Connect Enterprise Edition

					TP Monitor			1			2
			(eg. CICS, ENCINA, MTS)					1			2
			(eg. CICS, ENCINA, MTS)					Application			Application

			Application Business Logic									. . .
			Application Business Logic

TP Monitor Client

Not all protocols are supported for all platforms.

*For Host connections only

**For AS/400

Application n

***TCP/IP connectivity requires DB2 for OS/390 V5R1, DB2 for AS/400 V4R2, or DB2 for VM V6.1

Figure 4. Using Transaction Monitors with DB2 Connect.

Chapter 1. About DB2 Connect 11

Image 23

IBM GC09-2830-00 manual OS/390 APPC TCP/IP*** MPTN, Escon, DB2 Connect Enterprise Edition

Contents

Version Quick BeginningsIBM DB2 Connect Personal EditionPage Version Quick BeginningsIBM DB2 Connect Personal EditionPage Connect Contentsand Installation Part 1. Introduction to DB2Use DB2 Connect Part 6. Using DB2 ConnectPart 7. Appendixes Part 5. Conguring DB2 Clients toAppendix G. List Files, Bind Files, and vi Quick Beginnings DB2 Universal Database Welcome to DB2 ConnectHow This Book is Structured Conventions v If you do not follow the documented installation method with the x Quick Beginnings Copyright IBM Corp. 1993 Part 1. Introduction to DB2 Connect2 Quick Beginnings DB2 Connect Personal Edition Chapter 1. About DB2 ConnectDB2 Connect Enterprise Edition 4 Quick Beginnings Accessing Host or AS/400 DB2 Data Using DB2 Connect Personal EditionWorking with DB2 Data Chapter 1. About DB2 Connect OS/390 APPC TCP/IP*** MPTN6 Quick Beginnings Connections via Communications GatewayOS/390 APPC TCP/IP*** MPTN ESCONv Middle-tier application server is employed v Database products, such as Lotus Approach and Microsoft Access Figure 3. DB2 Connect Enterprise Edition OS/390 APPC TCP/IP*** MPTNESCON DB2 Connect Enterprise EditionDB2 Connect Enterprise Edition Figure 4. Using Transaction Monitors with DB2 ConnectOS/390 APPC TCP/IP*** MPTN ESCON12 Quick Beginnings OS/390 APPC TCP/IP*** MPTNESCON Figure 5. Java Server SupportFigure 6. DB2 Connect working with Microsoft IIS OS/390 APPC TCP/IP*** MPTNESCON 14 Quick Beginnings Accessing DB2 Data from the Web Using JavaESCON Figure 7. Using Java AppletsOS/390 APPC TCP/IP*** MPTN 16 Quick Beginnings Accessing DB2 Data from the Web Using Net.DataFigure 8. Net.Data with DB2 Connect OS/390 APPC TCP/IP*** MPTNESCON Developing Applications Using the DB2 Software Developers Kit Running Your Own Applications v Net.Data macros containing HTML and SQL Copyright IBM Corp. 1993 Part 2. DB2 Connect Planning and Installation22 Quick Beginnings Disk Requirements Chapter 2. Planning for InstallationMemory Requirements DB2 Connect RequirementsComponents Estimating Fixed Disk RequirementsSoftware Requirements Table 2. Software Requirements Product RequirementsCommunications Table 2. Software Requirements continuedProduct Hardware/SoftwareBefore You Begin Chapter 3. Installing DB2 Connect on OS/2Performing the Installation 28 Quick Beginnings x\installx\install /i language Software Registration Upgrading from a Try-and-Buy License Before You Begin Chapter 4. Installing DB2 Connect on Windows 9x or Windows NTTo manually invoke the setup program, perform the following steps Performing the InstallationStep 4. The Welcome window opens 34 Quick Beginnings Software RegistrationUpgrading from a Try-and-Buy License 36 Quick Beginnings Copyright IBM Corp. 1993 38 Quick Beginnings Preparing MVS/ESA or OS/390 for DB2 Connect Chapter 5. Conguring Host and AS/400 Databases for DB2 ConnectConguring VTAM Summary of StepsChapter 5. Conguring Host and AS/400 Databases for DB2 Connect Sample Network Element Names VTAMSample VTAM APPL Denition for OS/390 NYM2DB2Sample VTAM PU and LU Denitions for DB2 Connect Figure 11. Sample VTAM Switched Major Node Denition for DB2 Connect Sample VTAM Log Mode Denition for DB2Conguring DB2 Universal Database for OS/390 Updating SYSIBM.IPNAMES Conguring DB2 for MVS/ESAUpdating SYSIBM.LUNAMES INSERT INTO SYSIBM.SYSLUMODES VALUES NYX1 Updating SYSIBM.SYSUSERNAMESUpdating SYSIBM.SYSLUNAMES Updating SYSIBM.SYSLUMODESPrerequisite OS/390 Software for TCP/IP Support Conguring TCP/IP for DB2 Universal Database for OS/390Collecting Information 1. To obtain the hosts IP address „TCP-9…, enter at the host Example Worksheet1. Verify the host address or the host name Update the DB2 Universal Database for OS/390 Host At your OS/390 host2. Verify the port number or the service name Conguring the TCP/IP ConnectionUpdate the DB2 Connect Directories DSPNETA Preparing DB2 Universal Database for AS/400 for DB2 ConnectDSPNETA Your value Preparing DB2 for VSE & VMParameter Example54 Quick Beginnings Copyright IBM Corp. 1993 56 Quick Beginnings With the CCA, you can Conguration Steps Adding a Database Using a Prole 60 Quick Beginnings Adding a Database Using Discoverya. Click on the Add System push button 62 Quick Beginnings Adding a Database ManuallyIf you are not using Lightweight Directory Access Protocol LDAP, this tab will not be shown, skip this step and go to Step OS/390 or MVSAS/400 VM or VSE64 Quick Beginnings Step 4. Click on the Bind push button 66 Quick Beginnings Step 1. Identify and Record Parameter Values targetdbname Table 5. Worksheet for Planning Host and AS/400 Server Connectionsor DB2DRDA localdcsnameConguring IBM eNetwork Communications Server for Windows NT Step 2. Update the APPC Proles on the DB2 Connect Workstationa. Click on the Start push button, then select Settings-Control Panel window a. In the Conguration options eld, select Congure connections a. In the Conguration options eld, select Congure devices74 Quick Beginnings Accept the defaults for the other elds f. Click on OK to register Communications Server with the default conguration, or b. Select Users-New User from the menu bar. The New User window opens SNA Client Conguration window opens Step 3. Congure Global Data Conguring Microsoft SNA Server for Windows NT Step 2. Dene the control point name Step 4. Dene the connection properties b. Select DLC 802.2 Link Service c. Click on the Add push buttond. Click on the Finish push button b. Enter a connection name „7… in the Name eld i. Select the System Identication tab window opens b. Enter the following information v The LU Alias „12… c. Select the Limits tab Step 7. Dene a modeb. Enter the Mode Name „6… in the Mode Name eld e. Accept the other defaults, and click on OK d. Select the Partner Information tab 88 Quick Beginnings Conguring Microsoft SNA ClientDB2 Connect Enterprise Edition with SNA Gateway client software OS/390 APPC TCP/IP*** MPTNESCON The rest of this section assumesStep 1. Obtain Required Information Step 3. Install DB2 Connect for WindowsStep 3. Catalog the APPC or APPN Node catalog dcs db localdcsname as targetdbname terminate Step 5. Catalog the Databasedatabasealias Table 6. Worksheet Parameter Values for Cataloging Databasesdatabasename localdcsname of the remoteStep 7. Test the Host or AS/400 Connection Step 6. Bind Utilities and Applications to the Database Serverselect tabname from syscat.tables 96 Quick Beginnings Chapter 8. Enabling Multisite Updates Two-Phase Commit v DB2 Common Server v DB2 Universal Database V5 and Note *AIX Host and AS/400 multisite update scenarios that require SPMChapter 8. Enabling Multisite Updates Two-Phase Commit For more information about DUOW refer to the DB2 Connect Users Guide Smartguide Steps Enabling Multisite Updates Using the Control CenterStarting the Multisite Update Smartguide Testing the Multisite Update Feature102 Quick Beginnings Copyright IBM Corp. 1993 Part 5. Conguring DB2 Clients to Use DB2 Connect104 Quick Beginnings If you are adding a host or AS/400 database, go to ªChapter 106 Quick Beginnings Adding a Database Using a ProleConguration Steps Page 108 Quick Beginnings Adding a Database Using DiscoveryStep 5. Register this database as an ODBC data source 110 Quick Beginnings Adding a Database ManuallyVM or VSE OS/390 or MVSAS/400 Server Proles Creating and Using ProlesStep 3. Select the Export server prole option Client Prolesv Database connection information including CLI or ODBC settings Step 6. Click on OK. The Export Client Prole window opens 116 Quick Beginnings Copyright IBM Corp. 1993 Part 6. Using DB2 Connect118 Quick Beginnings Binding Database Utilities Chapter 10. Running Your Own ApplicationsBinding to DB2 Universal Databases Binding to Host DatabasesReference Running CLI/ODBC ProgramsStep 3. To access the DB2 database from ODBC c. Select the Register this database for ODBC check box Platform Specic Details for CLI/ODBC AccessWindows 32-bit operating systems Client Access to DB2 using CLI/ODBC 124 Quick Beginnings CATALOG user system ODBC DATA SOURCE3 Select the Register this database for ODBC check box OS/2 Client Access to DB2 using CLI/ODBC126 Quick Beginnings Detailed Conguration InformationRunning Java Programs Solaris Conguring the EnvironmentHP-UX Silicon Graphics IRIXOn UNIX platforms Java ApplicationsOn UNIX platforms On Windows and OS/2 platformsJava Applets Copyright IBM Corp. 1993 Part 7. Appendixes132 Quick Beginnings OS/2 Click on OS/2 Warp and select DB2 for OS/2±Registration Appendix A. Basic Task KnowledgeStarting the Software Registration Tool Starting the Client Conguration AssistantOn Windows 9x or Windows NT Entering Commands Using the Command CenterStarting the Control Center On OS/2On OS/2 Start the Command Center in one of the follows waysOn Windows 9x or Windows NT Interactive Input Mode Entering Commands Using the Command Line ProcessorCommand Line Mode Command Line ModeWindows 9x or Windows NT Interactive Input ModeOS/2 Click on OS/2 Warp, and select DB2 for OS/2±Command Windows-Command Line ProcessorOS/2 Working with the System Administrative GroupPage Preparing DB2 for OS/390 Servers for the Control Center Using the Control Centerv DB2 Universal Database UDB for Windows NT Version 5 all editions 142 Quick Beginnings Completing Tasks with SmartGuides Appendix D. How the DB2 Library Is StructuredCreate-Table space using Accessing Online HelpHow to Access Create-Table using SmartGuideAppendix D. How the DB2 Library Is Structured ContentsHow to Access Type of HelpCross-platform sample programs in HTML DB2 Information ± Hardcopy and OnlineCross-platform books Platform-specic booksAdministration Guide HTML NameDescription Form NumberDirectory NameDescription Form Number HTMLSC09-2851 db2q0 db2q0x60 Directory NameDescription Form Number HTML152 Quick Beginnings See Application Building Guide for moreViewing Online Information Reference Accessing Information with the Information CenterTroubleshooting TasksSetting Up a Document Server Printing the PostScript Books Searching Online InformationOrdering the Printed Books 158 Quick Beginnings Code Page and Language Support Appendix E. National Language Support NLSTable 8. Languages and Code Pages continued Conversion of Character Data1. DB2 Connect sends an SQL statement and input data to OS/390 or MVS Bidirectional CCSID Support Bidirectional-specic CCSIDs Where CDRA String Types are dened Database, Database Alias, and Catalog Node Name Rules Appendix F. Naming RulesGeneral Naming Rules Object Name Rules Windows 32-bit operating systems Use any case Username, User ID, Group Name, and Instance Name RulesWorkstation Name nname Rules UNIX Password RulesDB2SYSTEM Naming Rules A maximum of 14 charactersAppendix G. List Files, Bind Files, and Packages OS/400 List Files Associated with DRDA ServersDRDA Server List File OS/390 and MVS Appendix G. List Files, Bind Files, and Packages Table 10. DRDA Bind Files and Packages continued172 Quick Beginnings Appendix H. Notices Trademarks of Other Companies TrademarksAppendix H. Notices 176 Quick Beginnings Index Page Page 180 Quick Beginnings Anonymous FTP Sites Contacting IBMTelephone CompuServe Page Part Number CT6D9NA IBMR