|
From: Ric <ri...@ya...> - 2006-12-11 12:16:40
|
I am having a problem using Squirrel browsing a DB2 database running "DB2 =
v8.1.13.193", "s060801", "WR21371", and FixPak=0A"13".=0A=0AIt was ok befor=
e I applied the fixpack. =0A=0AI have tried IBM's DB2JCC driver 2.7.58 and =
2.10.27 (which came with fixpack 13)=0A=0AThe symtoms I get when i connect =
to a database on a fixpack 13 DB2, I just see TABLE, PROCEDURE and UDT appe=
ar on the object tab in Squirrel, and nothing under any them.=0A=0AI dot be=
lieve the problem is priviledges, as this is the administrator account, and=
I am able to execute sql commands which work ok in the SQL tab ok.=0A=0ATh=
is is what I get in the log.=0A6654 [Thread-3] ERROR net.sourceforge.squirr=
el_sql.client.session.schemainfo.SchemaInfoCache - Could not get table typ=
es=0Acom.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE=
: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805=0A at com.ibm=
.db2.jcc.b.sf.d(sf.java:1396)=0A at com.ibm.db2.jcc.c.jb.l(jb.java:367)=
=0A at com.ibm.db2.jcc.c.jb.e(jb.java:92)=0A at com.ibm.db2.jcc.c.w.e=
(w.java:72)=0A at com.ibm.db2.jcc.c.cc.h(cc.java:203)=0A at com.ibm.d=
b2.jcc.b.sf.q(sf.java:1363)=0A at com.ibm.db2.jcc.b.tf.d(tf.java:2388)=
=0A at com.ibm.db2.jcc.b.uf.X(uf.java:188)=0A at com.ibm.db2.jcc.b.t.=
a(t.java:7201)=0A at com.ibm.db2.jcc.b.t.Yd(t.java:5975)=0A at com.ib=
m.db2.jcc.b.t.getTableTypes(t.java:5903)=0A at net.sourceforge.squirrel_=
sql.fw.sql.SQLDatabaseMetaData.getTableTypes(SQLDatabaseMetaData.java:990)=
=0A at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo=
Cache.initTypes(SchemaInfoCache.java:147)=0A at net.sourceforge.squirrel=
_sql.client.session.schemainfo.SchemaInfoCache.setSession(SchemaInfoCache.j=
ava:61)=0A at net.sourceforge.squirrel_sql.client.session.schemainfo.Sch=
emaInfoCacheSerializer.load(SchemaInfoCacheSerializer.java:30)=0A at net=
.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(=
SchemaInfo.java:128)=0A at net.sourceforge.squirrel_sql.client.session.S=
ession$1.run(Session.java:224)=0A at net.sourceforge.squirrel_sql.fw.uti=
l.TaskExecuter.run(TaskExecuter.java:82)=0A at java.lang.Thread.run(Unkn=
own Source)=0A6765 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.ses=
sion.schemainfo.SchemaInfo - failed to load catalog names=0Acom.ibm.db2.jc=
c.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: =
SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805=0A at com.ibm.db2.jcc.b.sf.d(sf.=
java:1396)=0A at com.ibm.db2.jcc.c.jb.l(jb.java:367)=0A at com.ibm.db=
2.jcc.c.jb.e(jb.java:92)=0A at com.ibm.db2.jcc.c.w.e(w.java:72)=0A at=
com.ibm.db2.jcc.c.cc.h(cc.java:203)=0A at com.ibm.db2.jcc.b.sf.q(sf.jav=
a:1363)=0A at com.ibm.db2.jcc.b.tf.d(tf.java:2388)=0A at com.ibm.db2.=
jcc.b.uf.X(uf.java:188)=0A at com.ibm.db2.jcc.b.t.a(t.java:7201)=0A a=
t com.ibm.db2.jcc.b.t.Xd(t.java:5886)=0A at com.ibm.db2.jcc.b.t.getCatal=
ogs(t.java:5811)=0A at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMe=
taData.getCatalogs(SQLDatabaseMetaData.java:566)=0A at net.sourceforge.s=
quirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadCatalogs(Schema=
Info.java:500)=0A at net.sourceforge.squirrel_sql.client.session.schemai=
nfo.SchemaInfo.loadCatalogs(SchemaInfo.java:390)=0A at net.sourceforge.s=
quirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.=
java:186)=0A at net.sourceforge.squirrel_sql.client.session.schemainfo.S=
chemaInfo.initialLoad(SchemaInfo.java:134)=0A at net.sourceforge.squirre=
l_sql.client.session.Session$1.run(Session.java:224)=0A at net.sourcefor=
ge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)=0A at jav=
a.lang.Thread.run(Unknown Source)=0A6818 [Thread-3] ERROR net.sourceforge.s=
quirrel_sql.client.session.SessionManager - Failed to get allowed Schemas=
=0Acom.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: =
38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805=0A at com.ibm.d=
b2.jcc.b.sf.d(sf.java:1396)=0A at com.ibm.db2.jcc.c.jb.l(jb.java:367)=0A=
at com.ibm.db2.jcc.c.jb.e(jb.java:92)=0A at com.ibm.db2.jcc.c.w.e(w.=
java:72)=0A at com.ibm.db2.jcc.c.cc.h(cc.java:203)=0A at com.ibm.db2.=
jcc.b.sf.q(sf.java:1363)=0A at com.ibm.db2.jcc.b.tf.d(tf.java:2388)=0A =
at com.ibm.db2.jcc.b.uf.X(uf.java:188)=0A at com.ibm.db2.jcc.b.t.a(t.j=
ava:7201)=0A at com.ibm.db2.jcc.b.t.Wd(t.java:5797)=0A at com.ibm.db2=
.jcc.b.t.getSchemas(t.java:5725)=0A at net.sourceforge.squirrel_sql.fw.s=
ql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:334)=0A at ne=
t.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(=
SessionManager.java:648)=0A at net.sourceforge.squirrel_sql.client.sessi=
on.SessionManager.getAllowedSchemas(SessionManager.java:600)=0A at net.s=
ourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadSch=
emas(SchemaInfo.java:525)=0A at net.sourceforge.squirrel_sql.client.sess=
ion.schemainfo.SchemaInfo.loadSchemas(SchemaInfo.java:365)=0A at net.sou=
rceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(S=
chemaInfo.java:188)=0A at net.sourceforge.squirrel_sql.client.session.sc=
hemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)=0A at net.sourcefor=
ge.squirrel_sql.client.session.Session$1.run(Session.java:224)=0A at net=
.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)=0A=
at java.lang.Thread.run(Unknown Source)=0A7073 [Thread-3] ERROR net.sou=
rceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Error occured=
creating data types collection=0Acom.ibm.db2.jcc.b.SqlException: DB2 SQL e=
rror: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLGETTYPEINFO;GETTY=
PEINFO;SYSIBM:CLI:-805=0A at com.ibm.db2.jcc.b.sf.d(sf.java:1396)=0A =
at com.ibm.db2.jcc.c.jb.l(jb.java:367)=0A at com.ibm.db2.jcc.c.jb.e(jb.j=
ava:92)=0A at com.ibm.db2.jcc.c.w.e(w.java:72)=0A at com.ibm.db2.jcc.=
c.cc.h(cc.java:203)=0A at com.ibm.db2.jcc.b.sf.q(sf.java:1363)=0A at =
com.ibm.db2.jcc.b.tf.d(tf.java:2388)=0A at com.ibm.db2.jcc.b.uf.X(uf.jav=
a:188)=0A at com.ibm.db2.jcc.b.t.a(t.java:7201)=0A at com.ibm.db2.jcc=
.b.t.Zd(t.java:6962)=0A at com.ibm.db2.jcc.b.t.getTypeInfo(t.java:6897)=
=0A at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTy=
pes(SQLDatabaseMetaData.java:869)=0A at net.sourceforge.squirrel_sql.cli=
ent.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:775)=0A =
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privat=
eLoadAll(SchemaInfo.java:223)=0A at net.sourceforge.squirrel_sql.client.=
session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)=0A at net=
.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:224)=0A=
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.j=
ava:82)=0A at java.lang.Thread.run(Unknown Source)=0A7338 [Thread-3] ERR=
OR net.sourceforge.squirrel_sql.client.session.SessionManager - Failed to =
check allowed Schemas=0Acom.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLC=
ODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-8=
05=0A at com.ibm.db2.jcc.b.sf.d(sf.java:1396)=0A at com.ibm.db2.jcc.c=
.jb.l(jb.java:367)=0A at com.ibm.db2.jcc.c.jb.e(jb.java:92)=0A at com=
.ibm.db2.jcc.c.w.e(w.java:72)=0A at com.ibm.db2.jcc.c.cc.h(cc.java:203)=
=0A at com.ibm.db2.jcc.b.sf.q(sf.java:1363)=0A at com.ibm.db2.jcc.b.t=
f.d(tf.java:2388)=0A at com.ibm.db2.jcc.b.uf.X(uf.java:188)=0A at com=
.ibm.db2.jcc.b.t.a(t.java:7201)=0A at com.ibm.db2.jcc.b.t.Wd(t.java:5797=
)=0A at com.ibm.db2.jcc.b.t.getSchemas(t.java:5725)=0A at net.sourcef=
orge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData=
.java:334)=0A at net.sourceforge.squirrel_sql.client.session.SessionMana=
ger.areAllSchemasAllowed(SessionManager.java:584)=0A at net.sourceforge.=
squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfo=
s(SchemaInfoCache.java:74)=0A at net.sourceforge.squirrel_sql.client.ses=
sion.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.=
java:109)=0A at net.sourceforge.squirrel_sql.client.session.schemainfo.S=
chemaInfo.privateLoadTables(SchemaInfo.java:1063)=0A at net.sourceforge.=
squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.jav=
a:340)=0A at net.sourceforge.squirrel_sql.client.session.schemainfo.Sche=
maInfo.privateLoadAll(SchemaInfo.java:253)=0A at net.sourceforge.squirre=
l_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:134)=
=0A at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session=
.java:224)=0A at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(T=
askExecuter.java:82)=0A at java.lang.Thread.run(Unknown Source)=0A7462 [=
Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.Sche=
maInfo - failed to load table names=0Acom.ibm.db2.jcc.b.SqlException: DB2 =
SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLE=
S;SYSIBM:CLI:-805=0A at com.ibm.db2.jcc.b.sf.d(sf.java:1396)=0A at co=
m.ibm.db2.jcc.c.jb.l(jb.java:367)=0A at com.ibm.db2.jcc.c.jb.e(jb.java:9=
2)=0A at com.ibm.db2.jcc.c.w.e(w.java:72)=0A at com.ibm.db2.jcc.c.cc.=
h(cc.java:203)=0A at com.ibm.db2.jcc.b.sf.q(sf.java:1363)=0A at com.i=
bm.db2.jcc.b.tf.d(tf.java:2388)=0A at com.ibm.db2.jcc.b.uf.X(uf.java:188=
)=0A at com.ibm.db2.jcc.b.t.a(t.java:7201)=0A at com.ibm.db2.jcc.b.t.=
a(t.java:5707)=0A at com.ibm.db2.jcc.b.t.getTables(t.java:5618)=0A at=
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatab=
aseMetaData.java:1109)=0A at net.sourceforge.squirrel_sql.client.session=
.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1067)=0A at net=
.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(S=
chemaInfo.java:340)=0A at net.sourceforge.squirrel_sql.client.session.sc=
hemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:253)=0A at net.source=
forge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaI=
nfo.java:134)=0A at net.sourceforge.squirrel_sql.client.session.Session$=
1.run(Session.java:224)=0A at net.sourceforge.squirrel_sql.fw.util.TaskE=
xecuter.run(TaskExecuter.java:82)=0A at java.lang.Thread.run(Unknown Sou=
rce)=0A7530 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.Se=
ssionManager - Failed to check allowed Schemas=0Acom.ibm.db2.jcc.b.SqlExce=
ption: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLT=
ABLES;TABLES;SYSIBM:CLI:-805=0A at com.ibm.db2.jcc.b.sf.d(sf.java:1396)=
=0A at com.ibm.db2.jcc.c.jb.l(jb.java:367)=0A at com.ibm.db2.jcc.c.jb=
.e(jb.java:92)=0A at com.ibm.db2.jcc.c.w.e(w.java:72)=0A at com.ibm.d=
b2.jcc.c.cc.h(cc.java:203)=0A at com.ibm.db2.jcc.b.sf.q(sf.java:1363)=0A=
at com.ibm.db2.jcc.b.tf.d(tf.java:2388)=0A at com.ibm.db2.jcc.b.uf.X=
(uf.java:188)=0A at com.ibm.db2.jcc.b.t.a(t.java:7201)=0A at com.ibm.=
db2.jcc.b.t.Wd(t.java:5797)=0A at com.ibm.db2.jcc.b.t.getSchemas(t.java:=
5725)=0A at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getS=
chemas(SQLDatabaseMetaData.java:334)=0A at net.sourceforge.squirrel_sql.=
client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:584)=
=0A at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo=
Cache.getAllSchemaLoadInfos(SchemaInfoCache.java:74)=0A at net.sourcefor=
ge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchema=
LoadInfos(SchemaInfoCache.java:109)=0A at net.sourceforge.squirrel_sql.c=
lient.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaI=
nfoCache.java:102)=0A at net.sourceforge.squirrel_sql.client.session.sch=
emainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:469)=0A a=
t net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadSto=
redProcedures(SchemaInfo.java:316)=0A at net.sourceforge.squirrel_sql.cl=
ient.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:257)=0A =
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.init=
ialLoad(SchemaInfo.java:134)=0A at net.sourceforge.squirrel_sql.client.s=
ession.Session$1.run(Session.java:224)=0A at net.sourceforge.squirrel_sq=
l.fw.util.TaskExecuter.run(TaskExecuter.java:82)=0A at java.lang.Thread.=
run(Unknown Source)=0A7538 [Thread-3] ERROR net.sourceforge.squirrel_sql.cl=
ient.session.schemainfo.SchemaInfo - Failed to load stored procedures=0Aco=
m.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553=
, SQLERRMC: SYSIBM.SQLPROCEDURES;PROCEDURES;SYSIBM:CLI:-805=0A at com.ib=
m.db2.jcc.b.sf.d(sf.java:1396)=0A at com.ibm.db2.jcc.c.jb.l(jb.java:367)=
=0A at com.ibm.db2.jcc.c.jb.e(jb.java:92)=0A at com.ibm.db2.jcc.c.w.e=
(w.java:72)=0A at com.ibm.db2.jcc.c.cc.h(cc.java:203)=0A at com.ibm.d=
b2.jcc.b.sf.q(sf.java:1363)=0A at com.ibm.db2.jcc.b.tf.d(tf.java:2388)=
=0A at com.ibm.db2.jcc.b.uf.X(uf.java:188)=0A at com.ibm.db2.jcc.b.t.=
a(t.java:7201)=0A at com.ibm.db2.jcc.b.t.a(t.java:5501)=0A at com.ibm=
.db2.jcc.b.t.getProcedures(t.java:5429)=0A at net.sourceforge.squirrel_s=
ql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:935)=
=0A at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo=
.privateLoadStoredProcedures(SchemaInfo.java:475)=0A at net.sourceforge.=
squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(Sche=
maInfo.java:316)=0A at net.sourceforge.squirrel_sql.client.session.schem=
ainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:257)=0A at net.sourcefor=
ge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo=
.java:134)=0A at net.sourceforge.squirrel_sql.client.session.Session$1.r=
un(Session.java:224)=0A at net.sourceforge.squirrel_sql.fw.util.TaskExec=
uter.run(TaskExecuter.java:82)=0A at java.lang.Thread.run(Unknown Source=
)=0A=0ARegards=0ARich=0A=0A=0A=0A=0A |
