Structure of the Global Database

Administrator Command Reference Manual

System and Global Projects : Structure of the Global Database

The Global System database contains Teams, Databases, Roles, Locations and Stamps. Figure 4:1.: Structure of the Global System Database shows the structure of the Global System database.

Figure 4:1.

Structure of the Global System Database

GSTAT Element (GSTAT)

Only one /*GS element can exist in the database and it is inherited from the STAT element in the Standard System Database.

Attributes


Name	/*GS
Lock	false
Owner	/*
Prjnumber	unset	Project number: 17 character text
Maxusers	999999
Prjdesc	unset	Project description 120 character text
Charset	-370086
Hccnt	Extract list changes count Integer =< 999999
Naccnt	Non additive changes count
Clccnt	Change list changes count

GTMWL Element

The Global Team World element GTMWL is named /*GT. Only one /*GT element can exist in the database. It is the same as the TMWL element, except that:

•

It does not own a user list element USLI.

•

The DB element does not own an MDB list element MDBL.

•

The DB element owns a single DBLOC element DBLOC.

Attributes


Name	/*GT
Lock	false
Owner	/*

TEAM Element

Attributes


Name	/name
Lock	false
Owner	/*GT
Description	unset

Database List Element (DBLI)

Attributes


Name	/name
Type	DBLI
Lock	false
Owner	/name

DB Element

The DB element owns the list element DBLOC which holds four additional attributes (see DBLOC Element). These attributes are attached to the DBLOC element to facilitate separate claiming of both this element and the owning DB element. This scheme reduces the contention between the AVEVA E3D™ ADMIN module and the Global daemon.

Attributes


Name	/name
Type	DB
Lock	false
Owner	/name
Stype	DESI
Fino	n	File number
Area	0	Area number
Daccess	Update
Claimdb	Explicit or Implicit if Daccess is Multiwrite
Description	unset
Proj	unset	(except for Foreign DBs, where it is set to the project code)
Fcpyref	Nulref
Bcpyref	Nulref
Extractno	n
Variant	false
Controlled	false
DBLC	List of locations to which DB is allocated
PRMLOC	Primary Location
ISDRDB	Does DB have drawing files
DBLNKP	The DBLNKP pseudo attribute will return TRUE is both Project and Database have propagation of linked documents enabled.

DBLOC Element

Attributes


Name	/name
Type	DBLOC
Lock	false
Owner	/name	DB element
Locrf	/name	Name of Primary Location
Prvrf		Name of previous
	Primary Location (normally unset)
Propg	true	Propagation flag
Picfd	false	Picture file propagation flag
DEALDB	Ref Array Indicates locations where db is being de-allocated
Hccnt	Extract list changes count = <999999
Naccnt	Non additive changes count
Clccnt	Changes list changes count
NOLNKP	false	If true propagation of linked documents is disabled for the database.

Global Role World (GROLW)

The Global Role World Element stores the ROLE elements in a Global project.

Attributes


Name	/*GRO
Lock	false
Owner	/*
LACR	false	Sets Data Access Control on or off

Role Element (ROLE)

Attributes


Name	/name
Lock	false
Owner	/*T
Description	unset	120 character text

Perop Element (PEROP)

Attributes


Name	/name
Lock	false
Owner	/name
Opcreate	ignore
Opmodify	ignore
Opdelete	Ignore
Opclaim	ignore
Opissue	ignore
Opdrop	ignore
Opoutput	ignore
Opexport	ignore
Opcopyfrom	ignore
Eclass	unset	Element Class
Aclass	unset	Attribute Class
Condition	unset
Acrmessage	unset

GLOCWL Element

The Global Location World element GLOCWL specifies information about Locations, Groups and Communications (Links). It is named /*GL and only one /*GL element can exist in the database. The GLOCWL element consists of the three list elements GRPLI for groups, LOCLI for locations and LNKLI for links. It has the following attributes:

Attributes


Name	/*GL
Lock	false
Owner	/*
Aduuid	text	Daemon version string (Project UUID)
Hubrf	/name	Hub Location Reference
Prvrf	Nulref	Previous Hub Reference (normally unset)
NxtHb	Nulref	Next Hub location (normally unset)
Newuid	text	gets new UUID value to use when setting ADUUID. To be used when a Global project is copied directly without the REPLICATE command (see REPLICATE (Project definition)) having been used.
GLINKP	false	To enable Link Propagation, the GLINKP attribute must be set to TRUE.

GRPLI Element

The GRPLI element contains a list of Group elements GRP. A Group is a fully connected local network of Locations which conceptually form a single node in the Plant Design Global-tree structure of Locations.

Attributes


Name	/name
Lock	false
Owner	/*GL

GRP Element

The characteristics of each group are defined by a GRP element which has the following attributes:

Attributes


Name	/name
Lock	false
Owner	/name
Description	unset

Membership of a group is indicated by the attribute GRPRF in each location element LOC, as described below. The location elements LOC are themselves listed in the LOCLI element.LOCLI Element

The LOCLI element contains a list of all Location elements LOC, including offline Locations and those which belong to Groups.

Attributes


Name	/name
Lock	false
Owner	/*GL

LOC Element

The characteristics of each Location are defined by a LOC element which has a set of attributes and a secondary list element DBALL. The DBALL element is a complete list of all Databases allocated to the Location. It is implemented as a Dabacon secondary list of DB reference numbers which refer to DB elements under the DBLI list element of TEAM elements.

Locations which belong to a Group have an attribute GRPRF holding the reference number of the Group. If this attribute is null then the Location does not belong to a group. LOC elements also possess a LOCRF attribute which points to the parent of the Location. This attribute is used to determine paths between Locations in the proposed tree structure for connecting Locations.

In a future implementation, based on a more general graph structure, the LOCRF attribute might either be dropped or used for another purpose. A Location is only recognised as fully initialised when the logical attribute LINIT is true. Other attributes of a Location are described in the following table.

The LOC element has the following attributes:

Attributes


Name	/name
Lock	false
Owner	/name
Description	unset	120 character text
Locid	XXX	3-letter identifier
Rhost	rhost name	host name
Iconn	1	Connection type: 1 = on-line 0 = off-line
Linit	false	Initialisation flag
Grprf	Nulref	Group reference set if Location is added to a Group
Locrf	/name	Parent Location
PRMRF	Primary location of system Database. If unset, (and PRVRF is unset) the Satellite will be administered locally .
PRVRF	Nulref	Old primary location (normally unset)
DEALAL	false	Indicates that ALL DBs are currently being de-allocated from this location.
CURLOC	True current Location (available everywhere)
ADMLOC	Currently administered location (available everywhere).
PRMLOC	Primary location of its system db
DBPRIMARY	(ref array) - List of Databases primary at the current location.
LOCPRIMARY	(ref array) - List of Locations primary at the current location.
DBALL	List of Databases allocated to this location.
NoExtCreation	default false	If true, disables the creation of extracts by this location. Extract creation must be done by the Hub (or an authorised administering location)
LCpOvWrite	default false	If true, database files which are locked by dead users may be overwritten if an update requires an entire file copy.

Note:

When a Global Project is created an initial Location element is created with a NAME of /PROJECTHUB and a LOCID of ‘HUB’. Its LINIT flag is set to TRUE.

Note:

Do not allow locked files in the current project to be overwritten during copying by Global updates if other projects are using the current project as a foreign one. This is because database readers in the other projects are valid users even though they are not recorded as users in the current project.

DBALL Element

Attributes


Lock	false
Owner	/name

LNKLI Element

The LNKLI element contains a list of link elements LNK which specify the connections between pairs of Locations. Not used at this release.

Attributes


Name	/name
Type	LNKLI
Lock	false
Owner	/*GL

LNK Element

Not used at this release.

Attributes


Name	/name
Description	unset	120 character text
LNKRX
LINKRY
LINKWV

GSTWLD Element

Any existing stamps in the standard System database are copied to the Global Stamp World element and deleted from the System database.