[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [aperi-dev] configuring Aperi 0.3 for DB2
|
DB2 9 is not supported...
Prasenjit Sarkar
RSM and Manager, Storage Analytics and Resiliency
Master Inventor
IBM Almaden Storage Systems Research
Hans Lin/San
Jose/IBM@IBMUS
Sent by: To
aperi-dev-bounces aperi-dev@xxxxxxxxxxx
@eclipse.org cc
Subject
04/19/2007 03:14 [aperi-dev] configuring Aperi 0.3
PM for DB2
Please respond to
Aperi Development
<aperi-dev@eclips
e.org>
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)
e.g. from
http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2006-03-10
+13%3A32%3A39.249253R&cat=database&fam=&s=c&S_TACT=104AH%20W42&S_CMP
All defaults are OK. Remember the db2admin password that you choose
in the installer.
Note: Need Prasenjit to verify whether DB2 9 will work for Aperi 0.3?
#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@xxxxxx.com_______________________________________________
aperi-dev mailing list
aperi-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/aperi-dev