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

Java Epoch to TIMESTAMP function

One of the timestamps in one tables I work with is stored as a java epoch.  Here is a function I wrote to convert it to a timestamp.

This is done in DB2 on a iSeries so some you may need to edit it some.  In particular ant line that *SomeWord is probably a iSeries thing.

CREATE FUNCTION YFUALFA.TIMESTAMP_EPOCH ( 
 EPOCH BIGINT ) 
 RETURNS TIMESTAMP   
 LANGUAGE SQL 
 SPECIFIC YFUALFA.TIMESTAMP_EPOCH 
 DETERMINISTIC 
 READS SQL DATA 
 RETURNS NULL ON NULL INPUT 
 NO EXTERNAL ACTION 
 SET OPTION  ALWBLK = *ALLREAD , 
 ALWCPYDTA = *OPTIMIZE , 
 COMMIT = *NONE , 
 DECRESULT = (31, 31, 00) , 
 DFTRDBCOL = *NONE , 
 DYNDFTCOL = *NO , 
 DYNUSRPRF = *USER , 
 SRTSEQ = *HEX   
 RETURN TIMESTAMP ( '1970-01-01' , '00:00:00' ) + EPOCH SECONDS  ; 
  
COMMENT ON SPECIFIC FUNCTION YFUALFA.TIMESTAMP_EPOCH 
 IS 'Timestamp from a Java epoch' ;