We're on IDS 9.21 UC5 on Solaris. I run the following sql:

select max(request_id) from req:

It returns 10359186 . This column is type serial.

Then I run select * from req where request_id = 10359186, and I get row not found. Sometimes I get a 243 and 111 error.

If I run this

select request_id from req where request_id = 10359186, It returns
10359186--what I would expect.

Any explanation for this behavior???