IBM Informix SQL Warehousing Tool, Version 11.70

Changing the connection settings to the metadata repository

The connection settings to the metadata repository are stored in a properties file named metadb.properties. You can change these connection settings by using the metadbconfig tool, or by editing the metadb.properties file directly.

Procedure

To change the connection settings to the metadata repository:

Change the connection settings by using the metadbconfig tool, or by editing the metadb.properties file directly.
Option Description
Run the metadbconfig tool
  1. Go to the ISW_directory/config/cmdutils directory.
  2. Read the readme file.
  3. Run the metadbconfig tool with options.
For example, if you must change the password for the user ID to the value myNewPassword, run the following command:
metadbconfig.bat -update 
  -password myNewPassword
Edit the metadb.properties file directly
Restriction: You cannot change the password with this option.
  1. Go to the ISW_directory/config directory.
  2. Open the metadb.properties file.
  3. Edit the connection settings, and then save the file.

You must restart the Warehouse Administration Console for the changes to take effect. You can restart the Warehouse Administration Console on the Enterprise Application page of the WebSphere® Administrative Console:

  • For WebSphere Application Server V7, click Applications > Application Types > WebSphere enterprise application.
  • For WebSphere Application Server V6.1, click Applications > Enterprise application.


Feedback | Information roadmap | Examples exchange