*************************************************************** {COPYRIGHT-TOP}
* Licensed Materials - Property of IBM
* Restricted Materials of IBM
* IBM Tivoli Usage and Accounting Manager
* 5724-O33, 5765-UAV, 5765-UA7, 44E7863
* (c) Copyright IBM Corp. 2004, 2008 All Rights Reserved.
*
* US Government Users Restricted Rights - Use, duplication or
* disclosure restricted by GSA ADP Schedule Contract with
* IBM Corp.
**************************************************************** {COPYRIGHT-END}



1. Description

Interim Fix 10 for TUAM 7.1.1 - fix also applies to TUAM 7.1.

This interim fix was created to solve the following Authorized Program 
Analysis Report (APAR):

*  APAR - IZ33827: The Budget column in the Line Item Budget report does not 
   match what is entered in the Budget Amount fields in the "Client Budget        
   Maintenence -> Client Detail" panel in the ISC console.     
                                                                  
   Additionally, the "Actual" column is showing values that are a multiple (the 
   multiple is equal to the number of users defined in this system) of  what is 
   showing up in the Invoice by Account Level report.      
  

                                                                  
2. Prerequisites 

You must be running TUAM 7.1.1. or 7.1.
  

  
3. Installation Instructions 

3.1 How to install the patch

For Windows: 
1. Extract the zip file to a temporary directory.
2. Open a command line window. 
3. Use the "cd" command to change to the temporary directory.
4. Type "applyFix.bat" into the command line window.
5. Deploy the new stored procedure to the database. See section 3.3.

For Linux, Unix:
1. Extract the tar file to a temporary directory.
2. Open a shell.
3. Use the "cd" command to change to the temporary directory.
4. Type "chmod u+x applyFix.sh" in the shell. This will change the rights 
   to applyFix.sh.
5. Type "./applyFix.sh" into the shell.
6. Deploy the new stored procedure to the database. See section 3.3.

3.2 How to uninstall the patch

For Windows:
1. Open a command line window. 
2. Use the "cd" command to change to the directory containing the extracted 
   zip file.
3. Type "undoFix.bat" into the command line window.
4. Redeploy the original stored procedure to the database. See section 3.3.

For Linux, Unix:
1. Open a shell.
2. Use the "cd" command to change to the directory containing the extracted 
   tar file.
3. Type "chmod u+x undoFix.sh" into the shell. This will change the rights 
   to undoFix.sh.
4. Type ./undoFix.sh into the shell.
5. Redeploy the original stored procedure to the database. See section 3.3.


3.3 Deploying the stored procedure to the database

1. Login to TUAM ISC Console.
2. Click "Usage and Accounting Manager -> System Maintenance -> Database -> 
   Objects Manager".
3. Click the "Select" checkbox for GET_LINEITEM_BUDGET.
4. Click "Drop" to drop the old version.
5. Click the "Select" checkbox for GET_LINEITEM_BUDGET again.
6. Click "Create" to apply the new version.

 
Problems (APARS) fixed: IZ33827