[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
[aperi-dev] configuring Aperi 0.3 for DB2
|
With the most recent DB2 performance fix by Prasenjt and the consolidation of the plugins directories, the Aperi 0.2 installation of using DB2 as the repository needs to be modified to fit into Aperi R0.3 environment
To use DB2:
#1 Download and install a version of DB2 UDB version 8 (not 9)
#2 Unzip an Aperi build.
#3 Copy the DB2 JDBC driver into Aperi:
They're probably in C:\Program Files\IBM\SQLLIB\Java -- the filenames are db2jcc.jar and db2jcc_license_cu.jar.
for dir in plugins & rcpgui/plugins
do
copy the driver files to $dir/org.eclipse.aperi.db_1.0.0
then go into $dir/org.eclipse.aperi.db_1.0.0
for each $dir/org.eclipse.aperi.db_1.0.0/MANIFEST directory, delete MANIFEST.MF and rename DB2-MANIFEST.MF to MANIFEST.MF
done
Note: defect 181241 addressed the above manually copying DB2 JDBC driver issue, will be improved in Aperi 0.4 time frame
#4 Then cd configure and run 'cfgaperi'.
Don't run 'cfgaperi easy', or you'll get Derby. You can accept all defaults (if you accepted defaults for the DB2 installation) except it will ask you if you want to use DB2 or Derby, and you'll want to choose DB2. You will be required to enter the db2admin password that you remembered from step #1. 'cfgaperi' will prompt you to enter DB2 Command Line Processor Path: it is probably in c:\Program Files\IBM\SQLLIB\BIN
#5 Then start aperi as usual.
Note that, naturally, Derby will not be started.
Note: The big difference between Aperi 0.2 and Aperi 0.3 is that we eliminate the step of using DB2 Control Center to create a database called 'Aperi', the cfgaperi will create one for you. My experience is that if you create 'Aperi' db first then run cfgaperi, you may encounter the following error:
java.io.IOException: CreateProcess: " c:\Program Files\IBM\SqlLib\bin\db2cmd"
/c scripts/db2config.bat db2admin itsa11gd Aperi Create 2500 -1 65537 1000 10240 1024
40000 4096 10240 50 10000 150 8 16 error=2
Hans H. Lin, Tivoli SAN Software Development
IBM San Jose, California
Phone: 408-284-4917, Fax: 408-256-8507
email: linh@xxxxxxxxxx
