Thanks a lot man, after creating the Aperi DB it works fine.
Appreciate if somebody document these changes in the install instructions.
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