Prospect for Core Release 8.0.4 Release Patch Core8.0.4_P6

Release Notes

Issue Date   :	Jun 27, 2008
Version      :    Core8.0.4
Patch        :	P6
Build        :	01


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

This patch introduces the support for 3GPP standard special characters, '<>"&, into the loader component.

Supported platforms: 
  Oracle versions 9i
  Prospect 8.0.4.1
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:

SEAde66354: Code cleanup to schedcheck.sql to not log when logging turned off
SEAde67198: Summation performance enhancements
SEAde66777: Ensure minimum enqueue times is 1 second to prevent flood status msg
SEAde67258: Active Heartbeat Queue failues causing decrementing license IN_USE
SEAde67756: BH_DRIVER_TMP & INDEX needs to be moved to TRAFFIC_LARGE tablespace
SEAde67897: Add softalarm to clean_iot waits
SEAde67118: Use AutoCleanIOTMaxLoops for autoclean.clean_iot
SEAde67119: add autoclean.clean_iot needs to schedule_maint
SEAde67708: Order of Copy is BH JOB is making it to run longer times
SEAde68144: autoclean.clean_iot should be optional
SEAde68272: Softalarm scheduler fails with ORA-06531 uninitialized collection error
SEAde68331: BH Slices: ability to splice a table into sections for BH copy purposes
SEAde68461: Import/Export sometimes fails to import udcs
SEAde66544: SBH and reports fail due to fx dataserver restart
SEAde68574: Some percentage values incorrectly truncated in reports
SEAde68590: IZ09131 - Summation job does not work on ericsson ggu
SEAde68058: PartMaint enhancements V2
SEAde68839: IZ14072 - BHSlice not working properly
SEAde68933: IZ15501 - BH optimitic insert
SEAde68939: IZ15512 - Incremental Summation
SEAde69008: IZ14162 - Busy Hour Update Copy does not show in ps-mgr watch
SEAde69134: IZ15662 - UDC computations incorrect in 8.0.4.x
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
SEAde69523: IZ18779 - pm_weekly summations take longer times as time progresses
valnt00019149: Introduce the 3GPP special characters support into the loader component

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.4.1 installed.


4.2 Pre-installation Instructions

  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 directory.
	 $ cd $FLEXPM_HOME
  3. Copy 8.0.4-PROSPECT-IF0006.tar.gz into this directory.
  4. Uncompress the file.
       $ gunzip  8.0.4-PROSPECT-IF0006.tar.gz
  5. Untar the package. It will create a subdirectory (patches/Core8.0.4_P6) 
     in $FLEXPM_HOME and untar the files in to this directory.
       $ tar -xvpf  8.0.4-PROSPECT-IF0006.tar
     Install the patch by following the instructions in Section 4.3 below.


4.3. Installation 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. Go to $FLEXPM_HOME/patches/Core8.0.4_P6 directory.
       $ cd $FLEXPM_HOME/patches/Core8.0.4_P6
  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 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.4_P6 directory.
       $ cd $FLEXPM_HOME/patches/Core8.0.4_P6
  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,
      un-install the patch files, and restart the middleware.



5. Customer Support
-------------------

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



6. Manifest
-----------
patches
patches/Core8.0.4_P6
patches/Core8.0.4_P6/backup
patches/Core8.0.4_P6/backup/install
patches/Core8.0.4_P6/backup/install/db
patches/Core8.0.4_P6/backup/install/db/Oracle8i
patches/Core8.0.4_P6/backup/install/db/Oracle8i/bh
patches/Core8.0.4_P6/backup/install/db/Oracle8i/cfgtool
patches/Core8.0.4_P6/backup/install/db/Oracle8i/dictionary
patches/Core8.0.4_P6/backup/install/db/Oracle8i/part_maint
patches/Core8.0.4_P6/backup/install/db/Oracle8i/rg
patches/Core8.0.4_P6/backup/install/db/Oracle8i/scheduler
patches/Core8.0.4_P6/backup/install/db/Oracle8i/scheduler/except
patches/Core8.0.4_P6/backup/install/db/Oracle8i/scheduler/sched
patches/Core8.0.4_P6/backup/install/db/Oracle8i/softalarm
patches/Core8.0.4_P6/backup/install/db/Oracle8i/softalarm/sacheck
patches/Core8.0.4_P6/backup/install/db/Oracle8i/summarize
patches/Core8.0.4_P6/backup/install/db/Oracle8i/utility
patches/Core8.0.4_P6/backup/install/db/Oracle8i/wmlib
patches/Core8.0.4_P6/backup/install/peik
patches/Core8.0.4_P6/backup/install/peik/loaders
patches/Core8.0.4_P6/backup/install/peik/loaders/scripts
patches/Core8.0.4_P6/backup/install/pm
patches/Core8.0.4_P6/backup/install/pm/adm
patches/Core8.0.4_P6/backup/install/pm/bin
patches/Core8.0.4_P6/backup/install/pm/lib
patches/Core8.0.4_P6/backup/install/pm/lib/wm
patches/Core8.0.4_P6/backup/install/pm/run
patches/Core8.0.4_P6/backup/install/sw
patches/Core8.0.4_P6/backup/install/sw/oracle
patches/Core8.0.4_P6/install
patches/Core8.0.4_P6/install/compile-schema.sql
patches/Core8.0.4_P6/install/Core8.0.4_P6.build
patches/Core8.0.4_P6/install/db
patches/Core8.0.4_P6/install/db/Oracle8i
patches/Core8.0.4_P6/install/db/Oracle8i/bh
patches/Core8.0.4_P6/install/db/Oracle8i/bh/BH_Driver_tmp.sql
patches/Core8.0.4_P6/install/db/Oracle8i/bh/BH_Update.sql
patches/Core8.0.4_P6/install/db/Oracle8i/bh/BH_UpdatePack.sql
patches/Core8.0.4_P6/install/db/Oracle8i/bh/busyhour_task.sql
patches/Core8.0.4_P6/install/db/Oracle8i/bh/busyhour_taskDrop.sql
patches/Core8.0.4_P6/install/db/Oracle8i/cfgtool
patches/Core8.0.4_P6/install/db/Oracle8i/cfgtool/create_schema_objects.sql
patches/Core8.0.4_P6/install/db/Oracle8i/dictionary
patches/Core8.0.4_P6/install/db/Oracle8i/dictionary/wmn_pkgb.sql
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/createTables.sql
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/createTriggers.sql
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/Makefile
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/part_maint.sql
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/part_maintDrop.sql
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/part_maintPack.sql
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/part_stat.sql
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/part_statDrop.sql
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/part_task.sql
patches/Core8.0.4_P6/install/db/Oracle8i/part_maint/part_taskDrop.sql
patches/Core8.0.4_P6/install/db/Oracle8i/rg
patches/Core8.0.4_P6/install/db/Oracle8i/rg/rg_common.sql
patches/Core8.0.4_P6/install/db/Oracle8i/scheduler
patches/Core8.0.4_P6/install/db/Oracle8i/scheduler/except
patches/Core8.0.4_P6/install/db/Oracle8i/scheduler/except/except.sql
patches/Core8.0.4_P6/install/db/Oracle8i/scheduler/sched
patches/Core8.0.4_P6/install/db/Oracle8i/scheduler/sched/schedule_maint
patches/Core8.0.4_P6/install/db/Oracle8i/softalarm
patches/Core8.0.4_P6/install/db/Oracle8i/softalarm/sacheck
patches/Core8.0.4_P6/install/db/Oracle8i/softalarm/sacheck/schedcheck.sql
patches/Core8.0.4_P6/install/db/Oracle8i/summarize
patches/Core8.0.4_P6/install/db/Oracle8i/summarize/CreateSumTab.sql
patches/Core8.0.4_P6/install/db/Oracle8i/summarize/summarize.sql
patches/Core8.0.4_P6/install/db/Oracle8i/summarize/summarizePack.sql
patches/Core8.0.4_P6/install/db/Oracle8i/summarize/summ_task.sql
patches/Core8.0.4_P6/install/db/Oracle8i/summarize/summ_taskDrop.sql
patches/Core8.0.4_P6/install/db/Oracle8i/utility
patches/Core8.0.4_P6/install/db/Oracle8i/utility/autoclean.sql
patches/Core8.0.4_P6/install/db/Oracle8i/utility/autocleanPack.sql
patches/Core8.0.4_P6/install/db/Oracle8i/utility/sched_immediate_pkg.sql
patches/Core8.0.4_P6/install/db/Oracle8i/utility/sched_immediate_pkgb.sql
patches/Core8.0.4_P6/install/db/Oracle8i/wmlib
patches/Core8.0.4_P6/install/db/Oracle8i/wmlib/wm_sysval_pkg.sql
patches/Core8.0.4_P6/install/db/Oracle8i/wmlib/wm_sysval_pkgb.sql
patches/Core8.0.4_P6/install/dew_drops.sql
patches/Core8.0.4_P6/install/downgrade_summations.sql
patches/Core8.0.4_P6/install/patch.sql
patches/Core8.0.4_P6/install/peik
patches/Core8.0.4_P6/install/peik/loaders
patches/Core8.0.4_P6/install/peik/loaders/scripts
patches/Core8.0.4_P6/install/peik/loaders/scripts/file_decode.pl
patches/Core8.0.4_P6/install/pm
patches/Core8.0.4_P6/install/pm/adm
patches/Core8.0.4_P6/install/pm/adm/exp_udc_convert.pl
patches/Core8.0.4_P6/install/pm/adm/import_docs.sh
patches/Core8.0.4_P6/install/pm/adm/part_mask.sh
patches/Core8.0.4_P6/install/pm/adm/wmpm-init
patches/Core8.0.4_P6/install/pm/adm/wmpm.sh
patches/Core8.0.4_P6/install/pm/bin
patches/Core8.0.4_P6/install/pm/bin/commander10g
patches/Core8.0.4_P6/install/pm/bin/commander9i
patches/Core8.0.4_P6/install/pm/bin/loader10g
patches/Core8.0.4_P6/install/pm/bin/loader9i
patches/Core8.0.4_P6/install/pm/bin/rgp
patches/Core8.0.4_P6/install/pm/lib
patches/Core8.0.4_P6/install/pm/lib/wm
patches/Core8.0.4_P6/install/pm/lib/wm/libexpressions.so
patches/Core8.0.4_P6/install/pm/lib/wm/libReportEngine.so
patches/Core8.0.4_P6/install/pm/lib/wm/libWmGateway.so
patches/Core8.0.4_P6/install/pm/run
patches/Core8.0.4_P6/install/pm/run/bhd.sh
patches/Core8.0.4_P6/install/pm/run/bhrgp.sh
patches/Core8.0.4_P6/install/pm/run/download
patches/Core8.0.4_P6/install/pm/run/ps-mgr
patches/Core8.0.4_P6/install/pm/run/rgp.sh
patches/Core8.0.4_P6/install/pm/run/udr.sh
patches/Core8.0.4_P6/install/recompile_view.sh
patches/Core8.0.4_P6/install/schema_patch.sql
patches/Core8.0.4_P6/install/sw
patches/Core8.0.4_P6/install/sw/oracle
patches/Core8.0.4_P6/install/sw/oracle/compile-schema.sql
patches/Core8.0.4_P6/install/unpatch.sql
patches/Core8.0.4_P6/install/upgrade_summations.sql
patches/Core8.0.4_P6/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.

