Table of Contents

Search

  1. Preface
  2. Backing Up and Restoring the Data Vault
  3. Configuring Centera as a Remote Data Vault Store
  4. Configuring Data Archive for a Legacy Source Using Legacy Adapters
  5. Data Archive Seamless Access for PeopleSoft
  6. Data Archive Transaction Restore API
  7. Dropping and Truncating Partitions in Data Archive
  8. High Availability Configuration for the Data Archive and File Archive Service Versions 6.1 to 6.3
  9. 0955-High Availability Configuration for the Data Vault Version 6.4 and Later
  10. How to Create Business Rules to Archive and Purge Transactional Data
  11. How to Uninstall Data Archive 5.1
  12. How to Uninstall Data Archive 5.3
  13. How to Use Scripts to Change Database User Passwords in the ILM Repository
  14. IBM DB2 Database Connectivity and Setup for Data Archive
  15. Installing Data Visualization
  16. Integrating Third-Party Schedulers in ILM Engine
  17. Parallel Processing in Data Archive
  18. Seamless Access Configuration for Siebel Applications
  19. Seamless Access Setup for Oracle E-Business Suite
  20. Using the Data Vault Service JDBC Driver to Connect to the Data Vault
  21. Using Multiple Engines in an ILM Environment
  22. Using PowerExchange ODBC Connections in a Data Archive Retirement Project
  23. Discovering Foreign Key Relationships in Enterprise Data Manager

Data Archive How-To Guide

Data Archive How-To Guide

Properties File

Properties File

The script uses values in a properties file to connect to the ILM repository and to change the passwords. You create and configure the properties file before you run the script.
The following table describes the required properties for the properties file:
Property
Description
amhome.connection.host
ILM repository host name.
amhome.connection.port
ILM repository port number.
amhome.connection.sid
ILM repository database service name or database name.
amhome.connection.username
ILM repository user name.
amhome.connection.password
ILM repository user password.
amhome.connection.schemaname
Unique database placeholder for tables.
amhome.connection.validate.sql
Script that determines if the installation repository is the ILM repository.
amhome.values.separator
Symbol that indicates the separation of multiple values for the other properties. Use a unique value that is not used in the database names or passwords. For example, use
@@
.
amhome.rep.names
ILM repository database schema name for the Admin, Apps, or Staging schemas. Use the same name as the
Schema Name
field in the Edit Archive Source or Edit Archive Target menu.
To enter multiple values, use the separator that you defined for the
amhome.values.separator
property. For example, enter
SYSTEM@@STAGING
to change the password for the SYSTEM and STAGING database schemas.
amhome.rep.usernames
Login name for the database schema or the Data Vault user. Use the same name as the
Login Name
field in the Edit Archive Source or Edit Archive Target menu.
To enter multiple values, use the separator that you defined for the
amhome.values.separator
property.
amhome.rep.newpasswords
New password for the login name.
To enter multiple values, use the separator that you defined for the
amhome.values.separator
property.