CSS

Wednesday, November 19, 2014

Fix errors with IBM Data Studio and DB2 10.4 on Linux Mint 17.1

I was getting the following errors every time I clicked on something with my newly installed IBM Data Studio:


com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSSH200 0X5359534C564C3031, DRIVER=4.18.60 at com.ibm.db2.jcc.am.kd.a(Unknown Source) at com.ibm.db2.jcc.am.kd.a(Unknown Source) at com.ibm.db2.jcc.am.kd.a(Unknown Source) at com.ibm.db2.jcc.am.bp.c(Unknown Source) at com.ibm.db2.jcc.t4.bb.p(Unknown Source) at com.ibm.db2.jcc.t4.bb.h(Unknown Source) at com.ibm.db2.jcc.t4.bb.b(Unknown Source) at com.ibm.db2.jcc.t4.p.a(Unknown Source) at com.ibm.db2.jcc.t4.vb.i(Unknown Source) at com.ibm.db2.jcc.am.bp.kb(Unknown Source) at com.ibm.db2.jcc.am.cp.xc(Unknown Source) at com.ibm.db2.jcc.am.cp.b(Unknown Source) at com.ibm.db2.jcc.am.cp.kc(Unknown Source) at com.ibm.db2.jcc.am.cp.executeQuery(Unknown Source) at com.ibm.datatools.uom.ConnectionService.getDB2Instance(Unknown Source) at com.ibm.datatools.dse.db2.luw.ui.internal.databases.listview.DB2ConnectionDetailsProvider.getInstanceName(Unknown Source) at com.ibm.datatools.uom.ui.internal.databases.listview.ObjectListDatabasesPropertiesProvider$ConnectionProfilePropertyValueProvider.getPropertyValue(Unknown Source) ...

I did a bind and it cleared up.


db2 terminate 
db2 CONNECT TO dbname user USERID using PASSWORD 
db2 BIND path/db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE 
db2 BIND path/@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD 
db2 BIND path/@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD 
db2 terminate

Here is where I got the commands from: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.qb.server.doc/doc/t0024970.html?cp=SSEPGG_10.5.0%2F2-2-0-4-2

No comments:

Post a Comment