Please take our Survey
logo       
<prev   next>

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

problem wiht db connection: msg#00025

db.squirrel-sql.users

Subject: problem wiht db connection

Hallo All,

I'm new to squirrel, so maybe I will just tell a few word about me :).
My name is Radoslaw Tomaszewski, came from Polen. I'm a linux fan and
found this great tool on the net :).

My problem:
I have some problem with db db2 (ibm udb db2 v8.2) , I will be very
appropriate if some body could give me some advises what is wrong:

Some info about my system:

$db2level
07.16@15:00 db2inst2@proddb:~/sqllib/bnd> db2level
DB21085I Instance "db2inst2" uses "32" bits and DB2 code release "SQL08024"
with level identifier "03050106".
Informational tokens are "DB2 v8.1.2.104", "s060120", "MI00152", and FixPak
"11".
Product is installed at "/opt/IBM/db2/V8.1".

$ uname -a
Linux u35 2.6.15-28-386 #1 PREEMPT Thu May 10 09:45:43 UTC 2007 i686 GNU/Linux

#i'm using the ubuntu system
$ cat /etc/debian_version
testing/unstable

$ java -version /usr/bin/java
java version "1.5.0_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode, sharing)


There is a db: coretest and when I'm connecting to this db, the log
file have following informations:

76869 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache
- Could not get table types
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
at com.ibm.db2.jcc.b.jb.l(jb.java:356)
at com.ibm.db2.jcc.b.jb.e(jb.java:92)
at com.ibm.db2.jcc.b.w.e(w.java:72)
at com.ibm.db2.jcc.b.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
at com.ibm.db2.jcc.a.tf.X(tf.java:188)
at com.ibm.db2.jcc.a.t.a(t.java:7199)
at com.ibm.db2.jcc.a.t.Yd(t.java:5973)
at com.ibm.db2.jcc.a.t.getTableTypes(t.java:5901)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTableTypes(SQLDatabaseMetaData.java:1007)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.initTypes(SchemaInfoCache.java:147)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.setSession(SchemaInfoCache.java:61)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCacheSerializer.load(SchemaInfoCacheSerializer.java:30)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:128)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
76989 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo -
failed to load catalog names
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
at com.ibm.db2.jcc.b.jb.l(jb.java:356)
at com.ibm.db2.jcc.b.jb.e(jb.java:92)
at com.ibm.db2.jcc.b.w.e(w.java:72)
at com.ibm.db2.jcc.b.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
at com.ibm.db2.jcc.a.tf.X(tf.java:188)
at com.ibm.db2.jcc.a.t.a(t.java:7199)
at com.ibm.db2.jcc.a.t.Xd(t.java:5884)
at com.ibm.db2.jcc.a.t.getCatalogs(t.java:5809)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDatabaseMetaData.java:583)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadCatalogs(SchemaInfo.java:500)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadCatalogs(SchemaInfo.java:390)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:186)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
77082 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.SessionManager - Failed
to get allowed Schemas
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
at com.ibm.db2.jcc.b.jb.l(jb.java:356)
at com.ibm.db2.jcc.b.jb.e(jb.java:92)
at com.ibm.db2.jcc.b.w.e(w.java:72)
at com.ibm.db2.jcc.b.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
at com.ibm.db2.jcc.a.tf.X(tf.java:188)
at com.ibm.db2.jcc.a.t.a(t.java:7199)
at com.ibm.db2.jcc.a.t.Wd(t.java:5795)
at com.ibm.db2.jcc.a.t.getSchemas(t.java:5723)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:351)
at
net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:648)
at
net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:600)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadSchemas(SchemaInfo.java:525)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadSchemas(SchemaInfo.java:365)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:188)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
77343 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo -
Error occured creating data types collection
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC:
SYSIBM.SQLGETTYPEINFO;GETTYPEINFO;SYSIBM:CLI:-805
at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
at com.ibm.db2.jcc.b.jb.l(jb.java:356)
at com.ibm.db2.jcc.b.jb.e(jb.java:92)
at com.ibm.db2.jcc.b.w.e(w.java:72)
at com.ibm.db2.jcc.b.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
at com.ibm.db2.jcc.a.tf.X(tf.java:188)
at com.ibm.db2.jcc.a.t.a(t.java:7199)
at com.ibm.db2.jcc.a.t.Zd(t.java:6960)
at com.ibm.db2.jcc.a.t.getTypeInfo(t.java:6895)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypes(SQLDatabaseMetaData.java:886)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:775)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:223)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
77672 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.SessionManager - Failed
to check allowed Schemas
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
at com.ibm.db2.jcc.b.jb.l(jb.java:356)
at com.ibm.db2.jcc.b.jb.e(jb.java:92)
at com.ibm.db2.jcc.b.w.e(w.java:72)
at com.ibm.db2.jcc.b.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
at com.ibm.db2.jcc.a.tf.X(tf.java:188)
at com.ibm.db2.jcc.a.t.a(t.java:7199)
at com.ibm.db2.jcc.a.t.Wd(t.java:5795)
at com.ibm.db2.jcc.a.t.getSchemas(t.java:5723)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:351)
at
net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:584)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:74)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:109)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1080)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:340)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:253)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
77720 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo -
failed to load table names
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
at com.ibm.db2.jcc.b.jb.l(jb.java:356)
at com.ibm.db2.jcc.b.jb.e(jb.java:92)
at com.ibm.db2.jcc.b.w.e(w.java:72)
at com.ibm.db2.jcc.b.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
at com.ibm.db2.jcc.a.tf.X(tf.java:188)
at com.ibm.db2.jcc.a.t.a(t.java:7199)
at com.ibm.db2.jcc.a.t.a(t.java:5705)
at com.ibm.db2.jcc.a.t.getTables(t.java:5616)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:1147)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1084)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:340)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:253)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
77781 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.SessionManager - Failed
to check allowed Schemas
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
at com.ibm.db2.jcc.b.jb.l(jb.java:356)
at com.ibm.db2.jcc.b.jb.e(jb.java:92)
at com.ibm.db2.jcc.b.w.e(w.java:72)
at com.ibm.db2.jcc.b.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
at com.ibm.db2.jcc.a.tf.X(tf.java:188)
at com.ibm.db2.jcc.a.t.a(t.java:7199)
at com.ibm.db2.jcc.a.t.Wd(t.java:5795)
at com.ibm.db2.jcc.a.t.getSchemas(t.java:5723)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:351)
at
net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:584)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:74)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:109)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:102)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:469)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:316)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:257)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
77786 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo -
Failed to load stored procedures
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC:
SYSIBM.SQLPROCEDURES;PROCEDURES;SYSIBM:CLI:-805
at com.ibm.db2.jcc.a.rf.d(rf.java:1396)
at com.ibm.db2.jcc.b.jb.l(jb.java:356)
at com.ibm.db2.jcc.b.jb.e(jb.java:92)
at com.ibm.db2.jcc.b.w.e(w.java:72)
at com.ibm.db2.jcc.b.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
at com.ibm.db2.jcc.a.tf.X(tf.java:188)
at com.ibm.db2.jcc.a.t.a(t.java:7199)
at com.ibm.db2.jcc.a.t.a(t.java:5499)
at com.ibm.db2.jcc.a.t.getProcedures(t.java:5427)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:952)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:475)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:316)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:257)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:222)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)

Have any one some ideas what can be wrong? I restared the db instance,
re-create the bind files for the db.

db2 bind @db2cli.lst BLOCKING all grant public
db2 bind @db2ubind.lst blocking all grant public

db2stop
db2start

Is it a problem on the db site or maybe in the application. With other
db'ses the tool works great!!! Only with this one is something wrong
:(.

Thanks and best regards,
Radoslaw

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: Small Font problem (8px) in version stable 2.5, James Im
Next by Date:  Re: problem wiht db connection, Robert Manning
Previous by Thread:  Re: Small Font problem (8px) in version stable 2.5, James Im
Next by Thread:  Re: problem wiht db connection, Radoslaw Tomaszewski
Indexes:  [Date] [Thread] [Top] [All Lists]

Google Custom Search
Recently Viewed:
hardware.arm.at...    cms.citadel.dev...    video.gstreamer...    java.facelets.u...    misc.basics.qna...    web.wiki.instik...    network.uip.use...    xdg.devel/2003-...    tex.bibtex.bibd...    finance.quotesp...    ietf.zeroconf/2...    redhat.blinux.g...    suse.db2/2003-0...    php.phpesp/2004...    uml.devel/2003-...    gnome.labyrinth...    qnx.openqnx.dev...    boot-loaders.gr...    db.dataperfect....    audio.audacity....    linux.uclinux.m...    editors.j.devel...    os.openbsd.tech...    kde.users.multi...   
Home | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation