IBM GC09-2830-00 - Manual

Code Page and Language Support . . . . 159 Conversion of Character Data . . . . . 160 Bidirectional CCSID Support . . . . . . 162 Bidirectional-specific CCSIDs . . . . . 163 Appendix F. Naming Rules . . . . . . 165 General Naming Rules . . . . . . . . 165 Database, Database Alias, and Catalog NodeNa...

Welcome to DB2 Connect! The DB2 Connect Quick Beginningsbooks provide a focused introductionto the installation and configurationof DB2 Connect products. This Quick Beginnings book will guideyou through the planning,installation, migration (if necessary),and setup of a DB2 Connectworkstation. Once t...

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 DB2Connect and your host or AS/400 database system. DB2 Connectcan locate and configure all TCP/IP and most SN...

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 tip. It provides additional information that can helpyou complete a task. For a complete description of the DB2 library, see “Appendix D. How the D...

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

Chapter 1. About DB2 Connect DB2 Connect Enterprise Edition DB2 Connect Enterprise Edition is a connectivity server thatconcentrates and manages connections from multiple desktop clientsand web applications to DB2 database servers running on host orAS/400 systems. IBM’s DB2 for AS/400, DB2 for OS/39...

Working with DB2 Data As well as providing a relational database to store your data, DB2 lets youissue requests to administer, query, update, insert, or delete data using local orremote client applications. Accessing Host or AS/400 DB2 Data Using DB2 Connect Personal Edition Direct connection withou...

Connections via Communications Gateway Some organizations prefer to concentrate access to SNA networks throughdedicated SNA Gateways, such as IBM eNetwork Communications Server,Microsoft SNA Server, or Novell Netware for SAA. DB2 Connect productssupport connections through gateways, so this can be a...

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 Clients. DB2 Connect Enterprise Edition can be installed on the DB2 forMVS DB2 forVSE DB2 forVM OS/390 AS/400 S/390, S/370 DB2 for AS/400 APPC TC...

same machine as IBM eNetwork Communications Server or Microsoft SNAServer, and in many cases it can provide a less expensive andbetter-performing solution. Contact your authorized IBM reseller for additional information about DB2Connect Enterprise Edition. Accessing Host or AS/400 DB2 Data from the ...

Java applets. In addition, you can use a wide range of off-the-shelf orcustom-developed database applications with DB2 Connect and its associatedtools. For example, you can use DB2 Connect products with: v Spreadsheets, such as Lotus 1-2-3 and Microsoft Excel, to analyze real-timedata without having...

DB2 Run-Time Client DB2 Administration Client DB2 forMVS DB2 forVSE DB2 forVM 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 for AS/400 Not all protocols are suppor ted ...

Accessing DB2 Data from the Web Using Java Java Database Connectivity (JDBC) and Embedded SQL for Java (SQLJ) areprovided with DB2 to allow you to create applications that access data in DB2databases from the Web. Programming languages containing embedded SQL are called host languages.Java differs f...

For more information on Java enablement, refer to the DB2 Java Enablementweb 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 ...

Managing Connections to Databases Using the Client Configuration Assistant The Client Configuration Assistant (CCA) helps you manage your databaseconnections to remote servers. The CCA is available on OS/2 and Windows32-bit operating systems. This is the preferred method to set up any OS/2,Windows 9...

Through a DB2 client, these applications can access all servers and, by usingthe DB2 Connect product (or the DB2 Connect functionality supplied withDB2 Enterprise - Extended or DB2 Enterprise Edition), they can also accessDB2 Universal Database for AS/400, DB2 Universal Database for OS/390, andDB2 f...

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

Chapter 2. Planning for Installation If you know that your system meets all the hardware and softwarerequirements, and you want to begin installing your DB2 product rightaway, go to “Chapter 4. Installing DB2 Connect on Windows 9x orWindows NT” on page 31 or “Chapter 3. Installing DB2 Connect onOS/2...

For information about space requirements for data, refer to the AdministrationGuide. Estimating Fixed Disk Requirements To estimate the disk requirements for a particular configuration, add therecommended minimum disk sizes for the products and components that youwant to install. Include an allowanc...

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 via an SNA gateway (see “Connections via CommunicationsGateway” on page 6). Product Requirements Table 2 lists the operating system and communications ...

Chapter 3. Installing DB2 Connect on OS/2 This section describes how to install DB2 Connect Personal Edition on anOS/2 workstation. For information on how to deploy this product using adistributed installation, refer to the Installation and Configuration Supplement. Before You Begin Before you begin...

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 command window and set the directory to yourCD-ROM drive by entering the following command: cd x: where x: represents your CD-ROM drive. Step 4. Ent...

For information on errors encountered during installation, see the l1.log and l2.log files. These files store general information and error messages resulting from installation and uninstall activities. Bydefault, these files are located in the x:\db2log directory; where x: represents the drive on w...

Chapter 4. Installing DB2 Connect on Windows 9x orWindows NT This section describes how to install DB2 Connect Personal Edition onWindows 32-bit operating systems. For information on how to deploy thisproduct using a distributed installation or set up a Thin Connect workstation,refer to the Installa...

__ 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 the Installation To install your DB2 product, perform the following steps: Step 1. Log on to the system with the user account that you created toperf...

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. Invoke the online help byclicking on the Help push button or pressing the F1 key at any time.You can click on the Cancel push button at any time to end ...

Chapter 5. Configuring Host and AS/400 Databases for DB2Connect This section describes the steps required to configure host and AS/400database servers to accept connections from DB2 Connect workstations. Thesesteps must be performed by users who have the necessary system privilegesand special expert...

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, but some also apply to users who will connect to DB2 UniversalDatabase for OS/390 via TCP/IP. For a summary of the example VTAM names used throughout...

Sample Network Element Names (VTAM) Figure 9 shows the sample VTAM definitions used to configure a hostdatabase server. Sample VTAM APPL Definition for OS/390 Figure 10 on page 42 shows the sample VTAM application major nodedefinitions. In most cases, such a definition will already exist with a diff...

Note: Continuations must begin in column 16, with continuation marks incolumn 72. Sample VTAM PU and LU Definitions for DB2 Connect If your security policies allow it, it is recommended that you enable DYNPU and DYNLU in VTAM to allow any PU and LU access through VTAM. Contact your VTAM administrato...

Sample VTAM Log Mode Definition for DB2 Figure 12 on page 44 shows the sample VTAM logon mode table definition forthe IBMRDB and SNASVCMG modes. Note that this example specifies a 4K RUSIZE, which may not be suitable for your environment (for example, if youare using Ethernet, which has a maximum Fr...

You 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/390Administrator must configure DB2 Universal Database for OS/390 to permitconnections from DB2 Connect workstations. This section...

The sections that follow contain examples of commands to update these tablesfor DB2 Universal Database for OS/390. Work with your DB2 Administratorto determine the updates required for your DB2 Universal Database forOS/390 system. For more information on the DB2 Universal Database forOS/390 Communic...

where: v NYX1 represents the PU name of server involved v IBMRDB represents the name of VTAM logon mode v 150 represents the maximum number of conversations v Y represents the number of sessions preallocated at startup. This can also beleft as N, or blank (the default) for deferred at startup. Confi...

Collecting Information Before you can use DB2 Connect over a TCP/IP connection, you must collectinformation about both the host database server and the DB2 Connectworkstation. For each host server that you are connecting to via TCP/IP, youmust have the following information: v The location of the TC...

Example Worksheet: Table 3. Example Worksheet for Planning TCP/IP Connections to DB2 UniversalDatabase for OS/390 Ref. Description Sample Value Your Value 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 Type db2390 „ ...

Configuring the TCP/IP Connection Use the manual steps in this section to complete the configuration and makethe connection. Complete the Worksheet: Complete a copy of the example worksheet for each TCP/IP host: 1. Fill in the values to be used for the TCP/IP address and hostname of theDB2 Universal...

v 1ST_CONN, the first database that a connection is established to will beused as the Transaction Manager database for transactions. If this option isused, then the first database connected to must be either a DB2 UniversalDatabase Version 5 or later database, or a DB2 Universal Database forOS/390 V...

CONNECT and BIND: Finally, connect to the target host server and bind the utilities and applications to the server using commands similar to thefollowing in the command line processor: connect to MVSIPDB1 user USERID using PASSWORD bind path/bnd/@ddcsmvs.lst blocking all sqlerror continue blocking a...

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 _ RCHA...

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 databases. v Manually entering database and communication protocol information for aserver. When you add a database using this configuration metho...

Adding a Database Using a Profile A profile contains information about instances and databases on a system, anddatabases within each instance. For information on profiles, see “Creating andUsing Profiles” on page 112. If your administrator provided you with a profile, perform the followingsteps: Ste...

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 filename for this file in the File datasource name field. d. Click on the Optimize for application drop down box and selectthe application for which y...

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 Discovery function times out. By default, the Discoveryfunction will search the network for 40 seconds; this may not belong enough to detect the remote...

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. Ensure that the Register this database for ODBC check box isselected. b. Select the radio button that describes how you would like toregister this data...

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 Directory Access Protocol (LDAP), thistab will not be shown, skip this step and go to Step 3. Step 2. Select the radio button that corresponds to the l...

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 bind that you want to perform: v Select the Bind DB2 utilities radio button if you want to bindutilities against the database v Select the Bind appli...

Chapter 7. Configuring APPC Communications on the DB2Connect Workstation This section describes how to configure a DB2 Connect workstation tocommunicate with a host or AS/400 database server using the APPCcommunication protocol. The instructions that follow assume that APPC issupported on the DB2 Co...

Note: The worksheet and configuration instructions supply suggested orsample values for required configuration parameters. For otherparameters, use the communications program’s default values. If yournetwork configuration is different from that used in the instructions,consult your Network Administr...

Table 5. Worksheet for Planning Host and AS/400 Server Connections (continued) Ref. Name at the DB2ConnectWorkstation Network or VTAMName Sample Value Your Value „ 13 … Local Node or NodeID ID BLK 071 „ 14 … ID NUM 27509 „ 15 … Mode name IBMRDB „ 16 … SymbolicDestination name DB2CPIC „ 17 … (Remote)...

4. For database name ( „ 5 … ), determine the name of the host database. This is the LOCATION NAME for OS/390 or MVS, the RDB_NAME for VM orVSE, or a relational database name for AS/400. 5. For mode name ( „ 6 … and „ 15 … ), usually the default IBMDRB is sufficient. 6. For remote network address ( ...

window. To configure IBM eNetwork Personal Server for APPC communications,complete the perform the following steps: Step 1. Configure Node a. In the Configuration options field, select Configure Node, thenclick on the New push button. The Define the Node windowappears. b. In the Fully qualified CP n...

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 appropriate DLC is highlighted.For example, LAN. c. Click on the New push button. The appropriate window appearswith default values displayed. For example,...

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 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...

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 the CommunicationsServer for Windows NT server a. Click on the Start button and select Programs->AdministrativeTools (Common)->User Manager ....

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 Information a. In the Configuration options box, select the Configure CPI-C sideinformation option and click on the New push button. The Define CPI-C side information window opens. b...

similar to that of the Windows NT Explorer. The following illustration showsthe interface. There are two panes in the main window of the Server Manager.All the configuration options we will be using can be accessed byright-clicking on objects in the left-hand pane of the window. Every object hasa co...

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 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 Commu...

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 … ) in the Name field. c. Click on the Link Service drop-down box and select the SnaDlc1option. d. Select the Remote End radio button from the...

d. Enter appropriate numbers for the Parallel Session Limit andMinimum Contention Winner Limit fields. Your Host-Side or LAN administrator should be able to supply you with thenumbers if you do not know the limits you should place here. e. Accept the other defaults, and click on OK. Step 8. Define t...

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...

Configuring Microsoft SNA Client Read this section if you have a Windows NT workstation that has DB2Connect installed. This section provides step-by-step instructions for settingup the communications between your DB2 Connect workstation and aWindows NT workstation that has Microsoft SNA Server V4.0 ...

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 and DRDA. Referto the Microsoft SNA Server documentation for further information. DB2 forMVS DB2 forVSE DB2 forVM OS/390 AS/400 S/390, S/370 DB2 for...

2. Microsoft SNA Client Version 2.11 is not already installed on your DB2Connect workstation. To configure the Microsoft SNA client perform the following steps: Step 1. Obtain Required Information For your Microsoft SNA client software to function properly you must haveaccess to a properly configure...

__ 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 … ). You now need to update the DB2 directories, bind utilities and applications to theserver, and test the...

program name ( „ 17 … ), the mode ( „ 15 … ), and the security type. Enter the following commands substituting your values from the worksheet in Table 5 on page 68: catalog "appn node db2node network SPIFNET remote NYM2DB2 tpname QCNTEDDM mode IBMRDB security PROGRAM" terminate Note: To conn...

database name (database_name). The information in the database directory,along with the information in the node directory, is used on the DB2 Connectworkstation to establish a connection to the remote database. To catalog a database on the DB2 Connect Workstation, perform the followingsteps. Step 1....

If you need to change values that were set with the catalog databasecommand, 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 D...

TP Monitor multisite update can coordinate a transaction that accesses bothDB2 and non-DB2 resource 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 participatingin a distrib...

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 ″ using the search keywords ″ DDCS ″ , ″ SPM ″ , ″ MTS ″ , ″ CICS ″ , and ″ ENCINA ″ . Enabling Multisite Updates Using the Control Center As o...

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

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 databases by clicking on the Add push button or exit theCCA. Adding a Database Manually If you have the protocol information for the server that you want to...

have incorrectly specified or click on the Help push button for moreinformation. For even more detailed information, refer to theTroubleshooting Guide. Step 8. Enter your user ID and password and click on OK. If the connectionis successful, a message confirming the connection appears. Step 9. You ar...

have the discover_inst database manager configuration parameter anddatabases with the discover_db database configuration parameter set toENABLE. The discover parameter in the Administration Server’s configurationfile must be set to either SEARCH or KNOWN to generate a profile for aserver system. The...

A Client Profile is generated from a client using the Export function of theCCA. The information contained in a Client Profile is determined during theexport process. Depending on the settings chosen, it can contain the existingclient’s: v Database connection information (including CLI or ODBC setti...

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. To import a Client Profile, perform the following steps: Step 1. Start the CCA. For more information, see “Starti...

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

Chapter 10. Running Your Own Applications Various types of applications can access DB2 databases: v Applications developed using the DB2 Software Developer’s Kit thatinclude embedded SQL, APIs, stored procedures, user-defined functions orcalls to the DB2 CLI. v ODBC applications such as Lotus Approa...

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 systems and sqllib for OS/2, and Windows 32-bit operating systems). Each file is specific to a server. Binding to Host Databases To bind the utiliti...

"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 topublic. Step 4. Reset the connection to the database by en...

Platform Specific Details for CLI/ODBC Access The platform specific details on how to give DB2 CLI and ODBCapplications access to DB2 are divided into the following categories: v “Windows 32-bit operating systems Client Access to DB2 usingCLI/ODBC” v “OS/2 Client Access to DB2 using CLI/ODBC” on pag...

OS/2 Client Access to DB2 using CLI/ODBC Before DB2 CLI and ODBC applications can successfully access a DB2database from an OS/2 client, perform the following steps on the clientsystem: 1. The DB2 database (and node if the database is remote) must be cataloged.To do so, use the CCA (or the command l...

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) 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 yo...

Running Java Programs You can develop Java programs to access DB2 databases with the appropriateJava Development Kit (JDK) on AIX, HP-UX, Linux, OS/2, Silicon GraphicsIRIX, Solaris, or Windows 32-bit operating systems. The JDK includes JavaDatabase Connectivity (JDBC), a dynamic SQL API for Java. Fo...

Configuring the Environment To build and run DB2 Java programs, you need to install and configure theappropriate version of the Java Development Kit (JDK) on your developmentmachine: AIX: The Java Development Kit (JDK) Version 1.1.2 for AIX from IBM. HP-UX: The HP-UX Developer’s Kit for Java Release...

You 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 thesecommands, refer to the Command Reference. On Solaris, some Java Virtual Machine implementations do not workwell in programs that run in a ″ setuid...

java prog_name where 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 communicate the requests to the server and receive theresults. An SQLJ application must be bound to the database before it is run. Java Applets Becau...

Appendix A. Basic Task Knowledge This section describes the basic tasks that you will need to know to use thisproduct effectively. Go to the task that you want to perform: v “Starting the Software Registration Tool”. v “Starting the Client Configuration Assistant”. v “Starting the Control Center” on...

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 Warp button and select DB2 for OS/2–>ControlCenter . Note: You must have the prerequisite Java Runtime Environment(JRE) level to launch t...

v Display all the command scripts known to the system through the ScriptCenter, 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 t...

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 you want to store commonly used SQL statements or DB2commands as scripts, click on the Script Center icon from the maintool bar. For more information, ...

If the DB2 command contains characters that have special meaningon the operating system you are using, you will need to enter thecommand in quotation marks to ensure that it is run properly. For example, the following command would retrieve all theinformation from the employee table, even if the * c...

db2 => select empno, function, firstname, lastname, birthdate, from \ db2 (cont.) => employee where function='service' and \ db2 (cont.) => firstname='Lily' order by empno desc To end interactive input mode, enter the quit command. For more information on advanced topics using the CLP, refe...

Appendix C. db2cpic.dll - Extended SNA Security Codes onWindows NT and Windows 95 Extended SNA Security Codes were not implemented by some SNAsubsystem providers. This may affect customers using one or more of thefollowing: v DB2 Universal Database (UDB) for Windows NT Version 5 (all editions). v DB...

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 theinformation that is provided, and how to access it. To access product information online, you can use the Informat...

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 withthe right mouse button on theTables icon and select Create ->Table using SmartGuide. Create Table Space Create a new table space. From the Co...

DB2 Information – Hardcopy and Online The table in this section lists the DB2 books. They are divided into twogroups: Cross-platform books These books contain the common DB2 information for allplatforms. Platform-specific books These books are for DB2 on a specific platform. For example,there are se...

Name Description Form Number File Name forOnline Book HTMLDirectory What’s New Describes the new features, functions,and enhancements in DB2 UniversalDatabase, Version 6.0, includinginformation about Java-based tools. SC09-2851 db2q0x60 db2q0 Platform-Specific Books Administering SatellitesGuide and...

Name Description Form Number File Name forOnline Book HTMLDirectory Cross-Platform Sample Programs in HTML Sample programs inHTML Provides the sample programs in HTMLformat for the programming languageson all platforms supported by DB2 forinformational purposes (not all samplesare available in all l...

Swedish s Trad. Chinese t Turkish 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 – /op...

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 using, the icon is in the main product folder or theWindows Start menu. To view online books or sample programs on the SCO UnixWare 7: v DB2 Universa...

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 Center launches aviewer to display the information. The viewer might be the system helpviewer, an editor, or a Web browser, depending on the kind of inf...

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. Ensure that your default printer is a PostScript printer capable of printingLevel 1 (or equivalent) files. 4. Enter the following command from ...

Appendix E. National Language Support (NLS) This section contains information about configuring national language supportfor the DB2 Connect product, and includes information on: v Which languages are supported by DB2 Connect Enterprise Edition andDB2 Connect Personal Edition. v How DB2 Connect hand...

Table 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 Turkish tw Traditional Chinese (Taiwan) ...

FOR BIT DATA clause) is not converted. Otherwise all input and outputcharacter data is converted if the two machines have different code pages orCCSIDs. For example, if DB2 Connect is used to access DB2 Universal Database forOS/390 or DB2/MVS data, the following happens: 1. DB2 Connect sends an SQL ...

Table 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 Taiwan 933, 1364 949, 970, 1363 Korea 935, 1388 1381, 1383, 1386 People’s Republic of China 1112, 1122 921, ...

Since defaults on different platforms are not the same, problems appear whenDB2 data is sent from one platform to another. For example, Windowsplatforms use LOGICAL UNSHAPED data, while data on OS/390 is usuallyin SHAPED VISUAL format. Therefore, without any support for theseattributes data sent fro...

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

Appendix F. Naming Rules Go to the section that describes the naming rules that you requireinformation 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” onpage 167 v “Pas...

Database alias names are synonyms given to remote databases. Database aliasesmust be unique within the System Database Directory in which all aliases arestored. When naming a database or database alias, see “General Naming Rules” onpage 165. In addition, the name you specify can only contain 1 to 8 ...

Using delimited identifiers, it is possible to create an object thatviolates these naming rules; however, subsequent use of the objectcould result in errors. For example, if you create a column with a + or − sign included inthe name and you subsequently use that column in an index, youwill experienc...

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 theDB2SYSTEM name during install. On Windows 3...

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 eachbind file is also listed: DRDA Server List File OS/390 a...

Contacting IBM This section lists ways you can get more information from IBM. If you have a technical problem, please take the time to review and carry outthe actions suggested by the Troubleshooting Guide before contacting DB2Customer Support. Depending on the nature of your problem or concern, thi...

Log on as anonymous. In the directory /ps/products/db2, you can finddemos, fixes, information, and tools concerning DB2 and many relatedproducts. Internet Newsgroups comp.databases.ibm-db2, bit.listserv.db2-l These newsgroups are available for users to discuss their experiences withDB2 products. Com...

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