IBM(R) DB2(R) Table Editor for Multiplatforms, Version 4 Release 3 Fix Pack 15 README CONTENTS 1.0 ABOUT THIS README FILE 1.1 Evaluation code 1.2 Corrected Known Problems 1.3 Enhancements 2.0 PREREQUISITES 2.1 Hardware Requirements 2.2 Software Requirements 3.0 INSTALLATION INSTRUCTIONS 3.1 Updates to Shared Dynamic Link Libraries 3.2 Configuration for Unattended Installation 3.3 Installing the DB2 Table Editor Control Center Plug-in 4.0 CONFIGURATION INSTRUCTIONS 5.0 RESTRICTIONS 6.0 CORRECTIONS TO DOCUMENTATION 7.0 HOW TO GET HELP 8.0 NOTICES 8.1 Other notices 8.2 Use of evaluation program 8.3 Trademarks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 Table Editor, Version 4 Release 3, Fix Pack 15 that contains the latest fixes for DB2 Table Editor V4.3. This README file contains information about installing IBM DB2 Table Editor. This Fix Pack is a complete replacement of the product without the License Use Management (LUM) key. IBM DB2 Table Editor has been tested and validated with all supported releases of DB2 for Linux, UNIX and Windows through Version 9 Release 7 modification 14 and DB2 for os/390 and z/OS PDO0409. Subsequent releases might require additional maintenance. In this README file, the following naming convention applies: IBM DB2 Table Editor for Multiplatforms is abbreviated to DB2 Table Editor. 1.1 Evaluation code If you are using evaluation code, the evaluation code enables you to try this product for a period of 60 days. After 60-days, you must purchase a license to continue to use the product. When you purchase the product, the license is enforced based upon the platform to which you are connecting using IBM DB2 Table Editor. For more information on Licensing, see "Licensing" in the DB2 Table Editor User's Guide. Read the NOTICES Section 8.2, USE OF EVALUATION PROGRAM, and the License Agreement provided with your evaluation copy of the program. 1.2 Corrected Known Problems This fix pack contains the following corrections: - you can now INSERT and UPDATE DB2 Version 9 XML data using the Java Player component as an applet. - You can now open forms containing list controls in the Java Player component without receiving an error message. - You can now insert data into a CHARBIT column using a form in the Java Player component. - When editing a table using a form in the Windows User component the Next Row button is no longer disabled after a deletion is cancelled. - You can now successfully connect to Informix from two instances of the DB2 Table Editor applet running on the same computer. 1.3 Enhancements - JDBC Type 4 Driver: You can now connect to your database server using the DB2 Type 4 driver. This means that you can use DB2 Table Editor while only having the DB2 Universal JDBC type 4 driver installed, there is no dependency on DB2 libraries. - Business Time: You can now: - Omit Business time columns from tables when you view or edit them - Easily modify the Business Time parameters using the Edit Table Wizard - Specify that only data matching a specified date or timestamp be displayed when editing or viewing a table 2.0 PREREQUISITES 2.1 Hardware Requirements Hardware requirements are those needed to run the Windows software as described in 2.2 Software Requirements. DB2 Table Editor has the following requirements: - Approximately 16 MB of free disk space on a Windows machine - A minimum of 32 MB memory. Additional memory improves performance. 2.2 Software requirements for DB2 Table Editor on Multiplatforms DB2 Table Editor runs on the following operating systems: * Microsoft Windows 2000 * Microsoft Windows 2003 * Microsoft Windows XP * Microsoft Windows Vista * Microsoft Windows 7 DB2 Table Editor supports the following database levels: * Informix Version 9.4, Version 10, and Version 11 Restriction: 64 bit versions of Informix are supported only when working with the Java Player component. * DB2 for Linux, UNIX and Windows Version 9 or DB2 Universal Database Version 8 Requirement: If you are working with DB2 Universal Database Version 8, you must have Java 2 installed and configured on your machine. * DB2 for z/OS Version 8, Version 9 and DB2 10. In order to run the DB2 Table Editor Java player in a browser, you must ensure that you are running Java JRE version 1.4 or higher. When working with DB2 Table Editor Java player ensure that you are using a browser enabled for Java 1.4. DB2 Table Editor has been tested with Microsoft Internet Explorer V 5.0 and higher. Requirements when working with DB2 Version 8: * In order to work with DB2 Version 8 data on z/OS, you must use the JDBC driver that is packaged with DB2 Version 8 Fix Pack 2 or higher. 3.0 INSTALLATION INSTRUCTIONS To install DB2 Table Editor: 1. Download the Fix Pack from the Web: http://www.ibm.com/software/data/db2imstools/support/fixpaks.html Download the file to a temporary directory on the system where the DB2 Table Editor is installed. 2. Browse to the Disk1 directory and double-click setup.exe. The DB2 Table Editor install starts. 3. Follow the steps in the DB2 Table Editor Install wizard. For specific information on items in the install wizard, click the Help button to access the online help. 4. When the installation is complete, start the DB2 Table Editor Console and create a server definition file for each server that you want to access using DB2 Table Editor. For more information on creating a server definition file, see the DB2 Table Editor User's Guide. Note: You must set up server definition files for the servers that you want to access using DB2 Table Editor before you can access these servers using DB2 Table Editor Developer, Windows User, or Java Player. Use the DB2 Table Editor Console to set up server definition files. 5. Bind the DB2 Table Editor packages. 3.1 UPDATES TO SHARED DYNAMIC LINK LIBRARIES DB2 Table Editor installs the Visual C Runtime library (MSVCRT.DLL v4.21.7303) and Microsoft(R) Foundation Classes library (MFC42.DLL v5.00.7303) to the Windows(R) System directory. 3.2 CONFIGURATION FOR UNATTENDED INSTALLATION An unattended installation allows you to select the installation options for your DB2 Table Editor users before beginning the installation process. By using this method, you can designate all of the options for multiple installations rather than having to select the same options repeatedly for each individual installation. Use the following steps to enable unattended installation. STEP ONE - Edit setup.ini Using a text editor such as Notepad, edit setup.ini. This file, on Disk 1 of the installation diskettes, controls the installation process and determines the settings used for the installation. The settings you can control are described below. Specify the settings that you want in setup.ini. _____________________________________________________________________________ [Options] Setting Effect AutoInstall= 0,1 Specify 1 to perform an unattended installation. All other settings in setup.ini are ignored if this setting is not 1. FileServerInstall= 0,1 Specifies whether DB2 Table Editor is already installed on a file server. If the settings is 0, all DB2 Table Editor files are installed to the directory specified in the InstallPath variable. If the settings is 1, DB2 Table Editor must be previously installed into the directory specified in the InstallPath variable. To enable a file server installation, you also must set SetupType=2. SetupType= 0,1,2 Specifies the type of installation to perform. 0 indicates a typical installation, 1 indicates a compact installation, 2 indicates a custom installation. If you select 2, you must indicate which components to install. Note: Option 2, the custom installation, is strongly recommended. Most users do not require the Console or Developer. InstallPath= Specifies the directory to receive the DB2 Table Editor installation (if FileServerInstall=0) or the file server directory that already contains the installation (if FileServerInstall=1). ProgramGroup= Specifies the name of the program group to create (under Program Manager) or the program folder to create (for the Windows 2000 and Windows XP) Start menu. _____________________________________________________________________________ [Components] Setting Effect Admin 0,1 Specifies whether to install DB2 Table Editor Console. If FileServerInstall=1, files are not copied to the local machine, but program group icons are still created. Always set this option to 0 for user installations. Developer 0,1 Specifies whether to install DB2 Table Editor Developer. If FileServerInstall=1, files are not copied to the local machine, but program group icons are still created. Always set this option to 0 for user installations. _____________________________________________________________________________ Setup.ini example This setup.ini file specifies an unattended installation. A typical installation is performed, copying files to the C:\Programs\DB2 Table Editor directory, and creating a program group or program folder named DB2 Table Editor. [Options] AutoInstall=1 FileServerInstall=0 SetupType=0 InstallPath=C:\Programs\DB2 Table Editor ProgramGroup=DB2 Table Editor STEP TWO - Save setup.ini After you edit and save setup.ini, copy it to Disk 1 of the DB2 Table Editor installation diskettes. STEP THREE - Run DB2 Table Editor Setup Run the installation from the source diskettes or server. The installation proceeds automatically. 3.3 INSTALLING THE DB2 TABLE EDITOR CONTROL CENTER PLUG-IN The DB2 Table Editor Control Center Plug-in is an extension to the DB2 Control Center. For more information about the Control Center, refer to the IBM DB2 Administration Guide. The DB2 Table Editor Control Center plug-in adds DB2 Table Editor menu items to the table pop-up menu and adds a tool bar button to start DB2 Table Editor as an add-in tool from the DB2 for Linux, UNIX and Windows Control Center. 1. Copy the following files and directories to the SQLLIB\tools: db2forms.jar * One or more of the following license files: - dbehost.lic - dbework.lic - dbehost.ecf (if you are working with a trial version of DB2 Table Editor) You must copy the license file that corresponds to the platform on which the DB2 database to which you want to connect resides. * HtmlHelp Directory (Including all sub folders) By default this directory is SQLLIB\tools. The DB2 Control Center requires that these files be located in the Java™ classpath so that they can be loaded when the Control Center is started. 2. Copy db2plug.zip, into SQLLIB\tools directory. Note: If there is already another version of db2plug.zip in SQLLIB\tools, you must combine the contents of the existing db2plug.zip and the version of the file that is supplied with this release of DB2 Table Editor. For Example, if you are using the Zip utility, use the following command: zip -r0 db2plug.zip com\rocketsoftware\ccplugin\*.* Where the plug-in package name is: com.rocketsoftware.ccplugin 3. If you are running the Control Center as a Java applet, complete the following steps: a. Copy the db2forms.jar and db2jcc.jar file where the tag points to in db2cc.htm. b. Update db2cc.htm to include db2plug.zip, db2jcc.jar, and "db2forms.jar" in the archive list. You can now start Table Editor from within Control Center by selecting a DB2 Table Editor menu item from the Table pop-up menu or the new toolbar button. 4.0 CONFIGURATION INSTRUCTIONS For complete instructions on how to customize and use DB2 Table Editor, refer to DB2 Table Editor for Multiplatforms User's Guide. If you received your copy of DB2 Table Editor electronically, locate the User's Guide here: http://www.ibm.com/software/data/db2imstools/library.html If you are installing this image from a CD-ROM, the documentation is located in /doc directory. The User's Guide on the Web can contain updates to the publication on CD-ROM. 5.0 RESTRICTIONS The following are the restrictions to the DB2 Table Editor functionality in Version 4.3 Fix Pack 15: - When the Table Editor catalog is defined to use long names and you are using a CLI connection, you cannot save forms at a server. - When working with Informix, if columns in your table are defined as CLOB and BLOB only insert and delete functionality are available due a limitation of Informix ODBC driver. However, if columns in your table are defined as TEXT and BYTE, all functionality is available. - When you are working with Universal JDBC driver and DB2 V 9.5, you must use V 3.4.65 of the Universal JDBC driver (V 3.4.65 is packaged with DB2 v9.1) when running the Table Editor java applet component. - When you are working with the Java player, ensure that you are using the JDBC driver that was shipped with DB2 Version 8, Fix Pack 13. DB2 APAR JR24973 has been opened to address this restriction. - If you specify CCSID "37 (U.S. English EBCDIC)" in the ANSI Client CCSID field in the DB2 Table Editor Console component when checking for the existence of DB2 Table Editor packages, you will get the following error: "SQL error with SQL code = +100 and SQL state = 02000" Use the default, CCSID 1252 instead. - When you are connecting to an Informix database server using the Java applet, the Informix server must be on the same machine as your Web server. - When a DB2 error message is generated, the following error message is displayed in place of the correct error message: "CCSID-0" DB2 PTF UQ86495 has been created to resolve this problem. - When working with any ODBC data source, primary keys and cascade updates and deletes are not supported. - When using a scalar FULLSELECT SQL statement in Table Editor Developer, you may encounter a -204 error message. This error will not affect the output from the SQL statement. - When using the DB2 Table Editor Java player component, very long table, creator, and column names may be truncated. - Long names are only supported when connecting to a DB2 V8 or later database when no earlier version of DB2 Table Editor and no version of QMF are being used to access the database. - In order to run the DB2 Table Editor Java Player against a DB2 V8 database, you must use Java 2. - When working with Informix databases, table locking is not available. - LOBs cannot be inserted when you are using a shared or an exclusive lock. - When accessing the DB2 Table Editor functionality through DB2 Web Query, on AIX, you can only update a primary key once per DB2 Web Query session. - When working with Informix databases, only CHARACTER data can be inserted into FOR bit data, LONGVARCHAR columns. - LOB controls are not available when connecting to an Informix server, when using the DB2 Table Editor Java player, or when using the DB2 Table Editor Control Center Plug-in. - Binary data cannot be read when reading data from an Informix server. Text files are supported. - In Java implementations of DB2 Table Editor (as an applet), the applet will hang if you attempt to open multiple applets at once if J2SDK 1.4.0 is installed. If you are using Microsoft Internet Explorer with the SUN Java JVM V1.4, you must upgrade to V 1.4.1_02. - If you have thousands separator and you use the 'Find' command you need to check 'match whole word only box' in order to find what you are searching for. - In order to insert 100 or more rows at a time you must change the following value in your Server Definition (SDF) file. NumDynamicSectionsForCall=100 NumDynamicSectionsWithHold=100 NumDynamicSectionsWithoutHold=100 In the example above the value of 100 indicates the number of rows that can be inserted at a time. Change this number to the number of rows that you want to insert. The maximum allowable value here is 999. - In the DB2 Table Editor Console, all creator names must be 8 characters or shorter - When calling a stored procedure the data type of the values that are passed in must match the data type of the input and output parameters of the stored procedure. - Cascading deletes can only be performed on Informix databases that have logging enabled. - When updating an Informix table using DB2 Table Editor, when inserting or updating values the Informix database only accepts the value based on the length of the field as defined in the table. If a value is entered in Table Editor that is longer than the length as defined in the database, the value will be truncated when the table is updated. - Running Informix stored procedures when using output parameters is not supported. 6 .0 CORRECTIONS TO DOCUMENTATION To obtain the latest refresh of DB2 Table Editor publications refer to: http://www.ibm.com/software/data/db2imstools/library.html 7.0 HOW TO GET HELP For a complete and up-to-date source of DB2 Table Editor information, including information on issues discovered after this readme was published, go to the following Website: DB2 Table Editor Online Support: http://www.ibm.com/software/data/db2imstools/support.html If you are not able to find your answer searching the listed URL, call 1-800-IBM-SERV to speak to an IBM representative for assistance. 8.0 NOTICES This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A. For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to: Intellectual Property Licensing Legal and Intellectual Property Law IBM Japan Ltd. 1623-14, Shimotsuruma, Yamato-shi, Kanagawa 242-8502 Japan The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice. Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk. IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you. Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact: IBM Corporation J46A/G4 555 Bailey Avenue San Jose, CA 95141-1003 U.S.A. Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee. The licensed program described in this information and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us. Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment. Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only. All IBM prices shown are IBM's suggested retail prices, are current and are subject to change without notice. Dealer prices may vary. This information is for planning purposes only. The information herein is subject to change before the products described become available. This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental. COPYRIGHT LICENSE: This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. You may copy, modify, and distribute these sample programs in any form without payment to IBM for the purposes of developing, using, marketing, or distributing application programs conforming to IBM's application programming interfaces. Each copy or any portion of these sample programs or any derivative work, must include a copyright notice as follows: © (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs. © Copyright IBM Corp. _enter the year or years_. All rights reserved. If you are viewing this information softcopy, the photographs and color illustrations may not appear. 8.1 Other Notices XMLParser.Java, AELfred, Version 1.1: AElfred Version 1.1 Microstar's Java-Based XML Parser Copyright (c) 1997, 1998 by Microstar Software Ltd. Home page: http://www.microstar.com/XML/ Licensing Terms: “AElfred is free for both commercial and non-commercial use and redistribution, provided that Microstar's copyright and disclaimer are retained intact. You are free to modify AElfred for your own use and to redistribute AElfred with your modifications, provided that the modifications are clearly documented.” Disclaimer: “This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of merchantability or fitness for a particular purpose. Please use it AT YOUR OWN RISK.” WFC XMLParser: “I'm just a simple little NT programmer. Most of the work I do is remote controlling equipment in real time. I started out using Windows 3.0. Then came Windows 3,1 and then NT. I started using NT but unfortunately, Microsoft didn't. I started using MFC but unfortunately, Microsoft didn't (and still doesn't) put any real support for NT into MFC so I wrote a bunch of C++ classes to make my life easier. Like all class libraries, mine grew. Now I'm giving it away. I call it Win32 Foundation Classes.” 8.2 Use of evaluation program If you are using an evaluation copy of the program, the following terms apply: This program contains a disabling device that will prevent it from being used upon expiration of this license. You will not tamper with this disabling device or program. You should take precautions to avoid any loss of data that might result when the program can no longer be used. See the License Agreement for a complete explanation of the terms that apply. 8.3 Trademarks IBM, the IBM logo, and ibm.com® are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. These and other IBM trademarked terms are marked on their first occurrence in this information with the appropriate symbol (® or ™), indicating US registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A complete and current list of IBM trademarks is available on the Web at http://www.ibm.com/legal/copytrade.shtml. Adobe®, Acrobat, PostScript® and all Adobe-based trademarks are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States, other countries, or both. Linux is a trademark of Linus Torvalds in the United States, other countries, or both. Microsoft, Windows, and the Windows logo are trademarks of Microsoft Corporation in the Unites States, other countries, or both. UNIX is a registered trademark of The Open Group in the United States and other countries. Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates. Other company, product, and service names may be trademarks or service marks of others.