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 22

DB2 Connect Enterprise Edition

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

Communication Support

1

2

Application

Application

IPX/SPX, TCP/IP

APPC, Named Pipes, NetBIOS,

DB2 Run-Time Client DB2 Administration 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 3. DB2 Connect Enterprise Edition

10Quick Beginnings

Image 22

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

Contents

Personal Edition Quick BeginningsIBM DB2 Connect VersionPage Personal Edition Quick BeginningsIBM DB2 Connect VersionPage Part 1. Introduction to DB2 Contentsand Installation ConnectPart 5. Conguring DB2 Clients to Part 6. Using DB2 ConnectPart 7. Appendixes Use DB2 ConnectAppendix G. List Files, Bind Files, and vi Quick Beginnings How This Book is Structured Welcome to DB2 ConnectDB2 Universal Database Conventions v If you do not follow the documented installation method with the x Quick Beginnings Part 1. Introduction to DB2 Connect Copyright IBM Corp. 19932 Quick Beginnings DB2 Connect Enterprise Edition Chapter 1. About DB2 ConnectDB2 Connect Personal Edition Working with DB2 Data Accessing Host or AS/400 DB2 Data Using DB2 Connect Personal Edition4 Quick Beginnings OS/390 APPC TCP/IP*** MPTN Chapter 1. About DB2 ConnectConnections via Communications Gateway 6 Quick BeginningsESCON OS/390 APPC TCP/IP*** MPTNv Middle-tier application server is employed v Database products, such as Lotus Approach and Microsoft Access DB2 Connect Enterprise Edition OS/390 APPC TCP/IP*** MPTNESCON Figure 3. DB2 Connect Enterprise EditionESCON Figure 4. Using Transaction Monitors with DB2 ConnectOS/390 APPC TCP/IP*** MPTN DB2 Connect Enterprise EditionFigure 5. Java Server Support OS/390 APPC TCP/IP*** MPTNESCON 12 Quick BeginningsESCON OS/390 APPC TCP/IP*** MPTNFigure 6. DB2 Connect working with Microsoft IIS Accessing DB2 Data from the Web Using Java 14 Quick BeginningsOS/390 APPC TCP/IP*** MPTN Figure 7. Using Java AppletsESCON Accessing DB2 Data from the Web Using Net.Data 16 Quick BeginningsESCON OS/390 APPC TCP/IP*** MPTNFigure 8. Net.Data with DB2 Connect Developing Applications Using the DB2 Software Developers Kit Running Your Own Applications v Net.Data macros containing HTML and SQL Part 2. DB2 Connect Planning and Installation Copyright IBM Corp. 199322 Quick Beginnings DB2 Connect Requirements Chapter 2. Planning for InstallationMemory Requirements Disk RequirementsSoftware Requirements Estimating Fixed Disk RequirementsComponents Product Requirements Table 2. Software RequirementsHardware/Software Table 2. Software Requirements continuedProduct CommunicationsPerforming the Installation Chapter 3. Installing DB2 Connect on OS/2Before You Begin x\install /i language x\install28 Quick Beginnings Software Registration Upgrading from a Try-and-Buy License Chapter 4. Installing DB2 Connect on Windows 9x or Windows NT Before You BeginPerforming the Installation To manually invoke the setup program, perform the following stepsStep 4. The Welcome window opens Software Registration 34 Quick BeginningsUpgrading from a Try-and-Buy License 36 Quick Beginnings Copyright IBM Corp. 1993 38 Quick Beginnings Chapter 5. Conguring Host and AS/400 Databases for DB2 Connect Preparing MVS/ESA or OS/390 for DB2 ConnectSummary of Steps Conguring VTAMNYM2DB2 Sample Network Element Names VTAMSample VTAM APPL Denition for OS/390 Chapter 5. Conguring Host and AS/400 Databases for DB2 ConnectSample VTAM PU and LU Denitions for DB2 Connect Sample VTAM Log Mode Denition for DB2 Figure 11. Sample VTAM Switched Major Node Denition for DB2 ConnectConguring DB2 Universal Database for OS/390 Updating SYSIBM.LUNAMES Conguring DB2 for MVS/ESAUpdating SYSIBM.IPNAMES Updating SYSIBM.SYSLUMODES Updating SYSIBM.SYSUSERNAMESUpdating SYSIBM.SYSLUNAMES INSERT INTO SYSIBM.SYSLUMODES VALUES NYX1Conguring TCP/IP for DB2 Universal Database for OS/390 Prerequisite OS/390 Software for TCP/IP SupportCollecting Information Example Worksheet 1. To obtain the hosts IP address „TCP-9…, enter at the hostConguring the TCP/IP Connection Update the DB2 Universal Database for OS/390 Host At your OS/390 host2. Verify the port number or the service name 1. Verify the host address or the host nameUpdate the DB2 Connect Directories DSPNETA Preparing DB2 Universal Database for AS/400 for DB2 ConnectDSPNETA Example Preparing DB2 for VSE & VMParameter Your value54 Quick Beginnings Copyright IBM Corp. 1993 56 Quick Beginnings With the CCA, you can Conguration Steps Adding a Database Using a Prole Adding a Database Using Discovery 60 Quick Beginningsa. Click on the Add System push button Adding a Database Manually 62 Quick BeginningsVM or VSE OS/390 or MVSAS/400 If you are not using Lightweight Directory Access Protocol LDAP, this tab will not be shown, skip this step and go to Step64 Quick Beginnings Step 4. Click on the Bind push button 66 Quick Beginnings Step 1. Identify and Record Parameter Values Table 5. Worksheet for Planning Host and AS/400 Server Connections targetdbnamelocaldcsname or DB2DRDAStep 2. Update the APPC Proles on the DB2 Connect Workstation Conguring IBM eNetwork Communications Server for Windows NTa. Click on the Start push button, then select Settings-Control Panel window a. In the Conguration options eld, select Congure devices a. In the Conguration options eld, select Congure connections74 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 d. Click on the Finish push button b. Select DLC 802.2 Link Service c. Click on the Add push buttonStep 4. Dene the connection properties 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… b. Enter the Mode Name „6… in the Mode Name eld Step 7. Dene a modec. Select the Limits tab e. Accept the other defaults, and click on OK d. Select the Partner Information tab Conguring Microsoft SNA Client 88 Quick BeginningsThe rest of this section assumes OS/390 APPC TCP/IP*** MPTNESCON DB2 Connect Enterprise Edition with SNA Gateway client softwareStep 3. Install DB2 Connect for Windows Step 1. Obtain Required InformationStep 3. Catalog the APPC or APPN Node Step 5. Catalog the Database catalog dcs db localdcsname as targetdbname terminatelocaldcsname of the remote Table 6. Worksheet Parameter Values for Cataloging Databasesdatabasename databasealiasStep 6. Bind Utilities and Applications to the Database Server Step 7. Test the Host or AS/400 Connectionselect 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 Chapter 8. Enabling Multisite Updates Two-Phase Commit Host and AS/400 multisite update scenarios that require SPMNote *AIX For more information about DUOW refer to the DB2 Connect Users Guide Testing the Multisite Update Feature Enabling Multisite Updates Using the Control CenterStarting the Multisite Update Smartguide Smartguide Steps102 Quick Beginnings Part 5. Conguring DB2 Clients to Use DB2 Connect Copyright IBM Corp. 1993104 Quick Beginnings If you are adding a host or AS/400 database, go to ªChapter Conguration Steps Adding a Database Using a Prole106 Quick Beginnings Page Adding a Database Using Discovery 108 Quick BeginningsStep 5. Register this database as an ODBC data source Adding a Database Manually 110 Quick BeginningsAS/400 OS/390 or MVSVM or VSE Creating and Using Proles Server ProlesClient Proles Step 3. Select the Export server prole optionv Database connection information including CLI or ODBC settings Step 6. Click on OK. The Export Client Prole window opens 116 Quick Beginnings Part 6. Using DB2 Connect Copyright IBM Corp. 1993118 Quick Beginnings Chapter 10. Running Your Own Applications Binding Database UtilitiesBinding to Host Databases Binding to DB2 Universal DatabasesRunning CLI/ODBC Programs ReferenceStep 3. To access the DB2 database from ODBC Windows 32-bit operating systems Client Access to DB2 using CLI/ODBC Platform Specic Details for CLI/ODBC Accessc. Select the Register this database for ODBC check box CATALOG user system ODBC DATA SOURCE 124 Quick BeginningsOS/2 Client Access to DB2 using CLI/ODBC 3 Select the Register this database for ODBC check boxDetailed Conguration Information 126 Quick BeginningsRunning Java Programs Silicon Graphics IRIX Conguring the EnvironmentHP-UX SolarisOn Windows and OS/2 platforms Java ApplicationsOn UNIX platforms On UNIX platformsJava Applets Part 7. Appendixes Copyright IBM Corp132 Quick Beginnings Starting the Client Conguration Assistant Appendix A. Basic Task KnowledgeStarting the Software Registration Tool OS/2 Click on OS/2 Warp and select DB2 for OS/2±RegistrationOn OS/2 Entering Commands Using the Command CenterStarting the Control Center On Windows 9x or Windows NTOn Windows 9x or Windows NT Start the Command Center in one of the follows waysOn OS/2 Command Line Mode Entering Commands Using the Command Line ProcessorCommand Line Mode Click on OS/2 Warp , and select DB2 for OS/2-CommandInteractive Input Mode OS/2 Click on OS/2 Warp, and select DB2 for OS/2±CommandWindows-Command Line Processor Windows 9x or Windows NTWorking with the System Administrative Group OS/2Page Using the Control Center Preparing DB2 for OS/390 Servers for the Control Centerv DB2 Universal Database UDB for Windows NT Version 5 all editions 142 Quick Beginnings Appendix D. How the DB2 Library Is Structured Completing Tasks with SmartGuidesCreate-Table using SmartGuide Accessing Online HelpHow to Access Create-Table space usingType of Help ContentsHow to Access Appendix D. How the DB2 Library Is StructuredPlatform-specic books DB2 Information ± Hardcopy and OnlineCross-platform books Cross-platform sample programs in HTMLAdministration Guide Form Number NameDescription HTMLForm Number HTML NameDescription DirectorySC09-2851 db2q0 db2q0x60 Form Number HTML NameDescription DirectorySee Application Building Guide for more 152 Quick BeginningsViewing Online Information Tasks Accessing Information with the Information CenterTroubleshooting ReferenceSetting Up a Document Server Searching Online Information Printing the PostScript BooksOrdering the Printed Books 158 Quick Beginnings Appendix E. National Language Support NLS Code Page and Language SupportConversion of Character Data Table 8. Languages and Code Pages continued1. 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 General Naming Rules Appendix F. Naming RulesDatabase, Database Alias, and Catalog Node Name Rules Object Name Rules Workstation Name nname Rules Username, User ID, Group Name, and Instance Name RulesWindows 32-bit operating systems Use any case A maximum of 14 characters Password RulesDB2SYSTEM Naming Rules UNIXAppendix G. List Files, Bind Files, and Packages DRDA Server List File OS/390 and MVS List Files Associated with DRDA ServersOS/400 Table 10. DRDA Bind Files and Packages continued Appendix G. List Files, Bind Files, and Packages172 Quick Beginnings Appendix H. Notices Trademarks Trademarks of Other CompaniesAppendix H. Notices 176 Quick Beginnings Index Page Page 180 Quick Beginnings Telephone Contacting IBMAnonymous FTP Sites CompuServe Page IBMR Part Number CT6D9NA