Hi All,

I am trying to customize a Siebel CRM Application (backend is DB2 on AIX 64)

I am receiving below error in the application log files:

"
Error Error 1 2010-01-27 14:57:53 SQLError: sqlstate 23502: [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=8, TABLEID=2580, COLNO=12" is not allowed. SQLSTATE=23502
"

In the above error, it is pointing to TBSPACEID=8, TABLEID=2580, COLNO=12

How can I find the names of the tablespace, table, column respectively from above information in the DB2 database.

I apologize for this simple question. This is the first time I am getting to DB level troubleshooting with DB2

Please let me know your thoughts.

Thanks and Regards,
Rishabh

Look at SYSCAT.TABLES and SYSCAT.COLUMNS