Hi,
 I have installed Squirrel SQL Client v3.2.1 on Windows XP 32bit and Java version 1.6.0_22.
 I am trying to connect to a db2 database.
 The problem is this: I am able to connect successfully, however in the object tree I only see the TABLE, PROCEDURE, and UDT folders. I'm not able to see any of the schemas, tables, procedures, views etc. Any ideas on why this would be happening?


JDBC Driver CLASSNAME : com.ibm.db2.jcc.DB2Driver
getDatabaseProductVersion : DB2
getURL : jdbc:db2://hostname:446/BAGTDB2T
getDatabaseProductVersion :DSN08015
getDatabaseMajorVersion : 8
getDriverName : IBM DB2 JDBC Universal Driver Architecture getDriverVersion : 2.3.63
getDatabaseProductName : DB2

2011-02-03 14:53:31,044 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - failed to load table names
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.a(s.java:6337)
at com.ibm.db2.jcc.b.s.getTables(s.java:6247)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:982)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1211)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:446)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:347)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187)
at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:240)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2011-02-03 14:53:31,106 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager - Failed to check allowed Schemas
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.Wd(s.java:6428)
at com.ibm.db2.jcc.b.s.getSchemas(s.java:6355)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:275)
at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:622)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:126)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:161)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:154)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:591)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:412)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:351)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187)
at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:240)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2011-02-03 14:53:31,200 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed to load stored procedures
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.a(s.java:6129)
at com.ibm.db2.jcc.b.s.getProcedures(s.java:6056)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:754)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:597)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:412)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:351)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187)
at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:240)
at java.lang.Thread.run(Unknown Source)
2011-02-03 14:54:47,026 [Thread-4] ERROR net.sourceforge.squirrel_sql.fw.dialects.DialectFactory - Encountered unexpected exception while attempting to determine database product name/version: unsupported encoding Cp1026 for result set column
2011-02-03 14:54:47,089 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager - Failed to get allowed Schemas
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.Wd(s.java:6428)
at com.ibm.db2.jcc.b.s.getSchemas(s.java:6355)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:275)
at net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:686)
at net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:638)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadSchemas(SchemaInfo.java:647)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadSchemas(SchemaInfo.java:476)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:280)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:207)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:324)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2011-02-03 14:54:47,323 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Error occured creating data types collection
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.Zd(s.java:7605)
at com.ibm.db2.jcc.b.s.getTypeInfo(s.java:7539)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypes(SQLDatabaseMetaData.java:711)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:899)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:314)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:207)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:324)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)