If any TDS table or screen is bound (that is, the session memory copy—not the MetaStor copy of its definition—is in use for the rest of the session), the Promotion system issues a warning message and requests that you restart the Execution Environment and apply the change request again. Unbinding the objects prior to applying the change prevents these messages. Two tools are available to assist with this, @PROMUNBINDOBJS and @PROMBINDOBJS.
You can use the @PROMUNBINDOBJS tool prior to applying a change or series of changes to unbind a set of objects. You can specify ALL, INSTALLATION or SYSTEM as the scope of the change. You must restart the Execution Environment after running this tool. After applying the change requests run @PROMBINDOBJS to rebind the objects and then restart the Execution Environment.
Tables modified by a promotion keep the security attributes they had before the promotion. When a promotion creates a new table in the target system, the new table’s classification defaults to the value of CLASSIFICATION in the @PROM_NSEC_DEF table. For more information about the @PROM_NSEC_DEF table, refer to
Chapter 2, Preparing For Promotions.
TIBCO Object Service Broker Application Administion for more information on building secondary indexes.
TIBCO Object Service Broker Managing Security for more information on granting security access to objects.