I am having a strange error in DB2 V 9.1(On AIX Version 5.3). The DB2 has fix pack 3 also installed on it.

When I am doing an Insert into a table, I am encountering the below error.

INSERT INTO tableabc(abc, def, ghi, jkl) VALUES (1, 1, 1, 1);

The primary key, data types all are taken care of during the insert.

The error received is as below.


DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: =;FUNCTION
Message: No authorized routine named "=" of type "FUNCTION" having compatible arguments was found.

A select on the same table works fine.

Also, when I am trying to create a procedure that is dependent on this table, I am running into the same exact error.

Temporary Solution that we found is to Drop and Create the table & indexes again, and the Insert, Create Procedure works fine without a single change in the SQL.

We need a solution which does not involve a drop of table.

We already raised a PMR with IBM, but in the mean time.. Anybody there who can help?