Installation instructions for hot fix F90004 on HP-UX IPF

Installation Instructions for Hot Fix F90004

HP-UX IPF

Hot fix F90004 addresses the issue(s) in SAS Risk Management for Insurance 2.1_M1 on HP-UX IPF as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/F90.html#F90004

F90004 is a "container" hot fix that contains the following "member" hot fixes which will update the software components as indicated. See the Container Hot Fixes section in the Maintenance Install Tool (MIT) Usage Guide for more information about container hot fixes.

G55002 for SAS Detail Data Store for Insurance 5.4_M1
F88004 for SAS Firmwide Risk Management for Insurance Server 2.1_M1
F89004 for SAS Market Risk Management for Insurance Server 2.1_M1
F03003 for SAS Risk Dimensions Server Component 5.3_M1
G61002 for SAS Risk Management for Insurance Mid-Tier 2.1_M1
F12005 for SAS Risk Management for Insurance Server 2.1_M1
G54002 for SAS Risk Reporting Repository 1.4_M1
F92004 for SAS Underwriting Risk Management for Life Insurance Server 2.1_M1
F91004 for SAS Underwriting Risk Management for P&C Insurance Server 2.1_M1

Before applying this hot fix, follow the instructions in SAS Note 35968 to generate a SAS Deployment Registry report, then verify that the appropriate product releases are installed on your system. The software components and release numbers should match the list of software components updated by the individual hot fix installers.

IMPORTANT NOTES

Files delivered in this hot fix will be backed up during the installation process. However, it is good general practice to back up your system before applying updates to software.
When applying this hot fix, the -alwaysoverwrite option should be used. This option causes the hot fix to overwrite files that are currently on your system with the updated hot fix version of those files. ANY customizations that may have been made to files included in the hot fix will be lost. The hot fix installer will automatically back up files for you. After the hot fix has been installed, use the backup copies to merge any of the customizations that you wish to retain. Links to manifests are provided in the section above to assist in determining which files will be overwritten.
Configurations and related uncompiled macro files for the following reports will be updated as a part of this install:
ASSETS-D1
ASSETS-D1S
ASSETS-D2O
ASSETS-D3
ASSETS-D4
ASSETS-D5
ASSETS-D6
COUNTRY-K1
COVER-A1A
COVER-A1Q
G20
IGT1
IGT2
IGT3
IGT4
OF-B1Q
RC
RE-J1
RE-J2
RE-J3
RE-SPV
SCR-B2A
SCR-B3B
SCR-B3C
SCR-B3D
SCR-B3E
SCR-B3G
TP-E1
TP-E1Q
TP-E2
TP-E3
TP-E4
TP-E6
TP-E7A
TP-F1
TP-F1Q
TP-F2
TP-F3A
TP-F3B
The following reports will not be available as they have been dropped from the latest EIOPA templates. Metadata and configurations for the reports have been removed:
Cover-A1
C2_ANALYSIS_LF
C2_ANALYSIS_NL
C2_SUMMARY
G10
G15
G30
IGT5
IGT6
TP-E5
TP-E7

Following reports were added/updated in the metadata per latest EIOPA QRT list:
Assets-D1Q
Assets-D1S
Assets-D2O
Assets-D2T
Cover-A1A
Cover-A1Q
VA-C2A
VA-C2B
VA-C2C
VA-C2D
TP-E7A
TP-E7B

Descriptions (report names) for the following changed per latest EIOPA templates and have been updated in the metadata:
ASSETS-D1
G14
IGT1
IGT2
IGT3
IGT4
Re-J1
SCR-B2A
SCR-B2C
TP-E1
TP-E1Q
TP-E3
TP-E6
TP-F4
If you need to retain previous versions of these files, they can be retrieved from backup locations as needed.
You must have Administrator Privileges on your CLIENT or SERVER machine.
All currently active SAS sessions, daemons, spawners and servers must be terminated before applying this hot fix.
This hot fix should be installed using the same userid who performed the initial software installation.
On UNIX systems, you may need to adjust file permissions on all new and updated files to meet with your sites security guidelines.

INSTALLATION

This hot fix must be installed on each machine where the updated components of the product, listed above, are installed. The installation process will determine which components of SAS Risk Management for Insurance 2.1_M1 are installed on each machine, and apply the appropriate updates.

If the updated components of this product are installed on multiple operating systems, you must download the hot fix for the appropriate operating system(s) and follow the installation instructions provided to complete the deployment of this hot fix.

The installer downloaded is F90004hx.bin.

When downloading SAS 9.2 hot fix packages, you must choose to Save the hot fix to disk, then execute the install from the saved location. Attempting to install a hot fix directly from the download page results in the error documented in SAS Note 37104.

To install the hot fix:

1. Verify that the installation binary has execute permission. If it does not, use the chmod command to make it executable.

$> chmod 755 F90004hx.bin

2. Set your $DISPLAY environment variable

export DISPLAY=<your_node_name>:0

3. Execute F90004hx.bin using the "-alwaysoverwrite" command line option:

<path_to_downloaded_file>/F90004hx.bin -alwaysoverwrite

For example:

./F90004hx.bin -alwaysoverwrite

This will initiate the installation wizard, which will guide you through the hot fix installation process. During the installation you will be prompted for the SASHOME location to be updated. You should provide the path to the top level SAS directory where the deploymntreg directory exists.

See the Maintenance Install Tool (MIT) Usage Guide for more details on the installation of hot fixes.

The content of this hot fix is listed in the hot fix manifest.

This completes the installation of F90004. You must perform any "Post-Installation Instructions" documented below to successfully complete the deployment of this hot fix.

POST-INSTALLATION INSTRUCTIONS

For each product installed, click the link to be redirected to post-installation instructions.

G55002 for SAS Detail Data Store for Insurance 5.4_M1
F88004 for SAS Firmwide Risk Management for Insurance Server 2.1_M1
F89004 for SAS Market Risk Management for Insurance Server 2.1_M1
F03003 for SAS Risk Dimensions Server Component 5.3_M1
G61002 for SAS Risk Management for Insurance Mid-Tier 2.1_M1
F12005 for SAS Risk Management for Insurance Server 2.1_M1
G54002 for SAS Risk Reporting Repository 1.4_M1
F92004 for SAS Underwriting Risk Management for Life Insurance Server 2.1_M1
F91004 for SAS Underwriting Risk Management for P&C Insurance Server 2.1_M1

G55002 for SAS Detail Data Store for Insurance 5.4_M1

If you have existing DDS physical tables, take a backup of the data in a different location.
Following is the summary of the changes in this hot fix:
Newly added tables:
ACCOUNTING_TRANS
ACCOUNTING_TRANS_LINE_ITEM
ACCOUNT_PERIOD
ACCOUNT_PERIOD_ASSOC
ASSET_PORTFOLIO_SEGMENT
ASSET_PORTFOLIO_SGMNT_X_EXPOSURE
ASSET_SEGMENT_X_EXPOSURE
CEDED_LOSS
CONTRACT_SECTION_X_RI_CARRIER
CURRENCY_CONVERSION_RATE
EXPOSURE_PLEDGED
GL_SEGMENT_BALANCE
GL_SEGMENT_PARAMETER
GL_SEGMENT_PARAM_GROUP
REINSURANCE_COLLATERAL
REINSURANCE_CONTRACT
REINSURANCE_CONTRACT_SECTION
REINSURANCE_COVERAGE
REINSURANCE_COVERAGE_REFERENCE
REINSURANCE_INTERMEDIARY
REINSURANCE_PROGRAM
REINSURANCE_RATE
REINSURANCE_REINSTATEMENT
RISK_DRIVER
RISK_DRIVER_X_EXPOSURE
RI_TRANS_X_CEDED_LOSS
SUB_LEDGER
SUB_LEDGER_BALANCE
XL_LAYER
XL_LAYER_X_RI_CARRIER
Updated tables:
CREDIT_FACILITY
EMBEDDED_OPTIONS
FINANCIAL_ACCOUNT
FINANCIAL_INSTRUMENT
FINANCIAL_INSTRUMENT_CHNG
FUND_INSTRUMENT
PHYSICAL_ASSET
SECURITIZATION_POOL
Newly added columns:
```
Table Name				Column Name


CLAIM_UNIT				CLAIM_UNIT_CURRENCY_CD
					RECOVERY_ESTIMATED_AMT
					RECOVERY_RECEIVED_AMT

COVERED_PERILS				PERIL_RK

GENERAL_UNIT_OF_EXPOSURE		UNDERWRITING_MODEL_AMT
					UNDERWRITING_MODEL_TYPE_CD

GL_ACCOUNT				CONTROL_ACCOUNT_FLG

GL_ACCOUNT_BALANCE			ACCOUNT_PERIOD_RK
					GL_BALANCE_BASE_CURRENCY_CD
					GL_BALANCE_REPT_CURRENCY_CD
					REPORTING_METHOD_CD

GL_JRNL					REVERSAL_DESC
					EVERSAL_REASON_CD
					REVERSED_GL_JRNL_ID

GL_JRNL_DETAILS				ACCOUNT_PERIOD_RK

PERIL					PERIL_RK
					VALID_FROM_DTTM
					VALID_TO_DTTM

REINSURANCE_CARRIER			PARTICIPATION_LIMIT_AMT
					RI_CARRIER_RK
					RI_CARRIER_TYPE_CD
					RI_NETWORK_ID

REINSURANCE_EXPOSURE			CEDING_COMMISSION_AMT
					RI_AMT_SHARE
					RI_CONTRACT_SECTION_RK
					RI_EXP_EFFECTIVE_DT
					RI_EXP_EXPIRATION_DT

REINSURANCE_TRANS			RI_CONTRACT_RK
					RI_CONTRACT_SECTION_RK
					RI_REINSTATEMENT_RK
					XL_LAYER_RK

REINSURANCE_TRANS_LINE_ITEM		LINE_ITEM_TRANS_AMT
					RI_CONTRACT_RK
					RI_CONTRACT_SECTION_RK

RI_TRANS_X_RI_EXPOSURE			RI_CONTRACT_RK
					RI_EXP_TRANS_AMT
```
Renamed Columns:
The column ASSET_PORTFOLIO_X_EXPOSURE__RK from ASSET_PORTFOLIO_SGMNT_X_EXPOSURE table had a typo. It has been renamed to ASSET_PORTFOLIO_X_EXPOSURE_RK.
Deprecated tables and columns:
A few tables and columns have been deprecated from previous versions. They will be removed physically in the future. The comment for such objects has been updated to "DEPRECATED" and can be used to know if the table or column is deprecated.
If you already have existing DDS physical tables, then execute the ddls of the tables which have undergone changes as mentioned in point 2 above from <SASHOME>/SASFoundation/9.2/misc/insurancedds/insurancedds_5.4M1/ddl folder.
If you do not have existing DDS physical tables, then execute the ddlgen.sas file present in <SASHOME>/SASFoundation/9.2/misc/insurancedds/insurancedds_5.4M1/ddl folder.
If you already have existing DDS physical tables, migrate data for those tables which are updated in this hot fix.
Copy the files present in <SASHOME>/SASFoundation/9.2/misc/insurancedds/insurancedds_5.4M1/metadata/ folder to a location which can be accessed by DI studio client.
Open DI studio and logon as unrestricted user.
If you have existing metadata for DDS, backup the same.
If you do not have existing metadata for DDS, then import insurancedds_54m1_sas.spk followed by insurancedds_54m1_hf2_sas.spk.
If you have existing metadata for DDS hot fix 1 on top of 5.4_M1, then import insurancedds_54m1_hf2_sas.spk.
Notes:
1. Before importing the insurancedds_54m1_hf2_sas.spk, please delete the table SCHEDULE_X_TREATY from the destination metadata server using DI Studio from the folder /Products/SAS Detail Data Store For Insurance/DDS5.4_M1/01] INSURANCE PRODUCT.
2. The table ASSET_PORTFOLIO_SGMNT_X_EXPOSURE has been renamed to ASSET_SEGMENT_X_EXPOSURE. The data if existing in the original table needs to be migrated to the newly created table. Please note that the column ASSET_PORTFOLIO_X_EXPOSURE__RK in the original table is represented as ASSET_SEGMENT_X_EXPOSURE_RK in the new table.

For detailed instructions of creating physical table and importing metadata, please refer to SASŽ Detail Data Store for Insurance 5.4 Second Edition.

F88004 for SAS Firmwide Risk Management for Insurance Server 2.1_M1

NONE

F89004 for SAS Market Risk Management for Insurance Server 2.1_M1

NONE

F03003 for SAS Risk Dimensions Server Component 5.3_M1

NONE

F12005 for SAS Risk Management for Insurance Server 2.1_M1

Import updated .spk files:

Backup existing metadata
Import delivered SPK files using SAS MC Import/Export SAS Package wizard
1. Import updated analysis.spk for the Firmwide component. You can skip this step if you had already performed the manual STP creation steps when installing HF3.
  1. Login to SAS Management Console (SMC) as the Administrator (sasadm) user
  2. Click on the Folders tab
  3. Navigate to the folder Analysis under System -> Applications -> SAS Risk Management for Insurance -> Firmwide Risk Server 2.1
  4. Right-click on the Analysis folder and select Import SAS Package from the menu
  5. Browse to <SASHOME>/misc/rmifirmmva/Config/Deployment/Packages and select the analysis.spk file.
  6. Select the radio button for New Objects Only and click Next
  7. You should see the following STPs in the window. Click Next and then Next again.
    1. ASSET_VALUATION_HSLT_SCEN
    2. HEALTH_CAT_SOLVENCY
    3. HNSLT SOLVENCY
    4. HSLT_SOLVENCY
    5. HSLT_VALUATION_SCEN_LF
  8. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
  9. On this screen, map source code repositories between original and target application servers. Choose the path to the <SASHOME>\rmicomnsvr\sasstp folder. Click Next.
  10. Review the Summary information and click Next if correct. Otherwise, click on the Back buttons to make necessary corrections in earlier steps.
  11. The next screen should show that the import was completed. Click the View Log button and scan the log for any errors. If the import was successful, you should see messages such as the below in the log:
    
    Create 5 Stored process objects:
    1. /System/Applications/SAS Risk Management for Insurance/Firmwide Risk Server2.1/Analysis/ASSET_VALUATION_HSLT_SCEN
    2. /System/Applications/SAS Risk Management for Insurance/Firmwide Risk Server2.1/Analysis/HEALTH_CAT_SOLVENCY
    3. /System/Applications/SAS Risk Management for Insurance/Firmwide Risk Server2.1/Analysis/HNSLT_SOLVENCY
    4. /System/Applications/SAS Risk Management for Insurance/Firmwide Risk Server2.1/Analysis/HSLT_SOLVENCY
    5. /System/Applications/SAS Risk Management for Insurance/Firmwide Risk Server2.1/Analysis/HSLT_VALUATION_SCEN_LF
  12. Click Ok and then Finish.
  13. You should now see the five newly created STPs in the Analysis Folder.
2. Import updated reports.spk for the RMI Common Server component
  1. Login to SAS Management Console (SMC) as the Administrator (sasadm) user
  2. Click on the Folders tab
  3. Navigate to the folder Reports under System -> Applications -> SAS Risk Management for Insurance -> Risk Management for Insurance Server 2.1
  4. Right-click on the Reports folder and select Import SAS Package from the menu
  5. Browse to <SASHOME>/misc/rmicomnsvr/Config/Deployment/Packages and select the reports.spk file.
  6. Select the radio button for All Objects and click Next
  7. You should see a list of STPs in the window. Click Next and then Next again.
  8. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
  9. On this screen, map source code repositories between original and target application servers. Choose the path to the <SASHOME>\rmicomnsvr\sasstp folder. Click Next.
  10. Review the Summary information and click Next if correct. Otherwise, click on the Back buttons to make necessary corrections in earlier steps.
  11. The next screen should show that the import was completed. Click the View Log button and scan the log for any errors. If the import was successful, you should see messages such as "The import process completed successfully" in the log.
  12. Click Ok and then Finish.
  13. If required, selectively import metadata from the backup SPK (refer to Step 1) for only those QRTs that were customized earlier and are not delivered in the hot fix.
3. Import updated system.spk for the RMI Common Server component
  1. Click on the Folders tab
  2. Navigate to the folder System under System -> Applications -> SAS Risk Management for Insurance -> Risk Management for Insurance Server 2.1
  3. Right-click on the System folder and select Import SAS Package from the menu
  4. Browse to <SASHOME>/misc/rmicomnsvr/Config/Deployment/Packages and select the system.spk file.
  5. Select the radio button for All Objects and click Next
  6. You should see a list of STPs in the window. Click Next and then Next again.
  7. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
  8. On this screen, map source code repositories between original and target application servers. Choose the path to the <SASHOME>\rmicomnsvr\sasstp folder. Click Next.
  9. Review the Summary information and click Next if correct. Otherwise, click on the Back buttons to make necessary corrections in earlier steps.
  10. The next screen should show that the import was completed. Click the View Log button and scan the log for any errors. If the import was successful, you should see a message such as "The import process completed successfully" in the log.
  11. Click Ok and then Finish.
  12. You should now see a new "Job name" parameter in the Parameters tab for the REPORT_OPTIONS STP.
4. Import updated utilities.spk for the RMI Common Server component
  1. Click on the Folders tab
  2. Navigate to the folder Utilities under System -> Applications -> SAS Risk Management for Insurance -> Risk Management for Insurance Server 2.1
  3. Right-click on the Utilities folder and select Import SAS Package from the menu
  4. Browse to <SASHOME>/misc/rmicomnsvr/Config/Deployment/Packages and select the utilities.spk file.
  5. Select the radio button for All Objects and click Next
  6. You should see a list of STPs in the window. Click Next and then Next again.
  7. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
  8. On this screen, map source code repositories between original and target application servers. Choose the path to the <SASHOME>\rmicomnsvr\sasstp folder. Click Next.
  9. Review the Summary information and click Next if correct. Otherwise, click on the Back buttons to make necessary corrections in earlier steps.
  10. The next screen should show that the import was completed. Click the View Log button and scan the log for any errors. If the import was successful, you should see a message such as "The import process completed successfully" in the log:
  11. Click Ok and then Finish.
  12. You should now see the following STPs in the Utilities folder:
    RE_J1
    RE_J2
    RE_J3
    TP_E4
5. Import updated rmi_etl_bridge_m1_hf5.spk for the RMI Solution Data Mart (SDM) ETL jobs
  1. Following is the summary of the newly added and modified jobs in this hot fix:
    Newly added jobs:
    
    Job Name
    RMI_INT_100_I_ASSET_SGMNT_X_EXPOSURE
    RMI_INT_100_I_EXPOSURE_PLEDGED
    RMI_STG_230_ASSET_PORTFOLIO_SEGMENT
    RMI_STG_230_ASSET_SGMNT_X_EXPOSURE
    RMI_STG_230_EXPOSURE_PLEDGED
    RMI_STG_230_RISK_DRIVER
    RMI_STG_230_RISK_DRIVER_X_FIN_CONTR
    RMI_STG_210_GENERAL_INSURANCE_SUBJECT
    
    Modified Jobs:
    
    Job Name
    RMI_INT_100_I_CREDIT_FACILITY
    RMI_INT_100_I_EMBEDDED_OPTIONS
    RMI_INT_100_I_FINANCIAL_INSTRUMENT
    RMI_INT_100_I_FINANCIAL_INSTRUMENT_CHNGM
    RMI_INT_100_I_FINANCIAL_INSTRUMENT_ISSUE
    RMI_INT_100_I_FINANCIAL_POSITION
    RMI_INT_100_I_PHYSICAL_ASSET
    RMI_INT_105_I_FINANCIAL_ACCOUNT
    RMI_INT_110_I_ACCT_POS_INST_FCLTY_APPEND
    RMI_STG_210_FUND_INSTRUMENT
    RMI_STG_210_SECURITIZATION_POOL_MART
    RMI_STG_230_EMBEDDED_OPTIONS
    RMI_STG_230_FINANCIAL_CONTRACT
    RMI_STG_230_FINANCIAL_CONTRACT_ISSUE
    RMI_STG_230_FINANCIAL_EXPOSURE
    RMI_STG_230_OPTION_SCHEDULE
    RMI_STG_230_SWAP_INSTRUMENT
    RMI_STG_210_CLAIM_HISTORY
    RMI_STG_230_PHYSICAL_ASSET
    RMI_STG_210_COVERED_PERILS
  2. If you already have existing RMI21.M1 ETL jobs, then import the rmi_etl_bridge_m1_hf5.spk file from <SASHOME>/SASRiskManagementForInsuranceMidTier/2.1/ETL folder as explained below.
    Note: If RMI21.M1 ETL is not existing then first import rmi_etl_bridge.spk from the same location.
  1. Login to SAS DI Studio as the Administrator (sasadm) user
  2. Click on the Folders tab
  3. Navigate to the folder Products
  4. Right-click on the Products folder and select Import SAS Package from the menu
  5. Browse to /SASRiskManagementForInsuranceMidTier/2.1/ETL and select the rmi_etl_bridge_m1_hf5.spk file.
  6. Select the radio button for All Objects and click Next
  7. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
  8. Review the Summary information and click Next.
  9. The next screen should show that the import was completed. Click the View Log button and scan the log for any errors. If the import was successful, you should see a message such as "The import process completed successfully" in the log
  10. Click Ok and then Finish.
If required, selectively import metadata from the backup SPK (refer to Step 1) for only those QRTs that were customized earlier and are not delivered in the hot fix.

Follow the steps below to regenerate the Solution Data Mart (SDM):

Locate the create_solution_data_mart.sas file in your install: in a typical install, the macro resides under SASHOME/misc/rmicomnsvr/solution_data_mart
Open the create_solution_data_mart.sas file in a BASE SAS session on the installation server (where the SAS code resides)
Scroll to the bottom of the macro file and comment out the following line:
%create_solution_data_mart(
soln_data_mart_dir=&sysparm,
fca_c_lib_nm=FINCAD_Suite_32_2011,
fea_c_lib_nm=intrlib,
run_tps_fincad_flag=N,
run_tps_fea_flag=N );
Compile the macro in the SAS session by clicking the Submit button on the menu
After successful compilation, execute the following macro below:
%create_solution_data_mart(soln_data_mart_dir=<complete path to indata directory in your install>);
Example of indata path: <CONFIGDIR>/AppData/SASRiskManagementForInsurance/2.1/indata
Check the SAS log for successful execution of the preceding macro.

In addition, complete the following to recreate any shared entity data marts and user directories.
Delete all user folders found in
<SASCONFIG>/Lev1/AppData/SASRiskManagementForInsurance/2.1/data/userdata
Login to Risk Management for Insurance 2.1
Select File > Select Entity, choose an entity from the list, and click OK.
Re-create the shared data mart for that entity.
Select File > Manage Shared Data Mart from the menu and click Delete, then click Create in the same Manage Shared Data Mart window.
Repeat steps 8 and 9 for each Entity
The following steps update a loading mapping configuration:
To load sample data in to the private SAS Risk Reporting Repositories:
Execute the following code in SAS to create sample data with the appropriate information for your installation:
For example:

options metauser="sasdemo" metapass="Pass99"
metaserver="rdcesx05105.race.sas.com" metaport=8561 metarepository="Foundation";
%rmiinit;
%rmi_batch_create_rrr_sample_data(ENTITY=MAIN,USERNAME=sasdemo,SCOPE=P);

G54002 for SAS Risk Reporting Repository 1.4_M1

Data model changes have been made to the SAS Risk Reporting Repository. You must update the structures of the private RRR locations and Shared location.

There are different ways in which to apply the new structure. Please select one of the following methods that is applicable to your installation(s).

NB: If the post-installation tasks for F12005 has been applied, the structures of the Private locations will be automatically updated with the latest reportmart structure the F12005 post-installation tasks. and the subsequent methods are not necessary for applying the data model changes to private RRR locations. The following methods can be applied to both the private and shared locations depending on the state of your installation.
1. Updating via the provided sample data:
If a given reportmart location has not been updated by another process, creating the shipped reportmart sample data in a given location will install the data model changes.
The shipped sample data scripts already contain the updates in the RRR data model/formats. If you would like to utilize the shipped RMI sample data for the RRR without maintaining existing data, create the RRR sample data using the following steps.
Note: The sample data creation script does not depend on the version of the original RRR that is being overwritten. This script will overwrite the existing data and data model. For example, if you are have the RRR 14 m1 version of the RRR and are installing the second RRR hotfix, by creating the shipped sample data you do not need to install the "sample data for the previous hotfix". The shipped sample data is a snapshot of the given version.
Submit the following code with your installation specific information. (Note: This has changed from previous releases as you are now required to submit the rmiinit; prior to submitting the batch program.)
options metauser="sasdemo" metapass="Pass99" metaserver="rdcesx05105.race.sas.com" metaport=8561 metarepository="Foundation";
%rmiinit;
%rmi_batch_create_rrr_sample_data(ENTITY=MAIN,USERNAME=sasdemo,SCOPE=P);
* If you need to install the reportmart sample data to the Global RRR with the sample data script, you must submit the following code with the additional information and changes:
%let rrr_user=sasdemo;
%let rrr_password=Pass99;
options metauser="sasdemo" metapass="Pass99" metaserver="rdcesx05105.race.sas.com" metaport=8561 metarepository="Foundation";
%rmiinit;
%rmi_batch_create_rrr_sample_data(ENTITY=MAIN,USERNAME=sasdemo,SCOPE=S);

NOTE: It is not recommended that you use this process on the Global RRR unless you are absolutely certain of your specific installation needs. The script as shown above deletes the Global RRR and replaces the location with the new version of the RRR with the shipped sample data ONLY. All data in the Global location will be lost using this process.
2. Updating an existing install with alter/migration scripts:
If you have existing data in your reportmart and wish to only apply the data model changes, execute the specific alter scripts for your given installations:
A. If the reportmart is the RRR14m1 version: execute %run_rrr14m1_to_rrr14m1hf2. Follow the instructions to execute this alter script in the PDF document m1rrr14_to_m1rrr14hf2_instructions.pdf that has been delivered with the alter scripts. These files will be typically located in the following directory:
Win:
<SASHOME>\SASFoundation\9.2\rskrptmrtvrt\sasmisc\alterscripts\hotfix_2\m1_to_hotfix2
Unix:
<SASHOME>/SASFoundation/9.2/misc/rskrptmrtvrt/alterscripts/hotfix_2/m1_to_hotfix2
B. If the reportmart is the RRR14m1HF1 version, execute %run_rrr14m1hf1_to_rrr14m1hf2. Follow the instructions to execute this alter script in the PDF document m1rrr14_to_m1rrr14hf1_instructions.pdf that has been delivered with the alter scripts. These files will be typically located in the following directory:
Win:
<SASHOME>\SASFoundation\9.2\rskrptmrtvrt\sasmisc\alterscripts\hotfix_2
Unix:
<SASHOME>/SASFoundation/9.2/misc/rskrptmrtvrt/alterscripts/hotfix_2

3. Installing a new reportmart using the ddls/createrrr.sas script:
If you would like to create a new RRR with the new data model, follow the instructions for installing a clear RRR in the Installing and Configuring the SAS Risk Reporting Repository section in the SAS Risk Reporting Repository 1.4 Reference Guide, Second Edition.

F92004 for SAS Underwriting Risk Management for Life Insurance Server 2.1_M1

NONE

F91004 for SAS Underwriting Risk Management for P&C Insurance Server 2.1_M1

NONE

G61002 for SAS Risk Management for Insurance Mid-Tier 2.1_M1

Re-build and Re-deploy Web Application
This hot fix requires that the WebApp be rebuilt and redeployed. Use the following steps to perform this post-installation task:

Step 1: Re-build Web Application
In order for this step to execute correctly, the Metadata Server must be running.
1.1 Invoke the SAS Deployment Manager 9.2
From the SASDeploymentManager directory launch config.sh.
SAS Deployment Manager is installed in the following default location:
<SASHOME>/SASDeploymentManager/9.2

1.2 Select a language in the Choose Language box
1.3 Select Rebuild Web Applications
1.4 Select Configuration Directory or Enter the Configuration Directory and Level that needs to be updated
1.5 Specify Connection Information, including the sasadm User ID and Password
1.6 Select Risk Management for Insurance as the Web Application to Rebuild
1.7 Verify the information on the Summary screen and select Start
1.8 Select Finish when the deployment is complete
This process will update the Risk Management for Insurance ear in <SASCONFIGDIR>/Web/Staging.
A backup of the original ear file will be placed in the directory below:

<SASCONFIGDIR>/Web/Staging/Backup

Step 2: Re-deploy Web Applications
Re-deploy the web applications based on the instructions for the web application server you are using.

Step 3: Copy files into the application's deployed ear file
Copy files into your application servers deployed EAR for SAS Risk Management for Insurance as follows:
From: <SASHOME>/SASRiskManagementForInsuraceMidTier/2.1/Static/wars/sas.solutions.risk.rmi/WEB-INF/web.xml
To: sas.solutions.risk.rmi.ear /sas.solutions.risk.rmi.war/WEB-INF/web.xml

From: <SASHOME>/SASRiskManagementForInsuraceMidTier/2.1/Static/wars/sas.solutions.risk.rmi/WEB-INF/spring-config/app-config.xml
To: sas.solutions.risk.rmi.ear /sas.solutions.risk.rmi.war/WEB-INF/spring-config/app-config.xml

Re-start the application (or the application server) using your application servers admin console.

This completes the installation of hot fix F90004 on HP-UX IPF.