Re: [aperi-dev] configuring Aperi 0.3 for DB2

[Dave Wolfe <dwolfe@xxxxxxxxxx>]

Are there instructions for how to do
this in the IDE? Is there a version of RunConfigureAperiIDE for DB2? Likewise
for RunAperiDerbyDB?

Dave Wolfe/Portland/IBM
(dwolfe@xxxxxxxxxx)
TL: 775-3376 Office: 503-578-3376 Personal: 503-329-3960

UI Technical Lead, Aperi Open Source Storage Management http://www.eclipse.org/aperi

"A good composer does not imitate; he steals." - Igor Stravinsky

 

Hans Lin/San Jose/IBM@IBMUS
Sent by: aperi-dev-bounces@xxxxxxxxxxx

04/19/2007 03:14 PM

Please respond to
Aperi Development <aperi-dev@xxxxxxxxxxx>

To	aperi-dev@xxxxxxxxxxx
cc
Subject	[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) 
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@xxxxxxxxxx_______________________________________________
aperi-dev mailing list
aperi-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/aperi-dev