IBM Tivoli Composite Application Manager for SOA V7.1.0 Interim Fix 0001 Readme Revised 2008/11/04 Notices =================================================================== Created/Revised by Creation/Update Summary of Changes ------------------------------------------------------------------- GC April 2008 Document created ------------------------------------------------------------------- GC November 2008 Update readme, minor changes install procedure ==================================================================== Contents Section 1. General Description Section 2. Defects Fixed Section 3. Prerequisites Section 4. Installation Instructions ==================================================================== Section 1. General Description -------------------------------------- This i-fix contains post GA function enhancements. ==================================================================== Section 2. Defects Fixed -------------------------------------- Post GA delivery. - Fix slow response time performance on Warehouse queries for the Operational Flow workspaces. - Fix for WebSphere Service Registry and Repository Discovery Library Adapter handling of XSD files with circular import references. - Fix the data collector for WebSphere Process Server 6.1 and WebSphere Enteprise Service Bus 6.1 so that the EnableDC / DisableDC Take Action commands turn data collector monitoring ON / OFF for both JAX-RPC web services and Service Component Architecture (SCA) components. Prior to this fix, the data collector monitoring for SCA components was always ON and was unaffected by the EnableDC / DisableDC Take Action commands ==================================================================== Section 3. Prerequisites -------------------------------------- IBM Tivoli Composite Application Manager for SOA V7.1 ==================================================================== Section 4. Installation Instructions ------------------------------------ 4.1 - Updates to the Tivoli Enterprise Portal Server 4.2 - Updates to the Tivoli Composite Application Manager Agent 4.3 - Updates to the Discovery Library Adapter Use the following steps to install the update on the computer where Tivoli components are installed: + Extract the Tivoli Enterprise Portal Server, Tivoli Composite Application Manager Agent and Discovery Library Adapter from the main containers on a temporary directory. Windows. C:\TEMP unzip 7.1.0-TIV-ITCAMSOA-Windows-IF0001.zip This package contains the following packs to be used and applied as needed. 7.1.0-TIV-ITCAMSOA-Windows_TEPS-IF0001.zip 7.1.0-TIV-ITCAMSOA-Windows_TEMA-IF0001.zip WSRRV600_DLA-G.zip Linux/UNIX #/temp tar -xvf 7.1.0-TIV-ITCAMSOA-Linux_Unix-IF0001.tar This package contains the following packs to be used and applied as needed. 7.1.0-TIV-ITCAMSOA-Linux_Unix_TEPS-IF0001.tar.gz 7.1.0-TIV-ITCAMSOA-Linux_Unix_TEMA-IF0001.tar.gz WSRRV600_DLA-G.zip 4.1 - Updates to the Tivoli Enterprise Portal Server Use the following steps to install the update on the computer where Tivoli Enterprise Portal Server is installed: NOTE: Please ensure the base product and support files have been fully configured before applying this fix. 4.1.1 From the directory, create a backup directory and copy the following currently installed files into the backup directory. = Windows : \CNPS\Products\KD4\latest\j2eeClient\kd4evaluator.jar \CNPS\Products\KD4\latest\j2ee\kd4sdms.ear \CNPS\Products\KD4\latest\bin\kd4version.properties \CNPS\Products\KD4\latest\lib\configdms.jar \CNPS\sqllib\kd4_kcj.sql = Linux/Unix: //cq/Products/KD4/latest/j2eeClient/kd4evaluator.jar //cq/Products/KD4/latest/j2ee/kd4sdms.ear //cq/Products/KD4/latest/bin/kd4version.properties //cq/Products/KD4/latest/lib/configdms.jar //cq/sqllib/kd4_kcj.sql Where: : Is the location where the IBM Tivoli Monitoring product is installed. : Is the Operating System specific directory created by IBM Tivoli Monitoring The /bin/cinfo -d command can be used to determine the platform name for the cq product code. Please note that the platform names may vary depending on the IBM Tivoli Monitoring level installed (6.1 or 6.2). 4.1.2 Apply patch by extracting the new files to the machine where the Tivoli Enterprise Portal Server is installed and reconfigure as follows. = Windows. Unzip the windows fixpack package 7.1.0-TIV-ITCAMSOA-Windows_TEPS-IF0001.zip at the location. Where = \CNPS i.e. cd C:\IBM\ITM\CNPS unzip 7.1.0-TIV-ITCAMSOA-Windows_TEPS-IF0001.zip This will replace : kd4_kcj.sql in the directory : \CNPS\sqllib kd4evaluator.jar in the directory: \CNPS\Products\KD4\latest\j2eeClient kd4sdms.ear in the directory: \CNPS\Products\KD4\latest\j2ee kd4version.properties in the directory: \CNPS\Products\KD4\latest\bin configdms.jar in the directory : \CNPS\Products\KD4\latest\lib - Update the SOA Domain Management Server queries : Ensure that the Tivoli Enteprise Portal Server is started before running the following KfwSQLClient command. - Run the command: \CNPS\KfwSQLClient -l -d KFW_DSN -f \CNPS\sqllib\kd4_kcj.sql This will update Tivoli Enterprise Portal Server with the new sql file. NOTE: This step should always be run before updating SOA Domain Management Server in the steps below. When the KfwSQLClient command is executed an error messages will be reported, this is normal and should be ignored. RC = -1 [IBM][CLI Driver][DB2/LINUX] SQL0532N A parent row cannot be deleted because the relationship "ITMUSER.KFWMOBJ.SQL080227172112440" restricts the deletion. SQLSTATE=23504 ERR: -532, SQLExecDirect rc=-1: SQL_ERROR RC = -1 [IBM][CLI Driver][DB2/LINUX] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "ITMUSER.KFWTMPL" from having duplicate rows for those columns. SQLSTATE=23505 ERR: -803, SQLExecDirect rc=-1: SQL_ERROR - Update SOA Domain Management Server : - Run \CNPS\Products\KD4\latest\bin\ConfigDMS.bat and select the option to update SOA Domain Management Server if only SOA Domain Management Server is configured. If both SOA Domain Management Server and Tivoli Common Object Repository are configured, select the option to update SOA Domain Management Server and Tivoli Common Object Repository. - Reconfigure Tivoli Enterprise Portal Server = Linux/Unix. Untar the Linux/Unix package 7.1.0-TIV-ITCAMSOA-Linux_Unix_TEPS-IF0001.tar.gz at the location. = //cq/ i.e. cd /opt/IBM/ITM//cq tar -xvzf 7.1.0-TIV-ITCAMSOA-Linux_Unix_TEPS-IF0001.tar.gz This will replace : kd4_kcj.sql in the directory : //cq/sqllib kd4evaluator.jar in the directory : //cq/Products/KD4/latest/j2eeClient/ kd4sdms.ear in the directory : //cq/Products/KD4/latest/j2ee/ kd4version.properties in the directory : //cq/Products/KD4/latest/bin configdms.jar in the directory : //cq/Products/KD4/latest/lib/ - Update the SOA Domain Management Server queries : 1) On Linux/Unix machines before executing the KfwSQLClient command, perform these steps: Ensure that Tivoli Enterprise Portal is started by using the Manage Tivoli Enterprise Monitoring Services application or by running this command to verify that the cq product code has a status of "running". /bin/cinfo -r If Tivoli Enterprise Portal Server is not running then start it using the Manage Tivoli Enterprise Monitoring Services application or by running this command: /bin/itmcmd agent start cq 2) cd /bin 3) Run this command to update Tivoli Enteprise Portal Server with the new sql file: ./itmcmd execute cq "KfwSQLClient -l -d KFW_DSN -f //cq/sqllib/kd4_kcj.sql" Where: : Is the location where the IBM Tivoli Monitoring product is installed. : Is the operating system specific directory created by IBM Tivoli Monitoring for the cq product code (the product code for Tivoli Enterprise Portal Server). The /bin/cinfo -d command can be used to determine the platform name for the cq product code. Please note that the platform names may vary depending on the IBM Tivoli Monitoring level installed (6.1 or 6.2). NOTE: These step should be run before updating the SOA Domain Management Server in the steps below. When the KfwSQLClient command is executed error messages similar to this will be reported. This is normal and should be ignored. RC = -1 [IBM][CLI Driver][DB2/LINUX] SQL0532N A parent row cannot be deleted because the relationship "ITMUSER.KFWMOBJ.SQL080227172112440" restricts the deletion. SQLSTATE=23504 ERR: -532, SQLExecDirect rc=-1: SQL_ERROR RC = -1 [IBM][CLI Driver][DB2/LINUX] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "ITMUSER.KFWTMPL" from having duplicate rows for those columns. SQLSTATE=23505 ERR: -803, SQLExecDirect rc=-1: SQL_ERROR - Update SOA Domain Management Server : - Run //cq/Products/KD4/latest/bin/ConfigDMS.sh and select the option to update SOA Domain Management Server if only SOA Domain Management Server is configured. If both SOA Domain Management Server and Tivoli Common Object Repository are configured, select the option to update SOA Domain Management Server and Tivoli Common Object Repository. - Reconfigure Tivoli Enterprise Portal Server Where: is the location where the IBM Tivoli Monitoring product is installed. is the Operating System specific directory created by IBM Tivoli Monitoring. The /bin/cinfo -d command can be used to determine the platform name for the cq product code. Please note that the platform names may vary depending on the IBM Tivoli Monitoring level installed (6.1 or 6.2). 4.1.3 After completing the above steps, restart Tivoli Enterprise Portal Server. 4.2 - Updates to the Tivoli Composite Application Manager Agent Use the following steps to install the update on the computer where Tivoli Composite Application Manager Agent is installed: NOTE: Please ensure the base product has been fully configured before applying this fix. 4.2.1 Stop (disable) the Data Collector. Windows: From /TMAITM6/KD4/bin Linux/Unix: From //d4/KD4/bin Execute: ./KD4configDC -disable -env 1 Where : This argument specifies the base installation directory for WebSphere Application Server. The typical default value is "C:\Program Files\WebSphere\AppServer" (note that because this path name contains a blank space, the entire path is surrounded with quotation marks). 4.2.2 Backup affected file. From the directory, create a backup directory and copy the following currently installed files into the backup directory. = Windows : \TMAITM6\KD4\lib\kd4was61dcagent.jar = Linux/Unix: //d4/KD4/lib/kd4was61dcagent.jar Where: : Is the location where the IBM Tivoli Monitoring product is installed. : Is the Operating System specific directory created by IBM Tivoli Monitoring The /bin/cinfo -d command can be used to determine the platform name for the d4 product code. Please note that the platform names may vary depending on the IBM Tivoli Monitoring level installed (6.1 or 6.2). 4.2.3 Apply patch to the machine where the Tivoli Composite Application Manager Agent is running by extracting the new files and reconfigure as follows. = Windows. Unzip the windows fixpack package 7.1.0-TIV-ITCAMSOA-Windows_TEMA-IF0001.zip. i.e. cd \TMAITM6\ unzip 7.1.0-TIV-ITCAMSOA-Windows_TEMA-IF0001.zip = Linux/Unix. Untar the Linux/Unix package 7.1.0-TIV-ITCAMSOA-Linux_Unix_TEMA-IF0001.tar.gz i.e. cd //d4 tar -xvzf 7.1.0-TIV-ITCAMSOA-Linux_Unix_TEMA-IF0001.tar.gz Where: : Is the location where the IBM Tivoli Monitoring product is installed. : Is the Operating System specific directory created by IBM Tivoli Monitoring The /bin/cinfo -d command can be used to determine the platform name for the d4 product code. Please note that the platform names may vary depending on the IBM Tivoli Monitoring level installed (6.1 or 6.2). 4.2.4 After completing the above steps, enable SCA (WAS) Data Collector. Windows: From /TMAITM6/KD4/bin Linux/Unix: From //d4/KD4/bin Execute: ./KD4configDC -enable -env 1 Where : This argument specifies the base installation directory for WebSphere Application Server. The typical default value is "C:\Program Files\WebSphere\AppServer" (note that because this path name contains a blank space, the entire path is surrounded with quotation marks). 4.3 - Updates to the Discovery Library Adapter Extract the new WebSphere Service Registry and Repository Discovery Library Adapter (WSRRV600_DLA-G.zip) and follow the installation and setup instructions as included in the DLA Readme.