Re: Fw: Problem Browsing DB2 Fixpack 13

On Mon, Dec 11, 2006 at 04:16:32AM -0800, Ric wrote:
> 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

Sounds similar to this problem with fixpack 10
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0509zikopoulos/

You've probably missed a step when applying the fixpack.

-- 
Colin Bell

-------------------------------------------------------------------------
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