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 |
bigint |
The ID of the database process where this atom resides.
|
||
STARTID |
bigint |
The ID of the database process where this atom resides. See Start ID. |