Hi,

I got below error when I ran "Set constraints for table_name disabled;"

Could anyone help me on this?

Error code: -892
Can not disable object(informix.pk_mytable_pkid) due to other active objects using it.

I have checked the error code, it says :
"892 Cannot disable object object-name due to other active objects using it.
Other objects are using this object. If the object being disabled is an index, then a unique constraint, primary constraint, or referential constraint might be using that object. If the object is a unique or a primary-key constraint, then a referential constraint might be using that object."

Is there anyway to find which active object is using it?

Thanks in advance.


Tony

yes, but is not easily...

probably you have a user session accessing this table.

There is somes steps... are not mutch detailed.. but maybe can help.
1) identify the partnum of the object.
2) if you are using IDS version >= 9.40 , execute :
onstat -g opn 0
will show all open tables/index by session.
3) look for your partnum...

If you are using IDS 7.31 , will be a little hard to do that because the onstat -g opn not work properly in this version...