Fw: Problem Browsing DB2 Fixpack 13

I am having a problem using Squirrel browsing a DB2 database running  "DB2 v8.1.13.193", "s060801", "WR21371", and FixPak

"13".

It was ok before I applied the fixpack.

I have tried IBM's DB2JCC driver 2.7.58 and 2.10.27 (which came with fixpack 13)

The symtoms I get when i connect to a database on a fixpack 13 DB2, I just see TABLE, PROCEDURE and UDT appear on the object tab in Squirrel, and nothing under any them.

I dot believe 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.

This is what I get in the log.
6654 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache  - Could not get table types
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
    at com.ibm.db2.jcc.b.sf.d(sf.java:1396)
    at com.ibm.db2.jcc.c.jb.l(jb.java:367)
    at com.ibm.db2.jcc.c.jb.e(jb.java:92)
    at com.ibm.db2.jcc.c.w.e(w.java:72)
    at com.ibm.db2.jcc.c.cc.h(cc.java:203)
    at com.ibm.db2.jcc.b.sf.q(sf.java:1363)
    at com.ibm.db2.jcc.b.tf.d(tf.java:2388)
    at com.ibm.db2.jcc.b.uf.X(uf.java:188)
    at com.ibm.db2.jcc.b.t.a(t.java:7201)
    at com.ibm.db2.jcc.b.t.Yd(t.java:5975)
    at com.ibm.db2.jcc.b.t.getTableTypes(t.java:5903)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTableTypes(SQLDatabaseMetaData.java:990)
    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:224)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)
6765 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  - failed to load catalog names
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
    at com.ibm.db2.jcc.b.sf.d(sf.java:1396)
    at com.ibm.db2.jcc.c.jb.l(jb.java:367)
    at com.ibm.db2.jcc.c.jb.e(jb.java:92)
    at com.ibm.db2.jcc.c.w.e(w.java:72)
    at com.ibm.db2.jcc.c.cc.h(cc.java:203)
    at com.ibm.db2.jcc.b.sf.q(sf.java:1363)
    at com.ibm.db2.jcc.b.tf.d(tf.java:2388)
    at com.ibm.db2.jcc.b.uf.X(uf.java:188)
    at com.ibm.db2.jcc.b.t.a(t.java:7201)
    at com.ibm.db2.jcc.b.t.Xd(t.java:5886)
    at com.ibm.db2.jcc.b.t.getCatalogs(t.java:5811)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDatabaseMetaData.java:566)
    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:224)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)
6818 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager  - Failed to get allowed Schemas
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
    at com.ibm.db2.jcc.b.sf.d(sf.java:1396)
    at com.ibm.db2.jcc.c.jb.l(jb.java:367)
    at com.ibm.db2.jcc.c.jb.e(jb.java:92)
    at com.ibm.db2.jcc.c.w.e(w.java:72)
    at com.ibm.db2.jcc.c.cc.h(cc.java:203)
    at com.ibm.db2.jcc.b.sf.q(sf.java:1363)
    at com.ibm.db2.jcc.b.tf.d(tf.java:2388)
    at com.ibm.db2.jcc.b.uf.X(uf.java:188)
    at com.ibm.db2.jcc.b.t.a(t.java:7201)
    at com.ibm.db2.jcc.b.t.Wd(t.java:5797)
    at com.ibm.db2.jcc.b.t.getSchemas(t.java:5725)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:334)
    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:224)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)
7073 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  - Error occured creating data types collection
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLGETTYPEINFO;GETTYPEINFO;SYSIBM:CLI:-805
    at com.ibm.db2.jcc.b.sf.d(sf.java:1396)
    at com.ibm.db2.jcc.c.jb.l(jb.java:367)
    at com.ibm.db2.jcc.c.jb.e(jb.java:92)
    at com.ibm.db2.jcc.c.w.e(w.java:72)
    at com.ibm.db2.jcc.c.cc.h(cc.java:203)
    at com.ibm.db2.jcc.b.sf.q(sf.java:1363)
    at com.ibm.db2.jcc.b.tf.d(tf.java:2388)
    at com.ibm.db2.jcc.b.uf.X(uf.java:188)
    at com.ibm.db2.jcc.b.t.a(t.java:7201)
    at com.ibm.db2.jcc.b.t.Zd(t.java:6962)
    at com.ibm.db2.jcc.b.t.getTypeInfo(t.java:6897)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypes(SQLDatabaseMetaData.java:869)
    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:224)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)
7338 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager  - Failed to check allowed Schemas
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
    at com.ibm.db2.jcc.b.sf.d(sf.java:1396)
    at com.ibm.db2.jcc.c.jb.l(jb.java:367)
    at com.ibm.db2.jcc.c.jb.e(jb.java:92)
    at com.ibm.db2.jcc.c.w.e(w.java:72)
    at com.ibm.db2.jcc.c.cc.h(cc.java:203)
    at com.ibm.db2.jcc.b.sf.q(sf.java:1363)
    at com.ibm.db2.jcc.b.tf.d(tf.java:2388)
    at com.ibm.db2.jcc.b.uf.X(uf.java:188)
    at com.ibm.db2.jcc.b.t.a(t.java:7201)
    at com.ibm.db2.jcc.b.t.Wd(t.java:5797)
    at com.ibm.db2.jcc.b.t.getSchemas(t.java:5725)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:334)
    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:1063)
    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:224)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)
7462 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  - failed to load table names
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
    at com.ibm.db2.jcc.b.sf.d(sf.java:1396)
    at com.ibm.db2.jcc.c.jb.l(jb.java:367)
    at com.ibm.db2.jcc.c.jb.e(jb.java:92)
    at com.ibm.db2.jcc.c.w.e(w.java:72)
    at com.ibm.db2.jcc.c.cc.h(cc.java:203)
    at com.ibm.db2.jcc.b.sf.q(sf.java:1363)
    at com.ibm.db2.jcc.b.tf.d(tf.java:2388)
    at com.ibm.db2.jcc.b.uf.X(uf.java:188)
    at com.ibm.db2.jcc.b.t.a(t.java:7201)
    at com.ibm.db2.jcc.b.t.a(t.java:5707)
    at com.ibm.db2.jcc.b.t.getTables(t.java:5618)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:1109)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1067)
    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:224)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)
7530 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager  - Failed to check allowed Schemas
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
    at com.ibm.db2.jcc.b.sf.d(sf.java:1396)
    at com.ibm.db2.jcc.c.jb.l(jb.java:367)
    at com.ibm.db2.jcc.c.jb.e(jb.java:92)
    at com.ibm.db2.jcc.c.w.e(w.java:72)
    at com.ibm.db2.jcc.c.cc.h(cc.java:203)
    at com.ibm.db2.jcc.b.sf.q(sf.java:1363)
    at com.ibm.db2.jcc.b.tf.d(tf.java:2388)
    at com.ibm.db2.jcc.b.uf.X(uf.java:188)
    at com.ibm.db2.jcc.b.t.a(t.java:7201)
    at com.ibm.db2.jcc.b.t.Wd(t.java:5797)
    at com.ibm.db2.jcc.b.t.getSchemas(t.java:5725)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:334)
    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:224)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)
7538 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  - Failed to load stored procedures
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLPROCEDURES;PROCEDURES;SYSIBM:CLI:-805
    at com.ibm.db2.jcc.b.sf.d(sf.java:1396)
    at com.ibm.db2.jcc.c.jb.l(jb.java:367)
    at com.ibm.db2.jcc.c.jb.e(jb.java:92)
    at com.ibm.db2.jcc.c.w.e(w.java:72)
    at com.ibm.db2.jcc.c.cc.h(cc.java:203)
    at com.ibm.db2.jcc.b.sf.q(sf.java:1363)
    at com.ibm.db2.jcc.b.tf.d(tf.java:2388)
    at com.ibm.db2.jcc.b.uf.X(uf.java:188)
    at com.ibm.db2.jcc.b.t.a(t.java:7201)
    at com.ibm.db2.jcc.b.t.a(t.java:5501)
    at com.ibm.db2.jcc.b.t.getProcedures(t.java:5429)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:935)
    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:224)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)

Regards
Rich

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users