[Squirrel-sql-users] Problem with DB2 on z/OS APAR PM58842

[<ant...@ke...>]

Hi,
I’m a DBA from Finish Social Insurance Institution. Our developers are 
using Squirrel to browse tables in our test environment. We are using DB2 
on z/OS.
After a latest update on DB2 we faced a new problem in Squirrel. The 
update was APAR PM58842 (PTF-number UK78737). Are there any known problems 
with Squirrel with that APAR? I try to describe how the problem occurs.
We have configured a driver to DB2 and it works fine. We face the error 
when we try to create an alias. I choose radio button “Specify Schema 
loading and caching”. I have chosen drop down boxes to be like “Set All 
Objects in all Schemas to Load but don’t cache”. Then I press the button 
“Connect database to refresh Schema table” and give my user id and 
password to connect. After these steps I get nothing in the Schema table, 
although I should get. Following error message is written in the Squirrel 
Logs:
2012-07-10 13:16:33,512 [Thread-4] ERROR 
net.sourceforge.squirrel_sql.client.session.SessionManager  - Failed to 
get allowed Schemas
java.lang.NullPointerException
        at 
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:289)
        at 
net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:686)
        at 
net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.SchemaPropertiesController.onConnected(SchemaPropertiesController.java:261)
        at 
net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.SchemaPropertiesController.access$500(SchemaPropertiesController.java:25)
        at 
net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.SchemaPropertiesController$8.connected(SchemaPropertiesController.java:212)
        at 
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:307)
        at java.lang.Thread.run(Unknown Source)

Anyway, the Alias can be created. But when I take connection to that 
alias, no objects can be seen in the “Objects” tab. If I choose the “SQL” 
tab, everything works fine. I can give straight SQL-commands and get 
desired result in that way.
Also the old aliases lost their information about tables etc., when we 
installed the DB2 APAR. So we cannot see for example tables anymore in the 
object tree in the “Objects” tab. Straight SQL-commands work fine with old 
aliases too.
Do you have faced the same kind of problem before? If you have something 
to ask, I will be delighted to answer. 
Thanks for your support.
Best regards
Antti Liesjärvi
IT Specialist
 +358 400767752
+358505919655