Re: [aperi-dev] Aperi issues with DB2 9.5.

[Dave Wolfe <dwolfe@xxxxxxxxxx>]

SQLCODE=-1031 is
probably a DB2 installation problem. Is DB2 really up? Can you connect
to it with any other tools? Control Center, etc?

The trail download form DB2 9.5 can
be found at http://www.ibm.com/developerworks/downloads/im/udb/

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

 

"Nissamudeen Rawther" <rnissamudeen@xxxxxxxxxx>
Sent by: aperi-dev-bounces@xxxxxxxxxxx

02/28/2008 06:03 AM

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

To	<aperi-dev@xxxxxxxxxxx>
cc
Subject	[aperi-dev] Aperi issues with DB2 9.5.

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