Passive routing sessions can access objects on the Teradata systems to which they are routed. It is not necessary to add or manage objects for passive routing sessions.
Managed routing sessions can only access objects that are managed on the systems to which they are routed. This means the objects must exist in the Business Continuity Manager data dictionary, which monitors the object definitions and placement.
Business Continuity Manager data dictionary is maintained automatically. As Business Continuity Manager connected clients create new objects, the objects are added to the data dictionary. As objects are dropped, they are removed from the data dictionary.
After running a data dictionary scan to find where an object exists, you can manage the object on all the systems on which the object exists or on a single system of the set, if the objects are not yet synchronized. Controlling where an object or database is managed can be done using Business Continuity Manager UI or the bcmadmin command line. When deploying applications to use managed routing, you can change where the application database is managed.
For best practice, start with managing the lowest level of a database hierarchy by selecting where to manage the databases containing staging and base tables. Then progress upwards to any dependent databases containing application views.
You can choose where to manage objects individually or at the database level. When deploying a new application to Business Continuity Manager, work at the database level.
bcmadmin> help database manage;
Command: DATABASE MANAGE {<database> [ON <tdpid> [, <tdpid>, ...]]} [REASON '<reason>']
Description: Changes the managed location of all objects in the specified database to the specified systems.
bcmadmin> DATABASE MANAGE dbtest on db1;