Drop diagnostic/violation table

IDS 9.40FC4W2 Trying to alter a table IDS generates the error: -898 Cannot alter a table which has associated violations/diagnostics tables. The user has tried to add, drop, or modify a column in a table that has a violations and diagnostics table associated with it. Trying to drop the dia and vio tables with drop table foo.dia/foo.vio a new error message appears: -897 Cannot modify/drop a violations/diagnostics table. The user has tried to alter or drop a table that is serving as a violations table or a diagnostics table for another table. I'm working as user informix and table owner is informix. Reading manuals didn't help so I have no clue what to do. Any help would be appreciated. Reinhard.

what does dbschema -d <db> -t yourtable -ss tells you; i guess you have to enable constraints/indexes etc and stop violations for that table. this is/should be doc'd in the manual. Superboer. Habichtsberg, Reinhard schreef: > IDS 9.40FC4W2 > > Trying to alter a table IDS generates the error: > -898 Cannot alter a table which has associated violations/diagnostics > tables. > > The user has tried to add, drop, or modify a column in a table that has > a violations and diagnostics table associated with it. > > Trying to drop the dia and vio tables with drop table foo.dia/foo.vio a new > error message appears: > -897 Cannot modify/drop a violations/diagnostics table. > > The user has tried to alter or drop a table that is serving as a > violations table or a diagnostics table for another table. > > I'm working as user informix and table owner is informix. > > Reading manuals didn't help so I have no clue what to do. > > Any help would be appreciated. > Reinhard.