GLOBALATOMS System Table Description

Description

A pseudo table generated to show all atomThe internal object structure representing all data in a NuoDB database. Atoms are self-coordinating objects that represent specific types of information (such as data, indexes or schemas).s that are currently cached on all running database process nodes (transaction engines and storage managers). Since a particular atom can be on multiple nodes, there might be multiple rows for the same atom — one row for each node that the atom is on. Each row for the same atom has a different value in the NODEID field.

The information in this table can be useful for debugging and for understanding application performance. Viewing all information in this table can generate a very large result set.

Caution: Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.

Fields

Field Type Description
OBJECTID integer A unique ID that identifies the database object.
CATALOGID integer The catalog ID for the database object.
OBJECTTYPE string The type of database object, one of: MasterCatalog, TransactionManager, Table, Records, Data, Index, Database, Schema, Catalog, Blobs, Ids.
STORAGEGROUPID bigint The ID of the storage group where this atom resides.
POPULATED boolean An internal flag that indicates the state of the atom.
OPEN boolean An internal flag that indicates the state of the atom.
COMPLETE boolean An internal flag that indicates the state of the atom.
REFCOUNT integer An internal reference count for this atom.
INCARNATION bigint

A unique number associated with each cached object. This number increases when an object is dropped and reloaded.

CONTENTSIZE bigint An internal estimation of object size. Do not use this to compute size on disk or memory consumption.
CHAIRMAN integer The node ID of the chairman for this atom.
REQUESTEDFROM integer The node ID of the database process (transaction engine or storage manager) that requested this atom.
DIRTY boolean A value of true indicates that this atom has data that needs to be recorded by the storage manager.
NODEID integer The ID of the database process where this atom resides.

Indexes

None