Prospect Web® 2.2.6 P3 (2.2.6.3)

Prospect Web® 2.2.6 P3 is a patch release for Prospect Web 2.2.6. It is a cumulative release and can be applied on Prospect Web 2.2.6, Prospect Web 2.2.6 P1 release, or on Prospect Web 2.2.6 P2 release, in order to bring a system up to the 2.2.6 P3 release point.

Check you have installed on your system one of the versions required as prerequisite, by running the show_installed command. Note that 2.2.6 release is displayed as 2.2.6.0, 2.2.6 P1 patch as 2.2.6.1, and 2.2.6 P2 patch as 2.2.6.2

This patch introduces the solutions for APARs:

• IZ56488
• IZ61976



Readme file for: Prospect Web® 2.2.6 Patch3 [build 3] Product/Component Release: 2.2.6
Update Name:2.2.6 P3 (2.2.6.3)
Fix ID: 2.2.6-PROSPECTWEB-IF0003
Publication Date: 09 October 2009
Last modified date: 09 October 2009


Contents

Download location
Prerequisites and co-requisites
      Installation Privileges Required

Installation Information
      Install Procedure Syntax
      Pre-Install Procedure
      Installation Instructions
      Uninstalling if necessary

List of fixes
Copyright and trademark information
Document change history

Download location


Download Prospect Web® 2.2.6 P3 from the following location:
ftp://ftp.software.ibm.com/software/tivoli_support/patches/patches_2.2.6/2.2.6-PROSPECTWEB-IF0003/ or access the fix from the table below.

Below is a list of components, platforms, and file names that apply to this readme file.



Product/Component Name:	Platform:	File:
Prospect Web	Solaris	2.2.6-PROSPECTWEB-IF0003.tar.gz


Prerequisites and co-requisites

• Before downloading or installing 2.2.6-PROSPECT-IF0003, Prospect Web 2.2.6 must be installed on the system;
          if this is not installed you must complete the 2.2.6 installation prior to installing this patch.


• Ensure that you have sufficient file system free space to download, extract and install the patch.
Installation Privileges Required

Privilege	Required
Oracle flexpm user DBA role	No
UNIX flexpm user in DBA group	Yes
Root privilege required	No
Oracle sys user password set to default (change_on_install)	No

Installation Information

This section describes how to install the Prospect Web patch, 2.2.6 P3. This patch can be uninstalled (see section Uninstalling if necessary)


Install Procedure Syntax

install.sh [ -install | -uninstall | -help ]

-install: installs the patch

-uninstall: removes the patch and restored the previously installed versions of any files that were updated

-help: help

The scripts depend on $DB_CONNECT, make sure you have this setup correct.

Pre-Install Procedure
1. Login as flexpm and verify $FLEXPM_HOME is set.

      $ echo $FLEXPM_HOME 

   If it is not set, source the profile from FLEXPM_HOME directory.

     $  .  ./.profile 

2. Copy 2.2.6-PROSPECTWEB-IF0003.tar.gz into $FLEXPM_HOME.


3. Uncompress the file.

      $ gunzip  2.2.6-PROSPECTWEB-IF0003.tar.gz 

4. Untar the package. It will create a subdirectory (patches/PWeb2.2.6_P3) in $FLEXPM_HOME and untar the files in to this directory. You must use gtar to successfully untar this file.

      $ gtar -xvpf  2.2.6-PROSPECTWEB-IF0003.tar 

5. Install the Patch by following the instructions below

Installation Instructions
Important: If there are no errors from the Pre-Install Procedure, then continue with the following steps:


1. Login as flexpm and verify $FLEXPM_HOME is set.

      $ echo $FLEXPM_HOME 

   If it is not set, source the profile from FLEXPM_HOME directory.

     $  .  ./.profile 

2. Go to $FLEXPM_HOME/patches/PWeb2.2.6_P3 directory.

      $ cd $FLEXPM_HOME/patches/PWeb2.2.6_P3

3. Install the patch.

      $ install.sh -install 2>&1| tee install.log

Note: the patch installation program will automatically stop the middleware, install the patch files, and restart the middleware.

Uninstalling if necessary
1. Login as flexpm and verify $FLEXPM_HOME is set.

      $ echo $FLEXPM_HOME 

   If it is not set, source the profile from FLEXPM_HOME directory.

     $  .  ./.profile 

2. Go to $FLEXPM_HOME/patches/PWeb2.2.6_P3 directory.

      $ cd $FLEXPM_HOME/patches/PWeb2.2.6_P3

3. Remove the patch.

      $ install.sh -install 2>&1| tee uninstall.log

Note: the patch installation program will automatically stop the middleware, uninstall the patch files, and restart the middleware.



Customer Support
Contact IBM Customer Support if a problem is encountered during the installation of this patch.


List of fixes
Fixes included in Prospect Web® 2.2.6 P3: see also

ClearQuest / APAR	Released in	Description
valnt00092644/IZ56488	2.2.6 P3	PWEB REPORT PERFORMANCE AFFECTED BY FULL TABLE SCANS ON THEWM_INSTANCE_CONTEXT TABLE ON THE REMOTE DATASOURCE SERVER.
valnt00096043/IZ61976	2.2.6 P3	PWEB REPORTS RETURN BLANK AND INCORRECT VALUES AFTER CORE PATCH 8.0.6.3 IS APPLIED TO THE REMOTE PROSPECT SERVER.
		The following fixes were delivered in 2.2.6 P2
valnt00086842 / IZ50880	2.2.6 P2	SBH REPORTS NOT WORKING IN PWEB 2.2.6. REPORTS PULLING DATA FROM CHILD ENTITIES MAY NOT WORK.
valnt00077570 / IZ43294	2.2.6 P2	Search PWEB ORA-02292: INTEGRITY CONSTRAINT ERROR OCCURRING IN JBOSS-AGENT.LOG
valnt00082022 / IZ45278	2.2.6 P2	A HINT IN ONE OF THE PWEB SQLS IS NOT VALID AND NEED TO BE FIXED.
valnt00081919	2.2.6 P2	Add compatibility support to pweb for reports running against systems with core patch 8.0.6.2 installed
valnt00016447	2.2.6 P1	The preferences are not setting properly for favourite page settings.
valnt00016461	2.2.6 P1	UDC promotion: Last column size issues.
valnt00016553	2.2.6 P1	The "reset" button in Tools->Check Remote Data Availability and E2E->data availability is not working properly.
valnt00016679	2.2.6 P1	Reports of a report group are not shown in the report definition section
valnt00016707	2.2.6 P1	Inconsistent labeling in Preferences tab.
valnt00051036	2.2.6 P1	The schedule parameters are not overwritten when saved with existing schedule name.
valnt00056478	2.2.6 P1	Automated Report Export: Email is not sent to the user for failure reports.
valnt00062666	2.2.6 P1	User is not able to overwrite the favorite page with same name in upper case.
valnt00062675	2.2.6 P1	Exceptions encountered when user tried to save/run a report of a Deleted DataSource.
valnt00062951	2.2.6 P1	Programming Error occurred while defining a report with "to" date alone.
valnt00062953	2.2.6 P1	ORA Error occurred while saving the Report Group with the same name as that of the existing report definition.
valnt00069720	2.2.6 P1	Flash player 10 causes error message to appear at login
valnt00069725	2.2.6 P1	Reports using relative by last x hours does not work correctly
valnt00066839	2.2.6 P1	The protect UDC failed with "IDENTIFIER TOO LONG "Unexpected sql error: ORA-00972
valnt00070719 / IZ38777	2.2.6 P1	Msg: Unexpected exception: Can't find resource for bundle java.util.propertyresourcebundle


Copyright and trademark information

http://www.ibm.com/legal/copytrade.shtml


Notices

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

Microsoft, Windows, and Windows Server are trademarks of Microsoft Corporation in the United States, other countries, or both.

Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel Centrino logo, Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.

Other company, product, or service names may be trademarks or service marks of others.

THIRD-PARTY LICENSE TERMS AND CONDITIONS, NOTICES AND INFORMATION

The license agreement for this product refers you to this file for details concerning terms and conditions applicable to third party software code included in this product, and for certain notices and other information IBM must provide to you under its license to certain software code. The relevant terms and conditions, notices and other information are provided or referenced below. Please note that any non-English version of the licenses below is unofficial and is provided to you for your convenience only. The English version of the licenses below, provided as part of the English version of this file, is the official version.

Notwithstanding the terms and conditions of any other agreement you may have with IBM or any of its related or affiliated entities (collectively "IBM"), the third party software code identified below are "Excluded Components" and are subject to the following terms and conditions:


• the Excluded Components are provided on an "AS IS" basis
• IBM DISCLAIMS ANY AND ALL EXPRESS AND IMPLIED WARRANTIES AND CONDITIONS WITH RESPECT TO THE EXCLUDED COMPONENTS, INCLUDING, BUT NOT LIMITED TO, THE WARRANTY OF NON-INFRINGEMENT OR INTERFERENCE AND THE IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
• IBM will not be liable to you or indemnify you for any claims related to the Excluded Components
• IBM will not be liable for any direct, indirect, incidental, special, exemplary, punitive or consequential damages with respect to the Excluded Components.
Document change history



Created/Revised By:	Date of Creation/Update:	Summary of Changes:
OC	08 October 2009	Document Created