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 ‘securityMechanism’ property in your connection string with value as supported by server, see below:
Continue reading “Mainframe CICS DB2 : Security mechanism not supported”
I was trying to access Mainframe () DB2 using standalone application with “com.ibm.db2.jcc.DB2Driver” driver where I encountered the below error
Problem was that ibmjceprovider.jar was missing from my classpath and java.security file I added the jar file and then added below line in security file..it works.
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 find table with given user id.
When I corrected the db name it works fine.
This error also appear when you are not using schema name in query.
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 column name using the following query:
C.TABNAME, C.COLNAME FROM SYSCAT.TABLES AS T,
SYSCAT.COLUMNS AS C WHERE
T.TBSPACEID = 2 AND T.TABLEID = 26 AND C.COLNO = 0 AND
C.TABSCHEMA = T.TABSCHEMA AND C.TABNAME = T.TABNAME