Datastage Randomly Locked out

Suddenly, my datastage pipeline stopped working. I hit this error: DB2_Connector_2: [Input link 0] SQLConnect reported: SQLSTATE = 42724: Native Error Code = -10,013: Msg = [IBM][CLI Driver] SQL10013N The specified library “GSKit Error: 408” could not be loaded. SQLSTATE=42724 (CC_DB2Connection::connect, file CC_DB2Connection.cpp, line 856) The error was due to permission change on our SSL […]

VIM – JOIN Conditions with Unicode and ASCII

JOIN Conditions with Unicode and ASCII I cannot stress the dangers of copying data from Excel or HTML and assuming that it’s ASCII. For example U+0040 is the unicode version of @. We ingested the unicode version and couldn’t see why a JOIN condition on the data table wasn’t working. I looked at the source […]

Remove Duplicates in DB2 Columnar Format

I had dupe data in my OLAP table, where the columnar data can be duplicated based on event id. (I loaded data 2x). I had to differentiate the data and remove the duplicates, so I assigned row_numbers over a partition ordered by. I hope this helps you. db2 “update (select OME.*, row_number() over(partition by IDN_EVENT_ID […]

BufferPool Error, Debug and Relevant Solution

My Java code kept hitting a buffer pool issue. com.ibm.db2.jcc.am.SqlException: There are no pages currently available in bufferpool “4099”.. SQLCODE=-1218, SQLSTATE=57011, DRIVER=4.19.49 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.ResultSet.completeSqlca(Unknown Source) at com.ibm.db2.jcc.am.ResultSet.earlyCloseComplete(Unknown Source) at com.ibm.db2.jcc.t4.bb.a(Unknown Source) at com.ibm.db2.jcc.t4.bb.n(Unknown Source) at com.ibm.db2.jcc.t4.bb.j(Unknown Source) at com.ibm.db2.jcc.t4.bb.d(Unknown Source) at com.ibm.db2.jcc.t4.p.c(Unknown Source) at com.ibm.db2.jcc.t4.vb.j(Unknown Source) […]