IBM DB2 Grouper Version 1 Release 1 Interim Fix 1, Install Instructions


1.0	Prerequisites

2.0	Problem Description

3.0	Installation Instructions

4.0	Back out Instructions

___________________________________________________________________

1.0 	Prerequisites

DB2 Grouper V1.1 is required in order to use Interim Fix 1.


2.0	Problem Description

Grouper 1.1, Interim Fix 1 solves the following problem:

- A view, which is one of the interfaces for tools that need to access Grouper data,
has incorrect column names. This fix is needed for DB2 Test Database Generator.

3.0	Installation Instructions

1.  Navigate to the DB2 Grouper server installation directory. The system environment
    variable, 'EGFSERVERHOME' contains the name of the server installation directory.
    (The default installation directory is: C:\program files\IBM\Grouper\server)
2.  Navigate to one of its sub-directories called 'schema'.
3.  Rename the file egffishl.db2 to egffishl_old.db2
4.  copy the file provided with this interim fix, egffishl.db2, into the sub-directory 
	'schema'.
5.  Copy dropfishl.db2 into the sub-directory 'schema'.
6.  Run the following commands (from a DB2command line processor window, containing DB2's
    SQLLIB\bin(SQLLIB/bin) directory in the PATH environment variable) against all the 
    databases on which Grouper has been deployed:
    . db2 connect to <databasename> using <userid>
      (note: you will be prompted for password)
    . db2 -ntf dropfishl.db2
    . db2 -ntf egffishl.db2
    (note: these commands are to be run from the sub-directory 'schema') 


4.0	Back out Instructions

1.  Navigate to the DB2 Grouper server installation directory. The system environment
    variable, 'EGFSERVERHOME' contains the name of the server installation directory.
    (The default installation directory is: C:\program files\IBM\Grouper\server)
2.  Navigate to one of its sub-directories called 'schema'.
3.  Rename egffishl.db2 to egffishl_new.db2
4.  Rename egffishl_old.db2 to egffishl.db2
5.  Run the following commands (from a DB2 command line processor window, containing DB2's 
    SQLLIB\bin(SQLLIB/bin) directory in the PATH environment variable) against all the 
    databases on which Grouper has been deployed:
    . db2 connect to <databasename> using <userid>
      (note: you will be prompted for password)
    . db2 -ntf dropfishl.db2
    . db2 -ntf egffishl.db2
    (note: these commands are to be run from the sub-directory 'schema')