IBM Prospect for Core Release 8.0.5 Release Patch Core8.0.5_P1

Release Notes

Issue Date   :	Apr 15, 2008
Version      :    Core8.0.5
Patch        :	P1
Build        :	04


1. Description
--------------

This patch contains the fixes for some issues faced during the BH job execution,
enhancements for ‘ps-mgr purge’ command and the PartMaint parallel granularity feature.

Supported platforms: 
  Oracle versions 9i, 10g
  Prospect 8.0.5
Usage:

install.sh [ -install | -uninstall | -help ]
-install  :  installs the wmn_pkgb.sql
-uninstall : removes the current file version and replaces it with the previous version
-help : help

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

2. Resolved Issues
------------------

This package addresses the following issues:

SEAde68988: IZ13905 - Need rg_common.sql to set hash_area_size
SEAde69274: IZ13925 - BHUpdate log shows #INVALID# message during copy to BH table
SEAde69079: IZ14994 - ORA-01410 errors occur when reports and soft alarms run
SEAde69384: Improve the 'ps-mgr purge' command
SEAde69411: PartMaint parallel enhancement
SEAde69523: IZ18779 - pm_weekly summations take longer times as time progresses

3. Known Problems
-----------------
Please ignore drop statement errors for objects that do not exist

None.

4. Installation Instructions
---------------------------

4.1 Prerequisites

This patch is applicable to Prospect applications that have Core8.0.5 installed.

4.2 Pre-installation Instructions

1. Login as flexpm.
2. Go to $FLEXPM_HOME directory.
	$ cd $FLEXPM_HOME
3. Copy 8.0.5-PROSPECT-IF0001.tar.gz into this directory.
4. Uncompress the file.
      $ gunzip  8.0.5-PROSPECT-IF0001.tar.gz
5. Untar the package. It will create a subdirectory (patches/Core8.0.5_P1) 
   in $FLEXPM_HOME and untar the files in to this directory.
      $ tar -xvpf  8.0.5-PROSPECT-IF0001.tar
   Install the patch by following the instructions in Section 4.3 below.

4.3. Installation Procedure

  1. Login as flexpm.
       $ cd $FLEXPM_HOME/
       $ . ./.profile
  2. Go to patch directory.
       $ cd $FLEXPM_HOME/patches/Core8.0.5_P1
  3. If Prospect Web is accessing the Prospect installation, then use the
     admin tool to disable the corresponding datasource.
  4. Install the patch.
       $ install.sh -install 2>&1| tee install.log
  5. If you disabled any datasource in step 4.3.3 then use the admin
     tool to re-enable them.

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


4.4 Instructions to uninstall the patch

  1. Login as flexpm.
       $ cd $FLEXPM_HOME/
       $ . ./.profile
  2. Go to $FLEXPM_HOME/patches/Core8.0.5_P1 directory.
       $ cd $FLEXPM_HOME/patches/Core8.0.5_P1
  3. If Prospect Web is accessing the Prospect installation, then use the
     admin tool to disable the corresponding datasource.
  4. Un-install the patch.
       $ install.sh -uninstall 2>&1| tee uninstall.log
  5. If you disabled any datasource in step 4.4.3 then use the admin
     tool to re-enable them.

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


5. Useful Hints
---------------

5.1 New Configuration Option

5.1.1 part_tablespaces.sh cli

This patch introduces 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 <tablespace> | -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
   -s <degree>	    : analyze parallelism degree during part_maint activity
                      : <degree> = 0: reset value (the upper level of hierarchy will be used)
                      : <degree> = 1: turn off parallelism for specified tablespace/table
                      : <degree> = >1 && <99: apply specified parallelism
   -h			    : help, show usage

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


6. Customer Support
-------------------

If a problem is encountered during the installation of this patch, please contact your IBM customer support. 



7. Manifest
-----------
patches
patches/Core8.0.5_P1
patches/Core8.0.5_P1/backup
patches/Core8.0.5_P1/backup/install
patches/Core8.0.5_P1/backup/install/db
patches/Core8.0.5_P1/backup/install/db/Oracle8i
patches/Core8.0.5_P1/backup/install/db/Oracle8i/part_maint
patches/Core8.0.5_P1/backup/install/db/Oracle8i/rg
patches/Core8.0.5_P1/backup/install/db/Oracle8i/utility
patches/Core8.0.5_P1/backup/install/pm
patches/Core8.0.5_P1/backup/install/pm/adm
patches/Core8.0.5_P1/backup/install/pm/bin
patches/Core8.0.5_P1/backup/install/pm/jloader
patches/Core8.0.5_P1/backup/install/pm/jloader/lib
patches/Core8.0.5_P1/backup/install/pm/run
patches/Core8.0.5_P1/backup/install/sw
patches/Core8.0.5_P1/backup/install/sw/oracle
patches/Core8.0.5_P1/install
patches/Core8.0.5_P1/install/compile-schema.sql
patches/Core8.0.5_P1/install/Core8.0.5_P1.build
patches/Core8.0.5_P1/install/db
patches/Core8.0.5_P1/install/db/Oracle8i
patches/Core8.0.5_P1/install/db/Oracle8i/part_maint
patches/Core8.0.5_P1/install/db/Oracle8i/part_maint/createTables.sql
patches/Core8.0.5_P1/install/db/Oracle8i/part_maint/Makefile
patches/Core8.0.5_P1/install/db/Oracle8i/part_maint/part_maint.sql
patches/Core8.0.5_P1/install/db/Oracle8i/part_maint/part_maintDrop.sql
patches/Core8.0.5_P1/install/db/Oracle8i/part_maint/part_maintPack.sql
patches/Core8.0.5_P1/install/db/Oracle8i/part_maint/part_task.sql
patches/Core8.0.5_P1/install/db/Oracle8i/rg
patches/Core8.0.5_P1/install/db/Oracle8i/rg/rg_common.sql
patches/Core8.0.5_P1/install/db/Oracle8i/utility
patches/Core8.0.5_P1/install/db/Oracle8i/utility/autoclean.sql
patches/Core8.0.5_P1/install/exec_drops.sql
patches/Core8.0.5_P1/install/patch.sql
patches/Core8.0.5_P1/install/pm
patches/Core8.0.5_P1/install/pm/adm
patches/Core8.0.5_P1/install/pm/adm/part_tablespaces.sh
patches/Core8.0.5_P1/install/pm/adm/wmpm-init
patches/Core8.0.5_P1/install/pm/adm/wmpm.sh
patches/Core8.0.5_P1/install/pm/bin
patches/Core8.0.5_P1/install/pm/bin/rgp
patches/Core8.0.5_P1/install/pm/jloader
patches/Core8.0.5_P1/install/pm/jloader/lib
patches/Core8.0.5_P1/install/pm/jloader/lib/jloader.jar
patches/Core8.0.5_P1/install/pm/run
patches/Core8.0.5_P1/install/pm/run/bhd.sh
patches/Core8.0.5_P1/install/pm/run/bhrgp.sh
patches/Core8.0.5_P1/install/pm/run/download
patches/Core8.0.5_P1/install/pm/run/ps-mgr
patches/Core8.0.5_P1/install/pm/run/rgp.sh
patches/Core8.0.5_P1/install/pm/run/udr.sh
patches/Core8.0.5_P1/install/recompile_view.sh
patches/Core8.0.5_P1/install/schema_patch.sql
patches/Core8.0.5_P1/install/sw
patches/Core8.0.5_P1/install/sw/oracle
patches/Core8.0.5_P1/install/sw/oracle/compile-schema.sql
patches/Core8.0.5_P1/install/unpatch.sql
patches/Core8.0.5_P1/install.sh




OWNERSHIP & CONFIDENTIALITY
No part of this document may be disclosed orally or in writing, including by 
reproduction, to any third party without the prior written consent of IBM 
Corp. This document, its associated appendices, and any attachments remain the 
property of IBM Corp. and shall be returned upon request.