Category Archives: DB2

Mainframe CICS DB2 : Security mechanism not supported

I was writing a code to access DB2 in CICS where I encountered this error. This error encounters when you are trying to access a secured Db with default options. In order to get this working, you have to specify … Continue reading

Posted in Articles, DB2 | Leave a comment

Mainframe CICS DB2 : java.lang.NoClassDefFoundError: com/ibm/crypto/provider/IBMJCE

I was trying to access Mainframe () DB2 using standalone application with “com.ibm.db2.jcc.DB2Driver” driver where I encountered the below error java.lang.NoClassDefFoundError: com/ibm/crypto/provider/IBMJCE Problem was that ibmjceprovider.jar was missing from my classpath and java.security file I added the jar file and … Continue reading

Posted in Articles, DB2, Java, Troubleshoot | Leave a comment

DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704

SQLCODE -204 is "object does not exist". I was getting this error while executing a query, this was happening because I was using the SCHEMA name of Q7 database and executing the query inside Q0 db. means not able to … Continue reading

Posted in DB2, Java, Troubleshoot | Leave a comment

DB2 SQL0407N : Assignment of a NULL value to a NOT NULL column “TBSPACEID=2, TABLEID=26, COLNO=0” is not allowed.

SQL0407N Assignment of a NULL value to a NOT NULL column name is not allowed. If you encounter this error and If the value for name is of the form “TBSPACEID=n1, TABLEID=n2, COLNO=n3”, you can determine the table name and … Continue reading

Posted in Database, DB2 | 1 Comment