Prospect® 8.0.6 P4 (8.0.6.4)

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

Check you have installed on your system one of the versions required as prerequisite, by running the show_installed command.
Note that 8.0.6 release is displayed as 8.0.6.0, 8.0.6 P1 patch as 8.0.6.1 and 8.0.6 P3 patch as 8.0.6.3.

This patch introduces the solutions for APARs IZ40085, IZ50881, IZ53006, IZ53521, IZ54532 and IZ55663 as well as MR0617092831.

This is the delivery of an Enhancement Request

Readme file for: Prospect® 8.0.6 Patch4 [Server: Build 1]
Product/Component Release: 8.0.6
Update Name: 8.0.6 P4 (8.0.6.4)
Fix ID: 8.0.6-PROSPECT-IF0004
Publication Date: 06 August 2009
Last modified date: 06 August 2009


Contents
Download location
Prerequisites and co-requisites
      Network Timeouts
      Installation Privileges Required
Known Issues

Installation Information

Installing the Prospect Server
  Pre-Install Procedure
  Installation Instructions
  Post-Installation Instructions

Additional Information
List of fixes
Copyright and trademark information
Document change history


Download location


Download Prospect® 8.0.6 P4 from the following location:
ftp://ftp.software.ibm.com/software/tivoli_support/patches/patches_8.0.6/8.0.6-PROSPECT-IF0004/ 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 Server	Solaris	8.0.6-PROSPECT-IF0004-server.tar.gz

Note: This patch release, Prospect® 8.0.6 P4, does not contain any changes for the client software. The most up-to-date client software, 8.0.6 P2, is available for download from 8.0.6-PROSPECT-IF0003-client.zip (8.0.6 P3 client is functionally equivalent). To install this client see installation instructions for 8.0.6.3

Prerequisites and co-requisites

• Before downloading or installing 8.0.6-PROSPECT-IF0004, Prospect Core 8.0.6 must be installed.
• Ensure that you have sufficient file system free space to download, extract and install the patch.
Network Timeouts
If your system has a security policy in place such that a session is disconnected after a lengthy period of apparent inactivity, you should disable it during this upgrade. There is the possibility that an upgrade can take a while to run. Since no user input is required during the most of the upgrade, this can make the upgrade session appear idle. If timeouts are not disabled, the upgrade terminal could be disconnected during the upgrade.


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


Known Issues


Tablespace usage

It is necessary to have at least 10% free in the TRAFFIC tablespace. To check tablespace usage run the following command;


healthcheck -e db_tablespace       (Note the TEMP tablespace is not checked)


• Returns WARN is any tablespace has less than 10% free disk space.
• Returns FAIL if any tablespace has less than 5% free disk space.
Problems may be resolved by either reducing the amount of data stored in the database or increasing the size of the tablespace.
See page 138 in the Prospect® 8.0.6 Administration Guide. for instructions on increasing tablespace if necessary.



Installation information:

This section describes how to install the Prospect® patch, 8.0.6 P4.


Installing the Prospect Server

This section explains how to install the 8.0.6 P4 Prospect Server
Pre-Install Procedure
1. Login as flexpm and verify $FLEXPM_HOME is set.

      $ echo $FLEXPM_HOME 

   If there are multiple Prospect installations on the server, source the .profile for the Prospect installation for which this patch should be applied.


2. Copy 8.0.6-PROSPECT-IF0004-server.tar.gz into $FLEXPM_HOME.


3. Uncompress the file.

      $ gunzip  8.0.6-PROSPECT-IF0004-server.tar.gz 

4. Untar the package. It will create a subdirectory (patches/Core8.0.6_P4) in $FLEXPM_HOME and untar the files in to this directory.

      $ gtar -xvpf  8.0.6-PROSPECT-IF0004-server.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 there are multiple Prospect installations on the server, source the .profile for the Prospect installation for which this patch should be applied.


2. Go to $FLEXPM_HOME/patches/Core8.0.6_P4 directory.

      $ cd $FLEXPM_HOME/patches/Core8.0.6_P4

3. If Prospect Web is accessing this Prospect installation, then use the admin tool to disable the corresponding datasource.


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

Post-Installation Instructions

Resource the Profile

If you have not done so already, log off and log on as flexpm.

Re-enable the datasource in Prospect Web

Once the installation has completed, re-enable the datasource in Prospect Web (if you disabled it before starting the patch installation)



Additional information


New Configuration Options

1. External Soft Alarms

For information on the External Soft Alarms feature please refer to page 215 in the Prospect® 8.0.6 Administration Guide.

For detailed instructions for configuring External Soft Alarms please refer to section 3.8 of the Prospect® 8.0.6 Installation Guide.

These guides can be found in the Prospect® 8.0.6 documentation set online at:
http://publib.boulder.ibm.com/infocenter/tivihelp/v8r1/index.jsp?topic=/com.ibm.netcool_pm.doc/prospect_806_docpage.html

2. part_tablespaces.sh cli

   This patch contains the feature that enhances the granularity of parallel execution during the Analyze phase of part_maint process. This way, it improves the performances of Analyze phase of part_maint process.
   In order to handle the data manipulation for this feature, a new cli called part_tablespaces.sh has been introduced. Following the cli usage:

   part_tablespaces.sh -O
   part_tablespaces.sh -S	[ -T | -t <table> ] [ -m <degree> | -s <degree> ]
   part_tablespaces.sh -h
   Where:
   -O	: output
   -S	: set
   -T <tablespace>	: for the specified tablespace
   -t <table>	: for the specified table
   -m <degree>	: move parallelism degree during part_maint activity
   -s <degree>	: analyze parallelism degree during part_maint activity
   	: <degree> = 0: reset value (use the upper hierarchy level)
   	: <degree> = 1: disable parallelism for specified tablespace/table
   	: <degree> = >1 && <99: apply specified parallelism
   -h	: help, show usage

   For appropriate parameter settings, please, contact IBM Customer support.


List of fixes


Fixes included in Prospect® 8.0.6 P4: see also http://www-01.ibm.com/support/docview.wss?uid=swg24023876

ClearQuest / APAR	Released in	Description
valnt00073703 / IZ40085	8.0.6 P4	RUNNING A NON-STORED DATA BUSY HOUR REPORT WITH A RELATIVE TIME SCOPE OF "WEEK".
valnt00087359 / IZ50881	8.0.6 P4	DATA FOR SOME INTERVALS IS REMEDIATED INCORRECTLY.
valnt00089597 / IZ53006	8.0.6 P4	TERMINATED REPORTS (REPORT RUN TIME TIMED OUT) LEAVES ORPHANED DB SESSIONS WHICH CONFLICT.
valnt00089926 / IZ53521	8.0.6 P4	DATA LOADING ON GGU SERVER WAS SLOW.
valnt00090873 / IZ54532	8.0.6 P4	FX DATASERVER CRASHED ON GGU SERVER/
MR0617092831	8.0.6 P4	SAEXT Pad LAC/CID values to 5 digits with leading zeros.
valnt00091905 / IZ55663	8.0.6 P4	PROSPECT PATCH FAILED WITH THE ERROR: ERROR IN TRUNC_NO_UDC:ORA-02298.
		The following fixes were delivered in previous 8.0.6 patches
valnt00089367	8.0.6 P3	New columns missing from traffic views after dict_update
valnt00089929 / IZ53523	8.0.6 P3	AFTER CORE 8.0.6.2 UPGRADE, REPORTS FAILING BECAUSE OF MISSING TABLES
valnt00090116 / IZ53790	8.0.6 P3	AFTER CORE 8.0.6.2 INSTALLATION, VERY LARGE INCREASE IN TABLESPACE JUMBO, LARGE AND MEDIUM.
valnt00087363 / IZ50816	8.0.6 P3	DEADLOCKS IN ORACLE ALERT LOG CAUSED BY PROSPECT
valnt00084016 / IZ48652	8.0.6 P3	SUMMARY JOB STARTED FAILING AFTER UPGRADE.
valnt00083869 / IZ48552	8.0.6 P3	THE LOADER LOG SHOWS ORA- ERROR IF THERE ARE A LARGE # OF MAPPING ERRORS.
valnt00081708 / IZ47231	8.0.6 P3	USERS REPORT PROBLEMS WITH DOWNLOADING REPORTS AFTE THEY UPGRADE PC'S TO OFFICE 2007
valnt00052618 / IZ30967	8.0.6 P3	PK_SWAP. THE GLOBAL UPDATE PORTION OF BH_UPDATE TAKES TOO LONG ON LARGE SERVERS. THIS MAKES THE JOB USELESS TO USERS
valnt00052635 / IZ31190	8.0.6 P3	CUSTOMER UNABLE TO DELETE USER FROM THE PROSPECT WINDOWS CLIENT
valnt00071553 / IZ39078	8.0.6 P3	PROSPECT CLIENT ERROR "OUT OF STRING"
valnt00081587 / IZ46982	8.0.6 P3	WHEN DOWNLOADING REPORTS, THE CLIENT WILL CREATE AN EXCEL .TMP FILE, BUT NOT THE FINAL .XLS FILE.
valnt00088955 / IZ52420	8.0.6 P3	CORE 8.0.6.2 UPGRADE DID NOT COMPLETE SUCCESSFULLY
valnt00078627 / IZ43835	8.0.6 P1	DAILY SUMMATIONS FAIL WHEN THE LASTAVAIL TIME STAMP MM:SS IS OTHER THAN THE EXPECTED 00:00.
valnt00081711 / IZ47230	8.0.6 P1	AFTER CORE 8.0.6 UPGRADE, REPORTS ARE FAILING BECAUSE OF RSDATASERVERS CORE DUMPING
valnt00080972 / IZ45459	8.0.6 P1	NO ERRORS WHEN THE MIDDLEWARE IS STARTED WITHOUT THE LISTENER.
valnt00080966 / IZ45463	8.0.6 P1	ALL SOFT ALARM PROCESSING JOBS FAIL AFTER ORA-08103
valnt00080969 / IZ45599	8.0.6 P1	SUMMARY JOB TAKES LONG TIME TO COMPLETE ON UMTS SERVER.
valnt00077159	8.0.6 P1	Improve classic report generation performance



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:
SD	06 August 2009	Document Created