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

[Prasenjit Sarkar <psarkar@xxxxxxxxxxxxxxx>]

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