Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008

    Unhappy Unanswered: Disable constraints error


    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.


  2. #2
    Join Date
    Apr 2007
    Jundiai / SP - Brasil
    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...
    César Inacio Martins
    Jundiai / SP - Brasil - em Português - English (translated by Google).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts