Generating usage reports

To run the FTM URT, begin by creating a working directory on the disk. For example, "C:\URT_work_dir". Then, copy each of the following files into it as needed:

• UsageReport.jar
• usageReport.properties
• messages.properties
• icu4j.jar
• FTMCoreJava.jar
• dbConnection4DB2.properties (Db2®)
• dbConnection4Oracle.properties (Oracle)
• db2jcc.jar (Db2)
• db2jcc_license_cisuz.jar (Db2 for z/OS®)
• db2jcc_license_cu.jar (Db2 for Linux®, UNIX, and Windows)
• ojdbc6.jar (Oracle)

Edit the database connection properties files and usageReport.properties, following the guidelines in Configuring the FTM URT. Then, encrypt (see Encryption of properties files) the database connection properties file and optionally, the usageReport.properties file. The nonencrypted versions of the now encrypted properties files can be removed.

To generate usage reports, start a Java™ command line, go to your working directory ("C:\URT_work_dir" in this example), and issue the following command:

<java path> -Djdbc.drivers=<JDBC driver> -cp <classpath> com.ibm.fxh.report.UsageReport

where:

• <java path> provides the path to the appropriate Java Runtime Environment. The file decryption and database connection encryption functions that are contained within the URT, and the file encryption functions that are contained within the tool that is used to encrypt one or more properties files, are sensitive to the version of Java used at run time. To avoid incompatibility issues, it is advised that the same IBM® provided version of Java is used to start each tool, such as that which comes with IBM App Connect Enterprise. For example, "C:\Program Files\IBM\MQSI\9.0.0.6\jre17\bin\java"
• <JDBC driver> is the appropriate JDBC driver value.
  • For Db2, use com.ibm.db2.jcc.DB2Driver.
  • For Oracle, use oracle.jdbc.OracleDriver.
• <classpath> is the path to all the various, required resources in the working directory. In this example, "C:\URT_work_dir\*".

Example (for Db2 on Windows) command prompt execution:

"C:\Program Files\IBM\MQSI\9.0.0.6\jre17\bin\java" -Djdbc.drivers=com.ibm.db2.jcc.DB2Driver -cp "C:\URT_work_dir\*" com.ibm.fxh.report.UsageReport