IBM GC09-2830-00 manual

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196

Go to page of

A good user manual

The rules should oblige the seller to give the purchaser an operating instrucion of IBM GC09-2830-00, along with an item. The lack of an instruction or false information given to customer shall constitute grounds to apply for a complaint because of nonconformity of goods with the contract. In accordance with the law, a customer can receive an instruction in non-paper form; lately graphic and electronic forms of the manuals, as well as instructional videos have been majorly used. A necessary precondition for this is the unmistakable, legible character of an instruction.

What is an instruction?

The term originates from the Latin word „instructio”, which means organizing. Therefore, in an instruction of IBM GC09-2830-00 one could find a process description. An instruction's purpose is to teach, to ease the start-up and an item's use or performance of certain activities. An instruction is a compilation of information about an item/a service, it is a clue.

Unfortunately, only a few customers devote their time to read an instruction of IBM GC09-2830-00. A good user manual introduces us to a number of additional functionalities of the purchased item, and also helps us to avoid the formation of most of the defects.

What should a perfect user manual contain?

First and foremost, an user manual of IBM GC09-2830-00 should contain:
- informations concerning technical data of IBM GC09-2830-00
- name of the manufacturer and a year of construction of the IBM GC09-2830-00 item
- rules of operation, control and maintenance of the IBM GC09-2830-00 item
- safety signs and mark certificates which confirm compatibility with appropriate standards

Why don't we read the manuals?

Usually it results from the lack of time and certainty about functionalities of purchased items. Unfortunately, networking and start-up of IBM GC09-2830-00 alone are not enough. An instruction contains a number of clues concerning respective functionalities, safety rules, maintenance methods (what means should be used), eventual defects of IBM GC09-2830-00, and methods of problem resolution. Eventually, when one still can't find the answer to his problems, he will be directed to the IBM service. Lately animated manuals and instructional videos are quite popular among customers. These kinds of user manuals are effective; they assure that a customer will familiarize himself with the whole material, and won't skip complicated, technical information of IBM GC09-2830-00.

Why one should read the manuals?

It is mostly in the manuals where we will find the details concerning construction and possibility of the IBM GC09-2830-00 item, and its use of respective accessory, as well as information concerning all the functions and facilities.

After a successful purchase of an item one should find a moment and get to know with every part of an instruction. Currently the manuals are carefully prearranged and translated, so they could be fully understood by its users. The manuals will serve as an informational aid.

Table of contents for the manual

  • Page 1

    IB M D B2 C o nn ect P e rs o nal Editi o n Qui c k B e gin ning s Ve r s i o n 6 GC09-2830-00 IBM[...]

  • Page 2

    [...]

  • Page 3

    IB M D B2 C o nn ect P ers o nal Ed i ti o n Qui c k B e gin ning s Ve r s i o n 6 GC09-2830-00 IBM[...]

  • Page 4

    Before using this information and the pr oduct it supports, be sure to r ead the general information under “Appendix H. Notices” on page 173. This document contains proprietary information of IBM. It is pr ovided under a license agreement and is pr otected by copyright law . The information contained in this publication does not include any pro[...]

  • Page 5

    Contents Welcome to DB2 Connect! ...... v i i How This Book is Structured ...... v i i Conventions ........... viii Part 1. Introduction to DB2 Connect ............ 1 Chapter 1. About DB2 Connect .... 3 W orking with DB2 Data ....... 4 Accessing Host or AS/400 DB2 Data Using DB2 Connect Personal Edition 4 Connections via Communications Gateway ....[...]

  • Page 6

    Step 2. Update the APPC Profiles on the DB2 Connect W orkstation ....... 7 0 Configuring IBM eNetwork Communications Server for W indows NT 70 Configuring IBM eNetwork Communications Server for W indows NT SNA API Client ......... 7 6 Configuring Microsoft SNA Server for W indows NT .......... 7 9 Configuring Microsoft SNA Client . . . 88 Step[...]

  • Page 7

    Code Page and Language Support .... 1 5 9 Conversion of Character Data ..... 1 6 0 Bidirectional CCSID Support ...... 1 6 2 Bidirectional-specific CCSIDs ..... 1 6 3 Appendix F . Naming Rules ...... 1 6 5 General Naming Rules ........ 1 6 5 Database, Database Alias, and Catalog Node Name Rules ........... 1 6 5 Object Name Rules ......... 1 6 6 Us[...]

  • Page 8

    vi Quick Beginnings[...]

  • Page 9

    W elcome to DB2 Connect! The DB2 Connect Quick Beginnings books provide a focused intr oduction to the installation and configuration of DB2 Connect products. This Quick Beginnings book will guide you through the planning, installation, migration (if necessary), and setup of a DB2 Connect workstation. Once the DB2 Connect workstation has been inst[...]

  • Page 10

    connections. For DB2 Connect installation instructions, see “Part 2. DB2 Connect: Planning and Installation” on page 21. Step 5. After installation, you will establish the connection between DB2 Connect and your host or AS/400 database system. DB2 Connect can locate and configure all TCP/IP and most SNA connections for you. If you are using a [...]

  • Page 11

    This icon marks a fast path. A fast path guides you to information specific to your configuration where multiple options ar e available. This icon marks a tip. It provides additional information that can help you complete a task. For a complete description of the DB2 library , see “Appendix D. How the DB2 Library Is Structur ed” on page 143. [...]

  • Page 12

    x Quick Beginnings[...]

  • Page 13

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

  • Page 14

    2 Quick Beginnings[...]

  • Page 15

    Chapter 1. About DB2 Connect DB2 Connect Enterprise Edition DB2 Connect Enterprise Edition is a connectivity server that concentrates and manages connections from multiple desktop clients and web applications to DB2 database servers running on host or AS/400 systems. IBM’s DB2 for AS/400, DB2 for OS/390, and DB2 for VSE & VM databases continu[...]

  • Page 16

    Working with DB2 Data As well as providing a r elational database to stor e your data, DB2 lets you issue requests to administer , query , update, insert, or delete data using local or remote client applications. Accessing Host or AS/400 DB2 Data Using DB2 Connect Personal Edition Direct connection without intermediate servers is a very convenient [...]

  • Page 17

    In this environment, if you ar e using W indows 32-bit operating systems you can use the DB2 Connect Personal Edition Integrated SNA Support to connect directly to the host or AS/400 servers. DB2 Connect Integrated SNA Support permits connections over a variety of local and wide area networks, such as T oken-Ring, Ethernet, SDLC, T winax, Coax and [...]

  • Page 18

    Connections via Communications Gateway Some organizations pr efer to concentrate access to SNA networks through dedicated SNA Gateways , such as IBM eNetwork Communications Server , Microsoft SNA Server , or Novell Netware for SAA. DB2 Connect pr oducts support connections through gateways, so this can be a good choice if you need terminal emulatio[...]

  • Page 19

    Although you can use DB2 Connect Personal Edition with SNA gateways, you may find DB2 Connect Enterprise Edition a better choice if you want to use many DB2 Clients. DB2 Connect Enterprise Edition can be installed on the DB2 for MVS DB2 for VSE DB2 for VM OS/390 AS/400 S/390, S/370 DB2 f or AS/400 APPC TCP/IP*** MPTN Coax* Ether net Asynch T winax[...]

  • Page 20

    same machine as IBM eNetwork Communications Server or Microsoft SNA Server , and in many cases it can provide a less expensive and better-performing solution. Contact your authorized IBM reseller for additional information about DB2 Connect Enterprise Edition. Accessing Host or AS/400 DB2 Data from the Desktop Using DB2 Connect Enterprise Edition A[...]

  • Page 21

    Java applets. In addition, you can use a wide range of of f-the-shelf or custom-developed database applications with DB2 Connect and its associated tools. For example, you can use DB2 Connect products with: v Spreadsheets , such as Lotus 1-2-3 and Micr osoft Excel, to analyze r eal-time data without having the cost and complexity of data extract an[...]

  • Page 22

    DB2 Run-Time Client DB2 Administration Client DB2 for MVS DB2 for VSE DB2 for VM OS/390 Communication Suppor t APPC , Named Pipes, NetBIOS , IPX/SPX, TCP/IP AS/400 S/390, S/370 Applic a tion 1 Applic a tion 2 Applic a tion n DB2 Connect Enter prise Edition DB2 f or AS/400 Not al l prot oc ols ar e su ppor ted for all pl at for ms. ... APPC TCP/IP**[...]

  • Page 23

    TP Monitor Client DB2 for MVS DB2 for VSE DB2 for VM OS/390 TP Monitor (eg. CICS , ENCINA, MTS) Application Business Logic AS/400 S/390, S/370 Applic a tion 1 Applic a tion 2 Applic a tion n DB2 Connect Enter prise Edition DB2 f or AS/400 Not al l prot oc ols ar e su ppor ted for all pl at for ms. ... APPC TCP/IP*** MPTN Coax* Ether net Asynch T wi[...]

  • Page 24

    Web Bro wser DB2 for MVS DB2 for VSE DB2 for VM OS/390 WebSphere Ja va Servlets, JSP , Enterpr ise Jav a Beans AS/400 S/390, S/370 Applic a tion 1 Applic a tion 2 Applic a tion n DB2 Connect Enter prise Edition DB2 f or AS/400 Not al l prot oc ols ar e su ppor ted for all pl at for ms. ... APPC TCP/IP*** MPTN Coax* Ether net Asynch T winax** SDLC T[...]

  • Page 25

    Web Bro wser DB2 for MVS DB2 for VSE DB2 for VM OS/390 ASPs, COM Objects AS/400 S/390, S/370 Applic a tion 1 Applic a tion 2 Applic a tion n DB2 Connect Enter prise Edition DB2 f or AS/400 Not al l prot oc ols ar e su ppor ted for all pl at for ms. ... APPC TCP/IP*** MPTN Coax* Ether net Asynch T winax** SDLC T oken-r ing X.25 *** TCP/IP connectivi[...]

  • Page 26

    Accessing DB2 Data from the Web Using Java Java Database Connectivity (JDBC) and Embedded SQL for Java (SQLJ) are provided with DB2 to allow you to cr eate applications that access data in DB2 databases from the W eb. Programming languages containing embedded SQL are called host languages. Java dif fers from the traditional host languages C, COBOL,[...]

  • Page 27

    JDBC and SQLJ applications can be run fr om any system that has a DB2 client installed; a W eb browser and a W eb server are not requir ed. Jav a-enabled W eb Browser DB2 for MVS DB2 for VSE DB2 for VM OS/390 DB2 JDBC Applet Server AS/400 S/390, S/370 Applic a tion 1 Applic a tion 2 Applic a tion n DB2 Connect Enter prise Edition DB2 f or AS/400 No[...]

  • Page 28

    For more information on Java enablement, r efer to the DB2 Java Enablement web page at http://www.software.ibm.com/data/db2/java/ . For more information on the JDBC API, point your browser to http://splash.javasoft.com/ . Accessing DB2 Data from the Web Using Net.Data Net.Data is provided with DB2 to allow you to cr eate applications that access da[...]

  • Page 29

    Web Bro wser DB2 for MVS DB2 for VSE DB2 for VM OS/390 Net.Data Net.Data T emplates AS/400 S/390, S/370 Applic a tion 1 Applic a tion 2 Applic a tion n DB2 Connect Enter prise Edition DB2 f or AS/400 Not al l prot oc ols ar e su ppor ted for all pl at for ms. ... APPC TCP/IP*** MPTN Coax* Ether net Asynch T winax** SDLC T oken-r ing X.25 ** For AS/[...]

  • Page 30

    Managing Connections to Databases Using the Client Configuration Assistant The Client Configuration Assistant (CCA) helps you manage your database connections to remote servers. The CCA is available on OS/2 and W indows 32-bit operating systems. This is the preferr ed method to set up any OS/2, W indows 9x, or W indows NT client to communicate wi[...]

  • Page 31

    Through a DB2 client, these applications can access all servers and, by using the DB2 Connect product (or the DB2 Connect functionality supplied with DB2 Enterprise - Extended or DB2 Enterprise Edition), they can also access DB2 Universal Database for AS/400, DB2 Universal Database for OS/390, and DB2 for VSE & VM database servers. The DB2 Soft[...]

  • Page 32

    v Net.Data macros containing HTML and SQL. The DB2 CLI/ODBC driver is an optional component during a DB2 client install. It is requir ed to run CLI, ODBC, JDBC, and some SQLJ applications. For more information on r unning your own applications, refer to the Installation and Configuration Supplement . 20 Quick Beginnings[...]

  • Page 33

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

  • Page 34

    22 Quick Beginnings[...]

  • Page 35

    Chapter 2. Planning for Installation If you know that your system meets all the hardwar e and software requir ements, and you want to begin installing your DB2 product right away , go to “Chapter 4. Installing DB2 Connect on W indows 9x or W indows NT” on page 31 or “Chapter 3. Installing DB2 Connect on OS/2” on page 27. For information on [...]

  • Page 36

    For information about space requir ements for data, r efer to the Administration Guide . Estimating Fixed Disk Requirements T o estimate the disk requirements for a particular configuration, add the recommended minimum disk sizes for the pr oducts and components that you want to install. Include an allowance for your application data. Components U[...]

  • Page 37

    v Whether you will be using a direct connection (see “Accessing Host or AS/400 DB2 Data Using DB2 Connect Personal Edition” on page 4), or connections via an SNA gateway (see “Connections via Communications Gateway” on page 6). Product Requirements T able 2 lists the operating system and communications software requir ed for DB2 Connect. T [...]

  • Page 38

    T able 2. Software Requirements (continued) Product Hardware/Software Requirements Communications W indows 32-bit Operating Systems v DB2 Connect Personal Edition v W indows 95 V ersion 4.00.950 or later v W indows 98 v W indows NT V ersion 4.0 with Service Pack 3, or later APPC, TCP/IP , and MPTN (APPC over TCP/IP) v The W indows NT base operating[...]

  • Page 39

    Chapter 3. Installing DB2 Connect on OS/2 This section describes how to install DB2 Connect Personal Edition on an OS/2 workstation. For information on how to deploy this product using a distributed installation, refer to the Installation and Configuration Supplement . Before Y ou Begin Before you begin the installation, be sur e that you have the[...]

  • Page 40

    Step 1. Log on to the system with the user ID that you created to perform the installation. Step 2. Insert the CD-ROM in the drive. Step 3. Open an OS/2 command window and set the directory to your CD-ROM drive by entering the following command: cd x: where x: r epr esents your CD-ROM drive. Step 4. Enter the following command: x:install where x: [...]

  • Page 41

    For information on errors encounter ed during installation, see the l1.log and l2.log files. These files store general information and error messages r esulting from installation and uninstall activities. By default, these files are located in the x:db2log dir ectory; where x: repr esents the drive on which your operating system is installed. F[...]

  • Page 42

    Upgrading from a T ry-and-Buy License T o upgrade from a T ry-and-Buy license, perform the following steps: Step 1. Start the Contr ol Center . For more information, see “Starting the Control Center” on page 134. Step 2. Click on the License Center icon fr om the Control Center toolbar . The License Center opens. Step 3. Complete the steps to u[...]

  • Page 43

    Chapter 4. Installing DB2 Connect on Windows 9x or Windows NT This section describes how to install DB2 Connect Personal Edition on W indows 32-bit operating systems. For information on how to deploy this product using a distributed installation or set up a Thin Connect workstation, refer to the Installation and Configuration Supplement . Before Y[...]

  • Page 44

    __ 3. For W indows NT , any user account that does not belong to the guests group. This user account will be used to perform the installation. Performing the Installation T o install your DB2 product, perform the following steps: Step 1. Log on to the system with the user account that you created to perform the installation. Step 2. Shut down any o[...]

  • Page 45

    Step 4. The W elcome window opens. Step 5. Respond to the setup program’s prompts. Online help is available to guide you through the r emaining steps. Invoke the online help by clicking on the Help push button or pressing the F1 key at any time. Y ou can click on the Cancel push button at any time to end the installation. For information on error[...]

  • Page 46

    T o set up connections to host or AS/400 database servers, go to one of the following sections: v “Chapter 6. Configuring DB2 Connect to Host or AS/400 Communications Using the CCA” on page 57 v “Chapter 7. Configuring APPC Communications on the DB2 Connect W orkstation” on page 67 Software Registration The Software Registration tool is u[...]

  • Page 47

    Upgrading from a T ry-and-Buy License T o upgrade from a T ry-and-Buy license, perform the following steps: Step 1. Start the Contr ol Center . For more information, see “Starting the Control Center” on page 134. Step 2. Click on the License Center icon fr om the Control Center toolbar . The License Center opens. Step 3. Complete the steps to u[...]

  • Page 48

    36 Quick Beginnings[...]

  • Page 49

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

  • Page 50

    38 Quick Beginnings[...]

  • Page 51

    Chapter 5. Configuring Host and AS/400 Databases for DB2 Connect This section describes the steps requir ed to configur e host and AS/400 database servers to accept connections from DB2 Connect workstations. These steps must be performed by users who have the necessary system privileges and special expertise, such as your network or system admini[...]

  • Page 52

    Many details of these steps have changed with the introduction of DB2 Universal Database for OS/390 V ersion 5.1. Most of these steps apply to SNA users, but some also apply to users who will connect to DB2 Universal Database for OS/390 via TCP/IP . For a summary of the example VT AM names used throughout this book, see “Sample Network Element Na[...]

  • Page 53

    Sample Network Element Names (VT AM) Figure 9 shows the sample VT AM definitions used to configure a host database server . Sample VT AM APPL Definition for OS/390 Figure 10 on page 42 shows the sample VT AM application major node definitions. In most cases, such a definition will already exist with a dif fer ent LU name. Otherwise, this appli[...]

  • Page 54

    Note: Continuations must begin in column 16, with continuation marks in column 72. Sample VT AM PU and LU Definitions for DB2 Connect If your security policies allow it, it is recommended that you enable DYNPU and DYNLU in VT AM to allow any PU and LU access through VT AM. Contact your VT AM administrator for more information. T o enable a speci?[...]

  • Page 55

    Sample VT AM Log Mode Definition for DB2 Figure 12 on page 44 shows the sample VT AM logon mode table definition for the IBMRDB and SNASVCMG modes. Note that this example specifies a 4K RUSIZE , which may not be suitable for your environment (for example, if you are using Ethernet, which has a maximum Frame Size of 1536 bytes). Y our VT AM Admin[...]

  • Page 56

    Y ou must define the SNASVCMG logon mode when using APPC. Configuring DB2 Universal Database for OS/390 Before you can use DB2 Connect, your DB2 Universal Database for OS/390 Administrator must configure DB2 Universal Database for OS/390 to permit connections from DB2 Connect workstations. This section indicates the minimum updates requir ed in [...]

  • Page 57

    The sections that follow contain examples of commands to update these tables for DB2 Universal Database for OS/390. W ork with your DB2 Administrator to determine the updates requir ed for your DB2 Universal Database for OS/390 system. For more information on the DB2 Universal Database for OS/390 Communications Database tables, refer to the DB2 Uni[...]

  • Page 58

    The sections that follow contain examples of commands to update these tables. W ork with your DB2 Administrator to determine the options r equir ed for your DB2 for MVS/ESA system. Updating SYSIBM.SYSUSERNAMES If you want to use secondary authorization IDs, you can use the following SQL command to update this table: INSERT INTO SYSIBM.SYSUSERNAMES [...]

  • Page 59

    where: v NYX1 repr esents the PU name of server involved v IBMRDB repr esents the name of VT AM logon mode v 150 repr esents the maximum number of conversations v Y repr esents the number of sessions pr eallocated at startup. This can also be left as N, or blank (the default) for deferred at startup. Configuring TCP/IP for DB2 Universal Database f[...]

  • Page 60

    Collecting Information Before you can use DB2 Connect over a TCP/IP connection, you must collect information about both the host database server and the DB2 Connect workstation. For each host server that you are connecting to via TCP/IP , you must have the following information: v The location of the TCP/IP services file at the DB2 Connect worksta[...]

  • Page 61

    Example W orksheet: T able 3. Example Worksheet for Planning TCP/IP Connections to DB2 Universal Database for OS/390 Ref. Description Sample V alue Y our V alue User Information  TCP-1  User Name A.D.B.User  TCP-2  Contact Info (123)-456-7890  TCP-5  User ID ADBUSER  TCP-6  Database T ype db2390  TCP-7  Connection type[...]

  • Page 62

    Configuring the TCP/IP Connection Use the manual steps in this section to complete the configuration and make the connection. Complete the W orksheet: Complete a copy of the example worksheet for each TCP/IP host: 1. Fill in the values to be used for the TCP/IP addr ess and hostname of the DB2 Universal Database for OS/390 host (items 8 and 9). 2[...]

  • Page 63

    v 1ST_CONN , the first database that a connection is established to will be used as the T ransaction Manager database for transactions. If this option is used, then the first database connected to must be either a DB2 Universal Database V ersion 5 or later database, or a DB2 Universal Database for OS/390 V ersion 5.1 or later database. This is th[...]

  • Page 64

    CONNECT and BIND: Finally , connect to the target host server and bind the utilities and applications to the server using commands similar to the following in the command line processor: connect to MVSIPDB1 user USERID using PASSWORD bind path/bnd/@ddcsmvs.lst blocking all sqlerror continue blocking all grant public disconnect all where path corr e[...]

  • Page 65

    Display Relational Database Directory Entries Position to ...... Type options, press Enter. 5=Display details 6=Print details Relational Remote Option Database Location Text _ __________________ _ DLHX RCHAS2FA _ JORMT2FA JORMT2FA _ JORMT4FD JORMT4FD _ JOSNAR7B RCHASR7B _ RCHASR7B *LOCAL _ RCHASR7C RCHASR7C _ R7BDH3SNA RCH2PDH3 _ RCHASDH3 RCHASDH3 [...]

  • Page 66

    54 Quick Beginnings[...]

  • Page 67

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

  • Page 68

    56 Quick Beginnings[...]

  • Page 69

    Chapter 6. Configuring DB2 Connect to Host or AS/400 Communications Using the CCA This section describes how to use the Client Configuration Assistant (CCA) to configure your DB2 Connect workstation to access host or AS/400 DB2 databases. The configuration steps described in this section apply if you are connecting to the host or AS/400 system [...]

  • Page 70

    v Change your server password. The CCA provides thr ee methods to set up a database connection to a server: v Using a profile. v Searching the network for databases. v Manually entering database and communication protocol information for a server . When you add a database using this configuration method, the Client Configuration Assistant will g[...]

  • Page 71

    Adding a Database Using a Profile A profile contains information about instances and databases on a system, and databases within each instance. For information on profiles, see “Cr eating and Using Profiles” on page 1 12. If your administrator provided you with a pr ofile, perform the following steps: Step 1. Select the Use an access pro?[...]

  • Page 72

    c. If you would like to create an ODBC data sour ce file to shar e database access, select the Create a file data source check box and enter the path and filename for this file in the File data source name field. d. Click on the Optimize for application drop down box and select the application for which you want to tune the ODBC settings. e. C[...]

  • Page 73

    The Client Configuration Assistant may be unable to detect a remote system if: v The Administration Server is not running on the remote system. v The Discovery function times out. By default, the Discovery function will search the network for 40 seconds; this may not be long enough to detect the remote system. Y ou can set the DB2DISCOVER YTIME re[...]

  • Page 74

    Step 8. Register this database as an ODBC data source. If you are not planning to use ODBC, click on the Done push button and go to the next step. a. Ensure that the Register this database for ODBC check box is selected. b. Select the radio button that describes how you would like to register this database: v If you would like all users on your sys[...]

  • Page 75

    Step 1. Select the Manually configure a connection to a DB2 database radio button and click on the Next push button. If you are not using Lightweight Dir ectory Access Protocol (LDAP), this tab will not be shown, skip this step and go to Step 3. Step 2. Select the radio button that corresponds to the location where you would like your DB2 director[...]

  • Page 76

    v If you would like all users on your system to have access to this data source, select the As a system data source radio button. v If you would like only the current user to have access to this data source, select the As a user data source radio button. c. If you would like to create an ODBC data sour ce file to shar e database access, select the[...]

  • Page 77

    Step 3. Select the database that you want to bind the utilities and packages against. Step 4. Click on the Bind push button. Step 5. Select the type of bind that you want to perform: v Select the Bind DB2 utilities radio button if you want to bind utilities against the database v Select the Bind applications radio button if you want to bind applica[...]

  • Page 78

    66 Quick Beginnings[...]

  • Page 79

    Chapter 7. Configuring APPC Communications on the DB2 Connect W orkstation This section describes how to configure a DB2 Connect workstation to communicate with a host or AS/400 database server using the APPC communication protocol. The instr uctions that follow assume that APPC is supported on the DB2 Connect and host or AS/400 machines. Y ou wi[...]

  • Page 80

    Note: The worksheet and configuration instructions supply suggested or sample values for requir ed configuration parameters. For other parameters, use the communications program’s default values. If your network configuration is dif ferent fr om that used in the instructions, consult your Network Administrator for values that are appropriate t[...]

  • Page 81

    T able 5. Worksheet for Planning Host and AS/400 Server Connections (continued) Ref. Name at the DB2 Connect W orkstation Network or VT AM Name Sample V alue Y our V alue  13  Local Node or Node ID ID BLK 071  14  ID NUM 27509  15  Mode name IBMRDB  16  Symbolic Destination name DB2CPIC  17  (Remote) T ransaction progr[...]

  • Page 82

    4. For database name (  5  ), determine the name of the host database. This is the LOCA TION NAME for OS/390 or MVS, the RDB_NAME for VM or VSE, or a relational database name for AS/400. 5. For mode name (  6  and  15  ), usually the default IBMDRB is suf f icient. 6. For remote network addr ess (  8  ), determine the contr [...]

  • Page 83

    __ 1. It is V ersion 5.0 or higher if you are planning to update multiple databases within the same transaction; if you are planning to use 2-phase commit then V ersion 5.01 of CS/NT is requir ed __ 2. The IBM Communications Server IEEE 802.2 LAN interface was installed (this is an installation option for Communications Server) __ 3. The AP AR fix[...]

  • Page 84

    window . T o configure IBM eNetwork Personal Server for APPC communications, complete the perform the following steps: Step 1. Configur e Node a. In the Configuration options field, select Configure Node , then click on the New push button. The Define the Node window appears. b. In the Fully qualified CP name fields, type in the network nam[...]

  • Page 85

    f. Click on OK . Step 2. Configure Devices a. In the Configuration options field, select Configure devices . b. Ensure that in the DLCs field, the appr opriate DLC is highlighted. For example, LAN . c. Click on the New push button. The appropriate window appears with default values displayed. For example, the Define a LAN device window . d. C[...]

  • Page 86

    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 Clients, in the Fully-qualified CP name fields, type in the network ID (  3  ) and the adjacent control point SSCP name (  4  )( SPIFNET.NYX ). Leave the other fields bl[...]

  • Page 87

    v T o specify a service TP , in the TP name field, type in the name of the service TP , for example 076DB , and ensure that there is a check mark in the Service TP check box. Accept the defaults for the other fields. f. Click on OK . Step 9. Save the Configuration a. Select File->Save as from the menu bar . The Save As window appears. b. T yp[...]

  • Page 88

    T o automatically start Communications Server when the machine is booted, you can register it as a W indows NT Service. T o register Communications Server as an NT service execute one of the following commands: csstart -a to register Communications Server with the default configuration, or: csstart -a c:ibmcsprivateyour.acg where c:ibmcspriva[...]

  • Page 89

    T o configure the W indows NT SNA API client for APPC communications, complete the following steps: Step 1. Create a user account for the SNA API client on the Communications Server for W indows NT server a. Click on the Start button and select Programs->Administrative T ools (Common)->User Manager . The User Manager window opens. b. Select [...]

  • Page 90

    SNA Client Configuration window opens. Step 3. Configure Global Data a. In the Configuration options box, select the Configure Global Data option and click on the New push button. The Define Global Data window opens. b. Enter the user name for the SNA API client in the User name field. This is the user name that was defined in Step 1. c. Ent[...]

  • Page 91

    b. T ype in the IP address of the server (for example, 123.123.123.123 ). c. Click on OK . Step 5. Configure CPI-C Side Information a. In the Configuration options box, select the Configure CPI-C side information option and click on the New push button. The Define CPI-C side information window opens. b. Enter the symbolic destination name ( [...]

  • Page 92

    similar to that of the W indows NT Explorer . The following illustration shows the interface. There ar e two panes in the main window of the Server Manager . All the configuration options we will be using can be accessed by right-clicking on objects in the left-hand pane of the window . Every object has a context menu that you can access by right-[...]

  • Page 93

    a. Right-click on the SNA Service icon and select the Insert->Link Service option. The Insert Link Service window opens. b. Select DLC 802.2 Link Service. c. Click on the Add push button. d. Click on the Finish push button. Step 4. Define the connection properties Chapter 7. Configuring APPC Communications on the DB2 Connect W orkstation 81[...]

  • Page 94

    a. Right-click on SNA Service and select the Insert->Connection- >802.2 option. The Connection Properties window opens. b. Enter a connection name (  7  )i nt h e Name field. c. Click on the Link Service drop-down box and select the SnaDlc1 option. d. Select the Remote End radio button from the Host System box. e. Select the Both Direc[...]

  • Page 95

    g. Select the Address tab. h. Fill in the Remote Network Address field (  8  ). Accept the default numbers in the other fields. i. Select the System Identification tab. j. Enter the following information: 1) For the Local Node Name , add the Network ID (  9  ), the Local PU Name (  10  ), and the Local Node ID (  1  plus [...]

  • Page 96

    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 Member of Default Outgoing Local APPC LU Pool option. Accept the other defaults. e. Click on OK . Step 6. Define a remote LU a. Right-click on SNA Services icon and sele[...]

  • Page 97

    Step 7. Define a mode a. Right-click on APPC Modes folder and select the Insert->APPC->Mode Definition option. The APPC Mode Properties window opens. b. Enter the Mode Name  6  in the Mode Name field. c. Select the Limits tab. Chapter 7. Configuring APPC Communications on the DB2 Connect W orkstation 85[...]

  • Page 98

    d. Enter appropriate numbers for the Parallel Session Limit and Minimum Contention W inner Limit fields. Y our Host-Side or LAN administrator should be able to supply you with the numbers if you do not know the limits you should place here. e. Accept the other defaults, and click on OK . Step 8. Define the CPIC name properties a. Right-click on C[...]

  • Page 99

    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  ), or select the Application TP radio button and enter the Application TP name (  17  ). f. In the Partner LU Name box, select the Fully Qualified radio button. g. Enter the fully-quali?[...]

  • Page 100

    Configuring Microsoft SNA Client Read this section if you have a W indows NT workstation that has DB2 Connect installed. This section provides step-by-step instr uctions for setting up the communications between your DB2 Connect workstation and a W indows NT workstation that has Microsoft SNA Server V4.0 (or later) installed. For instructions on h[...]

  • Page 101

    The rest of this section assumes: 1. The Microsoft SNA Server has already been configur ed for APPC communications with the host, and is enabled for ODBC and DRDA. Refer to the Microsoft SNA Server documentation for further information. DB2 for MVS DB2 for VSE DB2 for VM OS/390 AS/400 S/390, S/370 DB2 f or AS/400 APPC TCP/IP*** MPTN Coax* Ether ne[...]

  • Page 102

    2. Microsoft SNA Client V ersion 2.1 1 is not alr eady installed on your DB2 Connect workstation. T o configure the Microsoft SNA client perform the following steps: Step 1. Obtain Required Information For your Microsoft SNA client software to function pr operly you must have access to a properly configur ed Micr osoft SNA Server . Request that y[...]

  • Page 103

    __ a. The Symbolic destination name (  16  ) defined at the Microsoft SNA Server for the Partner LU (  2  ) of the target host or AS/400 database server . __ b. The real database name (  5  ). Y ou now need to update the DB2 directories, bind utilities and applications to the server , and test the connection. The easiest way to d[...]

  • Page 104

    program name (  17  ), the mode (  15  ), and the security type. Enter the following commands substituting your values from the worksheet in T able 5 on page 68: catalog "appn node db2node network SPIFNET remote NYM2DB2 tpname QCNTEDDM mode IBMRDB security PROGRAM" terminate Note: T o connect to DB2 for MVS, it is recommended [...]

  • Page 105

    database name ( database_name ). The information in the database directory , along with the information in the node directory , is used on the DB2 Connect workstation to establish a connection to the remote database. T o catalog a database on the DB2 Connect W orkstation, perform the following steps. Step 1. Log on to the system as a user with Syst[...]

  • Page 106

    If you need to change values that were set with the catalog database command, perform the following steps: Step a. Run the uncatalog database command: uncatalog database database_alias Step b. Recatalog the database with the value that you want to use. Step 6. Bind Utilities and Applications to the Database Server The steps you have just completed [...]

  • Page 107

    The userid and password values requir ed ar e those defined at the host or AS/400 system, and must be provided to you by your DB2 Administrator . For more information, r efer to the DB2 Connect User’s Guide . If the connection is successful, you will get a message showing the name of the database to which you have connected. Y ou are now able to[...]

  • Page 108

    96 Quick Beginnings[...]

  • Page 109

    Chapter 8. Enabling Multisite Updates (T wo-Phase Commit) This chapter provides an overview of the multisite update function as it applies to scenarios that involve host and AS/400 database servers. It describes products and components needed to implement PC, UNIX and web applications that update multiple DB2 databases in the same transaction. Mult[...]

  • Page 110

    TP Monitor multisite update can coor dinate a transaction that accesses both DB2 and non-DB2 resour ce managers such as Oracle, Informix, SQLServer , etc. Native SQL multisite update is used with DB2 servers only . For a multisite update transaction to work, each of the databases participating in a distributed transaction must be capable of support[...]

  • Page 111

    Host and AS/400 multisite update scenarios that require SPM. Y es TCP/IP Y es v DB2 Connect Enterprise Edition v DB2 Universal Database Enterprise Edition v DB2 Universal Database Enterprise- Extended Edition v DB2 for OS/390 V5.1 v DB2 Universal Database for OS/390 V6.1 Ye s S N A Ye s v DB2 Connect Enterprise Edition* v DB2 Universal Database Ent[...]

  • Page 112

    Host and AS/400 multisite update scenarios that require SPM. No TCP/IP No v DB2 Connect Personal Edition v DB2 Connect Enterprise Edition v DB2 Universal Database Enterprise Edition v DB2 Universal Database Enterprise- Extended Edition v DB2 for OS/390 V5.1 v DB2 Universal Database for OS/390 V6.1 No SNA Y es v DB2 Connect Enterprise Edition* v DB2[...]

  • Page 113

    1. Set your W eb browser to the following URL: http://www.software.ibm.com/data/db2/library/ 2. Select ″ DB2 Universal Database ″ . 3. Search for ″ T echnotes ″ using the search keywor ds ″ DDCS ″ , ″ SPM ″ , ″ MTS ″ , ″ CICS ″ , and ″ ENCINA ″ . Enabling Multisite Updates Using the Control Center As of V ersion 6, you c[...]

  • Page 114

    Step 2. Select the databases you wish to test from the available databases in the left sub-window . Y ou can use the arrow buttons in the middle to move selections to and from the Selected Databases sub-window . Step 3. When you have finished your selection, press the T est... button at the bottom of the window . The Multi-Site Update T est Result[...]

  • Page 115

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

  • Page 116

    104 Quick Beginnings[...]

  • Page 117

    Chapter 9. Configuring Client-to-Server Communications Using the Client Configuration Assistant T o configure communications fr om a DB2 client to a server , the remote server must be configured to accept inbound client r equests. By default, the server installation program automatically detects and configur es most protocols on the server for[...]

  • Page 118

    When you add a database using this configuration method, the Client Configuration Assistant will generate a default node name for the server where the database r esides. Configuration Steps T o configure your workstation to access a database on a remote server , perform the following steps: Step 1. Log on to the system with a valid DB2 user ID.[...]

  • Page 119

    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 add a comment that describes this database in the Comment field. Click on the Next push button. If you do not specify a database alias name, the default will be the same as the remote database alias name. Step 4. R[...]

  • Page 120

    Adding a Database Using Discovery This option cannot return information about pr e-V ersion 5 DB2 systems or any systems where an Administration Server is not running. For more information, r efer to the Administration Guide . Y ou can use the Discovery feature to search the network for databases. T o add a database to your system using Discovery ,[...]

  • Page 121

    b. Enter the requir ed communication pr otocol parameters for the remote Administration Server and click on OK . A new system is added. For more information, click on the Help push button. c. Select the database that you want to add and click on the Next push button. Step 4. Enter a local database alias name in the Database alias field and add a c[...]

  • Page 122

    Step 8. Y ou are now able to use this database. T o finish using the Add Database SmartGuide, click on the Close push button; you can then add more databases by clicking on the Add push button or exit the CCA. Adding a Database Manually If you have the protocol information for the server that you want to connect to, you can manually enter all of t[...]

  • Page 123

    OS/390 or MVS Location name AS/400 RDB name VM or VSE DBNAME When a database is created on the r emote server , if a database alias is not specified during database creation, the database is cr eated with a database alias= database_name ; otherwise, the database alias is the name that was specified when the database was created. Step 6. Register [...]

  • Page 124

    have incorrectly specified or click on the Help push button for mor e information. For even more detailed information, r efer to the T roubleshooting Guide . Step 8. Enter your user ID and password and click on OK . If the connection is successful, a message confirming the connection appears. Step 9. Y ou are now able to use this database. T o ?[...]

  • Page 125

    have the discover_inst database manager configuration parameter and databases with the discover_db database configuration parameter set to ENABLE . The discover parameter in the Administration Server’s configuration file must be set to either SEARCH or KNOWN to generate a profile for a server system. The default settings for these configura[...]

  • Page 126

    A Client Profile is generated fr om a client using the Export function of the CCA. The information contained in a Client Profile is determined during the export process. Depending on the settings chosen, it can contain the existing client’s: v Database connection information (including CLI or ODBC settings). v Client settings (including databas[...]

  • Page 127

    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 window opens. Step 8. Click on OK . T o import a Client Profile, perform the following steps: Step 1. Start the CCA. For mor e information, see “Starting the Client Configuration Assistant[...]

  • Page 128

    v If you would like all users on your system to have access to this data source, select the As a system data source radio button. v If you would like only the current user to have access to this data source, select the As a user data source radio button. c. If you would like to create an ODBC data sour ce file to shar e database access, select the[...]

  • Page 129

    Part 6. Using DB2 Connect © Copyright IBM Corp. 1993, 1999 11 7[...]

  • Page 130

    11 8 Quick Beginnings[...]

  • Page 131

    Chapter 10. Running Y our Own Applications V arious types of applications can access DB2 databases: v Applications developed using the DB2 Software Developer’s Kit that include embedded SQL, APIs, stored procedur es, user-defined functions or calls to the DB2 CLI. v ODBC applications such as Lotus Approach. v JDBC applications and applets. v Net[...]

  • Page 132

    The bind files are gr ouped together in dif ferent .lst files in the bnd dir ectory , under the installation directory (typically sqllibwin on W indows 3.x systems and sqllib for OS/2, and W indows 32-bit operating systems). Each file is specific to a server . Binding to Host Databases T o bind the utilities and applications to the DRDA server[...]

  • Page 133

    "bind @db2ubind.lst messages bind.msg grant public" "bind @db2cli.lst messages clibind.msg grant public" In this example, bind.msg and clibind.msg are the output message files, and EXECUTE and BINDADD privileges are granted to public . Step 4. Reset the connection to the database by entering the following command: connect reset[...]

  • Page 134

    The following general steps are r equir ed on the client system to give DB2 CLI and ODBC applications access to DB2 databases. These instructions assume that you have successfully connected to DB2 using a valid user ID and password. Depending on the platform many of these steps ar e automatic. For complete details, see the section that deals speci?[...]

  • Page 135

    Platform Specific Details for CLI/ODBC Access The platform specific details on how to give DB2 CLI and ODBC applications access to DB2 are divided into the following categories: v “W indows 32-bit operating systems Client Access to DB2 using CLI/ODBC” v “OS/2 Client Access to DB2 using CLI/ODBC” on page 125 Windows 32-bit operating system[...]

  • Page 136

    d. On W indows 32-bit operating systems you can use the radio buttons to add the data source as either a user or system data source. v Using the Microsoft 32-bit ODBC Administration tool , which you can access from the icon in the Contr ol Panel or by running odbcad32.exe from the command line: a. On W indows 32-bit operating systems the list of us[...]

  • Page 137

    OS/2 Client Access to DB2 using CLI/ODBC Before DB2 CLI and ODBC applications can successfully access a DB2 database from an OS/2 client, perform the following steps on the client system: 1. The DB2 database (and node if the database is remote) must be cataloged. T o do so, use the CCA (or the command line processor). For more information see the o[...]

  • Page 138

    2) Click on the Add push button from the Data Sour ces window . The Add Data Source W indow opens. 3) Double-click on the IBM DB2 ODBC DRIVER in the list. 4) Select the DB2 database to add and click on OK . 3. Configure the DB2 CLI/ODBC driver using the CCA: (Optional) a. Select the DB2 database alias you want to configure. b. Click on the Proper[...]

  • Page 139

    Running Java Programs Y ou can develop Java programs to access DB2 databases with the appropriate Java Development Kit (JDK) on AIX, HP-UX, Linux, OS/2, Silicon Graphics IRIX, Solaris, or W indows 32-bit operating systems. The JDK includes Java Database Connectivity (JDBC), a dynamic SQL API for Java. For DB2 JDBC support, you must include the DB2 [...]

  • Page 140

    Configuring the Environment T o build and run DB2 Java programs, you need to install and configur e the appropriate version of the Java Development Kit (JDK) on your development machine: AIX: The Java Development Kit (JDK) V ersion 1.1.2 for AIX from IBM. HP-UX: The HP-UX Developer’s Kit for Java Release 1.1.3 or later from Hewlett-Packard. Lin[...]

  • Page 141

    Y ou may want to pipe the output to a file for easier viewing. The JDK11_PATH field appears near the beginning of the output. For more information on these commands, refer to the Command Refer ence . On Solaris, some Java V irtual Machine implementations do not work well in programs that run in a ″ setuid ″ envir onment. The shar ed library t[...]

  • Page 142

    java prog_name where prog_name is the name of the pr ogram. The DB2 JDBC driver handles the JDBC API calls from your application and uses the DB2 CAE to communicate the requests to the server and r eceive the results. An SQLJ application must be bound to the database before it is run. Java Applets Because Java applets are deliver ed over the web, a[...]

  • Page 143

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

  • Page 144

    132 Quick Beginnings[...]

  • Page 145

    Appendix A. Basic T ask Knowledge This section describes the basic tasks that you will need to know to use this product ef fectively . Go to the task that you want to perform: v “Starting the Software Registration T ool”. v “Starting the Client Configuration Assistant”. v “Starting the Control Center” on page 134. v “Entering Command[...]

  • Page 146

    Starting the Control Center Start the Control Center in one of the following ways: On OS/2 v Enter the db2cc command at a command prompt. or v Click on the OS/2 W arp button and select DB2 for OS/2–>Control Center . Note: Y ou must have the prerequisite Java Runtime Envir onment (JRE) level to launch the Control Center using this command. For [...]

  • Page 147

    v Display all the command scripts known to the system through the Script Center , with summary information listed for each. Start the Command Center in one of the follows ways: v Click on the Command Center icon in the Control Center . v Enter the db2cctr command. v Launch the Command Center from the toolbar as follows: On W indows 9x or W indows N[...]

  • Page 148

    T o save commands as scripts, select Script->Save as from the menu bar . For more information, click on the Help push button or pr ess the F1 key . If you want to store commonly used SQL statements or DB2 commands as scripts, click on the Script Center icon from the main tool bar . For more information, click on the Help push button or press the[...]

  • Page 149

    If the DB2 command contains characters that have special meaning on the operating system you are using, you will need to enter the command in quotation marks to ensure that it is run pr operly . For example, the following command would retrieve all the information from the employee table, even if the * character has a special meaning on the operati[...]

  • Page 150

    db2 => select empno, function, firstname, lastname, birthdate, from db2 (cont.) => employee where function='service' and db2 (cont.) => firstname='Lily' order by empno desc T o end interactive input mode, enter the quit command. For more information on advanced topics using the CLP , refer to the Command Reference .[...]

  • Page 151

    Appendix B. Using the Control Center to Administer DB2 for OS/390 and DB2 Connect Enterprise Edition servers DB2 Control Center is an easy to use application pr ovided as part of the DB2 Administration Client. The Control Center gives database administrators a powerful tool for managing DB2 Family databases. In V ersion 6, the Control Center has be[...]

  • Page 152

    Preparing DB2 for OS/390 Servers for the Control Center The DB2 Control Center uses stor ed pr ocedures to deliver many of its management functions. Therefor e, for the contr ol center to function properly each DB2 for OS/390 server that will be managed from the Contr ol Center needs to have stored pr ocedur es enabled and the proper stor ed pr oce[...]

  • Page 153

    Appendix C. db2cpic.dll - Extended SNA Security Codes on Windows NT and W indows 95 Extended SNA Security Codes were not implemented by some SNA subsystem providers. This may af fect customers using one or mor e of the following: v DB2 Universal Database (UDB) for W indows NT V ersion 5 (all editions). v DB2 Connect Enterprise Edition for W indows [...]

  • Page 154

    142 Quick Beginnings[...]

  • Page 155

    Appendix D. How the DB2 Library Is Structured The DB2 Universal Database library consists of SmartGuides, online help, books and sample programs in HTML format. This section describes the information that is provided, and how to access it. T o access product information online, you can use the Information Center . Y ou can view task information, DB[...]

  • Page 156

    SmartGuide Helps Y ou to... How to Access... Create T able Select basic data types, and create a primary key for the table. From the Contr ol Center , click with the right mouse button on the T ables icon and select Create -> T able using SmartGuide . Create T able Space Create a new table space. From the Contr ol Center , click with the right m[...]

  • Page 157

    T ype of Help Contents How to Access... Control Center Help Client Configuration Assistant Help Event Analyzer Help Command Center Help Explains the tasks you can perform in a window or notebook. The help includes prer equisite information you need to know , and describes how to use the window or notebook controls. From a window or notebook, click[...]

  • Page 158

    DB2 Information – Hardcopy and Online The table in this section lists the DB2 books. They are divided into two groups: Cross-platform books These books contain the common DB2 information for all platforms. Platform-specific books These books are for DB2 on a specific platform. For example, there ar e separate Quick Beginnings books for DB2 on O[...]

  • Page 159

    Name Description Form Number File Name for Online Book HTML Directory Cross-Platform Books Administration Guide Administration Guide, Design and Implementation contains information requir ed to design, implement, and maintain a database. It also describes database access using the Control Center(whether local or in a client/server environment), aud[...]

  • Page 160

    Name Description Form Number File Name for Online Book HTML Directory Application Development Guide Explains how to develop applications that access DB2 databases using embedded SQL or JDBC, how to write stored pr ocedures, user -defined types, user-defined functions, and how to use triggers. It also discusses programming techniques and performan[...]

  • Page 161

    Name Description Form Number File Name for Online Book HTML Directory Installation and Configuration Supplement Guides you through the planning, installation, and set up of platform-specific DB2 clients. This supplement contains information on binding, setting up client and server communications, DB2 GUI tools, DRDA AS, distributed installation, [...]

  • Page 162

    Name Description Form Number File Name for Online Book HTML Directory What’s New Describes the new features, functions, and enhancements in DB2 Universal Database, V ersion 6.0, including information about Java-based tools. SC09-2851 db2q0x60 db2q0 Platform-Specific Books Administering Satellites Guide and Reference Provides planning, configura[...]

  • Page 163

    Name Description Form Number File Name for Online Book HTML Directory DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings Provides planning, installation, and configuration information for DB2 Enterprise - Extended Edition for W indows NT . Also contains installing and setup information for many supported clients. GC09-2833 db2v6x60 [...]

  • Page 164

    Name Description Form Number File Name for Online Book HTML Directory Cross-Platform Sample Programs in HTML Sample programs in HTML Provides the sample pr ograms in HTML format for the programming languages on all platforms supported by DB2 for informational purposes (not all samples are available in all languages). Only available when the SDK is [...]

  • Page 165

    Swedish s T rad. Chinese t T urkish m 2. For late breaking information that could not be included in the DB2 books: v On UNIX-based platforms, see the Release.Notes file. This file is located in the DB2DIR/Readme/%L directory , where %L is the locale name and DB2DIR is: – /usr/lpp/db2_06_01 on AIX – /opt/IBMdb2/V6.1 on HP-UX, Solaris, SCO Uni[...]

  • Page 166

    If you have not installed the Information Center , you can open the page by double-clicking on the DB2 Online Books icon. Depending on the system you are using, the icon is in the main pr oduct folder or the W indows Start menu. T o view online books or sample programs on the SCO UnixW are 7: v DB2 Universal Database for SCO UnixW are 7 uses the na[...]

  • Page 167

    W eb. T o access this information, you must have a connection to the W eb from your system. When you select an item in one of the lists, the Information Center launches a viewer to display the information. The viewer might be the system help viewer , an editor , or a W eb browser , depending on the kind of information you select. The Information Ce[...]

  • Page 168

    v List of books v T ables of contents of frequently used books v Frequently r efer enced articles, such as the AL TER T ABLE topic v The Search form For information about setting up a search, see the NetQuestion Appendix in Installation and Configuration Supplement book. Searching Online Information T o search for information in the HTML books, yo[...]

  • Page 169

    book, simply run it as you would run any other executable pr ogram. The result fr om this step is a printable PostScript file with a file extension of .ps . 3. Ensure that your default printer is a PostScript printer capable of printing Level 1 (or equivalent) files. 4. Enter the following command from a command line: print filename.ps On UNIX-b[...]

  • Page 170

    Note: These form numbers only apply if you are or dering books that ar e printed in the English language in North America. Y ou can also order books individually by the form number listed in “DB2 Information – Hardcopy and Online” on page 146. T o or der printed versions, contact your IBM authorized dealer or marketing repr esentative, or pho[...]

  • Page 171

    Appendix E. National Language Support (NLS) This section contains information about configuring national language support for the DB2 Connect product, and includes information on: v Which languages are supported by DB2 Connect Enterprise Edition and DB2 Connect Personal Edition. v How DB2 Connect handles the conversion of data between unalike syst[...]

  • Page 172

    T able 8. Languages and Code Pages (continued) Country Code Language en English es Spanish fi Finnish fr French gr Greek hu Hungarian il Hebrew it Italian jp Japanese kr Korean nl Dutch no Norwegian pl Polish pt Portuguese ru Russian se Swedish si Slovenian tr T urkish tw T raditional Chinese (T aiwan) Conversion of Character Data When character d[...]

  • Page 173

    FOR BIT DA T A clause) is not converted. Otherwise all input and output character data is converted if the two machines have dif ferent code pages or CCSIDs. For example, if DB2 Connect is used to access DB2 Universal Database for OS/390 or DB2/MVS data, the following happens: 1. DB2 Connect sends an SQL statement and input data to OS/390 or MVS. 2[...]

  • Page 174

    T able 9. Workstation Code Page to Host CCSID Conversion (continued) Host CCSIDs Code Page Countries 838 874 Thailand 930, 939, 5026, 5035 932, 942, 943, 954, 5039 Japan 937 938, 948, 950, 964 T aiwan 933, 1364 949, 970, 1363 Korea 935, 1388 1381, 1383, 1386 People’s Republic of China 1 112, 1 122 921, 922 Estonia, Latvia, Lithuania 1025 915, 1 1[...]

  • Page 175

    Since defaults on dif ferent platforms ar e not the same, problems appear when DB2 data is sent from one platform to another . For example, W indows platforms use LOGICAL UNSHAPED data, while data on OS/390 is usually in SHAPED VISUAL format. Therefore, without any support for these attributes data sent from DB2 Universal Database for OS/390 to DB2[...]

  • Page 176

    X'3F21' 856 11 X'3F22' 862 11 X'3F23' 916 11 X'3F24' 1255 11 Where CDRA String T ypes are defined: String - Text - Numerical - Orientation - Shaping - Symmetrical Type - Type - Shape - - - Swapping ---------+-------+------------+-------------+-----------+------------- 4 Visual Arabic LTR Shaped OFF 5 Implici[...]

  • Page 177

    Appendix F . Naming Rules Go to the section that describes the naming rules that you requir e information on: v “General Naming Rules” v “Database, Database Alias, and Catalog Node Name Rules” v “Object Name Rules” on page 166 v “Username, User ID, Group Name, and Instance Name Rules” on page 167 v “Password Rules” on page 168 v[...]

  • Page 178

    Database alias names are synonyms given to r emote databases. Database aliases must be unique within the System Database Directory in which all aliases ar e stored. When naming a database or database alias, see “General Naming Rules” on page 165. In addition, the name you specify can only contain 1 to 8 characters. T o avoid potential problems,[...]

  • Page 179

    Using delimited identifiers, it is possible to create an object that violates these naming rules; however , subsequent use of the object could result in err ors. For example, if you create a column with a + or − sign included in the name and you subsequently use that column in an index, you will experience problems when you attempt to r eorganiz[...]

  • Page 180

    v Can contain 1 to 8 characters v Cannot include &, #, and @ v Must be unique within the network DB2SYSTEM Naming Rules DB2 uses the DB2SYSTEM name to identify a physical DB2 machine, system, or workstation within a network. On OS/2, you must specify the DB2SYSTEM name during install. On W indows 32-bit operating systems, you do not need to spe[...]

  • Page 181

    Appendix G. List Files, Bind Files, and Packages This appendix lists the bind files contained in dif ferent .lst files shipped with the product. Although the contents of these lists are similar for each platform, the bind packages are generated specifically for each platform. Each package name can be mapped back to the client platform. Note that[...]

  • Page 182

    xMz Clients for Macintosh xGz Clients for Silicon Graphics List Files Associated with DRDA Servers The following table lists which bind files are included in the .lst file associated with a particular DRDA host. The package associated with each bind file is also listed: DRDA Server List File OS/390 and MVS ddcsmvs.lst VSE ddcsvse.lst VM ddcsvm.l[...]

  • Page 183

    T able 10. DRDA Bind Files and Packages (continued) Component Bind File Name Package Name MVS VM/VSE OS/400 Isolation level NC db2clpnc.bnd sqlc6 xyz no no yes REXX Isolation level CS db2arxcs.bnd sqla1 xyz yes yes yes Isolation level RR db2arxrr .bnd sqla2 xyz yes yes yes Isolation level UR db2arxur .bnd sqla3 xyz yes yes yes Isolation level RS db[...]

  • Page 184

    172 Quick Beginnings[...]

  • Page 185

    Appendix H. Notices Any refer ence to an IBM licensed pr ogram in this publication is not intended to state or imply that only IBM’s licensed program may be used. Any functionally equivalent product, pr ogram or service that does not infringe any of IBM’s intellectual property rights may be used instead of the IBM pr oduct, program, or service.[...]

  • Page 186

    T rademarks The following terms are trademarks or r egister ed trademarks of the IBM Corporation in the United States and/or other countries: ACF/VT AM ADST AR AISPO AIX AIXwindows AnyNet APPN AS/400 CICS C Set++ C/370 DA T ABASE 2 DataHub DataJoiner DataPropagator DataRefresher DB2 DB2 Connect DB2 Universal Database Distributed Relational Database[...]

  • Page 187

    Microsoft, W indows, W indows NT , V isual Basic, and the W indows logo are trademarks or register ed trademarks of Micr osoft Corporation in the United States, other countries, or both. PC Direct is a trademark of Zif f Communications Company in the United States, other countries, or both and is used by IBM Corporation under license. ActionMedia, [...]

  • Page 188

    176 Quick Beginnings[...]

  • Page 189

    Index A Access Profile creating 1 13 using 1 12 accessing data through DB2 Connect 8 through Net.Data or JDBC 14 accessing host servers configuring communications IBM Personal Communications for W indows 32-Bit Operating Systems 79 SNA API Client 76 Administering Satellites Guide and Reference 150 Administration Guide 147 Administrative API Refer[...]

  • Page 190

    DB2 Connect User’s Guide 148 DB2 Data Links Manager for AIX Quick Beginnings 151 DB2 Data Links Manager for W indows NT Quick Beginnings 151 DB2 Enterprise - Extended Edition for UNIX Quick Beginnings 150 DB2 Enterprise - Extended Edition for W indows NT Quick Beginnings 150 DB2 Enterprise Edition configuration planning 23 memory requir ements 2[...]

  • Page 191

    partner node name 69 password naming rules 169 planning DB2 configuration 23 DB2 Connect configuration 23 privileges requir ed 138 product descriptions 3 overview 3 protocols APPC 67 PU 70 Q Quick Beginnings for OS/2 150 Quick Beginnings for UNIX 150 Quick Beginnings for W indows NT 150 R RDB_NAME (VSE or VM) 70 registering ODBC driver manager 12[...]

  • Page 192

    180 Quick Beginnings[...]

  • Page 193

    Contacting IBM This section lists ways you can get more information fr om IBM. If you have a technical problem, please take the time to r eview and carry out the actions suggested by the T roubleshooting Guide befor e contacting DB2 Customer Support. Depending on the nature of your pr oblem or concern, this guide will suggest information you can ga[...]

  • Page 194

    Log on as anonymous. In the directory /ps/pr oducts/db2, you can find demos, fixes, information, and tools concerning DB2 and many related products. Internet Newsgroups comp.databases.ibm-db2, bit.listserv .db2-l These newsgroups ar e available for users to discuss their experiences with DB2 products. CompuServe GO IBMDB2 to access the IBM DB2 Fa[...]

  • Page 195

    [...]

  • Page 196

    IBMR Part Number: CT6D9NA Printed in the United States of America on recycled paper containing 10% recovered post-consumer fiber . GC09-2830-00 CT6D9NA[...]