Action Catalog data export and import

The Adaptive Action Manager provides a command-line tool you can use for exporting the defined actions and templates data stored in the action catalog database to an XML file. This file can be imported again into another action catalog database. You do not have to redefine the actions and templates, for instance, when you are moving from a testing environment to the production environment.

The export and import is performed using a command-line tool, Importer.java, that is initiated by running a batch file, runAAMExport.bat. This tool uses a properties file, config.properties, that contains required properties and the values needed for the export and import operations. By editing these properties, you can determine whether the tool will export the data in the action catalog database to the XML file or import the XML file to the action catalog database. You can change the properties that indicate the source and destination of the tool. You can export data from an existing action catalog to an XML file with one run of the tool. Later, you can change the configuration parameters in the properties file and run the tool again to import the data from the XML file to a new action catalog database. If this new action catalog database contains any actions data, it will be replaced with the imported data for the identical records (identical templates, identical situation-event binding names).

You can override the configuration parameters in the config.properties file by using the –D command in the command line from which you are running the runAAMExport.bat, and then include the parameters with different values in this command. You can use this command to invoke the tool with new values for the parameters without having to change these values in the config.properties file.

The action catalog data export and import tool provides logging and tracing. The logging and tracing feature is configured using the logging.properties file that is located in the same directory that contains the runAAMExporter.bat file. The logging.properties file conforms to the JSR47 specification format for controlling logging. By default, this file is set to log to the command prompt window from which you run the tool. You can reconfigure this file to use different handlers, log levels, and formats. Refer to the JSR47 documentation before editing the logging.properties file for details about its contents and how to change the values of its properties.

The following table contains the available configuration parameters in the config.properties file, with their possible valid values.

Note: If you specified the XML file as the target of the tool (in the ActionManager.to.type property), then you only need to set the value for the ActionManager.to.XmlFilename property. All the target database-related properties are not needed and will be bypassed. If you have specified the XML file as the source of the tool (specified in the ActionManager.from.type property), you only need to set the value for the ActionManager.from.XmlFilename property. All source database-related properties are not needed and will be bypassed. You only need to fill in database information when using a database and to fill in XML information when using XML.
Action Catalog data export and import tool configuration properties
Property name Description Valid values

ActionManager.from.moveGlobalConfig

Determines whether to export the static configuration, which is in the action catalog database. true, false

ActionManager.to.type

Determines the output type of the tool (action catalog database or XML file). CM_DB_LAYER, XML

ActionManager.to.serverName

The server name or IP address of the server machine where the target action catalog database resides. For example, localhost

ActionManager.to.portNumber

The port number of the action catalog database to which you are moving the data. For example, the DB2® default port number is 5000.

ActionManager.to.driverType

The DB2 driver type for the action catalog database to which you are moving the data. 2 or 4. (The default value is 4.)

ActionManager.to.dbName

The name of the action catalog database to which you are moving the data. The default database name is AAMCAT.

ActionManager.to.schemaName

The Schema of the action catalog database to which you are moving the data. The default Schema name is AAMCAT.

ActionManager.to.username

The user name of a user with enough authorizations on the action catalog database to which you are moving the data.  

ActionManager.to.password

The password of the given user name on the action catalog database to which you are moving the data.  

ActionManager.to.XmlFilename

The path and name of the XML file to which you are moving the data. (On the Windows® platform, use a double backslash in the file path.) For example, C:\\AAMCAT.XML

ActionManager.to.overwriteXML

Determines whether you want to overwrite the XML file, if it exists. true, false

ActionManager.from.type

Determines the input source type of the tool (action catalog database or XML file). CM_DB_LAYER, XML

ActionManager.from.serverName

The server name or IP address of the server machine where the source action catalog database resides. For example, localhost

ActionManager.from.portNumber

The port number of the action catalog database from which you are moving the data. For example, the DB2 default port number is 5000.

ActionManager.from.driverType

The DB2 driver type for the action catalog database from which you are moving the data. 2 or 4. (The default value is 4.)

ActionManager.from.dbName

The name of the action catalog database from which you are moving the data. The default database name is AAMCAT.

ActionManager.from.schemaName

The Schema of the action catalog database from which you are moving the data. The default Schema name is AAMCAT.

ActionManager.from.username

The user name of a user with enough authorizations on the action catalog database from which you are moving the data.  

ActionManager.from.password

The password of the user name on the action catalog database from which you are moving the data.  

ActionManager.from.XmlFilename

The path and name of the XML file from which you are moving the data. (On the Windows platform, use a double backslash in the file path.) For example, C:\\AAMCAT.XML
Related tasks
Using the Action Catalog database export and import tool

Copyright IBM Corporation 2005, 2006. All Rights Reserved.