squirrel-sql-users

[Squirrel-sql-users] problem wiht db connection

[Radoslaw T. <rad...@gm...>]

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

Re: [Squirrel-sql-users] problem wiht db connection

[Radoslaw T. <rad...@gm...>]

Hallo all,

I just solved the problem. The problem is on the db site, with the db
engine. It has nothing to do with the SQuirreL!  A good description
you can find at:

http://www-1.ibm.com/support/docview.wss?rs=71&dc=D600&uid=swg21215626

In sort. The db after the fixpac 8.1 FixPak 10 (also known as Version
8.2 FixPak 3), can encounter an SQL0443N error if invoking a DB2 Call
Level Interface (CLI) catalog function (such as SQLTables(),
SQLColumns(), or SQLStatistics()).

The solution:

db2 terminate
db2 connect to <database-name>
db2 bind <path>/db2schema.bnd blocking all grant public sqlerror continue
db2 terminate

Thanks all, have a nice day
Radoslaw

2007/7/17, Robert Manning <rob...@gm...>:
> Hello,
>
> Looks like you have 8.1 fixpak 11 installed.  You might try to get
> fixpak 14 (that's what I updated to recently).  There is some newer
> support for IBM's driver in the latest snapshot for getting more
> detailed error messages from the exceptions that DB2 driver throws.
> You may want to try that, and report back with a more detailed error
> message.  The snapshot can be found here:
>
> http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=523220
>
> The symptom appears to be that whenever SQuirreL asks the driver for
> metadata about tables, schemas, etc. the driver throws an Exception.
> I'm guessing - perhaps the system catalogs aren't installed/configured
> properly - or you don't have access to them?
>
> Rob

-- 
ITIL,RHCE,CCNA,Linux enthusiast.
M.Sc. Radoslaw Tomaszewski

Re: [Squirrel-sql-users] problem wiht db connection

[Robert M. <rob...@gm...>]

Great.  Thanks for the update!

Rob

On 7/17/07, Radoslaw Tomaszewski <rad...@gm...> wrote:
> Hallo all,
>
> I just solved the problem. The problem is on the db site, with the db
> engine. It has nothing to do with the SQuirreL!  A good description
> you can find at:
>
> http://www-1.ibm.com/support/docview.wss?rs=71&dc=D600&uid=swg21215626
>
> In sort. The db after the fixpac 8.1 FixPak 10 (also known as Version
> 8.2 FixPak 3), can encounter an SQL0443N error if invoking a DB2 Call
> Level Interface (CLI) catalog function (such as SQLTables(),
> SQLColumns(), or SQLStatistics()).
>
> The solution:
>
> db2 terminate
> db2 connect to <database-name>
> db2 bind <path>/db2schema.bnd blocking all grant public sqlerror continue
> db2 terminate
>
> Thanks all, have a nice day
> Radoslaw
>
> 2007/7/17, Robert Manning <rob...@gm...>:
> > Hello,
> >
> > Looks like you have 8.1 fixpak 11 installed.  You might try to get
> > fixpak 14 (that's what I updated to recently).  There is some newer
> > support for IBM's driver in the latest snapshot for getting more
> > detailed error messages from the exceptions that DB2 driver throws.
> > You may want to try that, and report back with a more detailed error
> > message.  The snapshot can be found here:
> >
> > http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=523220
> >
> > The symptom appears to be that whenever SQuirreL asks the driver for
> > metadata about tables, schemas, etc. the driver throws an Exception.
> > I'm guessing - perhaps the system catalogs aren't installed/configured
> > properly - or you don't have access to them?
> >
> > Rob
>
> --
> ITIL,RHCE,CCNA,Linux enthusiast.
> M.Sc. Radoslaw Tomaszewski
>