The DB2® Client connect does not need to be installed on the Stat® Central Agent machine, however the agent does need the jdbc drivers provided in DB2 connect.
The Stat Central Agent uses the IBM JDBC 4.0 type 4 driver (db2jcc4.jar). The required files can be found in C:\Program Files\IBM\SQLLIB\java of the DB2 client installation..
2 |
Copy db2jcc4.jar and db2jcc_license_%%.jar from C:\Program Files\IBM\SQLLIB\java to <STAT_HOME>\app\modules\com\ibm\db2\jcc\main directory. The location of required drivers may vary on your site due to DB2 installation preferences. |
NOTE: The db2jcc_license_cisuz.jar file has been removed from certain products in DB2 client installations. Depending on the DB2 configuration, it may or may not be needed. |
3 |
Edit <STAT_HOME>\app\modules\com\ibm\db2\jcc\main \module.xml in a text editor and uncomment the 3 jar files in the resources section. |
4 |
Edit <STAT_HOME>\app\standalone\configuration\standalone-full.xml (or for https, <STAT_HOME>\app\standalone\configuration\standalone-full-https.xml) in a text editor and locate the datasources:2.0 subsystem. You need to uncomment the driver for ibmJDBCDriver. |
5 |
NOTE: When you modify an .xml file, be sure that there is only one copy of it in the directory when you are finished. Do not rename the old copy and leave it in that directory. |
• |
Host — The IP address or Server name where the database resides |
• |
Service — The UDB/DB2 database name as defined during installation, not an alias. |
• |
Port — The port that is listening for requests against the UDB/DB2 database. |
• |
currentSQLID= The implicit qualifier of all table, view, alias, and index names specified in dynamic SQL statements (Mainframe). |
• |
currentSchema= Specifies the default schema name that is used to qualify unqualified database objects in dynamically prepared SQL statements-also case sensitive (AIX®). |
The Stat® Central Agent defaults to a character map of ISO-8859-1, which is compatible with sites that are upgrading from older versions of Stat. If desirable, the agent can be configured to use UTF-8.
1 |
Open <STAT_HOME>\app\bin\standalone.conf.bat. |
• |
• |
• |
• |
2 |
Download the Java Cryptography Extension (JCE), which is contained in the appropriate zip file (jce_policy-8.zip) to a temp folder and unzip the file. |
3 |
4 |
5 |
6 |
Go to the temp folder where you unzipped the jce_policy file and copy local_policy.jar and US_export_policy.jar. |
7 |
9 |
11 |
12 |
14 |
Go to the <STAT_HOME>/app/bin directory and locate the standalone.conf.bat (for Unix, standalone.sh) file. |
3 |
Finally you need to tell the Stat Oracle Agent to use https protocol for its communications. Edit the <STAT_HOME>/conf/stat.conf file and uncomment the following property: |
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center