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 (TEs) and Storage Managers (SMs)). 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 |
bigint |
A unique ID that identifies the database object. |
CATALOGID |
bigint |
The catalog ID for the database object. |
OBJECTTYPE |
string |
The type of database object, one of: |
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. |
FETCHCOUNT |
integer |
The number of times this object has been fetched. |
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 (TE or SM) that requested this atom. |
DIRTY |
boolean |
A value of true indicates that this atom has data that needs to be recorded by the SM. |
NODEID |
integer |
The ID of the database process where this atom resides. |