IBM DB2 Performance Expert Version 2 Release 2, GA, Interim Fix 6

Install Instructions

1.0	Prerequisites
2.0	Problem Description
3.0	Installation Instructions

___________________________________________________________________

1.0 	Prerequisites

DB2 Performance Expert V2.2 GA is required in order to use Interim Fix 6.

2.0	Problem Description

Interim Fix 6 solves the following problem:

APAR PK17657 JAVA.IO.IOEXCEPTION ERROR MESSAGE "A FILE OR DIRECTORY IN THE PATH NAME DOES NOT EXIST" DURING SQL ACTIVITY TRACE EXECUTION.
Running Performance Expert Server an error might occur executing
SQL Activity Trace report in Performance Warehause (PWH).

Possible error message can be found in PWH LOAD step log file:
java.io.IOException: No event monitor files found in '<Local event monitoring path>'. <Local event monitoring path>/PWH/NNNNNNNNNN/N/00000000.evt
(A file or directory in the path name does not exist.) :
Return code ....... :201
Reason code ....... :201
Detecting module .. :LoadEngine
Error message ..... :
  +-------------------------------------------------------------------------------+
    No event monitor files found in '<Local event monitoring path>/PWH/NNNNNNNNNN/N'.
    <Local event monitoring path>/PWH/NNNNNNNNNN/N/00000000.evt (A file or
    directory in the path name does not exist.)
  +-------------------------------------------------------------------------------+

Reason:
Remote event monitoring path, used on a monitored instance to store
DB2 event monitor files, specified during server configuration is too long.


3.0. Installation Instructions

3.1. As DB2 instance owner stop Performance Expert Server.

3.2. Extract the APAR archive.

Unzip the file db2pe2206_all.zip using WINZIP or any unzip utility of your choice.

Contents: 'fpesrv.jar'
This is common for all platforms, so if you extracted it on Windows and your server is on
a different platform, you must transfer it to that machine.


3.3. Go to the 'bin' directory of your Performance Expert Server installation and save
the existing 'fpesrv.jar' (for all platforms) file to a new name as backup.
Note, that you must do it as root on UNIX and Linux platforms.

3.4. Copy the extracted 'fpesrv.jar' file into the 'bin' directory of
your Performance Expert Server installation.
Note, that you must do this step as root on UNIX and Linux platforms.

3.5. On UNIX and Linux platforms change the permissions of the file to 755,
the owner to root and group to system, you must do this step as root.

3.6. As DB2 instance owner start Performance Expert Server.


4.0	Back out Instructions

As long as the server has not been restarted (and therefore migrated the DB2PE
databases), you can rename your saved backup version of 'fpesrv.jar'.
Otherwise you must additionally delete the DB2PE databases by command:
    peconfig -deinstall
and recreate them by peconfig.
Then you can start the server.