10. Understanding Ingres Management Architecture : REGISTER TABLE Examples : Examples: Domain Tables
 
Share this page                  
Examples: Domain Tables
The ima_session_domain table below shows the domain of SERVERS and VNODES visible to the MIB Server domain:
REGISTER TABLE ima_session_domain
(
domplace VARCHAR(64) NOT NULL NOT DEFAULT IS 'exp.gwf.gwm.session.dom.index'
)
AS IMPORT FROM 'tables'
WITH DBMS = IMA,
STRUCTURE = UNIQUE SORTKEYED,
KEY = (domplace);
The ima_places table below shows all the servers known to the DBMS, but only in the local MIB Server domain, because when there is no VNODE or SERVER specified, the default is SERVER:
REGISTER TABLE ima_places
(
place VARCHAR(64) NOT NULL NOT DEFAULT IS 'exp.gwf.gwm.places.index',
type I4 NOT NULL NOT DEFAULT IS 'exp.gwf.gwm.places.type',
class VARCHAR(64) NOT NULL NOT DEFAULT IS 'exp.gwf.gwm.servers.class',
flags I4 NOT NULL NOT DEFAULT IS 'exp.gwf.gwm.servers.flags'
)
AS IMPORT FROM 'tables'
WITH DBMS = IMA,
STRUCTURE = UNIQUE SORTKEYED,
KEY = (place);