Working with BIRT iHub utilities : Working with System Data Store Administrator : Specifying System Data Store Administrator properties
 
Specifying System Data Store Administrator properties
The system data store is a separate schema in the database that stores iHub metadata. The system schema is a required element for any iHub installation. In a cluster, the nodes share the system schema metadata and use this information to communicate and coordinate processing.
In iHub, it is not necessary to back up the iHub system schema, although future versions may require this procedure to protect critical system metadata. If a system schema becomes corrupted or is accidentally deleted, the administrator can use the System Data Store Administrator utility to create a new schema. You can define a new system schema in Configuration Console or edit acserverconfig.xml to refer to the current system schema.
Use the System Data Store Administrator utility to perform the following tasks:
*Create or delete a schema.
*Populate or depopulate a schema.
*Import or export data.
Before running the System Data Store Administrator utility, edit the PATH environment variable on your machine to contain the following string:
<AC_SERVER_HOME>/bin
where AC_SERVER_HOME refers to the iHub installation path. For example, using the default value for AC_SERVER_HOME, add:
/home/actuate/iHub/AcServer/bin
To run the System Data Store Administrator utility, perform the following tasks:
1 Navigate to AC_SERVER_HOME/bin.
2 Create a properties file containing the property definitions necessary to perform an operation, such as creating and populating a system schema, described in “Performing operations using the System Data Store Administrator utility,” later in this chapter. You pass this file to the System Data Store Administrator utility when you execute it.
3 Create a script or run the administrate_system_data_store.sh script, passing in the name of the properties files as an argument, using the following command line syntax:
sh ./administrate_system_data_store.sh systemdatastore .properties
Alternatively, you can execute the utility by running the upgrdsds.sh script, using the following command-line syntax:
sh ./adminsds systemdatastore.properties
The script performs the following operations, as shown in Listing 11‑1:
*Checks to see if the administrator submitted a property file on the command line when running the script.
*If the administrator does not submit an argument, the script echoes a usage statement that describes the command-line syntax.
*Calls the set_tools_environment.sh script, which sets the environment variables.
*Executes the System Data Store Administrator utility using the name of the properties file as an argument.
Listing 11‑1 administrate_system_data_store.sh
#!/bin/sh
 
if [ "x$1" = "x" ]; then
echo "Usage: administrate_system_data_store.sh <properties file name>"
exit 1
fi
 
# Set up environment variables
. `dirname $0`/set_tools_environment.sh
 
# Administrate data store
java com.actuate.iserver.system.datastore.admin.SystemDataStoreAdministrator "$PROPERTY_FILE"
The SystemDataStoreAdministrator class has the same parent class as the Encyclopedia Data Store Administrator and uses the same property settings. System Data Store Administrator properties include the following categories:
*Properties that specify details of the iHub installation environment, such as AC_SERVER_HOME and AC_DATA_HOME
*Database properties that specify the RDBMS type and JDBC connection details, such as the schema, application user, and superuser names and passwords
*Schema operation properties that specify an action to perform, such as create, populate, or delete a schema
*Logging properties that control messages sent to the console and log files
*Engineering properties used by Actuate Support or Professional Services to assist with diagnosing or resolving specific issues
Refer to the required and optional properties tables in “Specifying Encyclopedia Data Store Administrator properties,” earlier in this chapter, for detailed information about these properties.