IBM Corporation July 2001 README for IBM(R) DB2 Intelligent Miner(TM) Scoring V7.1 Fixpack 1 CONTENTS 1.0 ABOUT THIS README FILE 2.0 CONTENTS OF THIS FIXPACK 3.0 INSTALLATION AND SETUP 3.1 Prerequisites 3.2 Installing IBM DB2 Intelligent Miner Scoring Fixpack 1 on Windows 4.0 MIGRATING FROM INTELLIGENT MINER SCORING V7.1 4.1 Required updates on DB2 systems 4.2 Required updates on ORACLE systems 5.0 NEW AND CHANGED TYPES AND FUNCTIONS for ORACLE 6.0 DEINSTALLATION OF THIS FIXPACK 7.0 NOTICES 7.1 Trademarks 7.2 Copyright statements 1.0 ABOUT THIS README FILE This Fixpack contains fixes that apply to the IBM DB2 Intelligent Miner Scoring Version 7.1. To install this Fixpack, see below the section INSTALLATION AND SETUP. 2. CONTENTS OF THIS FIXPACK The following problems are fixed: - Memory leaks in Windows kernels - Apply function on common tables are executed twice - Neural kernel crashed sometimes - Frequencies of over 1 million - Error in script banking.apply2V7 - Tree Classification problem with non binary PMML 1.1 models - Improved ORACLE support (enhanced performance, known memory leaks) The following files are automatically installed during the installation procedure: Common to all components: Files Target directory ------------------------------------ idmacx.dll bin idmbsx.dll bin idmxtree.exe bin idmxdclu.exe bin readmeFP1.txt DB2 component: Files Target directory ------------------------------------ idmapplyupdt.db2 bin idmapplyupdtF.db2 bin idmclf.db2 bin idmclf.dll bin idmclfF.db2 bin idmclu.db2 bin idmclu.dll bin idmcluF.db2 bin idmrec.dll bin idmreg.db2 bin idmreg.dll bin idmregF.db2 bin banking.apply2V7 sample\udf ORACLE component: Files Target directory ------------------------------------ idm_package.sql bin idm_setup.bat bin idm_setup.sql bin idm_setvars.sql bin idm_uninstall.sql bin idmoclf.dll bin idmoclu.dll bin idmorec.dll bin idmoreg.dll bin PMML Feature component: Files Target directory ------------------------------------ (only common files) IM4D component: Files Target directory ------------------------------------ idmxtree.exe \bin idmxdclu.exe \bin 3.0 INSTALLATION AND SETUP 3.1 Prerequisites You must have successfully installed the IBM DB2 Intelligent Miner Scoring V7.1 or the PMML feature. 3.2 Installing IBM DB2 Intelligent Miner Scoring Fixpack 1 on Windows To install the Fixpack on Windows, follow these steps: - Be sure that all IM Scoring runs are finished. - Copy the PTF_IP22297.exe file to IM Scoring installation path. - Execute the file PTF_IP22297.exe. - Follow the instructions that are displayed. ------------------------------------------------------------------ Warning: If you want to install additional components of the IBM DB2 Intelligent Miner Scoring at a later point of time, make sure to reinstall all PTF packages. If you do not reinstall PTFs, the IBM DB2 Intelligent Miner Scoring might become unusable because you had a mixture of old and fixed files. ------------------------------------------------------------------ 4.0 MIGRATING FROM IM SCORING V7.1 4.1 Required updates on DB2 systems After installing this PTF, you must do the following changes in databases that are already enabled for DB2 IM Scoring: Do the following steps as a user with DBADM or SYSADM authority: For unfenced enabled databases: - Change to the bin directory of your DB2 IM Scoring installation, for example, c:\Program Files\IBM\IMinerSc\bin for Windows - Connect to the database with db2 connect to - Execute the idmapplyupdt.db2 script with db2 -tf idmapplyupdt.db2 For fenced enabled databases: - Change to the bin directory of your DB2 IM Scoring installation, for example, c:\Program Files\IBM\IMinerSc\bin for Windows - Connect to the database with db2 connect to - Execute the idmapplyupdtF.db2 script with db2 -tf idmapplyupdtF.db2 The scripts drop all DM_apply* UDFs from your database and recreate them. Instead of the keyword NO EXTERNAL ACTION, the keyword EXTERNAL ACTION is used. If you call the DM_apply* UDFs in a common table expression and use more than one result function (for example, DM_getClusterId and DM_getClusterScore) to get the result values from the temporary table created by the common table expression, the DM_apply* UDF is called only once per record. With the original keyword NO EXTERNAL ACTION, the DM_apply* UDF was called many times per record dependent on the number of result functions used. If you want to enable new databases, see the following manual after you have installed the PTF: IBM Intelligent Miner Scoring Administration and Programming for DB2 Do not use the idmapplyupdt.db2 or the idmapplyupdtF.db2 script. 4.2 Required updates on ORACLE systems After installing this PTF, you must execute the script idm_setup.bat in databases that are already enabled for the IBM DB2 IM Scoring. For further information, see this manual: IBM Intelligent Miner Scoring Administration and Programming for Oracle8i Refer to the following sections in Chapter 2, Installing IM Scoring: - Configuring the system environment on Windows systems - Enabling a database for IM Scoring Note: Trace environment variables are reset when calling idm_setup.sql. 5.0 NEW AND CHANGED TYPES AND FUNCTIONS for ORACLE The source data type for DM_ApplicationData was changed from CLOB to VARCHAR2. Because VARCHAR2 strings in PL/SQL functions are limited to a length of 4k, the XML string that is returned by DM_impApplData must be shorter than 4k. The following function is new: DM_impApplDataLarge( applData_as_DM_ApplRow ) This function works like DM_impApplData (see the documentation), however, it does not have the restriction that the returned XML string cannot be longer than 4k. This function works slower than DM_impApplData, and it consumes much additional space in the Oracle datafiles. So, before you use DM_impApplDataLarge, consider to assemble your SQL statement in the following way (which is recommended if the XML string does not exceed 32k): Because of performance reasons, the DM_applyXXXModel functions were extended to directly accept the parameter that is passed to DM_impApplData normally. So you can optionally omit DM_impApplData. For example: Old: DM_applyClusModel(model, DM_impApplData( ... ) ) New: DM_applyClusModel(model, ... ) You should use the DM_applyXXXModel functions in this way as long as the internally constructed XML string is shorter than 32k (which is the string length limit of the PL/SQL engine). Use DM_impApplDataLarge only if you get the error ORA-06502: PL/SQL: numeric or value error: character string buffer too small which indicates that the 32k limit has been reached. You should follow these rules: - Directly pass the input data to DM_applyXXXModel - In the rare cases (your model has several hundred fields) where you get the above error, use DM_impApplDataLarge - There is no need to use DM_impApplData any more. 6.0 DEINSTALLATION OF THIS FIXPACK IMPORTANT: BE AWARE THAT THE DEINSTALLATION OF THIS FIXPACK REMOVES THE FILES LISTED IN CHAPTER 2.0, CONTENTS OF THIS FIXPACK. This means that the installation of the following products is not complete and does not work. - IBM DB2 IM Scoring V7.1 - IBM DB2 IM Scoring V7.1 - PMML Feature - IBM DB2 Intelligent Miner for Data V6.1 If you want to go back to Fixpack Level 0, you must follow these steps: - Deinstall IBM DB2 IM Scoring V7.1 Fixpack 1 (this Fixpack) - Deinstall IBM DB2 IM Scoring V7.1 or PMML Feature or IBM DB2 Intelligent Miner for Data - Install IBM DB2 IM Scoring V7.1 or PMML Feature or IBM DB2 Intelligent Miner for Data from the original CD 7.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: IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106, 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. 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 Deutschland Informationssysteme GmbH Department 3982 Pascalstrasse 100 70569 Stuttgart Germany 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 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 measurement 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 IBMs future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only. All IBM prices shown are IBMs 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 illustrates 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. 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. 7.1 Trademarks The following terms are trademarks of the IBM Corporation in the United States, other countries, or both: AIX DB2 DB2 Universal Database IBM Intelligent Miner IM Scoring PMML Feature SP2 Oracle8i is a trademark of Oracle Corporation in the United States, other countries, or both. Lotus and WordPro are trademarks of Lotus Development Corporation in the United States, other countries, or both. AFS and DFS are trademarks of Transarc Corporation in the United States, other countries, or both. ActionMedia, LANDesk, MMX, Pentium and ProShare are trademarks of Intel Corporation in the United States, other countries, or both. UNIX is a registered trademark of The Open Group in the United States and other countries. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. PC Direct is a trademark of Ziff Communications Company in the United States, other countries, or both, and is used by IBM Corporation under license. Other company, product, and service names may be trademarks or service marks of others. 7.2 Copyright statements This product includes software developed by the Apache Software Foundation (http://www.apache.org/). The Apache Software License, Version 1.1 Copyright (c) 1999-2000 The Apache Software Foundation. All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. 3. The end-user documentation included with the redistribution, if any, must include the following acknowledgment: "This product includes software developed by the Apache Software Foundation (http://www.apache.org/)." Alternately, this acknowledgment may appear in the software itself, if and wherever such third-party acknowledgments normally appear. 4. The names "Xerces" and "Apache Software Foundation" must not be used to endorse or promote products derived from this software without prior written permission. For written permission, please contact apache@apache.org. 5. Products derived from this software may not be called "Apache", nor may "Apache" appear in their name, without prior written permission of the Apache Software Foundation. THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. ==================================================================== This software consists of voluntary contributions made by many individuals on behalf of the Apache Software Foundation and was originally based on software copyright (c) 1999, International Business Machines, Inc., http://www.apache.org. For more information on the Apache Software Foundation, please see .