GLOBALATOMS System Table Description

Description

A pseudo table generated to show all atoms 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.

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