| Re: [aperi-dev] Aperi issues with DB2 9.5. |
|
Hi Hans
Thanks a lot man, after creating the Aperi DB it works fine.
Appreciate if somebody document these changes in the install instructions.
thanks and regards
nissam
>>> Hans Lin <linh@xxxxxxxxxx> 2/28/2008 10:18 PM >>> Hi Nissam, My experience with the install of Aperi using DB2 was that you need to create 'aperi' db first before running the Aperi install and the key is that you also need to manually Copy the DB2 JDBC driver into the directory where you unzipped the Aperi Storage Manager files. To do this perform the following steps: 1. Locate the DB2 JDBC driver that was installed during the DB2 installation. On Windows, check C:\Program Files\IBM\SQLLIB\Java. The filenames are db2jcc.jar and db2jcc_license_cu.jar. 2. Copy the driver files to the following Aperi directories: [aperi_install_dir]\plugins\org.eclipse.aperi.db_1.0.0 [aperi_install_dir]\gui\plugins 3. Go to [aperi_install_dir]\plugins\org.eclipse.aperi.db_1.0.0\MANIFEST . 4. Delete MANIFEST.MF. 5. Rename DB2-MANIFEST.MF to MANIFEST.MF. Hans H. Lin, Tivoli SAN Software Development IBM Almaden Research Center, California Phone: 408-927-2286, Fax: 408-927-2040 email: linh@xxxxxxxxxx "Nissamudeen Rawther" <rnissamudeen@nov To ell.com> <aperi-dev@xxxxxxxxxxx> Sent by: cc aperi-dev-bounces @eclipse.org Subject [aperi-dev] Aperi issues with DB2 9.5. 02/28/2008 06:03 AM Please respond to Aperi Development <aperi-dev@eclips e.org> Hi I tried to install Aperi Storage Manager using DB2 Version 9.5 as the database repository. It was showing the following error during the install configuration. I gone through the installation instruction, Under the plan of deployment(1st Heading ) it says, Database Repository A single database instance serves as the repository for data collected by agents. The Aperi database repository can run under either of the following relational database systems: Apache Derby DB2 8 for Linux UNIX and Windows. Under the 3rd Heading, it says Aperi R4 was tested using DB2 v9.5 for Windows XP, DB2 v9.5 for Windows 2003 Server, and DB2 v8.1 for Linux RHEL3. My setup is DB2 9.5 on Windows XP and using Aperi R4 . I couldn't find some external link to download and try DB2 version 8. Somebody faced similar problem? thanks and regards nissam Error ----- com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-1031, SQLSTATE=58031, SQLERRMC=null, DRIVER=3.50.152 at com.ibm.db2.jcc.b.wc.a(wc.java:55) at com.ibm.db2.jcc.b.wc.a(wc.java:126) at com.ibm.db2.jcc.b.eb.a(eb.java:3609) at com.ibm.db2.jcc.t4.bb.q(bb.java:696) at com.ibm.db2.jcc.t4.bb.n(bb.java:524) at com.ibm.db2.jcc.t4.bb.a(bb.java:328) at com.ibm.db2.jcc.t4.bb.a(bb.java:111) at com.ibm.db2.jcc.t4.b.i(b.java:1358) at com.ibm.db2.jcc.t4.b.b(b.java:1249) at com.ibm.db2.jcc.t4.b.s(b.java:1020) at com.ibm.db2.jcc.t4.b.c(b.java:632) at com.ibm.db2.jcc.t4.b.b(b.java:618) at com.ibm.db2.jcc.t4.b.a(b.java:360) at com.ibm.db2.jcc.t4.b.<init>(b.java:298) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:193) at org.eclipse.aperi.infrastructure.database.Database.getConnection (Database.java:278) at org.eclipse.aperi.infrastructure.database.Database.getConnection (Database.java:245) at org.eclipse.aperi.infrastructure.database.DBConnPoolDataSource $Pool.remove(DBConnPoolDataSource.java:310) at org.eclipse.aperi.infrastructure.database.DBConnPoolDataSource.getPooledConnection (DBConnPoolDataSource.java:114) at org.eclipse.aperi.install.SilentDatabaseInstall.initializeApi (SilentDatabaseInstall.java:1049) at org.eclipse.aperi.install.SilentDatabaseInstall.main (SilentDatabaseInstall.java:971) at org.eclipse.aperi.install.DatabaseInstall.runSilentDatabaseInstall (DatabaseInstall.java:57) at org.eclipse.aperi.install.DatabaseInstall.execute (DatabaseInstall.java:16) at org.apache.tools.ant.UnknownElement.execute (UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.tools.ant.dispatch.DispatchUtils.execute (DispatchUtils.java:105) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets (Project.java:1329) at org.apache.tools.ant.Project.executeTarget(Project.java:1298) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets (DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1181) at org.tp23.antinstaller.antmod.Main.runBuild(Main.java:704) at org.tp23.antinstaller.antmod.Main.startAnt(Main.java:216) at org.tp23.antinstaller.antmod.Launcher.run(Launcher.java:242) at org.tp23.antinstaller.runtime.exe.AntLauncherFilter.exec (AntLauncherFilter.java:76) at org.tp23.antinstaller.runtime.ExecInstall.exec (ExecInstall.java:85) at org.tp23.antinstaller.runtime.ExecInstall.main (ExecInstall.java:157) at org.eclipse.aperi.install.Activator.start(Activator.java:16) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run (BundleContextImpl.java:999) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator (BundleContextImpl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start (BundleContextImpl.java:974) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker (BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume (AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle (Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles (StartLevelManager.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL (StartLevelManager.java:508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel (StartLevelManager.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent (StartLevelManager.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent (EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run (EventManager.java:297) java.lang.Exception: 2/28/08 5:54:39 PM INS2071E: <text unavailable> SQLSTATE: 58031, Vendor error code: -1031 DB2 SQL Error: SQLCODE=-1031, SQLSTATE=58031, SQLERRMC=null, DRIVER=3.50.152 initializeApi failed in getPooledConnection at org.eclipse.aperi.install.SilentDatabaseInstall.initializeApi (SilentDatabaseInstall.java:1056) at org.eclipse.aperi.install.SilentDatabaseInstall.main (SilentDatabaseInstall.java:971) at org.eclipse.aperi.install.DatabaseInstall.runSilentDatabaseInstall (DatabaseInstall.java:57) at org.eclipse.aperi.install.DatabaseInstall.execute (DatabaseInstall.java:16) at org.apache.tools.ant.UnknownElement.execute (UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.tools.ant.dispatch.DispatchUtils.execute (DispatchUtils.java:105) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets (Project.java:1329) at org.apache.tools.ant.Project.executeTarget(Project.java:1298) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets (DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1181) at org.tp23.antinstaller.antmod.Main.runBuild(Main.java:704) at org.tp23.antinstaller.antmod.Main.startAnt(Main.java:216) at org.tp23.antinstaller.antmod.Launcher.run(Launcher.java:242) at org.tp23.antinstaller.runtime.exe.AntLauncherFilter.exec (AntLauncherFilter.java:76) at org.tp23.antinstaller.runtime.ExecInstall.exec (ExecInstall.java:85) at org.tp23.antinstaller.runtime.ExecInstall.main (ExecInstall.java:157) at org.eclipse.aperi.install.Activator.start(Activator.java:16) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run (BundleContextImpl.java:999) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator (BundleContextImpl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start (BundleContextImpl.java:974) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker (BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume (AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle (Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles (StartLevelManager.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL (StartLevelManager.java:508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel (StartLevelManager.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent (StartLevelManager.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent (EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run (EventManager.java:297) DB2 SQL Error: SQLCODE=-1031, SQLSTATE=58031, SQLERRMC=null, DRIVER=3.50.152_______________________________________________ aperi-dev mailing list aperi-dev@xxxxxxxxxxx https://dev.eclipse.org/mailman/listinfo/aperi-dev _______________________________________________ aperi-dev mailing list aperi-dev@xxxxxxxxxxx https://dev.eclipse.org/mailman/listinfo/aperi-dev |